I need help validating input mask in a single field on a form.
my input mask in the field "Ref#" is 000/00
the first three digits "000" represent the number of entries for the day and
the last two digits "00" represent the day.

I have a table with 10 fileds. Out of which, a combination of 4 fields make a
primary key.
In the dataentry form, when the user enters these 4 fields, i would like to
check if they make a unique record and not a duplicate.

I need help!I have to check is one table example first column is related to
other table second column, where i have to use tables an columns names.
Also i have to check join type from -"Join Properties" and integrity from
"Referential Integrity" . how can i do it?

I installed SP3 for office 2003 and now I cannot build my project from source
safe. Numerous errors result. If I uninstall office and then install SP2, all
works well again.
Anyone else having this problem? If anyone has an idea or fix, please advise!

Can someone tell me how to write a vba code to open an Access application
(MyApp2_rev_n.mdb) from the same folder as my current project (MyApp1.mdb) as
shown in the example below.  MyApp2_rev_n.mdb is rev controlled and the name
is stored on zDbName table in MyApp1.mdb.  Thanks ...

I need the solution for 3 Simple expressions. Sum and subtraction.For example:
subtotal1 + subtotal 2 = TOTAL
subtotal 1 - subtotal 2 = TOTAL
date1+7 days= DATE 2

Based on what I've learned on these posts, I've gotten my multiple forms
instances running nicely, and referenced in a collection.
I'd like to ensure that if a user has one instance of a form open with a
particular record in it that they don't open that same record in another

Hi,
I am trying to create a database that has a few table and forms. But the one
i am working on is a form that has a table that i created from a query made
into a sub form. The table was made from the  form.  I would like to be able

I want to disable the standard menu bar in my application. I tried doing it
through Tools -> Startup options, but nothing seems to work. Can someone
explain exactly how to do this (and leave nothing out in the explanation
please!) ? Thanks.

According to the documentation, if you go into Access Options, Current
Database and uncheck Display Navigation Pane this should hide it.  It does
not.  The navigation pane shows up the same regardless of how this box is
checked.

I would like to use an if... then statement as follows
if string1 = string2 or string3 then
I get a type mismatch error though, since, I guess, "or" only works with
numerical values.  How can I compare the string to more than one value?

I have a VBA script that reads the contents of a text file to a variable. In
order to send it to another system I have to encode the string to ISO 8859-1.
Is this possible using Access 2003 VBA?
Thanks.

How would one determine the sequence number of 6 random lottery values
between 1 and 53. If the lowest possible combination was 1-2-3-4-5-6 and that
was sequence 1, then 1-2-3-4-5-7 was seqence 2...and so forth. I could build
a nested loop, but that would be terribly slow. Is ...

I cant find how to to change window state of access window(like minimaze,
maximaze) from access application object. Also there isnt any width and
height either. So if anyone have found where these properties are hidden
please tell me.

How do you determine which version of Access was used to launch an
application ?  Basically, on startup, I want to be able to read which version
was used.
Thank you.