I am using two successive DLookUp statements against the same table with
different criteria after a form button is clicked.  Sometimes, the second
statement generates an "invalid use of NULL" error, and I can't figure out
why.  It is certainly not a data issue.  Both calls ...

I'm using this.  It seems to work but it looks suspicious.  Is this the
correct syntax?
Thanks
DS

I have these two DSum statements that I get an Error on because the table is
Empty.
Me.TxtDebit = Nz(DSum("[GiftAmount]", "tblGiftCardDetails", "GiftCardNumber
= " & Forms!frmFXGiftManager!TxtGiftID And GiftDebit = -1), 0)

I'm using Excel to keep data on students
I'm currently describing the state of any particular field as either '*' =
student has started this part of their programme - or a date "15/7/08" to
describe their end/completion date for that same part of the programme

Let me start out by saying that I'm a bit of a novice when it comes to Access
so I'm probably not even usuing the right terms and I'm probably taking the
long way around)
But anyway, in a database that I'm running I ask the user a couple of

I think this is really easy to do, I just don't know anything about
coding, so I don't have a clue.
I have a form with 5 fields that looks something like this...
Vehicle Name = A     <---Combo box (A or B)

I'm a newbie.
I have a form named "Form1" that has an unbound listbox that shows me the
dates from a table named "Invoice".  I need to open my report named,
"PreviousInvoices" with the information from my table for that selected date.

I have a db that has the form Job Name
This form also has several page tabs that have sub forms on them
What I would like to do is to be able to know what sub form has data in it
without clicking on that tab

I am fairly new to Access 2007. I would appreciate any help with the
following:
This is what I have: Many tables, each with the same settings, but
different data. A form with a drop down box listing the names of each

Does anyone know how to manage security settings of Outlook to allow code in
MS Access to use objects in Outlook?
We are using Office 2007 in a corporate environment.  Trust Center in
Outlook appears to be set to allow programmatic execution from an

Hi how do I work out the difference between to dates and times based on 24
hrs being one day
20/07/08 11.00 hrs on hire - 28/07/08 13.00 hrs off hire   would be 9 days
because it has gone past the 11.00 hrs

I'm trying to load an Access 2003 file into Access 2000 but get the
following error:
Run-Time error '2114':
Microsoft Access doesn't support the format of the file

I have some combo boxes that I only want visible based on certain selections
in another combobox.  I have no problem using Me.Type_of_Vendor.Visible =
(Me.Type_of_Contact = "Mojo Ticket"), and it works perfectly. My problem is
that I need this combo box to be visible when Mojo ...

We have an Access 2007 front end to a MS SQL Server database with a bunch of
employee data to include names and e-mails.  The goal is to add a VBA
function to the Access front end to generate distribution lists based on
data in the database.  I actually had some code that did this ...

I've been trying to figure this out today with no success.
I'm working on a clients code that has forms attached to parameter queries.
I don't have a choice to change all their code to get the parameters before
calling the form, so I'm limited to no rewrites.