Hello all and a big thanks for reading,
I am wanting to open a folder and prosess all the files in it. The first two
lines of code works, but it reads just 1 file at a time and I have to enter
in the name of the file.  Is there a way to have it open a folder then I can

I'm importing an Excel Spreadsheet through code and would like to add an
autonumber ID field during the import process (not by touching the
spreadsheet first).  Thoughts?
Thanks,

I have a continous form in Access (Frm_Update Rate tbl_Main) linked to a
table called LABOR RATE TBL. The form has (among others) 5 textboxes called
HOURLY, MONTHLY, VACATION, [OTHER WEEKS], [LABOR RATE CODE]. The [Labor Rate
Code] textbox is invisible on the form.

Here is the coding i developed. i have the question if a table field (Lot_No)
is a number format. this code is running normally. When i have changed to
text format (Lot_No) in table field. It has an error prompt out. Now i am
guessing the problem is caued by field format. If i ...

I'm trying to use visual basic code to blank out a date in a database in
Access 2003. None of the help programs and books I've looked at have helped.  
When I try to run an SQL command to update the field with '', I get an
invalid type message.  Use of NULL does not work either.  ...

Hello. I have a form set to continuous bound to a table.
For each record of the table i have a Yes/No field.
I want to know if its possible to lock all the controls of the continuous
form for the records that has that field value TRUE.

I'm trying to create a procedure that parses out a comma-delimited
string and returns a specific value in it using the values ordinal
position. (ie. grab "test3" out of "test1", "test2", "test3", "test4")
formatOpenArgsString() successfully takes a string and breaks up as

I want to be able to overwrite tables using Access VB code without a message
box popping up each time asking the user to verify that that's what he/she
wants to do.

I have a problem on the "frmDelivery". After i input the value and press
enter. it suppose to check the tlbReceiving table. if the value is existed.
the related data will extract to frmDelivery and all frmDelivery data are
save in tlbDelivery table. I know and thanks somebody ...

I saw reference to this in a different thread and was interested.  I looked in
Help and on the MSDN site and can't seem to get it to work.  This looks like it
could be a very usfull function but I keep getting "out of range" or "type
mismatch" errors.  Does anybody have a piece of ...

I am trying to set the value of a set of controls on a form programmatically.
Using something like the following code:
Do While Not rs.EOF
   sCtlName = "txt" + LTrim(Str(i))

I'm new to programming in access and I have a file I want to automatically
import into access each month by pushnig a button.  I have the form, and the
button, and the file location but I cannot get it to import.  Any help on the
code would be appreciated.  Thanks.

We have a Access 97 application which was running on windows 2000 Prof
machines. Recently all the computers have been upgraded to windows xp. With
this upgrade, this application gives the following error:
Complile Error: User defined type not defined

I need to record the next output file index number to a table. This table is
called "tlkpStoredStrings". It has three columns: "VariableName",
StoredText", "Description". I want to write this index number to the record
whose name is "File Number". Every way I try, I get an error: ...

I have a form with a two column list box of employee names and the bound
column being set to the employee ID.  I want to be able to select a name and
have their information automatically populate in the form's text boxes to
display their address, phone number, job title, and etc.