Search results

Hi All – I have just encountered a strange problem in my long running DB. Users enter a clients name, surname and DOB and the system checks for existing records; if none, we need to know if the client exists in the master file. The user clicks a button displaying all records for the entered DOB...

Hi Richary - yes, she is just double clicking which takes her into Word. The Macro (in Word) then saves the RFT as a DOC, always in the LINKED REPORTS folded and then closes the RFT and opens opens the DOC file, saving it with P/W protection. She then closes Word. It just seems that when she...

Silverboood - are you asking why you would use IIF statements? I use them a lot on FORMS when displaying different data depending on different variables. For example- we use a code A if a client needs to be kept track of. If the client has been on the system for more than 3 days the name appears...

Hi Ed - I concur with the others - DON'T run compact on the the server unless you are very certain no one is still in the DB. I learned the hard way - we had problems with data disappearing when I set the Compact on Close - even though it should not run if the .ldb indicates someone is still...

Password Protection for E-mailed Access Report Sorry this is a bit long winded but here goes - we have a very simple Access 2002 DB of 60 – 100 client records. It’s updated weekly and a report is then sent to a distribution list. In the past it was printed and faxed. As all on the list have...

Pat - thanks for your reply. I am going to stay away from setting security due to the work setup here. I am part time, and we have problems enough without trying to password anything. But again, thanks. Yours Dika

I have a very simple database used by 3 users at a time. It is split into BE and FE. One user accesses the DB with queries only so I have created a DB with the master file linked - and literaly nothing else, She will then create and save all of her queries here. But - I want to keep her from...