I have a textbox (txt_StartDate) and I have a listbox (lst_CableEnds).
The listbox picks up data from a query (qry_Cables) and the contents
of that listbox are Bin Number, Date and Quantity. Just to make
something clear txt_StartDate and Date are two different fields with

I have a report to show different datafields.
Is it possible that, if one field has no data to show or if the value is 0,
the field is invisable?
If yes, please be as kind as to tell me how.

What Happened to the SetWarnings True/False ability in Macro - MS Access 2007?
I can do this via code, but wanted to know what happened to our other Macro
functions?
Thanks in advance

Can a log be created that shows a name was changed on a certain date at a
certain time by a certain user, etc.?

I have a contact database that I need to import data into on a weekly basis.
The data is in an Excel file with client and contact information all in one
record (one row).
I need all the client data to go in the client table, and the contact

I am recieveing an error message too few parameters, on the following code
below using an INSERT statement.
 Dim DrivePath As String
   Dim dbs As Database

I have quite a problem with relations, imagine a table Clients and a
table Products. if i relate them one to one... i would have the table
Products with a list of products, price, quantity, date, and a yes/no
object called Buy(to return results on a query for reports) the

Does anyone knows when will be available.
My app are in Acc 2002, and they don't work on Vista unless I convert them
to 2007.

Can anyone tell me how I can set up a form to import an excel sheet into an
exisiting table in access?
Thank you!!

Hi, i now have a problem with opening a record set of a table, i want it to
give me field 2 from the lookup and not the bound column, is this possible ?

Dim i As Long
Dim j As Long
Dim cnn As ADODB.Connection
Dim rs1 As ADODB.Recordset

I'm building the following expression:
after5: IIf([TimeAssigned] Like "6:*PM",[CustExp2]+1,(IIf([TimeAssigned]
Like "7:*PM",[CustExp2]+2,(IIf([TimeAssigned] Like
"8:*PM",[CustExp2]+3,(IIf([TimeAssigned] Like

Hi all,
Fairly new to Access, taking a class, and trying to do something at my job.  
I have an accounting spreadsheet for preparing invoices to be processed.  I
imported it into Access without a hitch.  One of the fields is 'month', and

I am maintaining anumber of Access 97 databases (Ueah, I know -Upgrade. Will
happen soon)
All DBs are Front End Pointing to back ends.  There is one major backend and
several others.

i made a dbase for students,what i want to do is that every changes i made in
the form will be automatically displayed when i click the report preview
button..what coding should i do?..thanks