I have a whole series of Union queries and there is one that just does not
work and it is structured like all of the ones that do work.  I can't find
the problem.
SELECT [QA_MiniMASS(8)FIN Hist 2].HierarchyLevel, [QA_MiniMASS(8)FIN Hist

I'm building a recordset based on a table created by a transfer of an Excel
spread sheet .  After the table has been created (and populated), I do the
following:
Dim con As Object

I'd like to be able to add a button to a form so that miscellaneous files can
be "tied" to a specific record only when necessary.  What I'd like it to do
when the button is clicked is to:
1.  Check to see there is a folder in a specific path with the value in the

Hope everyone is well, I have been trying to create a flat file that can be
saved as a fixed length file. This file is required to transmet claims over
an edi connection.
Challenges

Does anyone know why one would get a VBA is corrupt message when trying to
run a mde file?  The file was built as a .mdb,  compiles without error and
converted to a .mde using "Microsoft Access 2003 developer resources-custom
start up wizard" without a problem.  Application has ...

I trying to reset the auto number in a linked table and getting this error:
"Cannot execute data definition statements on linked data source"
I must keep the data in a separate mdb than where the forms/modules are.
Is there a way around for this problem?

In my database i have an own-made menubar with a lot of menu items.  
Depending on the user i wish to lock or unlock different items so that the
user can't use them.
At this moment i check the user AFTER he/she clicks on the menu.

I have beening seeing possible corruption in my database and I don't know the
reason.  Does anyone have a possible reason??
1)    When I notice something of this when I edit a module, my "Declaration"
down down menu at the upper right side of the module code is gone.

Need to kow how to delete multiple queries.

I am discovering that sometimes these projects are like similar to tackling a
plumbing project at home, you start, go to loews to get what you need,
proceed, go back to loews to get what you need, etc etc.
Can someone tell me the difference between the SQL Access builds its ...

I have Access 2002 sp3.  In my vba code, I delcared and set an object
variable to Excel.  I was able create the instance, have it open a workbook
and do a fews things through code.  However, when it was time to close and
save the workbook,  and close the instance of Excel and ...

Access allows a designer to open a table and view/change indexes in Design
View.   I want to allow any user to view/add indexes of any table using a
Class Module I design.  It's a relatively straight-forward process to list
the properties of an Index and IndexFields within a ...

Access 2003.  How can I programmatically set the computer screen resolution?

Good day
Is it possible to shut off the ability to have the standard right-click
popup menus?
[I could replace with a new menu if that helps, although I don't really have

In about 5-10% of the cases syscmd function fails with error 7952 in
following code error means function not called correct).
Dim Meter As Variant
Meter = SysCmd(acSysCmdInitMeter, "Busy...", UBound(varOrdernr))