Search results

Sorry I can't. Could I send it to you as a private message as it isn't ideal to post it on an open forum, even though there is no genuine data? Thanks, Mark

Hi Adam, Thanks very much for your assistance. I'm relieved I'm not the only one to have got stuck with this issue. Unfortunately my knowledge of Access is pretty much limited to built in functions and applications, and I really start to struggle with SQL queries. My Query is several fields...

Re: Query by Combo Box / Query by Form Controls Hi Adam, Thanks very much for your assistance. I'm relieved I'm not the only one to have got stuck with this issue. Unfortunately my knowledge of Access is pretty much limited to built in functions and applications, and I really start to...

Hi All, I have a query set up to use the input from a combo box in a form as my criteria. This works fine if I enter data in it, but I also want the query to include ALL records if the combo box is left blank. Basically I have multiple filtering criteria, and I want the Query to ignore all the...

Hi All, Could anybody tell me please why a switchboard created in Access 2007 produces an error message, something like "Error: Var("Switchboard")" in both Access 2000 AND 2003, despite saving the database in the relevant compatible file format? There is nothing at all complicated about the...

Bob, Your comment above........ "But that appears to use that as well to make sure that you don't have a form open in design view (which can't happen in an MDE/ACCDE file anyway, so the check is pointless in that)." ...... set me thinking, and what do you know? As I run all my forms in...

Hi Again Bob, The modified code you suggested still works fine in the ACCDB file, but unfortunately gives me exactly the same error in the ACCDE format ????? I am well out of my depth now. Anymore ideas gratefully received???? Regards, Mark.

Hi Bob, Access 2007 doesn't give you many options for splitting; it just does it! However when the split was complete all Tables were in the Back End as Hoped. Everything else, including links to these tables and Module 1 (with IsLoaded function), was in the Front End. The IsLoaded Module...

Thanks Dave, Could you point me in the right direction or help with some instructions for this please? also do you have any idea about why the IsLoaded module now causes an error? Thanks, Mark.

Hi again, I've followed the steps carefully to split my database, make a back end and front end, and then converted my front end to an ACCDE file. I still seem able to see, open and edit tables, macros and queries. Also I have a report module called IsLoaded in my original database, and...

Thanks again for the advice. Have found some help screens what you advised and should be able to take it from there. Cheers, Mark.

Hi Scooterbug, Thanks for the advice. If I were to do this would it simply mean copying Forms into a fresh database and then re-linking them. I have a sneaky suspicion this would mean a lot of re-working? Also our computers at work "do not" have a local gard drive. Everything is run from...

Ha ha, thanks! Please see my latest post!!!! Mark.

Dear all, I have been posting quite a few problems over the last few days as I've been working on a project for work, and I just wanted to say thank you to everyone for their assistance and patience! You will be delighted to know that the project now seems complete, and all I have to do is...

Thanks very much Bob, Mark.

Hi, I want to set up a report to view in print preview as default, to make it as easy as possible for the end user. I've set the default view to Print Preview, but it still stubbornly opens up in Report View. I have an old database where I achieved my goal, and I've checked every setting in...

Thanks for your help. Regards, Mark.

The Checkbox is inside a frame, and cannot be moved without disrupting the rest of the report, i.e. the headings which the frame is grouped with (the headings are in the right place). ????

Dear All, Is there a simple way of centering a control (i.e. a checkbox) on a report? The checkboxes seem to be aligned to the top right of the field that they are in. I have tried removing the report's Contol Layout, but the report's layout is then competely disrupted. Surely it must be...

Hi All (especially Bob!), I think I have stumbled on a solution. I'm sure I've seen it posted before (possibly on here so apologies if I didn't spot it's effectiveness before), but failed to make it work. It seems easier than some of the other options, so I thought I might post it for your...