Hey all, let me extemporize.
I want a box of text that will change instructions according to what a user
has their mouse on. So if they are pointint to a button on a form, the text
box will display instructions on what that button does...

I am executing a query that creates a table from a TEMPLATE table.
   SQL = "SELECT * INTO tbl" & Me.txtNewStockName & " "
   SQL = SQL & "FROM tblTemplate"
When I run the following command to execute the query I get an alert message

i am using the VBA coding to enable a command button to clear all text boxes
when pressed...  i am using setFocus to select a txtbox, and then setting the
text to "", but i get an error when it tries to setFocus to the second
textbox, when focus was already set to the first...

I am receiving an overflow error when this line is executed...
varSource = Nz(rstExcelRS.Fields(strIndexName).Value, -1)
The values are retrieved from a spreadsheet.  The code was working fine
until it reached the value 38387.  There isn't any calculations, so what

I'm working on an Access Project and I need to update a table (Companies)
with the following info
MainContact = Me.FName + Me. LName
Contact_ID = Me.Contact_ID

I have a calculated control on my form and two fields in my database. I know,
I should not record a calculated control's content into a table, but I still
want to do it regardless.
My calculated control: txt RecordedAmount

I have inherited an ancient green screen system which produced a strange file
output for a major customers EDi app. Luckley the green screen can go, but
only when I can replicate this file format from our new system. I have tried
every veriation of DoCmd. TransferText ...

I have a 9 digit field as listed below:
5001-9700
The 5001 is the julian date (military style) and the 9700 is the first
number in my series.. I would like to restrict the user when entering the

I seem to remember seeing some code, several years ago, in which a table and
its fields were added in code.  Can anyone point me to this code, or give me
a sample?
Thanks

is there any way to duplicate (copy to same database with diffirent name)
'MSysRelationships'  table by writing vb.net code ?
or to remove read-only property ?

I have 2 cascading combo boxes .  The first lists  the 50 states.  The second
lists the cities and zipcodes for whichever city is chosen.
The query for my first combobox(cities) has 2 fields:   stateid. state
The query for my second combobox(cities) has 5 fields:  CityID,city, zip,

I am using the code from Marshall Barton's post above...
   Dim db As Database
   Dim rs As Recordset
   Set db = CurrentDb()

I have a text field that I use to keep track of the lastest revision of quotes.
rev a, rev b, etc.
How would I go about incrementing the alpha character so when the user wants
to generate another record/revision, the form would automatically increment

I am trying to create a date variable in a case statement.  I want to use
DLookup to pull a date from a date from another and pass it to a unbound
textbox to be used in a date calculation.   I have to use a variable because
a textbox will only accept text.  I keep getting a Type 13 ...

I need help badly...
I have a form with unbound fields and a combo box that is linked to a
table, that table is called units. When I selected an option in that
combo it brings up an Run time error '2455'