I am running a large Access 2000 application (installed using Access Runtime) that uses many VB SendKeys, primarily to expand combo boxes On Enter.
When trying to run it on Vista I get a "Permission denied" (error 70) error whenever entering a combo box.  I have already changed ...

I'm using the OnKeyDown event in hopes of capturing a key being held
down during the initial startup of my application.  Does anyone know,
at what point the OnKeyDown event fires?
I checked to see if the key would be captured in the OnOpen and OnLoad

Is there any way to push a form/module/macro to an external database
via VBA?
I'd like to be able to copy my production version down and push all
the modules/utilities that I use for development to it (including a

Is there a "best practice" maximum number of controls that can be
loaded on to a tab control before things start getting messy and
sluggish?  I'm asking for a "best practice" maximum number across all
tabs and not the maximum number that is theoretically possible.

We have this access application - which we use to register stuff into.
Most of the time we're online, and that's all right, but now we need
be able to register stuff offline, and then it would be nice if we
could copy the registered stuff into the main database when we get

Morning all,
I've found over the years that this newsgroup is an absolute fountain of
knowledge and I have been able to use heaps of stuff in the databases
I've written.  Personal knowledge and experience can never be properly

I am working with a database and I would like to be able to populate
an array at run time and then use the values that were pushed into the
array as criteria for a select query.  It seems that this should be
possible to so.  Here is an example...

Can someone explain to me the proper syntax for requery and where to
input it in my form?
I have a main form "Account-Master" with two subforms: 1.) Contacts
and 2.)TNotes.

OK, I am thoroughly confused.  All I am trying to do is fill in a
Status field on my form with the condtions below, with all my theory
being based on what I have read in various newsgropups.  The IIf
statement works in the forms Status field when I use the IIf wording

Does anybody know why my Office 2003 apps including Access have taken
on a blue theme when running under Windows Vista irrespective of which
"Window Color and Appearance" I choose in Control Panel?  It doesn't
seem to matter if I'm running Aero or Vista Basic.

Do you have your users rely on the windows taskbar to manage/navigate
between the forms they have open, or do you provide another (more
robust) method?  Does anyone use a custom navigation system (like
keeping a selectable list of open forms in a listbox/commandbar/

I need some help with my website.  I will need to write a boolean
value every 5 minutes for 100 users.  that is about 28,000 writes per
day.  This data must be kept for at least a month.  Can I simply write
this to a db as a new record each time?  Should I write once per hour

I do fair amount of data analysis using access pivot tables and charts.  Can
any body suggest a method to run the queries based on accounting month and
Accounting year.As an example: I want to analyze sales order per month and
per Quarter.  Our fiscal First quarter starts at 1st ...

I've added the ability to send e-mails from MyApp using CDO.  I would
like to programatically get the name of the Microsoft Exchange Server.
How do I do that?
Thanks.

Hi:Can any one please tell me how to convert excel file into a text
file thru VB6 Program? Also is it possible that i read the values from
the converted text file of any column one by one thru do while loop?
Or can i read the values of any column directly from excel file