I want to be able to reference a connection included in a module funcion
through the "ODBC Connection Str" property found in the properties window of
a "SQL Pass-Through Query".
Any ideas if this is possible, and if yes, how can I do this?

I am very new in Access 2000 with little knowloedge about coding. Here's my
problem:
1. I have 2 tables - MachineMaster and MachineJobs.
2. MachineMaster determines whether a machine is available for job orders

I am using .addnew to add 100 columns per record to a table from an array.
Is there a way to loop through the code so as not to have to write 100
individual assign statements as below?
tdf.addnew

Help! I'm not sure where to post this, so here goes. Is
it possible to use 'AND' in the criteria portion of a
dcount() function. Specifically, I want to count the
number of records that have a particular value in Field

friends,
i am looking into distributing an access database for company-wide use which
i have developed and used personally.  we would therefore need to purchase
visual studio tools, but my company's vice-president also wants to know what

I am running an append query in Access 2000 VBA. I need to count the number
of records actually appended to the file, as they are appended. I am
getting key violations, which I expected to get due to duplicates. I do not
want the duplicates appended, but I need to be able to ...

We will be closing this Newsgroup soon. Please redirect to
microsoft.public.access.modulescoding
Thank you,
suzanna moran | MVP Lead | (w) 425.707.5507 |  suzannam@microsoft.com

I'm trying to figure out a way to tell if any combination of the words
(single space separated) in List A exactly matches any combination of the
words in List B (including only matching the exact number of words)
I would be happy to use either Excel or Access to work on this...

The import screen allows you to import a query as a table.  The feature is
under <Options>, on the import screen.  How can I import a query result set
as a table in vba?  
Thanks in Advance

I'm trying to create a form with a text box that displays the contents of a
certain recordset with the slidding efect. The solution i've found is
displaying character by character with a certain time interval between then.
The problem is that this only works if the textbox has ...

I have the following code in a report that it trying to
count the when a text field says "Yes" instead of "No" I
always end up with 0 as a count when there are 15 to
count. I stepped through the code and it does not look

I have a record that is either yes or no (-1 or 0).
The statement is
IF rstItem!prj Then
   code

Hi, I am trying to use the Err object, but every time I compile my VBA
application I get a compile error, "Invalid Qualifier"
If you have any suggestions, I would greatly appreciate them.
Thanks for your help

If I wanted to import a .txt file, but the location could change how do I
open the Import window explorer to assign the file to import?
-Steve

Could you guide me to create a 3 forms to do:
- Search a record with P_ID or lastname or firstname (P_ID is Pri key)
called Form1
- Form1 search complete and a browse window pop up let the user select a