Search results

What version of Access? 2003 Is this database split into front end/back end as it should be? No Are you the only one using the db at the time you're trying to back it up? Yes Thanks

Hi I have devloped a multi user application that required user level security. Works fine except when I want to back up the database I get this message that I don't have permission to do so. I gave myself admin rights. Does anyone knows why I can't backup the database? thanks

This sounds confusing but 2010 is a name of a column that contains a number. The formula is trying to divide the number in 2010 column by 12. I did not create this I was only asked to fix it.

Thanks for the quick reply. It's not a text it a number.

Hi, Can anyone tell me why this is not updating the table? UPDATE FMPSL SET MODE_PREM = ([2010]/12) WHERE (((DatePart("m",(DateAdd("m",1,Date()))))=DatePart("m",[FMPSL].[REG_DATE])) AND (([MODE])="M")); Thanks.

Hi, I searched everywhere for an answer but no luck please let me if you encountered this issue before and you have an answer. Thanks in advance We have this database (Access 2003) shared by 6 users. We have a linked object that open a pdf file when clicked on. It works for all users except...

David, Sorry I did not respond quickly I got busy at work. But I like the find file database you recommended. I think I can use it to solve my problem. Thank you so much.

Yes, I am linkking directly to the PDF file and we're keeping the old licenses for historic purposes. thank you

Hi all, I have this database to keep track of our company's licenses. It works fine. We have about 250 records, each record contains licensee's info and also has an ole field linked to a folder that gets updated directly from the form. All the linked files are pdf files. Whenever we...

thank you. I figured it's not easy to do since no one has given me an anwser. What I did so far is create a report and grouped it, exported it to excel. It's not the way i want it but it's close. Maybe it needs more programing.

Hi, I have a report gruoped by Owner that I was able to export to an excel sheet using the following code: DoCmd.OutputTo acOutputReport, "FinalReport", acFormatXLS, "C:\FinalRep.xls", True It's working but.. everytime I export it, it creates a brand new report. I would like to append data...