this is my table structure
lower                upper              price
100                    200                $7.20
200                    300                $8.10

I'm a very occasional VB programmer who remembers being able to do such
things as macro substitution for field names in FoxPro.  For example, if
fieldname = "address", then using &fieldname would refer to a field named
address.  Is there similar functionality in ACC2000?  The ...

I want to be able to calculate a student's cumulative GPA given each
semesters credit hours attempted and quality points.  The calculation is to
sum the quality points and divide by credit hours attempted so that for each
semester I will have a cumulative GPA (grade point ...

I have a link to a SQL table to which another application can append
records.  When this occurs, I need to take certain actions in my Access app.
I'm handling this now by querying the table every minute (using the timer
event in an open form) to see if any new records were added ...

Hello;
I created a form which enables a user to select 1 of 3 reports and filter
them using a series of combo boxes.  I now want to create an option box which
would enable him/her to sort the data by the field chosen in the option box.  

We are a manufacturer and I am trying to develop a inventory control system
tied into order entry and shipping.  Any advise or input is greatly
appreciated.  

Need help addressing the KepPress Event
I'm new to Access programming...
Background & Fact pattern:
I downloaded the Calander example example form:

I noticed the "acCmdBackup" and "acCmdCompactDatabase" listed in the
RunCommand reference. When I tried to use them I received an error that you
can not Compact an open database from VB Code. The acCmdBackup simply stated
it was not available.

Can I use the TransferText method to import Tab separated .txt file in to a
tabel?
Let me describe what I'm trying to do in order to see if there may be a
better method of doing this. :)

The program that I am trying to modifiy is not my own and I can't redo
everything.  with that said...
The problem:
I added a field "Service Charge" to and existing VBA code.  This code will

I have a zip archive with a file that i want to link to. This process should
be automatic because is to run on a daily basis.
The zip utility i use is PowerArchive and the zip archive is a .gz file. The
file contained on the archive doesn't have extension and the name can vary.

I need some assistance
I have this database that has to import 35 files everyday. NOw for checking
purpose, i have this code that once it imports all the files, it deletes all
files from that folder so user can't upload same files

I am having an issue with various PC's and the references set in my Access
DB. I am using Access 2002 and have DAO3.6 seleted as a reference but on
ertain PC's I am getting an error saying "That command is not available."
When debugging the error hits on the .edit of a recordset ...

Morning All,
I need to use the Microsoft Word 9 Library in Access, but the file
MSword9.olb is not installed on my computer.
Does anyone know where to get hold of this file?????

In a post in september you said you could help downloading references for VB
(see original message below). Im missing the Word 9 Object Library reference
(MSword9.olb) Could you help me out.
Thanks in advance