Your code worked great for searching the queries for a referenced table.  I'd
like to do the same with table field names.  Would I need another loop to
traverse thru each field in the table?

I need to put an optional argument in one of my sub procedures.  How do I do
that?

What is the functionality of "<>" ?

I'm starting to play with using the EXECUTE method of the DB object. In
the current sub that I'm working on the statement
CurrentDb.Execute strSQL, dbFailOnError
does not appear to be executing the SQL Statement contained within the

What is the initial value of an unbound text box? I have tried evaluating for
Is Null, Is Empty and "" but these don't seem to be true.
The reason I ask is that I want to be able to check to see if a user has
input anything in the textbox and message them if they didn't but when I ...

In a section footer, I need the label (or textbox displaying label data) to
read "SubTotal " <Section Name>. What contol should I use and how do I set
its properties to acheive that?
Thanks

If you place a calculated field in a query that results to purely numeric
data, how do you get the resulting datasheet to recognize those values as
numbers rather than text? I want to use that field as a sort field and I
dont want 10 to take ascending precedence over 2, 3, 4, ...

I want to download several files from an FTP server but i have a problem. I
got the source code on the internet and the files are correctly downloaded.
The procedure first creates a blank file with the same name as the source and
then starts downloading the infornation by blocks.

I have so many photos storing on internet.
Now, I want to create an image object on Form or Report, so that users can
view the photos for each record. But it failed. In MS Access, Image Object is
not allowed to link the file from internet.

I would like to profile the Trace (Select, Inseert, Update and Delete) SQL
statements fired to a specifc MS Access 2000 database like the SQL Profiler
tool supplied with MS SQL Server. Is it possible to do this?

When i write the contents of a memo field to an Excel cell i get squares at
the end of each line, presumably from the enter button. I have tried putting
in a line
   invAdd = Replace([invAdd], Chr(13) & Chr(10), "")

*copy of msg posted in "Macros" discussion group aswell
Hi
I am very new to Access and have recently built my first database (using
Acess 2003), the purpose of which is essentially to enter our client firm

I have a table which includes,among others, the following fields,
TranDate(Date field), ClientID(Number field), and Attendance(Text field). I
would like to be able to have a series of text boxes on a form that would
pull in the first date and attendance, then the second date and ...

I have a form which is used to update a record. What I would like to happen
is once the user makes their updates and clicks the button a yes / no field
in the table is ticked.
How is the best way to do this?

Can you point me in the right direction? I want to combine the address fields
into one textbox. Then I want to click a button to create an envelop. Thank
you.