Hi;
Dumb question, but I have a query and i want to accept the record if a field is blank. I
have tried criteria of ="", isempty(Fieldame) and a rich variety of other things with no
joy. How do I accept a record in a query if a specific field is blank?

I have a control that calls a form and that form has a control that
calls a second form.  how can I set it to close the first form when
the second is called

I have a monthly safety slogan competition which requires back
checking to a list of already submitted slogans. This takes forerver
to do. I have 2 lists: this month's slogans and a master list of all
slogans.

How can i email from access and hide or change the senders email-address?
Why:
Quotations for a house are made by several salers with an Access-interface
on the firms server ( Remote Desktop) . When sending the report by email to

I have used recordsets in my query but only referenceing an sql string and
not a query. I tried to reference a query that was created but it falls
over.
I have that works:

I am getting locking errors while using a split database and a shared back-
end. The front-ends are setup to open in "shared" mode and record-level
locking. We are using Access 2000 and 2003 as clients but 2003 clients are
setup to save in 2000 format. Any ideas how to correct ...

Is there an easy way to enter lots of duplicate data in Access, like
you can in Excel by just clicking and dragging? I have various fields
that require the same data for each record and I can only find
reference to repeating whats in the previous field when trying to

I've custom-built a fairly extensive object model that is designed to
run in the background
and control the opening and closing of related forms.  The whole thing
kicks-off with an

I would like a query to show all if nothing is selected in the combo box
on a form.  I've used the following:
IIf(IsEmpty([Forms]![frmRptDates]![cmbPrvdr]),Like
"*",[Forms]![frmRptDates]![cmbPrvdr])

I am developing a database to track inspections conducted on homes. I
have two main types of inspections, Punch & Final; however Final
inspections have 3 possible sub-categories: failed, with exception, no
exception. Each home will always have one Punch inspection; however

Hopefully, someone will take the time to answer this. I have MYSQL
back-end data source that I would like to link MSAccess to. My goal is
to use Access to query specific pieces of information from the MYSQL
database. I have downloaded the ODBC driver from MYSQL and managed to

I have one Access 2000 DB on my website. I want to access these tables
from my local database so i do not need to down-/upload the database
each time i want to make changes.
Meanwhile i want a external partner to access (just read) another

I have a single (not continuous) form with an Undo button for entering
finished projects. On the form is also a subform that lists all finished
projects for reference. When I enter the CompletionDate which is near the
beginning of all the fields, I would like the current project to ...

Hello.
I use the following line which returns the path of a file and adds it to
a listbox. How can I modify this line so that it only returns the
filename and not the entire path?

I have a slight problem. I have a form that I designed without a header, and I
subsequently decided a header was required.
In design I went to View/Page header footer, and it appeared nice as you please. I then
put in a heading and clicked on Form View, and the header vanished. It ...