I have a text box that will have a string of numbers in it separated by a
comma. I need to do a lookup in a table for each number string. ie, the
string maybe 1230,1323,1223,1322 and i need to lookup 1230 from a table, then
1323 from the same table,  and so forth. the data will ...

I am trying to create a membership form that by selecting a yes/no option it
will update the membership date to a new year.  Thanks in advance for any
help.

Access 2007
I have a form that has 18 combobox controls all named starting with
cbx......
I want to be able to validate all the controls to make sure that all of them

What I want to do for April Fools day is reprogram all the command buttons on
our attendance database switchboard such that when a teacher moves the mouse
over it, it moves. I have the following:
Private Sub Command0_MouseMove(Button As Integer, Shift As Integer, X As

I'm using Access 2007 and appear to have a discovered a bug can anyone shed
any light?
I have a form with a datasource and have a simple piece of code that formats
a date to give me the week number of the current week:

I am used to Powerbuilder..
there is fucntion called accepttext(), the purpose of this function is to
accept the data entered by user before doing any update or save in case he
did not hit the tab key or enter key.

I am running code in the current event of a form and I want to prevent the
user to do anything until it's over (not click on any control or on the form
either).
Is there an easy way to do it?

Hello.  I have a situation in which the users are wanting to import the data
(not the table) from other Access2003 dbs to the one they are working on.  
There are 3 other db's that have tables that the users will want to bring the
data from and combine/append into one (1) table.  ...

I have code and description fields in my query.
I need the code on the datasheet subform and only want to show the
description to the user.
I tried to use visible to false, but it still shows the field on the user

I was wondering if there was a way to set the recordsource of my subform  to
a back-end query. I have been trying to put the information from the query
into the textboxes on my subform. i have a way to do it with a list box. but
i need to have it in the datasheet view of the ...

I have a datasheet subform on my data entry form.
The column width is always set by Access which does not apply my data length.
Are there any way to customize the width of the datasheet subform?
Your help is great appreciated,

I have two tables related via an ID field. I have form that is based on a
query on the two tables. When I base the report on only the secondary table,
not a query, I can enter data for that table. But when I set the record
source to use a query, I can't enter data. I'm sure it's ...

I have a form that is set to Continuous and in the Form_Open event I have
the code which "binds it"
Set cn = CurrentProject.AccessConnection
     Set rs = New ADODB.Recordset

In Visual Basic programming (MS Access 2007), is there an instruction that
appears a message or a text if I leave the program alone for instance 1
minute.
Thanks.

Hoping someone can help....
I have a main table that has an auto number field. On my form there is a
dropdown box at the top that queries this field in ascending order. When my
user selects the record id (auto number) then it populates all of the bound