In Access 2003, when the user is in a bound form, rolling the mouse wheel
causes the recordset to go to the next or previous record and refresh the
screen.  I'd like to disconnect this feature; for one thing it is causing a
bypass of validation checks I've attached to anything ...

Calculating a past date in Access that excludes weekend

I can't get this to wotk the way I want it. here goes:
I have a form which contains a subform based on a query of TableX. The
subform order is a time field in TableX. By double-clicking a record
in the subform, another form is open, which can edit a record (of

using a2k again....
i typically don't worry about the public-ity of variables but i think this
is one place where i want to...
i have a form and on my form i have a BeforeUpdateEvent wherein i declare a

I have some code that works well if there are already records in the table
components1.  if the
count returns an empty record set, it gives an error.  I need to have the
value

I have a combo with a query LOV, it's a selection of T-shirt sizes from a
table.  Works fine and can select values.  But I want to have the LOV get
smaller as the sizes are not available.  So I have the LOV query based on
More=Yes.  The LOV is limited fine.  My problem is the ...

I have a form which is populated with a query and displays people.  One field
is a COMBO box which looks up values from a query of available shirt sizes
from a separate table.  The LOV works great and the values display.  The
problem is that  when I change the available shirt ...

Ok have it set as primary key.  I have everything I can imagine done.  I even
have it working just one big problem.  When I go to the form and select the
ID for the title  it puts in the number where the title should be.

I would like to run a sql command on a button wich inserts values from one
table into another based on values in two combo boxes.
It would have to look something like this, but it doesn't work:
CurrentDb.Execute("INSERT INTO tblNameX ([Id],[ValueX],[ValueY]) VALUES

I set up a database with control tabs but I'm finding it annoying to stop and
grab the mouse to navigate to the next control tab.  I'd like to build a
macro that will programmatically move me to the next control tab but I always
end up with a separate pop-up form.

I'm trying to run a DELETE sql statement, based on two ComboBoxes.
CurrentDb.Execute ("DELETE FROM tblOne WHERE tblTwo.[Id] <>  " & cboId & "
AND tblname.[name] <>  " & cboName & " "), dbFailOnError
Both seperate they work fine...This AND statement will not work?!

Hi, I have been converting an Access 2003 application to display images from
files through an image control rather than embedding images in the database.
I have used the knowledgebase article here as a guide:
http://support.microsoft.com/default.aspx?scid=kb;en-us;285820

I have an application with FE and BE.
When I copy the front end to each computer I would like to check if all the
references are valid to avoid
'Missing' in the refence list.

I have got another problem here.
I want to get data from table A and copy it into table B.
I dont want to use query as i want the user to be able to update data in that
form.

I have a sub form that flickers when I open the master form.  It stops
flickering when the mouse moves over the subform or clicks on the subform.  I
am using conditional formatting on many textbox fields to change the color of
the record selected.  The conditional format for each ...