Hi
I am using a table to import data from text files.  the text filess are
daily files with about 60K rows per day.  So after one month, I clean out the
data and I want to reset the auto number

I am using a loop to iterate through a list and sometimes need one vbTab in
the code, other times need (2): vbTab & vbTab :
For each Tcolumn in rs.Fields
 strMy=strMy & vbTab & column.Name & vbCrLf

Not exactly sure where I am likely to get an answer to this question, so
have cross-posted to a couple of Access and SQL Server newsgroups.
I've got an Access database that I need to migrate to SQL Server (too many
users over a wireless network).

I have a form in my database that contains a listbox of card numbers.  This
listbox is a multiselect listbox.  I also have a combobox with employee
names.  I want to choose an employee name and then select multiple card
numbers and when i click a button I want the cards to be ...

I am trying to sum up values in an array. Since I am using real
numbers (with decimals), I have declared the array 'as single' .
Unfortunately, whenever one of the items in my array is null, this
causes an error when running a For ...Next routine since ACCESS cannot

ufTimeReg is a subform with a datasheet. SelHeight = 0 when I select several
records with the mouse. RecordCount has the right number of records.
Do I have to change any property to get SelHeight containing the number of
selected records?

Dear Friends
I have got 2 nos  combo boxes in my form
On focus event of 2nd combo following actions must happen
   1. automatic drop down on focus if current value is null

Please help. I cannot figure out how to refresh (requery) a record in
a subform.
Main form is frmClient
Subform is frmClientReferralsubform (subform and source form have same

I have about 4 excel workbooks that related to my db.I want to include
these 4 workbooks as one package with my DB.I create a package cause
need to copy to another computer.
Let say their names are MyWorkbook 1,2,3,and 4.

Because of the rather strange design specs I have been given, the same
subform appears four times on a single form. Each instance of the subform
appears on a different tab of a tab control and is linked to a different
master field on the primary form. Put another way, there are ...

I am having problems assigning the values of several repetitive
textbox controls to an array. I can't seem to get the event procedure
to save the values to the array rather than the name of the control:
Below is my code:

Is possible to know (is the file exists)
Is possible to know (If folder exists)
What I want if the code find the file or folder (display message box (the
file exists) else (the file not exists)

I'm not sure if I'm on the right track.  I have a MainForm and SubForm.  
When tab to end of MainForm, SubForm is populated through an append query.
Works very well.
Here is my problem.  

We’d like to store the reference (for lack of a better word) of a control in
a variable for future use.  For example:
Me.Suffix1 is a text box on a form so things like Me.Suffix1.SetFocus will
set the focus to the text box.  When we loose focus on this text box we’d

I have 3 Tables - that each have their own data entry form.  All 3 tables are
related through a one to one relationship.
I have added the following code to the AfterInsert event of the parent form:
Private Sub Form_AfterInsert()