the table is very simple, just 10 fields with 300K records.
However, i find it extremely slow to search at Form recently.
when i search records with "ABC*", the 1st record show up after 90 seconds
if i search in query, all the records show up within 5 seconds

Når jeg laver brevfletning med en database i access, udskriver den datoformat
f.eks. 6/9 2008 og det betyder datoen 9. juni 2008. Jeg ønsker at udskrive
datoen i brevfletningen enten som 9/6 2008 eller 9. juni 2008. Dette sker kun
i databasen, men ikke ved brevfletning.... Kan ...

I have a DB that has all the employee's performance averages among other
things.
I want to make a form that would allow you to select who is working that
day, and based on the perfromance averages, calculate an expected output.

Brief synopsis of my situation:
I've got several linked SQL tables in an MS Access db with a form input
screen.
Can I expect problems when opening this db to input data from multiple

I've decompiled mdbs before and then gone to debug/compile in the toolbar and
recompiled. This mdb is not giving me the opportunity to recompile in the
debug menu after a decompile. I have tried both:
"Path to MSACCESS.EXE" "Path to mdb" /decompile and

I have a memo field (which is originally an imported email from Outlook).
I would like to scan through each memo field, extract certain information
and add it to new fields, and then delete the memo field.
Contents in the memo field look like this:

I need to create a function that I can use in a query to calculate the
record number for a line.
So if my query has 5 lines, I need the column to show 1 in the first line,
and 5 in the last.

We have several complex applications developed in Access 2003 by
various outside consultants.  These applications link to a variety of
Oracle tables and are used only for Access reports.  User level
security is also built in via the mdw workgroup file for all

Have a subform with fields: first name, last name, phone, expiration date,
membership status. Need the calculated control to display the total number of
records that appear in the subform. How to I do this?

I need some help on how to charge for an Access application written for free
for Customer #1 if I sell it to Customer #2.
Up to now, I have only ever written in-house Access apps while working as an
IT Manager (recently retired), apps for my own use and my most recent

I have MS Access 2000 and have a BookJobs database and when I open it from my
C Drive and try to open Quotes Form from it, it is giving me error "G:\SH
Data.Mdb is not a valid path".Can anybody help me how do I change the path so
that the SH Data.Mdb filw which is on C Drive can ...

When i firs installed vista (about 3 days ago) everything worked fine i
rebooted after updating and the edge of the windows were not transparent and
alt-tab did not show the live preview (instead it showed only the old
alt-tab) and the "switch between windows" does not work it ...

Hi,    
  I have a table that contains many yes/no fields.   "Attribute 1",
"Attribute 2", "Attribute 3", etc.   I would like to set up a query whose
criteria for these fields comes from a form with a check box for each field.