On a form I calculate the product of 2 numbers from a table and place them in
a corresponding textBox for that record on the form. The user can update
these 2 numbers or add a new record.I would like to sum the textBox's with
the products from each record in a textBox in the form ...

I have two combo boxes to allow user to select date range. My LogInTime
field has date and time. My following query would not select [cboTo] date,
only the day earlier. (If user, for example, select 7/20/07 in the cboTo, it
only displays records upto 7/19/07). If I add [cboTo]+1 ...

In my form I need to change my Invoice# from number to text. I went to the
table to change it but I cant because it is part of a relationship. When I
delete the relationship and go to change it, it will let me but then when I
make the relationship again and go back to the form I get ...

I'm a new user and not sure how to do this.

How can I send a SNP file to a my aaa folder on my c drive.  Here is what I
have so far.  Thanks.
DoCmd.SendObject acSendReport, "123report", acFormatSNP, c:\aaa

I have a form that has three tabs.  On the first tab, I have three buttons,
each with a label off to the side.  For some reason, one of these labels
shows up on all three of the tabbed pages of the form, while the other two
labels only show up on the first tab (where they belong) ...

How can I open a form in ADD mode. My idea is to open a form in  order that
users may insert data instead of pressing the button new first.
But that form is already used to show data.
Any idea?

I have a command button to open and merge data from the current form record
into a Word form.  The code below loads Word (showing in Task Manager
Processes tab) but it is not visible.  
I'm using Access 2002 and Word 2003

Hi Folks - I have a db that tracks felony charges against defendants. I have
a main defendant form with a charges subform. On the subform, I have 2
fields: Count and Statute. Count is a number from 1 to 999. Statute is a
drop-down that references the master statute table.

I have three combo boxes cboQuartile, cboRating, cboIncreasePercent. The user
selects a quartile and then a rating and then an increase percent. This part
works fine, but when I move to the next record it doesn't requery. I've
received lots of help getting this far and I need a ...

So under each field in my report there are records, and depending on which
field, there are some without records.  Here is an example:
--------------------------------------------------------
NAME        DIVISION        Y/N

I've got a subform that has a table as its record source, and a mainform
which has a query as its record source.  An unbound text box is set up on the
mainform to filter the underlying query and thereby limit the results in the
subform.  It works pretty well.  The problem is that ...

I have a form based upon a table [Sample Details] upon which I display
various fields. On the form, if the field [CertNo] has a value in, I want the
form to be AllowEdits=False, but this may change as the user changes the
record viewed in the form

I have created a form that draws its data from a query to join three tables.
The fields do not allow me to update information.  How can I change these to
accept changes?  Thanks

I am using the «basSetAccessWindow» module to hide completely the Access
window. However I am facing two problems with it and I hope someone could
help me to solve it:
1. With this module activated, the reports don’t work (the program just