Topics Search

Can I limit a Table to only one record ?

Can I limit a Table to only one record ?
Views: 11
Have problem with operators entering dates as I cannot put input masks into the dialog boxes when they ask for a date.

So I decided to have a Table [DateFromTo] with two fields (Obviosly DateFrom and DateTo).

All OK, but wandering fingers always find an error in this sort of thing and as I need the DateFrom and DateTo to use as criteria in subsequent queries and reports I want to make sure there is only one of each.

That is, I want to prevent the operator from being able to accidentaly open a second (new) record in the table and then inputting another pair of dates.
Sponsored Links:

More topics


Adding a record question

When I attempt to add a new record to my table, it appears to work, since the record at the bottom increments. However, when I go into the actual table itself to look at the records, it seems to limit the display to 10.

When I click the filter icon, I have to select the record to see it. What settings do I need to set so that I am able to see every record in the table ?

Limit a specific value from a lookup field to only ONE record at a time?

I'm wondering if there's a way I can set a table up with an intrinsic limit, specifically that only ONE record at a time (this will vary) can possibly have value X selected from a lookup field containing assigned values X, Y and Z. If so, how do I do this?

Making a button limit the view of the records

I must limit the possibility of viewing the records by day and by person. Every record has a person that entered the record and date. I want to make my button (buttons for record navigation) limit by person and by date so you can only view that current date and if you entered it today. (by date

Limit to fields in a Table

Just a quick question, is there a limit to the number of fields you can have in a table, if so does anyone know what that limit is

Using the date on one form to limit the records from another table

How do I limit the records in a query to a certain month? Example: I want to know how many records (count) there are in a table for the month of September 2009 from one table - but use the date on a form from another table.

Table 1: Complaints Table 2: CostOfQuality
Table 1: Date Field: "ComplaintDate" Table 2: Date Field: "Month" (always entered as the first day of the month like 9/1/09.)

Form: frm852COQ

The report uses Table2 as the record source (the current record on frm852COQ) I need to total the number of complaints from table 1 for the current month and display the count on the report.

2007 Access - Record too large

I have a database that currently is 300M. Periodically, I get a Record is too large error. The information I have seen on the web generally say that the limit for a row is 2K, limit for a column is 255 (change to Memo). However, when I get the error (visual basic program), I compact and repair the data base and rerun the same process that caused the error and the problem does not recur. So it seems it is none of the above problems

Text Box control and character limit?

I have an unbound text box on a form. The form is bound to a query but only for reading records. The unbound text box is programatically populated with data from the form's recordset. If the text gets around 2038 characters long trying to save via the form produces the error "could not update; locked by another session on this machine." I can still update via the table, just not the form. Also, if I have the form viewing the record containing this long text then even via the table it says the record is locked and cannot be updated.

**The field in question is in its own table because it is a memo field that gets changed regularly in production. The production environment has this as a bound control but I am trying to implement unbound controls to avoid excessive record locking.**

Is there some limit on text controls regarding length of text? I cannot find anything by googling or searching this forum

deduct order quantity from credit limit

I have on my customer master, a field for credit limit. The user can input the credit limit for that particular customer. When the user then goes in to the order screen, in the line item section, I would like for an message to come up if they have reached their credit limit. So I know I would have to compare the order quantity against the credit limit. Would I do this in a query? Do I need to create a different type of query instead of a standard one? So I would want to see:


I want to get the sum value of LIMIT on distinct value of FACID.

Table: A1
A1 F1 100
A3 F1 100
A2 F2 100
A4 F5 200
A5 F5 200
400=100+100+200= sum of (Limit) for unique FACID.

Need to display this value in the form?
Form contains all the record?
then need to display sum of distinct FACID,LIMIT then sum

Access DB Size

I have a 2007 Access Database with 14 tables, 3 queries, 21 forms, 2 reports, 7 macros, and 3 modules.

I know that there is no row/record limit but there is an overall file size limit of 2 GB.

What I need to know is the average size of a record in my DB so I can estimate how many records it can hold. I attempted this by making a copy of the existing DB with all of it's 200+ records and then deleting all the records, leaving only the structure (tables, forms, etc.).

However, when I compared the size in the properties of the "empty" DB to the functional DB, the size was exactly the same (20,744 KB).

Is there a way I can find out the average record size so I can estimate how many I can fit in the DB with the 2 GBlimitation?