Limiting Records

[alastair69]

I have been looking for answer to my question for a few days now and really would like some help.

What i would like to do is based on the user and the number of records, and a command button will asign the number of records to that user, then hide these records asigned to the user from other users.

I am new to the forum and hope help is friendly and speedy.

Regrads

Alastair

 

[alastair69]

Can anybody help me with the above problem!

 

[alastair69]

Do you need me to explain a bit more or are you just thing about the problem?

 

[alastair69]

Is it normal for people to not to answer in this forum?

 

[RayH]

When the records are created for the user add that users name/sign on/code or whatever unique identifier they use to the table for those records.
Then when the records are retrieved just match their id to the id in the table.

Am I in time?

 

[Rich]

Is it normal for people to not to answer in this forum?

Patience is a virtue my friend, this isn't an answer on demand forum and most are still on holiday anyway

 

[alastair69]

When the records are created for the user add that users name/sign on/code or whatever unique identifier they use to the table for those records.
Then when the records are retrieved just match their id to the id in the table.

Am I in time?

I understand the above but was wanting access xp to put the sales ID (Unique identifier) automatically. i have a form with a field named "NumberRecords" and a Field called "SalesID" a subform that should show the number of records entered into "NumberRecords" then a button which will place the "SalesID" in a colum. Please can some body help as this is driving me nuts.

Alastair Lane

 

[alastair69]

There must be a way of doing this, it sounds stright forward.

 

[alastair69]

I understand the above but was wanting access xp to put the sales ID (Unique identifier) automatically. i have a form with a field named "NumberRecords" and a Field called "SalesID" a subform that should show the number of records entered into "NumberRecords" then a button which will place the "SalesID" in a colum. Please can some body help as this is driving me nuts.

Alastair Lane

Forgot to enclose this as a few people have helped me so far.

 

[ColinEssex]

Is it normal for people to not to answer in this forum?

I answered it yesterday when you posted the same question elsewhere

Col

 

[alastair69]

I was just asking if this could be done autmatically, i have done as you said and it worked but i have over 50,000 records and going though each one is going to take a long time. There must be a way of doing this either though a filter or something.

I need to do the asigning of calls on a daily basis it will take most of the day to do the above as i have 10 users all with there own logon and password.

Alastair

 

[alastair69]

I understand the above but was wanting access xp to put the sales ID (Unique identifier) automatically. i have a form with a field named "NumberRecords" and a Field called "SalesID" a subform that should show the number of records entered into "NumberRecords" then a button which will place the "SalesID" in a colum. Please can some body help as this is driving me nuts.

Alastair Lane

Got the following strnumber = Me.txt_NumberRecords this shows the number of records i want to asign to each sales person, i can not get the filer bit to work any ideas.