I have been task with writing an Inventory Tracking program for my group and
ran into a small problem.  I have two numbers used in issuance of inventory
(1) and item number (2) a serial number both of these are set  for no
duplicates so the same item is not issued twice.  One number ...

If I am iterating through a collection object, how do I retrieve the
key?  Thanks.
-Vincent

            My code is working fine.  I just need help with looping
the rst.move
  Dim rst As Recordset
  Dim varCXL1, varCXL2, varclx3, varCXL4, varCXL5  As Integer

And if it can be done, what things should I check to fix the issue
below.
Some users just have Acc97 RUNTIME and not full Access.
I rolled out a new app today to a user who only has hte runtime,

Want to know how do we get the information about the software installed
and hardware attached on a system using windows APIs.
To be specific i need the exact function to get the above information.
Plz reply as soon as possible.

Good morning,
I have this procedure that is run that pulls email names that match our
global database and emails reports to automatically to each group of names,
using click yes and Outlook.  I have created a trap, error handler that skips

I have an access database with a table that contains two columns:
Computer_Name,User_ID
The table contains 600 computer names.  I need to populate the User_ID
column with data from an SQL database.

I would like, if it's possible, to set the value of a field in a table
to a number of spaces.  One space would be fine, I just want to be
able to set the field to a default value that's not NULL but also
doesn't show anything when the field is displayed.

I am setting up a simple hotel reservation application which have two dates,
i.e. CheckIn and CheckOut. I would like to construct a graph based on a
crosstab query. Therefore, I need to have columns for each date between
CheckIn and CheckOut and the numeric 1 in the field. I have ...

Thank you Stephen Lebans!
This solution implements easily... and it works well. I figured performance
would suffer a little because the report is first saved as a snapshot then
converted but, initial testing (standalone PC) shows about 20 per cent speed

I'm still confused about this and I can't find anywhere that explains
it properly.
I have the MS book "Access 2003" in front of me and I'm reading Part 5
about VB and so on.  It's telling me about how to refer to a specific

I have a database that is used to process warranty claims.  Each record in my
main table (tblClaim) represents a claim.  Each claim has a status of Paid,
Unpaid, or Pending.  I would like to add a button that would automatically
export a query containing all information that our ...

I have this large table that we use to track attendance.  Since access
does not automatically fill the book like excel does we have to type
every employee over and over.  Is there a way now to add a drop down
list to this table with all the current employees on it?

tempname = FindSpaces(rs![column 1])
this works fine but if I try to pass a variable value to it
For i = 1 To 3 Step 2
tempname = FindSpaces(rs![column (i)])

I have an application that I distribute as a 97 or 2000 mde. If the
client has A2000/2/3, he uses the 2000 version. If he has 97, he uses
the 97 version.  If he has neither, he uses the 97 runtime.
Occasionally a client has Office 2000+ SBE which doesn't include Access.