Search results

Sorry! Dim strFileName As String Set db = CurrentDb strSql = "Select company_information.quote_template from company_information INNER JOIN (customers INNER JOIN quotes ON customers.CustomerID = quotes.CustomerID) ON company_information.ID = customers.ResponsibleCompany WHERE...

In Access I do write into a temporary txt file that I read with the Word macro. But it never gets to Word because the code is interrupted in Access. BTW: It's a docm file and I didn't want to use an auto excec macro because the file is a template.

Hi - I'm getting a very strange File not found message. I have set up my Access FE in a way that users can use an Access BE database or a MySQL database. To create quotes/invoices I pass data to Word - this works perfectly using the filepath stored in the MySQL database. With the Access database...

0.00 - this is what I needed! Thanks a lot!!! FRANK

I already tried your format() suggestion, but the problem was that if the variable was zero the output was ,00 Maybe there is a way to solve this? Btw: the values are passed on in a temporary txt file and then inserted into bookmarks. Regards, frank

Hi! I need help: I'm passing a few numbers on to Word and these should always appear with two decimal places, also if it's a whole number etc. e.g.: 10 -> 10,00 or 9,8 -> 9,80 Depending on the regional settings, the decimal marker can be . or , Thank you for any tips! Frank

Hi there - I would like to export my report data to Word using a preformatted Word template. Here I found a very nice example of how to pass queries on to Word: http://www.kallal.ca/msaccess/msaccess.html 1 However my report contains some calculated fields built in the Expression Builder. 2...

Hi there - did you manage to solve your problem? Could you maybe post your updated code and your word template? That would be cool! Thx, Frank

Add a textfield and delete the caption. The content of the textfield should be: =[hostname] & ", " & [MAC Address] & ", " & ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,"

Hi there - I have a few expandable fields in the detail section of my report. If the report has more than 2 pages, sometimes the expandable fields are cut in half and displayed partially on 2 pages which is of course not so good. Can I somehow tell Access simply to move these fields to the next...

It's definitely not a problem of empty fields. All those fields that you see in the design view are all filled with data. The emtpy space on the report is really just empty space. So every field gets its own row, instead of placing the filled fields next to each other as requrested by my...

Hi there, in my report I would like to integrate a calculation table that only appears in certain cases. I thought the option of making text fields expandable is a nice solution. Now I did place several text fields next to each other (see attached image). When I run the report Access places...

Well, every now and then there are users who can't install (and buy) the application because they have 64 bit office installed. Microsoft says that pre-installed office is by default always 32 bit, even on 64 bit OS, but I doubt that all these people install 64 bit on purpose/on their own. So...

OK - do you have any experiences with deploying a 32 bit and 64 bit application? Is it possible to run win 32 bit + office 32 bit and win 64 bit + office 64 bit on one PC?

Hi, the problem I currently have is that people interested in my 32 bit Access app complain because they cannot install/run it with Office 64 bit. Is it possible to simply convert my 32 bit app to an 64 bit app by opening and saving it under Office 64 bit? Or how does the conversion work...

Well, the majority has Word and those who don't could still use my app. But if I populate a Word file, there will be users who can't use my application at all. ....I just want to offer my users maximum formating flexibility....any ideas??

Hi! I was thinking today if it is possible to fill Access reports based on a specific Word template? I don't want to populate a Word file with Access data as users of my app might not all have Word. Or is there another solution using a WYSIWYG editor where users can format everything according...

Thank you - that was good advice. Building the form from scratch didn't help, but then I simply deleted the form elements successively to see what element is causing the error. In three different forms I had text fields named jobid etc. that caused the errors. After renaming them, the errors...

...ok, but I don't see how that relates to the fact that Access simply does not recognise my query field criterion (form!customerid) in one form, while everything works fine in the other...

...don't know! But I get the same errors when I change the regional settings on my system...