Recent content by Stevo3737

thanks bud, I'll look into that. Working with dates and time is a pain haha.

Well I added the button to the file in 02-03 format and It just created the VBA for me. This is good except for two problems. #1 I am getting an error because of duplicate primary keys. #2 I am looking to increment date by 364 days because we are re-booking events for the same day of the week...

Hmm so If I add the button while the file is in 02-03 format perhaps the button will work correctly? Or would I have to create the button using office 03? Otherwise maybe I can find what the macro would look like in 02-03 format and then just adjust my macro. Thanks again SOS.

Thanks for the help anyway. I did use the wizard to create this duplicate record. I was trying to avoid writing more VBA but it looks like a might have to make the plunge.

No all Macros are enabled. I am using the same version of Access to open the file, the file is just saved as an older format. Eventually this DB is going to be used on a computer which only has office 2003.

Here's a screen shot, sorry for it being in excel I was having trouble meeting the file size limitations. I'm guessing it's something to do with the yellow caution symbols. When you scroll over those it says. "This action will not be allowed if the database is not trusted." Hence why I...

I have a duplicate record macro button. In Access 2007 it works fine. However, when I convert the file to 2002-2003 format I get the error posted in the title. I basically added my entire C: drive to the trusted locations, but that didn't do anything.

Thanks! That was easy.

I have a form which is populated with a record chosen by a combo box. I have set Navigation Buttons to "NO". However, when I TAB through the form and I get past my last button, I am taken to the next record. Anyway I can stop this? The only way I want someone to be able to switch records is...