Search results

Hi There, Hoping someone can help as I've got a bit stuck! I am dynamically constructing an SQL query within Access VBA to allow a user to define what columns they want to include in a query and then also define the criteria. My VBA then constructs the SQl code from what they have entered...

Hi, I have a form which loads containg a sub form based on a query. The query is definded in a previous form by the user who selects options from a list box. I've got the query defs VBA sorted and all works fine. However, the form that loads showing the sub form which displays the query...

Hi, Thanks for your reply, after playing about some more I think the above code isn't the root course of the error. I've been trying to trace it back to true break point but I'm having no luck at the moment. The database contains a lot of VBA and it's all very advanced in terms of my...

Hi Everyone, I am trying to get a database working that was written by an old colleague of mine and worked perfectly well on Access 2000. I am now working on Access 2003 and part's of the database are no longer working, I presume because of the new version?? There seems to be a common point...

ok well thanks very much for your help. much appreciated!!

i dont suppose you know already what changes i need to make to the code to adapt it to my report names, my file path and file name that i want to save as do you?

when the save as dialogue box comes up, i can specifiy whatever filename I want and it saves no problems. But I had thought from the code that it was already specified where to save and the file name to give it. I may have a look at the other option you supplied and see if I can get that one...

sorry, its too big to attach but it is being written and the other registry entries are also there.

Just checked and it is being written. see attached pic.

Yes I have the software installened and it all works fine. the file is being outout to a pdf but it asks me for a filename where i thought the code states the file name and file path to save it to. I really need the function to save to a pdf without asking the user where to save it to and what...

I have found that attached bit of code which is working fine, apart from it opens the save as dialogue box even though the file name and location should be set in the code. Anyone know why this is happening? Thanks

just one more questions!! if the user has a pdf writer installed, by vba could the report be set to print and define the printer as the pdf writer?

hmmm, back to the drawing board then!! I need to able to export an access report to pdf so it can be distributed via email as and when needed. I have crystal reports which would do the trick, only problem is my end users will not!! Thanks for your time today!

Do you know if it will work if I'm working with Access 2000?

No I haven't, I thought that might be it. but not sure where to get it from?

Can anyone help? I need to save a report to a PDF and am using the following code: Private Sub Label16_Click() DoCmd.OutputTo acOutputReport, "All Active Change Controls Report", acFormatPDF, ("Change Controls" & Format(Now(), "mmmyyyy") & ".pdf"), True End Sub I am getting an error saying...

Thank you so much!! that works a treat now!! You are a star! :):):):):)

Thank you!! that now works!! Any ideas if I can supress the workbook from opening? As at the moment the workbook opens, then when I close it down, excel notifies me that the workbook is now free for editing and freezes up when I try and say Cancel as to not open it again. It will be an end...

Thanks for your help with this David. I have already defined the Range within Excel, it is called Access and I have used this in the transferspreadsheet code, but it is still bringing it in 3 times. How can I amend the code so that it doesnt Loop and only looks for the named range? Thanks

Yes the cells are in the same place, from cells A1:I1 on sheet6