Search results

Thanks isladogs. I'm having problems with the DoCmd.OutputTo for some reports that I'm exporting to pdf. I have a workaround for these but trying to find shorter coding to manage them. I thought having a printing module might help, but the one I found wouldn't compile in VBA - and you have...

Thanks June7 - it appears this code is for Excel not Access. isladogs has given me pointers to Access coding. Much appreciated

Hi, The following code I found on https://www.tek-tips.com/viewthread.cfm?qid=599797 supplied by a programmer Nelviticus. It was back in 2003. I'm using MS Access 2021 and I can't compile this. The first stumbling block is SetPrinterProperty with ActivePrinter with the error 'Variable not...

Thanks to sxschech I have a workaround using the DoCmd.Printout command which I found in the similar threads below. Thank you sxschech. It's much appreciated. I would still prefer to be able to use the direct command DoCmd.OutputTo.

This is a wonderful workaround for my problem with DoCmd.OutputTo. Thanks a million.

Hi I'm using the following piece of code to automatically print to pdf 4 different reports in an Access DB (2021) DoCmd.OutputTo acOutputReport, "ReportName", acFormatPDF, myPathnFile This is working perfectly for 2 of the reports but not for the other 2. These reports are also manually run...

Thanks Pat. Very useful to know. Option groups are trickier than I thought, so I will stick to the basics for them. Thanks everyone for the help. Moving on to the next challenge in the DB !!!!

Ok, thanks Mike.

Hi all, Thanks for the advice and helpful suggestions. I did have extra code added to the DoubleClick Event of the Frame to change value to "". Although I wouldn't have thought this would interfere with the workings of the option group. I deleted the option group and started again with the...

The frame of the option group is set to the Field. Actually I've realised that the responses are correct in the table, but the options on the form are all showing the same. If I click No on one Option Group all the No's are activated. There must be something on my form that's interfering. I...

Thanks for coming back to me. No, the binding is working fine. My problem is isolating the current record so that the response only appears in the current record instead of all the questions. If it wasn't bound it wouldn't appear at all. Ginny

I have a simple option group set up to record responses to questions on a form (Yes, No, Pending). This works perfectly for single records. I have the list of questions on a continuous form binding to a Query for the selected questions. So in design mode there is a single record with one...

That will be a future feature. Hopefully I won't be involved then. I'm supposed to be retired!! Thanks :cool: Ginny

(y)

Thanks to everyone for the help with this problem. I've learnt a lot. Appreciated.

The WHERE FieldA IN (SELECT Param FROM ParameterTable)[/CODE] was the most efficient and simplest solution to what I needed. I make a table from the ListBox.ItemsSelected and use the table in the Query exactly as listed here. I delete the table after the query has run. Marvellous. Thanks so...

Yes, I have tried it a few different ways, putting the string values in form textbox and in a global variable and also in a global single field table. Would WHERE FieldA IN (SELECT Param FROM ParameterTable) work if I could put the values from the listbox into a table?

Correct - not a lot of data :)

Yes, I have a listbox set to multivalue, a textbox and a button to run the query on the form. I would like to try this solution suggested. My problem is what exactly should I have in the textbox for the query criteria - [Forms]![YourForm]![txtIDs]. I can construct the textbox to contain it...

Thanks Gasman, I'll try replicating the attached and see how I get on with it. I'm assuming you ended up with a string output from your function, what does your query criteria look like? Thanks for going to so much trouble with this. Ginny