Recent content by NewbieUK

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?