Recent content by Maa421s

Thank you both for your suggestion. That works perfectly! Now to address the SetFocus commands... I inherited this application, which does all validation checking in AfterUpdate events and assumed it was coded correctly. I didn't have much Access coding experience prior to this assignment...

Here is my problem In namefield_AfterUpdate, I check for duplicate name entries and notify the user if any are found - they are prompted as to whether the duplicate was accidental or intentional and continue working. This works fine for normal circumstances. However, if the user updates...

Ok, this was fixed by changing my default printer from OneNote 2010 to an actual printer on my network. Another unrelated post led me to try that. So, if reports can't be viewed, try changing the default printer... So obvious... Sigh...

I have an unbound report - which is actually a form for the user to print out if they need one. There is no data on the form. Here is the code that is run when the Button is Clicked: 'First, I reenable the Access menus so that they can use those to print DoCmd.OpenReport...

I was also able to correct this behavior by setting the Detail Alternate Back Color to something. Seems like a bug to me... Thank you for this post - it saved me a lot of time.

I am converting an XP/A2003 app to Win7/A2007. EDIT: I tested some more - Could this be because of Windows 7? I do not have this problem with A2007 on XP. The colors are the same with both Access versions on XP. So could Win7 be the issue? The problem is that in XP/A2003, I start with...

I must use XP/Access 2003 to solve this problem for reasons I won't get into. I have a report with a Group by on City. The users need to be able to sort by Coordinator within that OR by Client Name based on a selection they make on the form that opens the report. -- I have tried to set...