Dear Gurus,
i had written following codes to auto generate the next claim no
Private Const strC = "GCT/02/J/"
Private Sub Command1_Click()

My report has a text field named ItemNum. Most records have a value for
ItemNum. I set Grouping And Sorting to sort ascending on the ItemNum field.
The records where ItemNum is Null appear at the top of the list in the
report. I want the records that have a value for ItemNum to be ...

Hello to all,
Here is my data
Bureau      Days  here are the samples
  1          12 (0 - 14 days)

I'm using the reverse pivot technique on an excel spreadsheet to create
a list dataset from which I can make a pivot table in excell.  The only
problem is that because there are so many years going across, whenever I
try to do this the computer tells me it was only able to do an

i have a mdb which imports file from excel(specified directory) into
access. once in access i have to run a self query/union query within one
table. can i do something so that the query becomes recursive...it picks
values from the access table(converted from the excel file), ...

Perhaps someone in this group smarter than me can help me with this
problem. On a data entry form, I have placed a command button to
"close" the form when the user is finished entering the required data.
To make sure the user enters complete data in every text control, I

I am trying to display information in Access on a form that takes
information from many different queries and puts them together on a
spreadsheet or chart.
Some specific info:  The information I am displaying consists of a work

Hello, I am very interested in the access 2000 data base posibilities.
I hope learn a lot about acces 2000 and solve some of your questions.
I have a big and simple problem. I use access to entry a big amount of
data. But Access 2000 has a big problem, that problem is: "if you

I have a data input form and need to automatically duplicate the existing
record as a new record by clicking a button.  The main purpose to duplicate
the record is that the new record is very similar to the existing record
with minor differences.  It will save the data input ...

Using Access 97 I have a form with several text boxes, I am trying to get
each text box to display the word "Required" for the appropriate boxes on a
new record. A friend gave me the following line of code that I put into the
text box Format property:

I'd like to try to have text displayed when I move my mouse over a
command button.
For example: let's say I have a form with 3 different command buttons.
Each command button launches a different report.

I have a need to update a table with the min date from another table.
I have a query that has the min date for each group in one table.  I
want to pass this value into another table.  I get an error saying that
Operation must use an updateable query.  I understand it won't update

It seems like at one time I knew how to do this, but right now I'm
drawing a blank.  I know there has to be an easier way to link tables
using more than one field.
Heres a simplfication of the problem:

Is there an add-in or other utility that would allow the basic
modules from two different databases to be diff'ed?

Hi,
In Query Analyzer:
update tblUserProcess
set usercode  = 1002