Hi, I have a new project that consist of transfering a JD Edwards
Database to an MS Access database.  I am just starting to learn how
those 2 databases works.  What is the general idea behind this??  
Outputing the data to a text file and read it?  I just need the basic

I'm trying with a query. A criteria of the query is a global variable
represented as a function. The variable is the result of a multiselect
listbox.
The function looks like this:

I had created a MS Access form. The form has an "Save" and a "Close"
button. I would like to set short cut keys for these buttons as "Ctrl
+ S" and "Ctrl + C" keys.
I heard that Send keys would work...But not sure How to use them in MS

I am looking for a good control that would display/print JPEG
images in Access 97.  The existing Image controls, even with
the JPEG filters, are very slow - and I know there are better
ones out there (preferably freeware).

Can anyone tell me when to use ENUM and when to use Public Const?
TIA
- Nicolaas

Hi:  I am developing an application using FoxPro 2.x tables.  My client
has AccessXP.  AccessXP uses Visual Foxpro ODBC to connect to tables.
It does not accept the ISAM Foxpro driver used in A97.
I have a problem that when I link to the tables on the client machine

I have a main form that is running maximized and looks very user
friendly. That is until something occurs with the recordset. like:
1. Delete a record
2. Change the recordset to a special lookup query temporarily.

When the user opens Access form, they can either right click on the
form to go to Form Design or click on View icon of Access (View -
Toolbars - FormView) to see form design.  From there, they can change
the design of the form or do almost everything to my form.

In my application, a text box control resides in a form.  The text box
control is unbound, but--assuming all edits are passed when the user
click a command button on the form--the contents of the text box
control end up in a field in a table with a data type of Date/Time.

sorry for repost but it is not showing up on my server.
How can one share tables over local net where one can read and write to
them and others can only read.
basically I am unfamiliar with sharing set-up with users, admin etc.

Hi everyone!  I'm trying to produce a periodic financial report on
projects from various departments.  My database is set up with the
tables tblDepartment, tblProjects, tblPeriods, and tblBudgets -- the
first three serve the obvious function; the last table contains

Hi Gurus
I am trying to make a custom message box with a dialog form.
Here is how I would like to do it:
   1- anywhere in the database, in any procedure, I call the function that

I want to add a user defined function inside of an SQL string.  I am
using the function to change a group of numbers in a string to a
specific format that can be sorted by Access(utilizing 0s).  Function
is called Zero pad and is from an old Access 97 magazine.  My question

I'm trying to create a report from two queries, one query displays
which customers bought a particular product, the quantity and price
using the "Enter productID" as parameter
While the other is displaying the dates which the product was bought

I have a database (2000.mdb) which links to my data tables (Data2000.mdb).
The database has a Main Menu screen (not a switchboard - a custom one).  I
need to import records from 5 text files into the 5 different Tables in
Data2000.mdb.