I know that MS Access has size limitation for 2 G.
I would like to know are there any solution for size bigger than 2 G.
Split the database in 2?
Does it mean that i export the old data to a database and change the query

I have a datefield in a form that I would like to have autofilled when I
enter a new record. Right now I have something like this:
If Me.NewRecord then
   Me.DateGauged = DMax("DateGauged","tblGaugesInput") + 1

I would like to double-click a text box to select the text and have it
automatically pasted to another text box on the same form.
Any ideas?
Thanks,

I have a form CLIENTLIST.  When I open this form it runs the query
qryClientLst.  One of the fields in the query named ClientID has the criteria
"Like [Enter Client Number]".  When I open the form CLIENTLIST I'm prompted
to "Enter Client Number".  When I do the form opens and ...

I have a combo box called [Title Pick] that I use to display catalog titles
to get to the record for that title.  I also have a text box, called Title,
that shows the title I just selected in the combo box.
In addition, I have several navigation buttons used to go to the next

I'd like to have a small button next to specific fields in my form, which
when clicked, will allow the user to search all records relating to that
field. In my case my serached vehicle will be Vehicle Regstration, Surname,
Reference and Accident Date.

I am trying to password protect a form.  I am terrible in coding and tried to
use the code from other posts but it didn't work.  Here is the code for the
button to access the form.  Would someone be kind enough to help me with this?
Private Sub Command13_Click()

I am trying to email a form with a command button that uses Outlook to
email.  I am using the following code:
Private Sub btnEMAIL1_Click()
Dim mess_body As String

Access XP.
I have a table that has the fields "Extension code" and "Description" and
I have a form where an "Extension code" is going to be entered following
this criteria:

I created a Form / Subform using Access wizrd.  I want to be able to go to a
new record on the Form when I hit enter on a control on the subform - which
will goto a new blank record on the Form & Subform.  Do I do this in Code and
how would I do this?  My VB skills from 1-10 ...

I'm using DAO to process a recordset, I build SQL using
replace(MyName,"'","''") because primary key contains names which may have
apostrophes.
I do a FINDFIRST looking for the key, I get a NOMATCH on the record even

I have treeview and listview Active X controls on a form.  When in form view
when either of these controls has the focus I would like to display some
descriptive text in the status bar.  Unlike other Access controls, these
Active X controls do not have a status bar text property. ...

I have two tables - one position, one personnel - which has a 1-to-many
relationship (1 position record to many personnel records).  The department
had a new requirement which made it necessary to change some coding (I
inherited this).  I'm using tab forms so that when a position ...

I am wondering if someone can help me.  I am using access to create a
survey/questionnaire that children with disabilities will be using.  I
am trying to make it user friendly for them and I am at the beginning
and already hit a snag.

We have a DB for data collection/telemarketing with a form and some VB
code. This one is created in Access 2000.
Can Access 2007 users open and work with this DB without causing
problems if it later has to be operated on using Access 2000?