| Thread | Last Post | Replies |
|
| Error 2471 | 12 Feb 2008 20:09 GMT | 11 |
I have the following code in the AfterUpdate event of a control. It produces the error. "The expression you entered as a query parameter produced this error. The object doesn't contain the Automation Object Forms!frmOrderDetails!LoadedDate"
|
| Clearing form after error | 12 Feb 2008 19:46 GMT | 14 |
When an item entered into a drop down box is not found, I have the application bring up a form so that the item with appripriate info can be entered. When that form is closed I am returned to the original form which is which is fine. However, the erroneously entered information ...
|
| Dependent combo box | 12 Feb 2008 19:35 GMT | 3 |
I've seen several posts related to this, but I don't seem to be able to get the answer. I have a table with people in it and another table with contact info (phone, email, etc.) The contact info is an ID, personID that relates to the id of
|
| Date turn time calculation HELP PLEASE! | 12 Feb 2008 19:16 GMT | 3 |
I have a some what messed up situation and hoppe someone out here can help. On my database form I have several date field but I only need three to work in a turnaround time. Here's what I have: Executed Scan Date, Funding Date and Original Docs Received Date. I need to
|
| Lock records against edits | 12 Feb 2008 19:16 GMT | 3 |
I have a form with several subforms that lists invoice information. Within one of the subforms there is a check box that indicates if invoice is complete. I am trying to lock the forms from update if the check box is checked. I have searched through the Access Discussions ...
|
| Form and subform | 12 Feb 2008 19:14 GMT | 4 |
I have a form (master form) and sub form What I want I want to put a button in a master form to change the view of the subform from data sheet view to single form view
|
| UPDATE QUERY not updating data | 12 Feb 2008 18:53 GMT | 1 |
Is there something obvious I should know about or is it plain magic? I've got a Access 2000 file format database in Access 2003. I've got a table called [Jobs] and I'm developing a way to edit a Job. So I've created an identical table called [EditedJob]. After clicking
|
| Avoid warning message from outlook when open it from a form | 12 Feb 2008 17:54 GMT | 2 |
I have a module to sent email from access with attachment is a pdf Access report. But when trying to display outlook new message window, outlook send a message:
|
| Computer name | 12 Feb 2008 17:12 GMT | 3 |
Is there a way to have a txt box on a form read the computer name and show it? thanks Al
|
| Queries to lookup a value | 12 Feb 2008 17:09 GMT | 1 |
I have a situation where what I want to do is: Combo Box one [Field 1] shows all the options e.g.: (Fruit, Meat, Breaed) Combo Box two [Field 2] shows all the options that have been limited by [Field One] e.g.: (Apples, Pears, Oranges)
|
| Running SQL statements in VBA | 12 Feb 2008 17:00 GMT | 4 |
I am constantly getting an error when I run the following sql statement in docmd runsql: dim sqlcheck as string Dim db As DAO.Database
|
| Remove Limit to list when in filter | 12 Feb 2008 16:36 GMT | 2 |
I have a main data entry form, Frm_Tbl_Master_Jobs, on which there is a combo box, cbo_RepName, that contains names of sales reps. I have set the Limit to List property on cbo_RepName to yes; however, when filtering I need this to remove the Limit to List restriction because ...
|
| Cascading Combo boxes | 12 Feb 2008 16:21 GMT | 27 |
I am creating a form with bound combo boxes. The Plant filters to the corresponding Process which filters to the corresponding Equipment. Plant-Process-Equipment I have all the combos boxes working. The issue I am having is when I
|
| count visible records only on continuous forms | 12 Feb 2008 15:40 GMT | 2 |
I would like to programmitically count # of visible records/rows in a continuous forms or datasheet format. So, I may have 200 records as the total recordcount in my recordset, but, I want to know how many are actually visible in the window.
|
| Change the text of a label on a modal form | 12 Feb 2008 15:16 GMT | 5 |
Hello. I'm having a bit of a hard time wrapping my head around exactly why this isn't working the way I have it written, because I'm quite sure I've done this very same thing before and it worked just fine. What I'm trying to do is use a single form to display a variety of system ...
|