Can I limit a Table to only one record ?
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.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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 ?
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.)
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.
**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
NAME FACID LIMIT
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
I am working on a database that with one main table, and several form which have record sets using this table (bound). but there is one rather large problem: The table of records they want to search through has over 130 fields (I know, the DB itself was built before I began trying to improveit) When searching for a record, the only applicable field used is [Address], though the preconstructed Access search feature looks through the whole table.which takes a long time with 130fields X 50,000 records.
Can I build a function that searches through only the Address field in the bound table?
I've setup the timetable as a sub-form of the person form, what I would like to do is limit the number of records that the timetable table/form can hold a maximum of 7 records (each day of the week) and validate so only one of each day can be used.
I was think I could try and match the newest added timetable record against others for that person and see if any days match but can't think of the code. From waht I've read so far would recordset or clone functions work