Recent content by FrankC

Hi, Does anyone have any ideas on how I might prevent a database from being copied. I have an application that I have set up with a number a tools to prevent exporting to an empty Access container, and from accessing the database design via the ShiftBypass feature, but the database can still be...

Hi, If there are any fishermen out there that would like a demo database for recording catches, please contact me. FrankC

I have created an algorithm that creates an activation code based on a customer name intermixed with some standard characters. This works fine except that it sometimes creates a blank character in the body of the text string (eg the string may be "f7Hk d3ghx"). I would like to remove the blank...

Thanks for the advice. I have done something similar by adding filters to the pivot table and printing a number of reports. However, the pivot table is a forward projection of the preventive maintenance programme for a complete site and I really need to get it all on 1 report. I could do this if...

I have a large pivot table that I need to print on an A0 printer (1189 x 841mm) which I have properly set up. When I try to print it I get a message "Cannot print or preview as the paper size selected is greater than 22.5 inches". I can't work out what I need to do to make Access accept the...