Hi!
In my table, I have only 1 field (Field1 - data type "Text" - size 42) with
thousands of records.
Every record is a combination of 10 numbers separated by comma and then a

I have a problem with my Access2000 application. After
some time it freezes the screen with the message "Not
enough memory to update display".
This error also makes the application itself stop.

I'm trying to create a database in which there is only one table that
contains all of the payables for a company. All the payable invoices have
primarily 3 fields: 'type of cost', 'date due' and 'amount'. The object of
the database is to obtain a printout of expenses categorized by ...

I'm trying to copy a backend table which has had a pivot table defined on it
to the front end with a new name, but retaining the pivot table definition.  
I can't seem to do this without it ending up in the front end as linked to
the backend.  I'm using docmd.copyobject to do this ...

I have developed an Access application that gathers data from a data entry
staff; it then generates and sends reports to management. Occasionally,
invalid entries (text instead of number etc.), cause data type mismatches
preventing the reporting.  How can I programmatically check ...

I have defined global variable in main form, I want
to use it in subform. Do I have to open the subform
using these global variables? If so, then what is the syntax? I know how to
pass just one variable, but not

Hi, I hope you are doing well.
I am using a Function to compare dates in a table for calculating invoices.
I am using the following statement to compare due dates:
If Table1![Due Dte] > 8 / 10 / 2004 Then

I have question with regards to link tables.
I have a liked table and would like to change it's source while keeing the
same table name.
Is there a way to simply change a property of the linked table to point to the

I wrote a procedure tha scan tx file, look for specific word  and replace it
by other.
the problem I have is when the replaceable word is shorter than the
original - I got at the end of the file garbage character. That meen if I

I have a table I want to look for matching records in.   One of the options
that data entry people have is to enter wildcards into records if they can't
read the ID# off of a receipt.   I want to be able to match records that use
the wildcards as a criteria.  i.e. once record ...

The macro I built is running too fast and I need to slow donw the pace.  Any
help?

I have Access 2000 running on a SB2000 Server machine with Terminal Server
enabled for one client. I cannot run my code when logged in as administrator.
I get an error on licensing when the code gets to the step "Set db =
currentDb".  Any ideas?

I have a database that tracks items that pass trough certain points.   Every
transaction is stored in a single table.   I need a query to look at each
record and see if there is another record in that table that occurs within a
designated time frame.  ie 20 minutes.

I have a loop.  For each record I perform two checks.
For each error I want to write a record in an error table.  If two checks
fail, I want to write two records.
Code in the loop: mystring = "......"

I know 2 Gigs is the limit for Access.
If I have a database with one table and only one field of type "Byte" (0-255
numbers), How many records can I add so that the database size is under 2
Gigs?