I have a sub form that has check boxes for user input, I want to put
a command button on my form so the user can clear the checked boxes all at
once.
any thoughts?

I have a list box with multi-select activated, this list boxs works great. I
need all (selected) records to be printed on one report. I guess what I
asking for is an example of code to gather all selected records and print
them on one report.

How can i copy or save data to another table?(it's just like duplicating the
same record into a new table).Hope to use vb code to do it in form...tq

I have a form which contains a field for a hyperlink. The user should be
able to edit the hyperlink by pressing the avaliable button. The following
code is then started:
  Me!photo1.SetFocus

I have a Main form with 2 subforms. One of the subforms, frmSub1 contains
records and the other subform, frmSub2 is a sum of the records in frmSub1.
Each time I update records in frmSub1, I want frmSub2 to requery to post the
new totals. My thought was to add the following code ...

I want to be able to move the record forward in 3 separate subforms on a (tab
page) within my main form, but when I set a macro with the ‘GoToRecord’
command, I get the following error:
The table ‘Final Top 10 A’ is already opened exclusivley by another user, or

I have an Access 2000 ADP which is a front-end to a SQL Server database.  One
table I am using has a VARCHAR column of 8000 characters.  Inside the code of
the Access ADP, where I assign a string variable to the SQL table's column,
the resulting value in the SQL table is ...

how do i design an access database table for compiling all the laws to help
prepare me for taking a bar examination?

I mistakenly posted this to the excel programming group. Please excuse
this double posting.
I have these two cboboxes in my app and the 'cascading' works great.
What I need is the coding for ThirdCboBox that would be using both of

Who could help me?
In a form I select a person from a dropdown list and than I check if there
already is a record in the table (with a dcount). If there is, the record
should not be saved in the table after closing the form. How can I reach this?

I have first two columns in datasheet date and time.
How to prevent double entries in rows?
Example:
Date          Time

Hi - I requested help this morning in changing the background color of all
controls on all forms in a database and received the response below - the
problem is I get a Data type mismatch at this line of code: For Each Doc In
Ctr.Documents

I have a query in which I introduce two dates, beginning and end. This query
makes some calculations and is used for a report.
Is it possible to store thise information I introduce for the date so I can
put in the report?

I have added a command button to a form with the following:-
Dim str As String
str = "UPDATE Testtable SET Testtable.CentreId = 1, Testtable.TypeId = 4
WHERE ((Left([Testtable]![CTEXT],3)="PAY"));"

Is there a funtion out there that will print MyFileList for me?
Private Sub Command1_Click()
On Error GoTo Err_Command1_Click
Command1.Caption = "Print"