Please help. I have two databases - one I'm designing that will be our
in-house data mgmt system (db1) and another that is a federally-mandated
system (db2). We must submit data from db2 but don't want to use this db
for our data mgmt needs. Some of the fields in db1 are shared with ...

I have a client using an Access 2002 front end and back end. A certain
record wasn't showing up in several reports. He sent me the back end (I have
the same front on my machine), and I ran the reports using Access 2000, and
the record showed up. I then notified him, he tried again ...

My problem is the following:
Made changes to code in form and closed the form.
Now unable to open / design the form.
- Tried copying and pasting - the new one does not open /display.

There was a post recently in one of the newsgroups about not being able to run
Access97 on systems with 1 GB + of memory. A response to the post included a KB
article. Does any one recall seeing the post or does any one know the KB
article.

How can look up a value in access if I have a table (GPA) with all the
endpoints.  Below, is the exact table.  For example, if someones grade
averaged to a 2.43, since the 2.43 lies within the 2.33-2.67 interval,
then the letter grade would be a B-.  Please help!!!!

Is there a way to send an email to myself from another pc yhat is running an
access application if there error condition is triggered in the program?
would be very handy
Thanks

From VBA, I need to create a new word-document, based on a template.
It should however not pop-up a form in that word document, which is
activated by the 'document_new' event procedure. How can I prevent
this from code?

  Does anyone have any bright ideas for Access'  tendency to add square
brackets when it parses queries, then tell you that the query syntax is
invalid.  In my case, I'm trying to do a LEFT JOIN on a subquery, like so:
SELECT DISTINCT [Marker-Values].[Marker-Label]

I have Office Xp Professional loaded. In Access the Make MDE file
option on the menu is greyed out. Is it possible to create an MDE file
without the developer version? Why is the option on the menu if I
can't use it?

Table A contains a list of colors (example red, blue, green)
Table B contains a variation of the colors in Table A (example
light-red, medium-red, dark-red)
To add a color variation to Table B, I want it to open a find record

DoCmd.OpenReport RPT_TEST, A_PREVIEW, QueryAsFilter doesn't work correctly
in A97 but works OK in A2K.
Is this a bug for A97 ?
Filip

What I need to have happen is, that when the form is filled out by the user,
the user can produce a report of that record only. Any help would be
appreciated.
Thank you.

how can i make it so that when the value of one field is 15 another field in same record automatically enters todays date?
thanks in advance!!

Thank you for take the time to read my problem!
I'm trying to delete a record in a table with VB code. I have done
this many times and this is not my issue.  I need to call a text field
on my Form.  I can't seem to figure out the correct syntax for make

I will make a form which will search the database (just like google
interface) that will look/match for the exact name in the records of a
given fieldname. Any suggestions on how to make the code?