Newbie... Need to filter a form by information stored in a module
Thu, 3 Jul 2008 09:39:03 -0700
Newbie to VB here. I'm working in Access 2007
I've created a login screen to a dbase I'm working on. In the code for the
script to validate the user and their password, I've ended it by establishing
values to store the name and ID of the user that just logged in. I did that
with the following code before t ...
|
looping parsing problem
Wed, 2 Jul 2008 19:15:31 -0700 (PDT)
Can someone tell me best way of correcting the following code, in
which I would like to move through the rows of a six-row dynaset,
and on each line of the dynaset look for particular field values.
If such a value is found, then the entire process can be exited.
I've written the following, but it's not progressi ...
|
Code to loop through and modify duplicate data
Mon, 30 Jun 2008 13:34:23 -0700 (PDT)
Hello,
I'm not too familiar with VBA code; however, I think it is a solution
to my issue and would like some help please.
I have a Customer table where there are duplicates in the Name field.
I don't want to remove the duplicates. Instead I would like to add a
sequence of numbers for each of the same name.
...
|
Resolved
Mon, 30 Jun 2008 09:01:01 -0700
ok, I made some headway here.
I finally discovered the "Compile" feature in the code window (funny I never
stumbled accross it after all these years) and it led me to discover the
problem with my object.
It was the "TextBox.DataObject" typing of the "Data" parameter in the
objRich_OLEDragDrop() procedure ...
|
Problem with Custom Objects in Access 2007
Mon, 30 Jun 2008 03:46:00 -0700
We have recently upgraded from Office 2003 to Office 2007.
The .mdb we've been using for inventory, which is jammed full of 4 years
worth of VBA
code, exhibited several problems after the upgrade. I've managed to solve
all of the
problems but one:
Whenever I declare a custom object in the code module o ...
|
Hate Your Job?
Sun, 29 Jun 2008 09:52:05 GMT
Do You Hate Your Job?
If You Are Like Me And REALLY Hate Your Job, You Can Do What I have Done And
Tell All About Your Company At A Great And CHEAP New Site Called
Dont Work For These . Com
http://www.dontworkforthese.com
This Site Has Chat Rooms,
A Joke Section,
A Great Story Section Where You Can Tell All ...
|
retreaving a value of a field
Fri, 27 Jun 2008 22:42:45 -0400
I am trying to get value from a qry using a select function in access. need
help with the coding. having trouble with the equal side of firstline
Thanks in advance
al
...
|
|
|
Re: Active x component can't create object (unless an MDE file)
Fri, 27 Jun 2008 14:27:32 -0600
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote:
>It shocks me that you'd get better performance. As I wrote in Access Advisor
>( http://my.advisor.com/articles.nsf/aid/16279 ), typically using VBA is an
>order of magnitude faster than using FSO, and using APIs is an order of
>magnitude faster ...
|
holland
Fri, 27 Jun 2008 20:16:14 +0200
Nu kunt u meer geld ook verdienen, omhoog nu ondertekenen!
www.miniemail.com/agamenon
...
|
Twist with (ADO or DAO) and Access Queries
Fri, 27 Jun 2008 07:25:01 -0700
Hi !
First, let's start with our context :
- DB on SQL Server
- Over 350 data tables
- Lots of tables have more than 100 000 data
- We have tons of queries for stats, checks, etc...
- We have about 20-30 access mdb files containg these queries
- To run our queries, we link tables from the database running o ...
|
