Recent content by AlliCarr

That's strange, the bypass works fine for me and my objects are usually sorted by type. I have opened it in design view and saved it and now it works! It's bizarre how when I did that after creating them and changing the settings several times yesterday, it didn't work. At least I'll know what...

Thanks @Gasman, the code for randomising data worked perfectly. Here's a copy of my DB. I have had to remove quite a few forms, reports and queries as the front end file is too large but hopefully you'll still be able to take a look at the relevant section. In the front end file 'CRT Support...

Hi, I have 4 reports in my database which do not open when opened in report view. The queries the reports are based on have been updated but it was just the change of a field in one table to a field in another and the query works perfectly when run alone. The reports worked fine previously so...

Thanks @Gasman and @Pat Hartman I'll take a look at your suggestions and try them out.

I don't need to view the reports but it would be useful to save them to a folder and to print them too.

The report combobox is used to filter the reports. It is based on a query which selects all the reports in the database and then the report is opened based on the combobox value.

Hi, I'm not quite sure whether what I want to do is possible but, here goes: I have a reporting form in my database which can be used to select a list of reports and the criteria for the reports. The example below will bring up all the grants our organisation has made in a specific geographic...

I have found the information on the Microsoft Support website on how to do this but I'm a little apprehensive as in the 'Allow Trusted Locations on my network' checkbox it states that this is not recommended. Is this due to security issues?

I never thought of this! That would be extremely easy to do. (y)

How would I do that? This is the first time I've built an Access database so am really inexperienced. The information I've found online about making the folder a trusted location mentioned using the windows registry app.

The database is split into the back end, a front end .accdb file that I can use for future development and a front end .accde file for users. I know it would be ideal for me to send out a copy of the .accde file to all users but this isn't practical at the moment as the users don't have Access...

The file is on our network in a folder I set up which I would assume is a trusted location but will check with our systems administrator. There's also no option in the properties to unblock the file.

Thanks, this is the first time I've done this so all info helps!

Hi, I have just split my database and created a .accde file to send out to users. However, when opening the .accde file the warning below pops up. When I click 'open' it takes me to the log in page which is fine but I'm trying to prevent users from having to click the message every time they...

Brill! Thanks, works perfectly!