Hopefully someone can help, as I'm sure this is pretty easy for those that
know what they are doing!   I want to know how to change
           if UC1.Value = CDbl(Text496.text) * 94.45/1000  
to include

I teach at a detention facility and I have a Data Base with 2 linked tables.
One is an intale table for students. After meeting with them it is determined
if they will attend class. I would like some of the fields in the intake
table to go to the main table upon me typing ...

The following statement is generating a 3061 error - too few parameters. How
do I refer to a control on a form? e.g.
strSQL="SELECT OrderID from Orders WHERE OrderID = Forms!Form1!OrderSel;"

Hello, I have searched for help on this but it just has me stumped. I
tried doing several different things, but none of them worked.
Here is the Scenario:
I have a table called Table1 and that table has several columns. Two

Hello,
I have taken the advice of Tim and Dave (thank you); however, this is what I
am running into now.
I created the following expression:

Following code is working in windows 2000 which uses MDAC 2.5 while same is
not working in Windows XP which uses MDAC 2.8. This is regarding Table
defination of DAO 3.6. Anybody has solution to work this code on Windows xp.
=====================================================

If I use a combobox can I then use the value to make some test boxes visible
At the moment I have
Dim stdstring as sting
Dim i as integer

I'm trying to make Doug Steel's DSN-Less code work for an Oracle connection
via an MS driver.  My connection string looks like:
   tdfCurrent.Connect = "ODBC;" & _
          "Driver={Microsoft ODBC for Oracle};" & _

Hello, we are creating a database to use in a Pawn shop business. All
required areas have been set up but somehow we are not able to get it to
create a new record after the intial record is input and saved. Can someone
please help guide me on this relatively simple process that I ...

I was successful with freezing the panes with my code. my code is in a
module which is called a few times by a sub. the first time the module
creates a new spreadsheet and then every other time it opens the existing
spreadsheet. on these subsequent iterations, the spreadsheets ...

when i press f1 to get help about any visual basic word like
"msgbox","isnull",etc
i get an empty  box with title "microsoft visual basic help" - i try to
uninstall office  and restart my computer and install office 2003 again but i

Hello,
My question is...
I am trying to write a code that will open a form or another table depending
upon whether or not a certain number is entered into a field.

I posted a similar request earlier but the browser crashed so I don't think
it got posted.
I have an application where I wish to open a form, enter some information,
close the form using a button open the next form, enter some information,

I want to reference the table names in one Access DB from another Access DB
via code. Any suggestions on how to do this?
Thanks in advance!

How do I disable the "You are about to update x Row(s)" message when I'm
executing an SQL statement from code?