I'm quite new to access & to VB. I'm working with a database which
through a form, you can generate a pdf report (using pdf995). Choose
the report from a dropdown box, and then click 'View Report'.
Every month I need to generate about 30 different reports and so was

I have to get public variable value using variable name.
Evals("myPublicVariable") do nor work
How can I do?
thank you

I'm trying to use a command button to the same thing as going to the
file menu and doing a Get External Data command to make the import
process easier for some end users. I'm using Access 2k, I have the
following code but I can't seem to get it to work properly.

I'm working on ADP (access/SQL server) project and I have bounded form
to a Sql server database. How can I commit or confirm insert in table
of new record when user clicks on confirm button? Actually I want to
confirm creation of identity field in that table so I can insert it

I have a form with a continuous subform.  I am working on putting
validations in for the subform's required fields.  Being somewhat new
to Access (or rather, an antiquated mainframe programmer), I finally
figured out that the place to put the validations is in

I am using SetValue to change the DataEntry property of a form to
"YES". But It doesn't work. No error messages, but the property didn't
change.Following is the what I am writing
SetValue:

hey, guys,
I have a simple question --- simple only for you. I created a combo box
called "pick up a name". And the underlying table has lastname and
firstname columns. The full name can be showed in the pull down menu

What event can track the menu-item or shortcut-menu-item 'Remove
Filter/Sort' - click.
Or the opposite op Apply-Filter-event.
Thank³,

All 12 of my department's machines are being converted next week from
Windows 2000/Office 2000 to Windows XP/Office 2003.  I have downloaded
the Migration document from Microsoft for distribution but would like
your input regarding Access as many of our group use it.

It would be great if someone can help me with this.  It seems like it
should either be easy (so far, not!) or maybe it isn't possible.  Here
goes:
Table B has TextField1 that looks up values from a single field in

Here is my issue. I have created a form called ?Search? that has several
unbound combo boxes, one for each of the attribute that match a column
in the Table [Movie Titles]. Each combo box has input from a separate
table that limits what the uses can select. IE. The Genre table feeds ...

I've got a text box that I want users to paste a list of values into
(from Excel for example). However, breaking this large string down into
its component records is a little harder. I've used left(), mid() etc
but they depend on a set number of characters for each line. I'm

Just wondering if there is a way to retrieve a list of the names of
custom properties (not inbuilt) after they have been saved to a db in
order to populate a listbox? I have around 5 custom properties but
possibly more in the future and rather than hard-coding the names of

I have an application in which I update a sql database from access
append query via linked tables. I use an ODBC connection with sql
authentication. I would like to hard code the sa password so the users
would not have to enter it each time the query runs.

I have a drop-down list that gets its listing from a table 'Therapy'.
There is no other information contained in the table.
My problem is that when used, the list is reversed alphabetically (when it
drops down).  I have tried doing a sort in reverse order on the table, but