I have a database function I'm trying to create which will upload a batch of
files with a naming convention of "BDMMDDYY.TXT". The upload itself is not a
problem, but I also need to add the transaction date of the file and the date
of the upload to the table as each file is ...

So far I have the following in a .vbs file it works with one exception. It
opens the database but not in full view "Maximized". what is needed to fix
this so it will open in full view?
Thanks in advance.

I need to deploy an access application to my client. Althought it is a fairy
complex application, it made only use of Access's features and some Office's'
features.
I know that to deploy the Application I need to use the  Access Developer

Can anyone recommend a company that puts on half-day or one-day VBA seminars
for Access? And if it covered database security and other advanced features
too, that would be great.
Thanks!

I am automating a vehicle fleet operation.  Two of the tables are tblDrivers
and tblVehicles (both with lots of fields) including memo fields DCmmts and
VCmmts respectively.  I hope to post a few selected events to the respective
memo fields for historical purposes.  For example, ...

"You loaded a form or report that has controls or properties that Microsoft
Office Access does not recognize and will ignore."
This error comes up using a database that has not been altered for a month
and worked without error once before.  Using Access 2003.

I am trying to find the first record and next record without using the Access
menu bar binocular control command button ie(The Find in Field) button.  I
wanted to be able to use just part of the string.  I was trying something
like:

I know how to SetValue in a macro.  I'd appreciate someone explaining to me
simply how to do the equivalent in VB...
Form1 is open.  Form1 has a primary key field "Form1ID"
Form2 is opened from Form1.  Form2 has a field "Form1Link"

I have a database and everything is fuctioning (thanks to Allen Browne MVP)
now I would like to reset the number ID back to 1 (one)
any suggestions?

I’m a struggling learner on programming and would appreciate some help.  This
is where I’m up to:
I have read several introductory articles on programming as referred to on
this excellent site.  As a result I can do one or two basic commands like

I have a module that converts access reports to pdf file formats. I
need to programatically turn on and off the Adobe PDF printer option
"View Adobe PDF results" this feature, if checked, launches the Adobe
acrobat program when pdf creation is completed. Thank you for your help

Found post 8/20/2005 from ofer and tried his solution. Also consulted on-line
docs, but still having no success passing a command line argument. Latest try
was this in a shortcut:
"G:\Access Projects\Scanning\Scanning.mdb"  /cmdHOME OFFICE

First of all, here is the code in question:
Function AutoImportImportFiles() As Variant
Dim strFileDateMonth
Dim strFileDateDay

I am a noobie, I have built a database that has 1 form getting it's
information from 1 table. this form sends the information to several reports
and autofills the information from the table to the fields in each report.
what I would like to do is (without having to learn VB) make ...

Is there a way to automate the naming of .pdf output in VBA using Cute
PDFWriter (or some other PDF-creation package) so that it can create the
PDF's non-interactively (i.e. using VBA to push the file name to the printer
driver).