Ladies and Gentleman,
I am attempting to execute an append query with paramaters. In the criteria
section of my query I have a parameter called strSQL. In the Query Parameters
Box I used the data type "Text". I placed [strSQL] in the criteria box.

Here is my code...
I want to run a query against an oracle database and make a table in Access.
This is what I came up with and it's not working.
The Error:

Keeping in mind I only want to have a back up for the data in the tables, I
have a procedure that:
When a user opens their front-end, a function checks the date in a table in
the back-end; if the date equals the date in the table or is an earlier date

Can someone help me on MSComctlLib.ListViewCtrl.2 and ListViewCtrl????
Is there any possibility to enter for ListSubItems an image and not text
value???
Thanks

I created a simple access database with two tables, one query, and one report
that lists several different cost items per individual.  Many of the records
contain $0 amounts.  In the report, I would like to only show the fields that
contain more than $0 amounts and eliminate the ...

I'm using the line: For x = 1 to Variable, where Variable is a integer.
Now it all works well but if a certain condition happens, then Variable can
go up by 1.
Now Variable will show that it has indeed gone up by one BUT the: For x = 1

Am stumped and a troll through the usual sources did not turn up anything
How do I get a function to fire when a user either clicks the close window
button on the Access application window or chooses File/Quit? (the database
window itself is hidden in my db)

I'm trying to create a SQL statement by going through each field, verify if
it's null and then update if it is NOT null.  If someone can look at my
thought process and logic.  I'm writing to a SQL Server DB.
Below is the first two lines of code to give you an idea of my logic.   ...

I have a bizarre problem with an error handler. I set it up to trap error
&H80040E14 (-2147217900), which occurs when the routine tries to create a
view that already exists. The code is:
    Public Function CreateOrReplaceView(strView As String, strSQL As String)

Is it possible to make a FK in a child table update when the parent table has
a new record added. I'm looking to have the child FK updated when a Parent PK
is increased via autonumbering?
If this is possible, can you provide the code?

I have a text box (of type Date) in a form that is used for updating table
(tblOrder).
By using the Control Source, I Calculate a new day for this text box (the
new value is O.K)

I have a program that was converted from Access 2.0 to Access 2003.  I’m in
the home-stretch of getting this out the door but only have a few lingering
issues.  
There is one function in a module that can’t be found, only at run-time.  

I need to convert it back from a string into code.  I'm a newbie - so I'm
really looking for a "how-to."
Function mouseover(buttonname)
Dim buttonname2 As String

I've searched here and mvps.org, and can't come up with an answer, so
any help would be much appreciated.
Through automation, I am pushing query results out to an Excel
workbook, and formating the text some.  That part works great.  The

I hope someone can help me.
I am trying to use a tree control, and am not very familiar with them.
I used one successfully in one database, but when I try to use the
same form in a different database, I get problems.  Below is the code