I've written a function that figures number of days from a given date. It
works well, but I am trying to make if fly from within a subform and make it
plug the result into a field in the parent form and I'm not getting the
syntax right. Everything within the If statement works, ...

I have a form based on query that filters on a user’s Sales ID, when opens.
for example the form for a specific user has 20 records; 10 of them are
locked (budget) and 10 can be edited (forecasted); Once the first forecast
record is found and a filter is applied to get just the ...

I have an access database that tracks all "stations" I created a main page so
when we have new information to add to an existing station we just select the
station from the combo box drop down list (there are thousands of stations!)
when you select the station you want (ie F12, ...

I am designing a form that allows a user to specify query conditions.  I run
into trouble is the user does not want to limit on a particular item.
I have a form, fDrill that has three combo boxes, once of which is for the
customer name, cboCustName.  The query that uses these ...

I have an error that only occurs now that our A2003 database is running in
A2007.  If we open a certain form, use the sort buttons on the Access
toolbar, then close the form and then the database, we get the "you attempted
to open a database that is already opened exclusively by. ...

I am trying to import records (Excel) to a database. It would be nice
if I could import through the all database structure, but it is OK to
import table by table (I will 'connect' table records latter using
regular form). There are no required key fields (pointing to other

I have a combo box that's used to navigate records either by making a
selection or mouse button scrolling it. The problem is that read-only
users can't use it as the AfterUpdate code is disabled for them.
What's an "easy" AfterUpdate code for comboxes that will allow all

I have this search form, which I need to make it look for each criteria and
the next...instead of just one of them.
I'm not sure how to do this?  
Private Sub Command12_Click()

I was wondering if it is possible to create i button with in custom
toolbar I've made which which will enable me to PDF, Current open
reports.
ive manage to create i button which will do this from a list of

Below is the SQL for a query that I have that sums how many documents were
issued to a department for a specific month.  The users select the month and
year from a form via combo boxes (that way they cannot select more than one
month for a date range).  Then I have hidden text boxes ...

I have form with some nested sub-forms, and I need to go through all
textboxes and combo boxes, when user changes data (Dirty event). I'm using
Access 2003.
Is there a way, how to do it?

A form holds some code that performs database health check.
As it can take some time to perform, it is possible to halt execution,
closing the form......
...but..... the underlying code, keeps executing......

How can I keep from getting the "Invalid use of Null" error if the
dateofReferral is indeed null?
vRefDate = DLookup("[dateofreferral]", "tbdetail", "RecordID =
Forms![frmain]!cbPatientList")

Using Access 2003, SP3.  I have this code when a button is clicked:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
When this line tries to execute, I get the error "You canceled the
previous operation".

Access 2003/Windows XP, continuous form.  Looking for a way to modify the
content of a hover-generated Tooltip depending on the value of the textbox
over which the mouse is currently hovering.  Specifically, the field in
question contains department names, and when the user ...