I have a table which has employee number. I have attempted to creat a
function whic will derive a unique number for each record how ever the
code below only returns 10,000 for all records. What I am doing wrong? I
am I right in saying that In assuming that I dont to loop since I ...

I found instructions for creating a default template, followed them, but when
I click default I go back to Arial & no tabs.  Any way to fix?

I have a data base with phone numbers as: (999)999-9999. I need to get rid on
the () and - in order to use with a dialer. How?

I'm using Access 2000 and trying to link two separate existing forms (in the
same database), with the intention of one form being the master form and the
other being the subform.  
The form is called 'Pump Process Data Sheet' and the subform is called 'Pump

hello group.  I'm trying to do something strange and I'm not sure how to go
about it.
I need a report to print out all the places (creditors) a person owes money
to.  The report is set up to print on a label format  (name , branch

I am trying to set up a database for capital and expense coding for invoices.
I need to key one invoice with multiple lines of capital and expense codes.  
When I put the invoice number as the primary key, I am receiving errors and
can not run reports and queries.

Im designing an invitation for my sons birthday party but can only get it to
print out in A4 size! How do a get it to print smaller? Cant adjust size
through my printer, what do a do on office to shrink it so it prints out A6?
Or 4 copies onto 1 A4 piece of card, which ever is ...

I have a table where there's  a "R" field (Yes/No Type)
For every record where R equals to -1 I have a function that do "something"
I am able to accomplish this by creating a query with a function on it
But couldn't I accomplish this with a while..loop or for....each statement?

Still in planning stages. I want to have a record repeat, much like
recurring appointments in Outlook. I want to be able to enter in when a
delivery should occur and then have a field for how many weeks/months this
should re-occur for. Each week, when a driver prints out the ...

I am new to Access 2003 but seem to be getting the hang of it.
I am however, having trouble with the label wizard.  I am creating a series
of mailing labels for different people.  I go ahead and create the labels,
choosing the queries that the data should come from.  After ...

I have a databse with about 6K records....need to select some of these
records and place them into a calendar-type document.  I'm new to Access, and
this seems like it should be fairly easy.  Ideas?

I have this function on a datasheet form.
It doesnt work. After i click Ok, the focus doesnt stay with the  RQTY
field, it actually moves to the next record.
Is there something like go back to last focus?

How do you correct an Access 2003 file when you get this error notice and it
isn't true?
"The Microsoft Jet database engine stopped the program because you and
another user are attempting to change the same data at the same time"

When i enter data in to table A, I want access to search field 1 in table B
and only accept the data i am entering if it is present in field 1.
Any help doing this would be much appreciated coz i have already pulled half
my hair out trying to do it.

I rececntly installed Office 2003 and now i cannot  access Access. The
components are all there.