I have a form with a lenghty If Then Else code that works perfectly however
I have to open the form and cycle through all of the records to update each
record. I'm checking conditions (several) to see if an order is on time,
late, not scheduled to run ect. There are several ...

I want to store a default folder path in table as a string and retrieve it
with code. Is there a facility to read and write directly to a table with
code?
The table I’m reading/writing to will have one record and a number of

I have a cbo that enters a name into a txtBx
I use a cbo to select a company name for John Doe
Say I select xyz company
Later though, John Doe is jobless

I design database to calculate working hours Total=(From-To)*(PayRate);Total
hours is wroking properly.
How can i change "PayAmount" formula  to calculate  Half hour correctly
1.This fomula calculate difference between start date and End Date

When a contact is added on our contacts form in Access, I would like for a
Contact Card to be added to a Shared Contacts file that we keep in Exchange.
I have coded everything so that it pulls into a contact card properly,
however it always saves to the local user's contact list. ...

I have a database the has two time/hour fields. Each field returns short
time data.
I want to create a text box the reflects the difference between the two time
fields in hours and minutes.

I have several tables where I have entered the descriptions of each field.
Can I write a routine for a bound form that would place a label whose
caption = the field's description and a texbox whose data source = the
field?

Hi again,
Is there way to capture the value in the OnClick event for a label. I want
to be able to perform an action if a user clicks on a label named
"lblAdmin_Click()".

I have a very very odd issue and I cannot figure it out... Any clues
would be greatly appreciated...
I have an old Access database (Access 97) that its first screen is a
login screen using a form. There is a table where all usernames and

I have an Access 2000 app that I want to freshen up - make it seem it little
more "graphical"...
One of the things is the menu area...
I currently have a "sub form" displayed on the main form where the user can

I have two codes for you guys to look at, the first code works properly and
is an example.
DoCmd.OpenForm "tblPropellant Query", , , "PLANAM = '" &
Me!Plastisizer.Value & "' And PLAPCT between " & Nz(LowPCT.Value, 0) & " and

I've been working in a MDB Database along with another person.
Does anyone know any kind of software to manage changes and sincronize them
into a unique database? We work in several objects (forms, queries, reports
and vba code).

I have an applicaiton where the user selects a "client" name from a drop
down "combo box" and then once the client has been sleected, they entere
hours against that client.
I have been asked if I can modify the app so that the user can select

I inherited a form with vba behind it that worked fine.  I added tabs and
now, the vba is getting bugged.
I am not sure what the code is supposed to be doing, but here is the first
part:

I am trying to make one combo box dependent on another in Access 2002. I
followed the instructions on this page:
http://office.microsoft.com/en-us/assistance/HA011730581033.aspx?mode=print
which had me copy code such as: