Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







How Do I Restrict Number Of Records In Form?


Hello,
My "customer" form is based on sigle table. I have to restrict no of customers only 5 customers. can anybody help me ?
This is required for distributing a database.

Regards,

Satish


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Restrict Number Of Table Entries?
Hey all,

I'm having a horrible time trying to get this to work. Basically, I have a database which has multiple tables. All of my tables are being generated with a CREATE TABLE statement. What I would like to do is add a validation rule or something else upon creation so that only X number of entries can be entered into the table.

Initially, I just added a rule that said id<5 or whatever manually to the table in order to restrict the number of entries, but I can't figure out how to do this automatically in my SQL statement or Visual basic. I want to be able to have this check added upon table creation. Surely what I'm doing must be possible.

Am I going about it the wrong way? Any Help would be appreciated. Thanks!

View Replies !   View Related
Restrict Records
I have a database that I want to install on a client's pc as a demo only. I want to restrict the number of records he can enter to 3. Is this possible in access? I will appreciate any help. Thx!

View Replies !   View Related
Restrict User Access To Specific Records
I have a staff database in my office which holds, amongst other things a list of staff holiday taken. Presently the staff have no access to view holidays because they will also be able to view other employees details. What I need to do is enable members of staff to see their own holiday, but no others and Im really not sure how to go about it.

I have a workgroup in place; so each user has their own login/password.

Any ideas would be gratefully received.

Thanks,
Adam.

View Replies !   View Related
Add Records, Restrict Entry To Prevent Blanks, Option To Cancel
I have a form I use to manage the records in a database. It has navigation buttons to browse through all records, a combo box to select a specific record by name, a delete button, and an add button. When the add button is clicked, a blank record appears on the current form. I would like to set the add function up so that:

1) Prevent the newly created record from being saved when field1, field2, and field 3 are not filled in.
2) Prompt the user to fill in field1, field2, and field3 WITH an option to cancel.
3) Disable all the other 15 fields on the form until fields until field1, field2, and field3 are filled in.

More specifically, I don't want them to have the option to go to field2 without completing field1, and to field3 without completing field2 while giving them the option to cancel when prompted that the field1, field2, or field3 are required.

I've tried various combinations of On Update, Before Update, etc. in the field and form, but haven't been able to come up with the desired results. Either the record

Can someone give me a strawhat outline of how this can be done. What is the right combination of Events, etc to make this happen and where do I place them?

I've searched throughout this forum and others and cannot find anything that does what I need.

View Replies !   View Related
Login Form Which Restrict The Access
hi

i am having a login form.
where i have only two users..may be 3
suppose it is admin and guest
then i have a main form where i have 5 tabs,...where each tab contains 7 or more command buttons which will open some forms
what i need is when the admin is login he should be able to edit add delete
but if it is a guest then all the forms should be read only
i know abt the allowaddition and etc..but i don't know where to use it..
is it in the login form or in the main form or in each and every form

regards
jenson

View Replies !   View Related
Counting The Number Of Records On A Form
How would i count the total number of records on a form

View Replies !   View Related
Displaying Number Of Records On A Form
Dear All:

I am curious to see if threre is a way to display the number of records on a form in a text box. I know access has this number on the bottom of the form, but it's a vision issue for me.

Any ideas on how to get this done?

I am most appreciative of all the help.

Regards,

Dion

View Replies !   View Related
Default Number Of Records In Continuous Form
Hello, i have a question,

I have Main form, and Subform (which is continuous form). Now when i open main form (or even subform itself) i see continuous form, and two empty rows.Whenever i fill first row and press on second, third row appears, and so on.

Can i set somewhere to show me only 1 empty row on this continuous form, and when i fill it, second row appears, and so on. E.g. is there any options for customizing how many empty rows are displayed and the begining of continuous form?

And how "saving of records" work here, because if i fill one row, it won't save anything....it will save it only when i press on other row (when third row creates)

Thanks for your help

View Replies !   View Related
Report Prints The Same Number Of Times As The Number Of Records
I've created a report and report has the same number of pages as the number of records that it's displaying.

If there are two records, the report has 4 pages...the first 2 are the actual report and then the other 2 are a copy. If there are 3 records, the report would have 3 copies (...6 pages).

Any idea how to change this so that I have only one copy of the report?

View Replies !   View Related
Appending Records With A Desired Auto Number In A Table With Auto Number
Here is my issue. In a table with an Auto Number index some records have been deleted. I have been able to recreate them along with their original auto number. The problem is that I do not know how to append these records forcing the original auto number. I have tried changing the auto number field to a number field in the table, this works except I cannot change it back to auto number.

I am sure Iím not the first with this question or issue. I did search through a couple hundred entries about auto number before I posted this question.

Jim

View Replies !   View Related
Restrict Access
Is there any way for me to have a button on my frontpage visible to only people i name
e.g.
if user = john smith or user = fred bloggs then show the button if not do not display it.?
Being a novice step by step idiot proof help would be appreciated
TIA

