I have a text box that the users enter a number between 1 and 10. If the
enter a number between 1 and 5, I want a yellow box to appear; if between 6
and 10, I want a blue box to appear.  I've been able to code it partially but
don't know how to make the range included (if between ...

Using vb in access 2003 i end up with a value of 1.006
i need to get the 1 on its own and the 006 on its own. Is there a function
that will remove the numbers to the left of the decimal point and to the
right of the decimal point?

I have a report that is linked to a query which has around 52 fields that
change when the fiscal years changes.  For example the fields may be
txtFY06sales, txtFY06inventory, etc....    Also the linked data fields in the
query are similarly named.  Changing the query is no ...

I have a access project for attedance backend is SQL.
I have a mdb/vba code which needs to be converted into sql,
can anone help me formulate this:
Private Sub Command4_Click()

for the sake of simplicity, This Table has a column for names and a column
for seating assigments,
Joe, table1
Mary, table1

I perform filter on subform.
After filtering I want to append values from column of subform to another
table.
This code is not working :

I manage an event database for foot races.
I have written VBA code to allow users to set the default
length of the race. But everytime I attempt to execute the
code, I get the following error:

Every time I try to enter an event or access the code builder I get the
following message:
Runtime Error!
Program: C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE

I'm doing a task scheduler macro that is deleting data from a table and then
adding
a new data there.
"C:\Program Files\Office\Office11\msaccess.exe" "C:\SomePath\MyDB.mdb"

I *hate to, but, have to* do this for reasons beyond my control : pure
easthetics and no functionality.
I have a Company Logo that looks a lot like a coin. I've to flip it (i.e.
rotate) on the sign-on screen.

#1       Today, 02:57 PM  
llkhoutx  
Registered User   Join Date: Feb 2001
Location: Houston,Texas USA

I am trying to use a hidden form to check out certain events happening with
its OnTimer Event. The timer interval is set to 1000, i.e. one sec. Is that
going too hard on the processor ? The screens are acting crazy (flickering
and all), though the code is doing what I've asked of ...

hi, how to run a query in my form_load (ms access 97) so it set the
value of the query to a textbox (txtinfo) and put the value in my
tblInfo table. My query is Select count(project) from tblproject;

I inherited an Access 97 db that is running on a windows XP box, and it has
started running into memory errors. This may not necessarily being a DAO only
question, but the code I am working with is DAO/VBA.  
 I have ruled out drivers as a cause of the errors, as the application ...

I have some tables in my Db that are password protected. I am automating
multiple steps in a Macro and would like to build in a step that reads the
password. Someone had recommened the sendkeys Action in a macro, but that
doesn't work for me. I have tried to set up an Autokeys ...