I have the following VBA:
Private Sub Command32_Click()
Dim intPos As Double
intPos = DMax("[Position]", "tbl_SubPosition", "[ID_C] =

Hej can i change the font color
in the propmt in my inputbox?
Alvin

Anyone there who can point me to any paper or any on-line documentation on
how to create installer packges for Access application using Installshield X?
thanks in advance.

i have a macro that when you update any of the fields/control it then puts
the date and time when last updated. does anyone know how to tell which
field/control has been updated?

I'm attached to a Sql Server through Access.  Every where
there is an appostrophy it is replaced by I&#8217.  I'd
appreciate any ideas on what the problem is.
Thanks so much.

I'm using MS Access to crawl thru my file server and for all office files
get their properties.
MS released a dll that does this nicely (dsofile.dll).
However, I would also like to grab all the text out of specified documents

Could you help me with code to loop thru the current database to identify all
the table names in that database?
Thank you.

How can i do so my msgbox come's
when i open my database
The first thing i want o see is my msgbox
Best regards

I want to use an Open File dialog via code to enable a user to select a file
to import. Once the file is selected, the code will do the rest. Excel has a
GetOpenFilename function. Is there a similar function in Access?
Thank you.

Windows 2000 Pro; Access 2000
I have been tasked with revising a major Access/Excel integrated APP because
of a  recent company merger and organizational changes. One of my first
priorities is an attempt at normalizing the "central" database which now has

Is there anyway to use Eval to programatically open up a form with arguments?
For example I get an error when trying to do the following:
eval("DoCmd.OpenForm
""frmSelect_RejectedDeliverables"",0,,,1,3,""openargs1"")")

Thanks for taking the time to read my question.
I have 5 fields named UpdatedTo with a number at the end
i.e. UpdatedTo1, UpdatedTo2, UpdatedTo3, UpdatedTo4, UpdatedTo5.
in my With statement, how can I iterate through these names with a variable?

Need to automatically fill 2 fields, when I choose an entry from a combo box.

In order to avoid the Outlook 2002 security issue, I changed from the
SendObject method to the Redemption method.  The Do.Cmd.Sendobject method
allowed me to us the asFormatSNP to easily send Snapshots of a report.  I
don't see such a straightforward option with Redemption.  Any ...

i have a type (see partial below)
after i create a varable dim pfile as tloanset. is there a way that i can
dynamicly load the new variable i want to do something like this
for i = 0 to ubound(pfile)