Search results

Solution using "resume next" I used. The NoData cancel event from the first report did not allow me to run the second report because I typically code the "Resume Exit..." in the error handling section. So I used a "Resume Next" to ensure the second report runs, even if the first has NoData...

Almost sounds like the codes entered for November are not the same as the codes previously used. Could it be an "O" (oh) instead of a 0 (zero)? Or perhaps there is an extra space in the code field.

Same problem I had the same problem. Last night I stepped away from my pc for dinner, came back to shutdown and received an access error. The database shutdown abruptly. I figured I would run a compact & repair in the morning. I attempted to recover with the suggestions above: run compact &...

I guess the easiest is make four shortcuts on their desktop. That would save you coding. Check out this MS Knowledgebase article And this MS article if you use passwords

The first field in the subforms are highlighted. Is there a way to turn this off? The field should only highlight when the user tabs or clicks into the subform. Thanks!

Ryan- Now that you described the users pattern of data entry it make sense. I would add the code to the forms beforeupdate event. This way even if they navigate off the record (using record selector or close) it will fire. So your exit or main menu button simply closes the form. But before the...

Can you supply some more details- The users typically open how many of these databases (menu choices) in a given day? Do you they jump between the databases often or do they sit in the same database most of the day? Could the databases be joined together in one application vs. seperate...

Thanks all. I knew this had to work sooner or later ;) I found the problem was two fold 1) The field [High School ID] was no longer on the main form. So the recordset would get the update, but the form which is linking to the subform did not recognize the change in value. In otherwords...the...

So you are doing a simple zip code check. Thats it? No City/State/Zip? Simply go to the US Postal Service web site

Thanks for your help Rich, Mod and WayneRyan! I greatly appreciate it. The popup gets the school ID, and this school ID is held in the recordset as ID. This ID is linked to a subform which holds all the detail information about the school. The idea is if you are browsing students, you would...

I hope you are joking. Sounds like more coding pain than coding the button above. Any chance you are setting focus away from your main form? What are your users doing? they must be moving off the main form or maybe you have some other code running which forces an update???

Alex- First, you posted in the Forms Forum. You should have posted in the general section. What is your ultimate goal? To call a program from within Access which will perform the login & address lookup or to import an external data table into access and do the state/zip checking in access? Two...

Rich- Trial and error. Yes the nomenclature is the issue. I'm still getting the main form giving me grief. As soon as the SetFocus executes I get the main form giving me the update message. I need the SetFocus, otherwise the subform NEVER shows the correct record. The recordset is still holding...

Rich/Mod- Yes the TxtHighSchoolID is getting populated by the popup result. BUT Now I need the subform which is linked to the TxtHighSchoolID to refresh/requery using this new value of TxtHighSchoolID. The rub- I can't do a Me.Requery because that causes the whole recordset to requery and then...

Sorry, tried that already and received a 'method not found' error message. I also tried a docmd.repaintobject, but it complained the object is not open. DoCmd.RepaintObject acForm, "High School SubForm"

I have a popup form, whose result value is used on a form. I then want to refresh a subform linked to this value. A requery is not good, because I don't want to prompt the user to update. The refresh/repaint of the subform does not work well. In Main Form: DoCmd.OpenForm strPopupForm...

Thanks Doc Man! Any good documentation on the different libraries?? Not necessarily the guts (objects,methods,syntax). But more on the general overview of when each is required. The ADO, DAO libs are described in every access book. But not the office, word, etc..libs... -norm.

Okay, Thats it Pat! I'm not sure why you need to select Microsoft Word 11.0 Object library. Under 2000 I did not have to select 9.0 object library. Strange. Quick question- I assume the Microsoft Office Object Library includes the objects/methods in the Microsoft Word Object Library. So...

I have a database which can perform a mail merge on my windows 2000 machine running access 2000. I moved the db to WinXP machine running Access2003 and I can NOT get the mail merge to run correctly. I tried OLE, DDE, ODBC. No luck with the merge within access. No luck running a merge from within...

I wanted to close the backdoor Admin user (default system.mdw) to ensure nobody will copy the db & mess around. I tried it manually but did not work (move Admin to Users group & remove permissions for Users group) Then ran the wizard and like magic the db is now secure. So what else is the...