View Replies !   View Related
Using A Checkbox To Restrict A Field
hi all

i have created a form to enter details into a 'job' table.

here is the part of the form my question deals with.

FIELD- Airport DATATYPE- Yes/No
FIELD- Terminal DATATYPE - Lookup wizard (the values 1-5 stored in a separate terminal table)

basically the system involves entering minicab jobs into the database.
the job may or may not be at the airport.

THE RESTRICTION I WANT TO PLACE ON THE JOB FORM/TABLE

if the airport checkbox is ticked (Yes), then the terminal value can be set (1-5) from the form.
if the airport checkbox is unticked (No), then the terminal value cannot be changed from the form.

if this can be done, how can it be done? anyone..??

View Replies !   View Related
Restrict Action Queries
Hi all,

I'm not sure where this question belongs, but as it involves a query I'll try here. I have searched the forum but, to quote U2, "I still haven't found what I'm looking for". Apologies if I am repeating another thread.

I have a multi-user database that from time to time needs to have it's basedata updated from the SQL server datasource. It is not possible to have the basedata running 'live' as it slows the database down too much due to the complexity of the data it needs to access.

Is it possible for an action query (maketable in this case) to be disabled when more than 1 person is logged in to the database. I.e. I only want to allow the basedata to be updated when the user performing the update is the only person logged in.

Thanks in advance,
Dan

View Replies !   View Related
Restrict Access To Forms
I have impletemented a user system for my database with different access levels relating to entering and editing data.

I would like to make certain forms only accessible to a specific group of users. Is this possible and how?

Thanks,

Gary

View Replies !   View Related
Restrict Data Entry In One Field
Hi,

Is it possible to restrict data entry for some users only on one field?


Regards,
B

View Replies !   View Related
Northwind, Need To Restrict Customers To One Category Only
Using the MS Northwind db as an example and without changing the table/rel structure or using vba, how can I implement the follwing...

'Customers cannot use the same Product Category more than once'.

i.e. on a customer order form a list (query) will show products from only categories that they haven't had before in previous orders.

Also, can't drill through Categories first.

I thought this would be straight forward, but am having problems creating a query for this.

I know I need to maybe start with a nested query so I have created a query that shows all DISTINCT customers and Categories that they HAVE used.

After that, I'm a bit stuck!

Cheers

View Replies !   View Related
Restrict Data Entry For Dates
I have a HUGE system which presently restricts updating a "Final Action" date to today's date only. However, I want to change it so users can input dates for only the present working week. The present coding is as follows...

Private Sub dteActioned_AfterUpdate()
Dim strTime As String

strTime = "07:30"

gintChanged = gintChanged + 1

If Not IsNull(Me![dteActioned]) Then
If Me![dteActioned] > Now Then
gintReply = MsgBox("Your actioned date is later than today !!", vbOKOnly + vbCritical, "Oops")
Me![dteActioned] = Null
Me![dteActioned].SetFocus
GoTo Exit_dteActioned_AfterUpdate:
Else
If Format(Me![dteActioned], "dd/mm/yyyy") < Format(Date, "dd/mm/yyyy") Then ' final action earlier than today
If Weekday(Now) = 2 And Format(Now, "hh:mm") > strTime Then
' If Weekday(Now) = 6 And Format(Now, "hh:mm") > strTime Then
' Not acceptable to enter a previous date
' older than 7 days is not acceptable
gintReply = MsgBox("Now too late to accept this 'Final Action' date !", vbOKOnly + vbCritical, "Oops")
Me![dteActioned] = Null
Me![dteActioned].SetFocus
GoTo Exit_dteActioned_AfterUpdate:
Else
' Previous date is acceptable but only as far back as 7 days
If CVDate(Me![dteActioned]) < CVDate(Now) Then
' older than 7 days is not acceptable
gintReply = MsgBox("Now too late to accept this 'Final Action' date !", vbOKOnly + vbCritical, "Oops")
Me![dteActioned] = Null
Me![dteActioned].SetFocus
GoTo Exit_dteActioned_AfterUpdate:
End If
End If
Else
' Actioned date is acceptable since it is today's date
DoEvents
End If
End If
End If
' if today is a Monday Only accept final action dates which fall within the previous week if today

Exit_dteActioned_AfterUpdate:

End Sub

Probably very simple but I just can't get it to work. Help please! Time is short.

View Replies !   View Related
Combo Box: Restrict Data Entry
Hey,

I have several list combo boxes on my form that I want to prevent users from adding data to. How can I do this? For example, there is a list box for insurance carrier, etc. :confused:

Thank you,

debo

View Replies !   View Related
Restrict Character Of A Textbox To Numeric Only?
Hi all,

I was wondering how i would be able to restrict the entry of a textbox to only numeric data input. I have a input append form and to reduce errors one aspect is limit the entry in a textbox to numeric data only (i.e. numbers). Any help appreciated, thanks in advance,
M-.

