Recent content by pcastner1

I tried the criteria above but still get more than one month. I put a [startdate] and [enddate] but didn't work. Can I query the start and end date to just show a certain month?

I have a query to find an employee and the month my query has this for the date>=[Start Date] And <=[End Date] and my employe has [Enter Name]. Everything works until the report. it shows all the months not just one. So if they select the month of Feb they also Jan.

What I'm trying to do is make it easy for an administrator to edit the database. When it opens it is read only. When the admin needs to make edits have a button turn off the read only.

Is it possible to have a command button with a password that when clicked would unlock records for editing, and when clicked again would lock all records?

Sorry I'm not understanding.

Ok changed checkbox to true but no luck. Private Sub ChkMailingAddressSame_AfterUpdate() If ChkMailingAddressSame = True Then Me.MailingAddress = Me.Address Me.MApt_lot = Me.Apt_Lot Me.MCity = Me.City Me.MState = Me.State Me.MZip = Me.Zip Else Me.Address = "" Me.Apt_Lot = "" Me.City = ""...

Walked through it but doesn't work. Here is the code: Private Sub ChkMailingAddressSame_AfterUpdate() If ChkMailingAddressSame = False Then Me.MailingAddress = Me.Address Me.MApt_lot = Me.Apt_Lot Me.MCity = Me.City Me.MState = Me.State Me.MZip = Me.Zip Else Me.Address = "" Me.Apt_Lot = ""...

I made the changes and when I check the box nothing happens

Wow! now that I look at it what a bonehead mistake. Thanks for the help.

I have an issue with a code I'm using. I have a code that when I enter the address info, if the mailing address is the same you would use the checkbox to fill out the mailing address. I'm using the code below. Private Sub ChkMailingAddressSame_AfterUpdate() If ChkMailingAddressSame = True...

I have a similar issue I have almost the same code, when I enter the address info and check the box the mailing info doesn't fill out. Private Sub ChkMailingAddressSame_AfterUpdate() If ChkMailingAddressSame = True Then Me!Address = Me!MailingAddress Me!Apt_Lot = Me!MApt_lot Me!City = Me!MCity...

Thanks for the advice I certainly will look at that.

Here is the database with the report.

I reposted the Database with the report (Org Chart). I think once you see it you will understand what I'm trying to do. I really appreciate the help!

Here is the database. In the report I tried this in the control source of the "Name" field, = DLookup("[LastName]", "Contacts", _"[JobTitle] = Director"),