Recent content by mitchem1

A 3-legged dog walks into an Old West saloon. He slides up to the bar and says, "I'm looking for the man that shot my paw."

Let's say I have a form with multiple tabs. If the various tabs are clicked, the form always looks the same. Would it be possible to have it so that only the left most tab (say tab A) contains data and other tabs (B, C, etc.) are empty? But by clicking a button, the user can duplicate the data...

It is in the Before Update event.

Hello all, I put some very simple code in a form. When a user tries to save a record or move to a different record, a dialog pops up that asks them if they are sure they want to save changes. It works just fine in the form. However, I have a user that likes to switch to datasheet view and do...

#@*##!@## You're right, totally embarrassed! What an idiot! I completely forgot I had added that stuff to the header. Thanks.

Here it is

It won't let me upload the mdw file (invalid file type) and I'm not able to zip it up either. Can I change the extension and then have you change it back?

Crap, I never thought about that. What would be the simplest way to get around this?

Hello All, Thank you for all of your ideas. Unfortunately, I still can't figure this out. I am going to attempt to upload the database (front and back ends). I have a report called rptContractsByDateFinalized. The source is qryContractsByDateFinalized. Originally, the user wanted to use a...

Must be hiding somewhere but I sure can't figure out where. I deleted every control on the report but 1 (date) and it still prompts for the 2 fields in question.

Total Deep Search did find references to the 2 offending fields, but I still don't see how to fix the problem. One reference was found in Sub Object - Group Level 0, Location - .ControlSource. The other was found in Sub Object - Group Level 2, Location - .ControlSource. If I double click the...

Using Access 2007. When I run my report, it prompts for a beginning and ending date as it should. However, it also prompts for 3 fields that are no longer included in the report or the query (they were at one time). The query runs fine and prompts for beginning and ending date only. I looked...

Access 2003 Is there a way to find out which users are members of a security group in the workgroup file?

Thanks AccessGuy 49, Using the variable worked like a charm.

If Month(Date) > 6 Then FiscalYear.Value = Year(Date) Else FiscalYear.Value = Year(Date) + 1 End If Since Month(Date) = 7, I was hoping this would return 2011, but it returns 2010. The + 1 must not work?? Thanks for any help.