Search results
-
E
Run-time Error
I’m not sure if there’s a fix for this but here’s my problem. We have an Access DB that was originally written for Access97 by a consultant no longer in business. It has since been converted to Access2K. However, we are running it under Access 2003 (I know – confusing). Many things are... -
E
Proceed if record found
Not quite sure what this all means, but I believe I resolved one my problems. I set the "Limit to List" = YES. However, I have a similar situation - only here, I want the entry to be unique. I have the field set to "no dups". This works fine except if someone enters a duplicate entry, it... -
E
Proceed if record found
I’m sure this has been address numerous times but I can’t seem to locate. I have a combo field in a form where I key in a value and it returns and populates other fields in a different table. It works great except if someone keys in a bogus value. The entry progresses as if it was OK. I’d... -
E
Verify data message
I have an update form which displays a field that is indexed with no duplicates. It defaults to EC-xx where the xx should be changed. Is there a way to prompt if it is not changed? I tried the after update parameter on the form but was unsuccessful. Thanks, SKK -
E
Update Table-A from Table-B
This is great. I'll have to incorporate into my full DB but I'm sure this will do it. Again thank you very much, SKK -
E
Update Table-A from Table-B
I have a database where we track Permits and Inspections. I would like to update the T_Inspect table based on an entry in a form. If I keyin a permit number, I want it to populate the Inspection form with the data from the T_Permits table (not simply display the linked data – I can explain... -
E
Print Query by Form
CyberLynx Superb.... Thank you very very much. This is exactly what I had in mind. Again, my thanks, SKK -
E
Print Query by Form
CyberLynx, Without beeing too much of a bother, this is close but when I click PRINT on the frmIndex form I see all the records not just the ones I queried (as show up on when the PRINT button is clicked on the frmSearch form). I like the Edit/Done option. Maybe I'm missing something, SKK -
E
Print Query by Form
Sorry for reposting this, but I was hoping I (or should I say you) could help resolve my issue. My original post was: "I have a Query By Form setup (based on Ken Getz QBF.exe routine) -- it works great. I have one more wish. Is it possible to print the result of the QBF to a specified report?"... -
E
Print Query by Form
I have a Query By Form (based on Ken Getz QBF.exe routine) -- it works great. I have one more wish. Is it possible to print the result of the QBF to a specified report? Thanks, SKK -
E
Validation Rule
I meant lack of screen space. I wanted three fields in a line. Howver, one of them was quite long. I guess it's working OK now. Thanks for your time, SKK -
E
Validation Rule
Is it possible to set a Validation Rule for a form input field based on a field in a different table? I have a small table (tblSuffix) with road name types (i.e., STREET, ROAD, AVENUE, LANE, etc). I can add these separatly to the validation rule on the form's properties field, but it would be... -
E
Open form in ADD or EDIT mode
First off, I’m not a programmer so please bear with me. I have a database with a STARTUP form that has two command buttons (NEW & VIEW), which run macros. Each macro opens a form, one in ADD mode, the other in EDIT. The two forms are basically identical except the EDIT form has a PRINT button... -
E
Sort Query
We have a data entry form with a command button that opens a query where our sidewalk inspector enters construction dates. He wants the query sorted by "address". There is a Notice_ID field he also wants to see. If he resorts on the Notice_ID then inadvertently says "yes" to save when... -
E
Sort Query
I have a query that has four fields. One is used only as a sort field. It works fine. However, if someone resorts the open query on one of the other fields (not the one used as the sort in the query), then inadvertently says “yes” to save when exiting, the next time they open the query, it is... -
E
Create database copy
We have an Access database that tracks sewer maintenance. It was originally created for Office2K, now runs under Office2003. One of the forms has an export button that creates creates a copy of the database prior to exporting to another DB. This works fine under Access2K, however, the "copy"... -
E
Print to network printer
Thanks, that did it. I probably set that a few years ago and forgot about it (this old brain just aint doin what it used to). Thanks again, SKK -
E
Print to network printer
I have a form with a button that prints a report. However, we installed a new printer but the button is still attempting to print to the old printer. I have looked at the code but can not tell where it is calling out the printer name. Is there a way to hard code in specific printer for a...