Search results
-
E
How to tell if form is open
This is probably very easy, but I have not been able to find an answer. I am using DLookup to pull info from a table based on the selection I have on one of two forms. If form A is open I want DLookup to use the selection from form A otherwise I want it to use the selection from form B... -
E
Automatically add record to another table
Items will be added to the Item table under certain categories. Each item may then be further categorized at a later time by sub-category. When an item is created, I need to already have a sub-category associated with the category (eg. an "Uncategorized" sub-category"). To ensure this, I need... -
E
Automatically add record to another table
I have a form a user uses to add to a table "Categories". I would like to have a record automatically created in another table "Subcategories" each time a record is created in the "Categories" table. The "Categories" table and "SubCategories" table are related by the Category_ID field. Any... -
E
Help! Need to clear "List Box" value after selection
The above code didn't work but I figured it out. All I needed to do was place the following code in the After Update of the 1st List Box: 2ndListBox.Value = Null -
E
Help! Need to clear "List Box" value after selection
Where does that code go? Thanks, esurfer -
E
How do I create a two part report
Ahh, I figured it out. Very easy. I just have to use sub-reports! esurfer -
E
How do I create a two part report
I'm not quite sure how to go about creating the kind of report I need. I have 3 tables, I'll call them "Categories", "Sub-Categories", and "Line Items". I want to print a report that shows on the first pages each "Sub-Category" grouped by "Category". Then I would like to have each "Line Item"... -
E
Help! Need to clear "List Box" value after selection
I have 2 list boxes that are synchronized. The idea is for a user to select an item in the first list and then select an item in the second list (if there are any.) I have this part working. The user then presses an "Edit" button to open the record that the selections refer to. The problem I... -
E
Inserting Date On Enter
Actually, I hadn't realized the former was available. So perhaps if you could inform me on both ways, but my original query was just to insert the current date upon double clicking. Thanks esurfer [This message has been edited by esurfer (edited 01-29-2002).] -
E
Inserting Date On Enter
This has got to be simple but I can't get it to work. I have a "Date_Modified" field that I want to be updated with the current date when I double click on the field in the form. (Not On Enter as my title suggests, my mistake) I added the expression =Date() to the text box Event "On Dbl Click"...