Recent content by Fi64

I have made an unsecured copy by exporting each item in the database to a new one and will now do more research before setting the security. Many thanks for your help.

Sorry - I meant to say I was working with Access 2003.

Thanks for the link - much appreciated :)

I just tried to do that - and I can't. I can access all the tables through an admin log-in when using the shortcut that was created when I set the security and I could duplicate it all in a new database but I assume then that the existing security wouldn't work? Thanks

Thanks for your reply. At the moment it isn't causing any problems but the potential is there and if I can somehow sort it out I would appreciate any advice. I am not a programmer by any means and have only dabbled a little with VBA. Having read lots of posts here about the security I realise...

I have successfully set up security on a database that is held on a network and access it throught the shortcut that was created at the same time as I set security. However, when I try to get into the original database neither of my admin passwords work.. I have a general admin password set and...

Hope someone can help. I have a report that contains several address fields. I have set the 'can shrink' property so if a field is blank it moves up to remove the blank. However, I have to make the report look like one that currently exists which involves sectioning the whole report off...

Thankyou I am not very good at using the visual basic in access but I have converted my macro (code below). It all works apart from actually inserting today's date in the table field. I am missing something very basic I am sure. Without the close option in the macro it ends with the cursor in...

Hi, I hope someone can help. I have a macro that appends and deletes records to a new table once the the record has been closed. I need to record the date this was done in my original table and the new table and have had brain freeze as to how to achieve this. Any suggestions??

Thanks for your reply. I have made copies of the database, the security file and the shortcut, using copy paste. I tried to create a backup from the file menu and thats when i hit on problems. It is on a network so the worst case scenario will mean i have to speak nicely to the IT dept ;-)

Thanks, I had changed one part of the line but the ref to my personal folder was there twice!! It works perfectly now .. ty I didn't set a default workgroup file and its the back up i tried to create after I set security I can't get into. I have access to the .bak file but it was made as I...

Hello I hope someone can help. I have successfully set up security on my database which is a muti-user one. However being ultra cautious before I started i made a copy in my personal folder (working on a network) to assign the security. I used the option to create a shortcut but now that I...

Hi, Thanks for that .. I had the date + or - ok .. it was how to create the email .. but I have it now having created a macro using 'sendobject' Thank you for your reply Fi :D

Hi, I've been looking around the forum and it has so much great advice.. I would try to answer some but feel a little out of my depth! I hope some kind soul will feel able to help me with the following :) I have to create a database that flags via email, prior to a due date, on a due date and...

Its a very simple macro that opens the report and defines the print options .. but its not in code. The report is developed from a parameter query that has the date field criteria set to 'true' this is the code that access created... Option Compare Database Private Sub Preview_Report_Click()...