I have a split database where the users have a local copy of the front
end.  I would like to use VBA to check whether the users have the most
recent version.  I have set up the following tables:
tVersion-Back-End (link to table in the BackEnd version)

Good Morning,
I'm currently working on putting a 'yes/no' dropdown box in my Access
form, without table lookup for the 'y/n' values.  I had read that the
table field for this could be 1 char long, with a validation rule of:

When trying to access internet I received a message stating cannot access
whilst offline.  This message locks the window so I have to use control alt
and delete to clear.   How can I stop this happening?

Is there anyone who can help me out with this question.
How do i create a button to Compact & Repair?
Any help with this matter would be greatly appreciated.
TIA

Each time I try to go into the internet I get a box up saying can't access
whilst working off line.  This locks the screen so I have to do Control Alt
and delete to clear it.  How do I clear this.

All nigth long and still do not know how to fix this query,
This works fine until finds an apostrophe and I guess any other
strange character
Run-time error '3075':

I have a stored query like this called VAL_REZERVE:
SELECT "Currency revaluation reserve" AS ITEMNAME, ValRezerve() AS
AMOUNTINT_LVL;
ValRezerve() is VBA UDF. This query works fine when I run it in by

I want to have a form filtered by the value in a combo box.  I have a
table that has a Date, SSN, contract number, and 2 dollar amounts.  I
want to select a SSN from the combo box, and then have the form show
all of the contract numbers along with the values.  I also want to be

I have a macro in Access that I want to run when someone clicks a
command button.  The code is as follows:
Private Sub Terminate_Click()
On Error GoTo Err_Terminate_Click

I learnt at some point that it s more secure to set the queries rights at
owners level rather than grant rights to the table itself.  and i have been
doing that, but quite blindly.
could someone clarify as to what is the exact benefit of doing this?  what i

Hi All, I have a form that displays three columns labelled Science,
Maths and Languages. Below each column is a command button "New
Records". Upon click the button a new form (frm_NewRecord) opens up
allowing the user to enter a new record. This form (frm_NewRecord)

Good morning, I wonder if anyone can offer some suggestions of what
might be going on here.
I have an access db/program that has a from that is filled in, and
that form has some sub-forms.  This has been working fine for months.

Good morning, I wonder if anyone can offer some suggestions of what
might be going on here.
I have an access db/program that has a from that is filled in, and
that form has some sub-forms.  This has been working fine for months.

I have two note fields on my form named...
1 - Today:
2 - History:
Client enters text into the "Today" field

I have a DB sitting on SQL S 2005 Express and can create a new Access
project adp to connect to that db but I can not create any other
objects such as tables, views, procedures or database diagrams on the
access project which is connected to the db on SQL server 2005