Search results

If you look at the code behind your Print command buttond. Is there a line that reads DoCmd.PrintOut If there is change it to: DoCmd.PrintOut acSelection That should do it I think. ATB, Pete

I found the solution and it's quite simple. I took the sql from the query and added it to the VBA code behind a command button: Here goes: DTable = InputBox("Please enter a name for the output table", "?") mysql = "SELECT table1.Field1 AS F1, table1.Field2 AS F2, table.Field3 AS F3 etc… INTO...

Is there a way to prompt the user for the name of the table to be created in a make table query? TIA, Pete

I'm no expert but a couple of things that spring to mind are: In the properties of you picture is the size mode set to clip. The other options can leave your image looking blocky. Also I wouldn't imagine Word is the best application in the world for editing images. You can download pretty...

I thought this was going to be a simple fix but after consulting with this forum, books, on line help and workmates I am still none the wiser. The only way I can think of to get around this prob is to constuct a dynamic sql statement with loads of If ... then... else or Select case statement...

Thanks for the reply Rich, but as far as I can see this only solves the problem if I can send values into the query depending on which checkboxes are checked. I'm afraid I'm still a bit lost. Ppete

Can anyone help? I want to filter a form with a number of check boxes. I've got two checkboxes for a field called Market, (UK & Europe), four more for ShopType and another for ShopStatus. I've started out using the following code behind the after update property of the checkbox... If...