I´m trying to renumber records in table and need some advise!
The table have two fields:
PstId is a number
PstID   PstDesign

Looking for something similar to the issues template for 2003

Posted originally in Modulescoding forum by mistake.
Hi, Using Access 2000.
I have lost some records in table within a large database (mdb file),
however I'm lucky enough (I think) to have a back up of the whole database

I have a huge list of cities and all of the corresponding shipment data for
every shipment during the year -- weight, costs, etc. I have created a query
to get the totals by city. But, my problem is there are some cities that have
been entered differently. For example, ...

Could please help in simple terms on how to create a query that will give me
the ability to run on query on data alreading in a field.  
I have one table that captures shipping info.  I would like to do a query
that has a drop down list of the entries of a field.  this way I will

  I've database that has all its forms property "Record locks" set to
"Edited record...
I'm facing a big problem as users say that,although one only at the moment
is editing a record,it's locked...

I have this code to find a record on the table and show it on the form, but
to make this operation I need to press ENTER key after scan the barcode where
the scanner place the data on a textbox named: ScanWO,
how can I do after to scan the barcode the access make this operation

I accidently changed the Field size from Long Integer to Replication
ID. Can anyone please tell me how I can change it back to Long
Integer? I am using Access 2003 (Access 2000 format).
Many thanks

i have reports the we have used for over a year that suddenly doesn't like
the =DATE() cell on one computer.  
We have reinstalled MS Office and this has not helped.  
It worked last week on that computer...and now does not.  Just that one

i have a report that has 5 subreports on it. In my page header I have 2 text
boxes one called Field0 which displays Store Name and Field4 which displays
the Total % Change for the quarter. In one of the sub form which is in the
detail section of the report I have a list of about ...

When I try to "Reply" on Craigslist (sending an email) I get an email message
saying the default email is not set up. I do not want to set up another email
account. It will bring up an email box, but has NO SEND BUTTON.

I have a really simple problem, but I can't figure it out:  I have a table
that lists conferences along with the associated fees.  Another table lists
employees who register for different conferences.  I enter the employee info
and do a lookup to the conference for the conference ...

As we all know, in Access 2007 we have this nifty little quick sort/filter
thingummy in the column headers of datasheets.
I've come across a couple of threads where people wanted to know how to get
rid of these, although no-one seemed to have an answer.  However, I have the

What are the changes  between Access 2002 and Access 2003

My file contains 737,768 records.
The first 9 characters is the part-number;
the next 9 characters is the price;
the next 7 characters is the tax;