Here's what I'm trying to do. I have a table where data in column A is
repeated and column B records sequencing such that if the first unique item
in column A has 10 entries, column B has a corresponding 1...10, and the
sequence starts over for the next unique item in column A.

In my VBA code I created an SQL statement which I need to run.  However, I
need a way of returning whether or not it ran successfully or not.
I tried the following
bSQl = db.Execute(sCSQL)

I'm completely new in this world, and i need to create an aplication in
access that sends data to axapta. how can i do it?
i also need to configure a job, or something like this, in axapta to send
data to access database every night.

I'm a little new to Access VBS programming and have a couple of questions.
To prevent clients from using my apps without paying for them, I am
incorporating a password procedure that kicks in via an Autoexec macro. I
want the client to be able to test the ap and then pay me if ...

I've struggled with this before but I don't remember how I fixed it. I have a
text box that points to a field in a subform.
There is probably a better way to do this, but I've had it! I spent 1 1/2
day's trying to display four hardly important figures > but I don't like to

i would like to replace substrings in txt files in folder and its subfolders
i have the sring to find and the string to replace in access table
it is my first time to do anything with vba
the function i found is here

I am trying to process data from a temp table and depending on criteria, in
one case append it to the data table.  To do so I thought that the INSERT
INTO SQL statement was the way to go but seem to be having difficulty with
the proper syntax.

My Access 2007 project print pdf document with this command:
DoCmd.OutputTo acOutputReport, "rptMaga", acFormatPDF
all ok if i run in my developer computer but when run my project in customer
computer (with AccessRuntime.exe) give my error 2501.

In a access form when I enter data Just like this
Date                       Invoice No
Product                  Price
02/11/2007              015                              Tea

I have set the PredeclaredId of one of my class modules to "True" and
stepped through the code only to see the class initialize and terminate
events are never touched. However, the recordset variables and the
dao.database variable which were intantiated in the class initialize ...

Please help me on this matter with Ms 2002
Figure 01
Date           Invoice Number        Grade                   Nett Weight(Kg)
15/11/2007    2       BOP1                     500

i build automation that collect information from a file and building
query with criteria
problem starts when the criteria is too complex
is it posible to some how increase the memory or the limit for the

All,
I have a need/Challenge to move all of our Access Databases and convert them
to SQL but keeping Access as the front end for all of the users.
Can anyone guide me to the right direction on how to accomplish this?

Access 2003.
This is a front end whose tables are attached to an access or SQL server
back end data container. It is 3 megs large as an MDE. It's autoexec runs a
Main function. The time it takes to get to the main function is about 20

When i want to make an mde db, i click on tools,database utilities and choose
make an mde file.Is it possible to do it by code ?