I have shied away from Access 2007 because frankly it looks to be pretty
screwed up for developer types, and clients of developer types. However
one client is migrating to Office 2007 so I have to deal with converting
the application. I am considering keeping it in 2003 as a ...

I have a form with two fields that I would like to confirm that the values
are equal.
First field requires basic information about an invoice:
fld_Amount

I'm not sure how to do the following. I have a single-selection
listbox. When I select a certain option and click a command button, I
want pre-specified multiple criteria to be used to generate a query.
Example: If I select "Light colors" from my listbox, and then click a

After you use VBA.SendKeys ("^c") to capture data in a textbox, is there a
way to assign this information to a variable?
A simple line of code strVariable = VBA.SendKeys ("^v") gets a compile error
"expected function or variable"

G'day all,
I am using Access 2000 under Win2000 and encountering some exceedingly
strange errors with some of the subforms in my solution.
The usual error is for Access to freeze upon a requery of the subform

I want to have a label that gives the difference of the values in two text
boxes. For example:
Number_visits and Visits_used are textboxes with number values, and I want
to write something like this in the caption of the label:

I am using the following code to calculate buisness days which is working
fine, but it requires input of both start and end dates.
I would like to modify the code to calculate with the input start date and
use the current date if the end date field is null until a date is entered ...

Please help.I am new to VBA.
I want to create a public function and embed it in my startup splash
form that quits the application if date() > mydate unless a user puts
in a value(input box in the function will take this value and assign

How to add item into a combo box using hard code...

Why if the below line of code works with hard-coded parameter values, does it
not work with variables?
These hard-coded parameter work...
    DoCmd.TransferText acImportDelim, RFPSpecs, "copy_tblRFP", _

I have the following code to calculate the correct SUBNET mask & GATEWAY
(depending on the third part of the IP Address txtPartIII):
----------------------------------
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

I have an access form I have been using for four years without any
major problems.  Part of the data entry requires a user to enter a
state two letter designation in three places.  I am trying to modify
the form to use a combo box which displays the two letters of the

A form that opens another form as a dialog form (DoCmd.OpenForm
"MyForm",,,,,acDialog) has its status changed to "not visible" to transfer
control to the main form after some selections are made.
The dialog form status is changed to visible later and I want to update a

My DB has two separate functions that access a table.
One is an administrative function that deletes/rebuilds the table.
The other function is a popup screen that displays the table in a listbox.
Today one user saw the pop-up screen with one valid row on it and then

I've created a continuous form and I'm trying to display (or hide) a control
(text field or button) depending on the result of a combo box entry in each
individual record. Up to this point I've been able to create the code that
will display or hide the control but it does so for ...