I have the following expression that takes the last name and inmate number
and combine them.  It works however if the field is blank I get ,0 int he
field. I just want it to be blank.
=IIf(InStr([IN_NAME],",")>1,Left([IN_NAME],InStr([IN_NAME],",")-1),False) &

When I am going throu my Access App. I receieve this error message from time
to to time.
I press the End Button and it continues working as if nothing had happend.
What is it?

I open with the Tools/Startup default of copywrite/title form, database is
hidden.
I want to display copywrite/title form while mainform loads and displays in
the background.

I have a vStartTime and an vEndTime.  I want to subtract one from the other,
and then subtract 30 minutes unpaid time for lunch to see how many total
hours a person worked in a day.
I have tried unsuccessfully to use many variations of the =DateDiff function.

I am generating a SqlString based on various inputs and want to do a SAVE AS
to save the final SqlString as a query. I will use this as a sub query to
generate a scatter plot. My sub query would be named Q_Sub
I will need to overwrite the Q_Sub query each time I run it.

I want to
Why this validation rule dont work?
Len([Text0])<8 And Len([Text0])>10

I am sure I am not the only one to ask this, so hope someone can point
me in the right directions.
I have a working add-in developed with Access 2003 and VBA.  I can
connected in to a database va Add-In Manager and everything works

I have a module called SendTrades which first checks conditions to send an
email, if the conditions are satified, it calls another module, EmailTrades
which will then put together an email and send it off.
It then goes back to the SendTrades function which then launches an update

The following code works with all data types except AutoNumber.  I get a
"Syntax error in field definition" error message.  Can anyone help me make
AutoNumber work?
DoCmd.RunSQL "CREATE TABLE tblTest(XYZ Datetime);"

If we want to send a message to a computer in a LAN, we type the following
command in the "Start --> Run" in Windows.
net send ComputerName 'MessageText'
How can I do that from an Access form ?

i wanna create a software using access. my backend will be visual basic and
front end will be ms access. i wanna feed entire datas from excel to access.
so guide me

This question is hard to explain but basically im getting a runtime error#13
at the bottom where it says: "if strng then". Idk if thats proper syntax or
not but im trying to make it so that i can have a search and a search
criteria withuot doing ALL the different IF combonations. ...

I am trying to create a form that will take Start Date and End Date from the
main form and give me a text box for each year between the two dates.
Example:
Start Date is 05/31/2000; End Date is 1/12/2006... when I go to the second

How can I get the user's full name that is signed into the computer.  For
example, I'm looking to retrieve Bob Jones, not a LAN ID of axcbj.  Any help
would be great.

I was trying to increase the number of threads that a program uses.  
I thought this would do it.
application.setoption "Threads", 10
This give me an error.  What is the correctly way to increase the number of