| Thread | Last Post | Replies |
|
| Simple validation rule needed | 19 Sep 2007 16:40 GMT | 1 |
I have a form that people MUST enter data before saving the entry. What is the validation rule to not leave a box blank? Thank you!
|
| Combo Boxes | 19 Sep 2007 15:40 GMT | 2 |
I'm creating a form that will show 3 lists of fault messages. The fault messages are all stored in the one table and are sorted by a fault type. I have a Sort Order query for each of the 3 fault lists, which is where the form gets them from. On the form there is a combo box for ...
|
| linking subform to subform? | 19 Sep 2007 14:58 GMT | 2 |
I have a form that has the Delivery Header as the main form, a subform showing containers, and another subform showing items in the containers. Record ID is the link field thru the form/subform1/subform2. The problem is I only want the detail (subform2) to show for the selected
|
| Using a combo box as a filter | 19 Sep 2007 14:40 GMT | 1 |
I am having some difficulties setting a combo box as a filter on a main form. I have a single form with the record source set as a query. Within the detail section, it shows all the records currently logged on the database which can be scrolled down (currently about 150 records ...
|
| Form/Subform link | 19 Sep 2007 14:24 GMT | 3 |
I have two tables and relating forms. One holds information about camps and the second holds data about each visit. I want to make the visit form a sub form of the camps form. Each form is based on a tabe with campID field set as the primary key. The two tables have a one to ...
|
| Typing to sleect an item in list box | 19 Sep 2007 13:56 GMT | 3 |
Ok, this one has to be easy becasue I can't find it anywhere. I have a list box. I want to select an item in it. When I type... every keystroke brings me to the first entry with that letter instead of going to the second letter in the word I am typing. For example when I type ...
|
| Requery a Combo Box After adding New Record To Its Source Row | 19 Sep 2007 13:43 GMT | 3 |
Im fairly new to access so forgive me if this is a simple question! I basically have a form from which the user can select a customer and a vehicle from two seperate combo boxes. This assumes the customer and vehicle already exists! I want to be able to place a button next to ...
|
| need to make a formula that would add a field value to current dat | 19 Sep 2007 13:14 GMT | 10 |
I have made a form in which I input different values. On of the values is (How Many Days). Now I need to a assign a default value, or expression (not sure which way to go about this) that will take the date value for (Date) and add the value (How Many Days)
|
| DLookup in subform | 19 Sep 2007 12:20 GMT | 11 |
Using Access 2007: Form - frmNewQuote Continuous (Tabular) Subform - subfrmOptions with unitPrice textbox calculating price from value entered into materials field in the subform
|
| Pivot Chart; Missing Categories; Have you cracked this one? | 19 Sep 2007 12:14 GMT | 7 |
I have a questionnaire result I want to chart. The question is "How likely are you to..." and the answers are out of ten with ten where they are extremely likely to and 1 where they are extremely unlikely to. No one gave answers 6 or 9 out of ten. I want to show all categories ...
|
| Time | 19 Sep 2007 10:12 GMT | 4 |
Is there anyway to set the time so it will come up as '6am-7am' when you press a start time button? There is 4 boxes that will gather data over 12 hours. The form looks very crowded just now as I have set it up with 48 boxes to gather the data.
|
| Lock a Form From Multiple Users | 19 Sep 2007 04:07 GMT | 5 |
My primary table contains records for different departments (loans, deposits, etc.). I have a form set up for data entry which has a filter applied at start up to only show the records for a specific department (loans). Therefore in this example, I have two forms that are ...
|
| My before update for Date modified is not working? | 19 Sep 2007 03:59 GMT | 1 |
A few weeks ago I had help setting up my before update section of a form I have to enter students information, it was all working so that when I added or edited any student information I have 2 fields Date modified and Time modified on the form that would automatically update, it ...
|
| CancelEvent in BeforeUpdate still allows attempt to write record | 19 Sep 2007 00:26 GMT | 3 |
1) I am using Forms with built-in macros. The file being written has a multi-field key to detect duplicate entries. How can I prevent the system error messages when a duplicate is detected? Is there an error number that will let me correct the entry before the attempt to write ...
|
| suppress empty cell | 18 Sep 2007 21:56 GMT | 6 |
When printing in form view, can an empty field be suppressed so it doesn't print out an empty box.
|