View Replies !   View Related
Maximum Number Of Records
hi all,

This is general question only. How many number of records that Access can handle as a maximum records?
Or it only depend on size limit (4GB)???
thanks

View Replies !   View Related
Limit On Number Of Records?
Is there a limit on the number of records you can have in an access database? I've got one with 8500 records and it's been a PITA! I have a webpage on our intranet so users can go and enter their information to it, and they get a nasty error whenever they try to enter information. I'm trying to figure out why and i was just wondering... i know it's not the webpage because when i connect it to my test database it works fine? so i dunno :confused:

any help is greatly appreciated!!

View Replies !   View Related
Limit Number Of Records....
Hi All.
Is it possible to limit the number of records in a form, to a number given in a linked form.

For Example.

tblA
StreetName
No_Of_Houses


tblB
Name
Number

I would only want the number of records in tblB to be the same as No_Of_Houses in tblA.
I have seen previous threads where you can limit it to a number, but do not know where to go from there.

Can anyone help?

Thanks.

Frank.

View Replies !   View Related
Combining A Number Of Records Into One.
I have a table that contains a number of email addresses. I need to combine a number these into a single record to allow me to email a report to a number of different recipients depending on the client the report is for.

At this point Iím not even sure were to start.

View Replies !   View Related
Selecting Specified Number Of Records
I have a database that allows the user to order clothing items.
Each size of each item has a different stock number.

I have [StockNo] - [StaffNo] - [Qty] i need to generate [OrderNo].

The problem i have is that [OrderNo] is incremented after every five five items (ie[StockNo]).
This gives me my first problem of selecting just the first five records of a table in order to allocate an order number.

The second problem i have is that in order to allocate an order number, i have to summarise the [Qty] by [StockNo].
This gives me the opportunity to select the order number but i lose the individual [StaffNo] information.
This information, together with the [OrderNo] is needed for a master order table.

I have created a crosstab query which summarised the [StockNo]but how do i retrieve the [StaffNo] information from the column headings.

I am new to Access and would be grateful for any help or comments as to whether i am going about solving this problem in the best way.

Thanks

View Replies !   View Related
Number Of Records In A Query
Hi.
I have a form (frmdetails) to store job details and another form (frmMaterials) to add materials to each job. They are both linked via a field Project_No

I have a query (QryTotal)that when run will list the materials used for each project, that is all OK.

What I am tryng to do, is add a text box to frmdetails, that will just tell me how many materials have been booked against each job. Just a running total that will tell me that for project number 100000, 4 items have been booked.

I have tried using subforms (using =count(*) ) but this doesn't seem to be working. I also added =Count(QryTotal!Material) to a text box but this doesn't work.

Can someone help?

Thanks.

Frank.

View Replies !   View Related
Auto Number Records
I have a query that pulls data from two tables. I need to have another column in the query that numbers the rows like a primary index or gives each records a different number. Any ideas without adding any columns to the orginal tables.

Thanks in Advance,
Greg

View Replies !   View Related
Total Number Of Records
I want to run a query to add up the total number of records in a table.

i have looked at the Microsoft help but that tells me how to add together the totals of the fields but not the total of fields

any ideas?

Thanks

View Replies !   View Related
Sequentially Number Records
Hi, i have a query which contains two fields: PtId and visitdate. I'd like to create a field that sequentially numbers the visits.

If you're really smart, the second part of my problem involves computing the time from the last (or max) visit to the visit before it. I was thinking if I had the visits numbered it would make this task easier, but if there is another way, that would be even better!
Thanks so much for your help!

View Replies !   View Related
Maiximum Number Of Records
Hi-
Im importing 80,000 records into a table and then using a query to reformat the records and append them to a second table. The import works, but the append quits after about 6500 records. Is there a limit to the number of records an ACCESS query can handle?

View Replies !   View Related
How Do I Set The Number Of Records For A Page?
Is there a way to set the number of records to say....25 per page then starts a new page?

I do have a footer with the inserted "Page Numbers"

View Replies !   View Related
Duplicate Specified Number Of Records
Acc 2003

Hi,

Does anyone know if this is possible. I've looked but can't find anything like it posted within the forums unless I'm searching for the wrong keywords.

If I have a list of records on a continuous form, I want to drop a combo box at the end of the each record with a list of numbers in ranging from 1 - 100.
When a value is chosen, the selected record is then duplicated by that number.

For example, Select a record, choose 20 from the combo box = 20 new entries of the record.

Also, as a side issue, is there a way of omitting or clearing certain fields from the process.
For example, Serail Numbers are unique, so I want the user to have to manually key these in once the duplication process completes.

Hope I have explained this in enough detail.

Thanks
Kempes

View Replies !   View Related
Number Of Records Found
A form i have gains its records from a query. I know that the number of records found is displayed down the bottom, but is it possible to have a text box displaying this, so i can choose where on the form i have it?

TIA
Dusp

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved