I create a database in my PC with office 2003. Now i just find out it doesn't in office 2002. I mean Access 2002. I would like to know what is the main difference between. When we upgrate to Office 2003. They ask many question, such as would you like to open it ,etc. So i change the security to low. It works fine with all macro and get user name. But if i use default that is medium. It won't work. So i would like to know what do you do. Can you give me some piont so i can understand. I just know the office 2003 add security, they block some functions. Many thanks.
Yes, i should create the datbase in old version. But we will upgrade to Office 2003 SOON. When i click the data entry form. There is date that is automatically retrieve today's date. I create default value using date() in the table design. But when i open in old version it didn't show up the date. Also i use other field that is use function like edit =date. It also gave me error message.
I also use DoCmd.TransferSpreadsheet, i add reference in new version as Microsoft Excel 11.0 object library. But the old version is Microsoft Excel 10.0 object library AND Microsoft Excel 5.0 object library. Is that way i can chance back to old library?
Yes, it is datetime data type. If change to now it work. But i would like to know why. If i want to retrieve only date like 8/9/2007 short time not long time 8/9/2007 11:30 am. I need to change the format in table or form?