Search results

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...

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...

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...

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...

Dear all, I have seen this query posted in numerous places before, but I have been unable to locate a complete answer. I would like help please with counting a yes/no field in a query/report. I understand that Access counts a "yes" as -1 using the "sum" Total function, and I have seen...

Dear All, I have used this forum with great success in the past, and I am embarrassed to say that my current problem is so humiliatingly simple that I feel I should apologise for insulting your collective intelligence! However I don't seem able to solve it so here goes!: I'm using Access...

Please help! I have just finished creating an Office application to store, manipulate and report data. I enter data in Access. Excel imports and manipulates it, nad then a Word mail merge outputs the report. I had been working with test data that worked fine. I deleted the data in access, and...

Hi, I'm not sure if this is an Excel Problem or a Word one, however if anyone can help I'd be very grateful. I'm starting a mail merge, and trying to connect to an Excel spreadsheet (xlsm format and has a simple macro within it). I cannot connect to it as I get the error message "External table...

Hi there, I've used this forum successfully in the past, so hopefully you will be just as helpful again. I am trying to produce a report that takes its data from a query, and filters by way of another form with unbound text boxes for inputting report criteria. When the report is produced it...

I am sorry, but I can't believe I don't know how to do this in Access 2007!!! Not meaning to insult everybody's intelligence, I have created a Form, and now I am not able to resize text boxes individually. Whatever I try, changing the width of one text box (by dragging or changing width...

Hi There, I have recently upgraded from Office XP to Office 2007. I had an Access database which worked fine in Access XP. In it I had a table linked to an Excel spreadsheet. When I entered data on an access form, it updated the Excel spreadsheet [source document] accordingly. This does not...