Using Access 2003 on XP.
First time caller, long time listener.  I am not a programmer per se,
and all my training in coding in the past year or so has come from the
wealth of info in these newsgroups, but I've finally hit a brick wall

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 ...

How do you get a sumon a calculated field in a detail section on a
report?  I have a group footer that I need the sum on.
Thanks
DS

I create a new user and make them a member of Admins. I then log on as
that user and try to modify an existing query. I'm told that I don't
have the necessary permissions. The Admins group has full permissions
on the query.

I am creating an Access client to a SQL db and decided to go with an ADP
instead of an MDB.  But I'm having some issues.  My previous post regarding
ADP's went unanswered.  Is there anyone out there who knows about ADP's?

I have a problem with DCount, the following code doesn't work:
DCount("[OrderDetailID]", "qryOrder", "([OrderID] = Me![OrderID] AND [CatID]
= 'drink')" > 0
Please help.

I created a report containing weight and height for 50 individuals.  The
field "ID" is included in the report.  Is there any way I can report the
data for a specific person (say, ID=A13) ?
Thanks for your help.

I have a form with fields that act as user specified criteria for a
form.  Two of the fields are start and finish date.  The fields in my
query are "ID", "TimeStart", "TimeEnd", etc. Currently, I have the
following:

I'm having a very strange problem in an AC97 MDB with ODBC Linked tables
to SQL Server 7. The table has an Identity field and a Timestamp field.
The problem is that when a new record is entered, either from a form or
from the table view of the table, when the record gets saved it ...

Good evening.
Few day ago i ask about this Object.
A very kindly replay of Sthepen Lebans give me the solution
to use ClipBoard to synthesise the Conversion, but i've some truble.

Hi there - it's pretty simple, and I'm an idiot.  I'm not a developer,
I just seem to have landed in this job building this Access database -
I've got two days to make it work...  aaahh!
1)  Within the User Interface, I've got a separate section for the

I have just created a database (partially) which will bill customers for
work done. However I am stuck when it is comes to different rates for
different works.
REQUIRED: What I intent to have is a form in which I will enter the customer

I have a form that is tied to a table. On this form I have a button that
when clicked prints a report based on the information currently on the
form. The problem is that unless the user tabs past the last control and
moves to a new record, and then back to the record they just ...

Hey, this is the situation. I have imported a table from Excel and
know i must edit the saldo in the corresponding records tbl_Lignes.
Impdata                               tbl_Lignes
.....................                 ...................

So in preparing an export routine to send stuff to the courier company's
label printing software (which is surprisingly rough, for a big company),
I've discovered a few carriage returns in fields that shouldn't have them.
They act as new record markers in the label printing thing ...