Search results

Thank you, but how can I overwrite the existing file without the message box coming up. I want to do this over night so it doesn't disturb the users. Smilla

Hi there, Can anybody tell how to export the data from a Query to RTF via VBA or Macro? I have tried TransferText from a macro but this comes up with an error "cannot update. database or object is read-only". Any ideas. Thanks Smilla

Just an idea, Could i set a macro to run from the merge template on open. If so, I would have to pass a parameter to the word document from the hyperlink. For instance, c:/CompanyA.doc&Value="7" and when the merge template opens the merge report, it takes the criteria from the parameter and...

I'm trying to find a way whereas a user can click on a hyperlink on a webpage (intranet) and it opens a report with live data taken from Access. My idea was to create a word template linking the data source to the db. My problem was that I have 55 companys with 10 different modules (sections...

Thanks for your advice, its not really want I want. I may have a memo field which has a paragraph of text and then a hyperlink so I will not know for sure where to put the extra hyperlink field. Anyway, will have a think about it. Any other ideas would be appreciated. Thanks

Hello, Can anybody tell me whether I can have a text/memo box and allow the administrator (Can Edit) to add in Hyperlinks. I have an example:- Text Box: "The Special Report can be found Here ." With the 'here' being the hyperlink. Thanks in advance Smilla

Thanks, not totally sure what you mean but will work it out. What about creating a different word document for each Company? Regards Smilla

Hello there, I have been asked this question a couple of years ago and I did not know the answer but I'm hoping someone will know now. I want to export my reports to RTF Word which works ok but I want to create a different word document for each Company. Is there a way of writing some code in...

Sorry, but I have sorted it. Very easy solution, just added the ID field (hidden) and it recognised it. Thanks Smilla

I seem to have another problem. I am using subforms so when I click on the command button to open the form with the double criteria, it is not recognising the ID field. I am linking the ID from the sub form to the ID of the main form therefore what would I need to change to incorporate the sub...

I shall try and remember that. Thanks

Thank you, i always get stuck on that one. Is there any rules to following if I am putting more than one criteria together which are different data types? Just for future reference any way. Thanks again Smilla

I need a little help please I have just got this help from Access Visual Basic stLinkCriteria = "[MID] = " & me![OID] ' this one works (numeric field) stLinkCriteria = "[MText] = 'Text' ' this one also works (text field) but as soon as I do this:- stLinkCriteria = "[MID] = " &...

Hi there, Can anybody tell how to create a Text to Display and when the user clicks on the link it is a hyperlink. For instance, I'm guessing that in the table I could create a field called TextToDisplay, text field as well as Hyperlink field as a hyperlink. On the form, instead of the user...

Hi there, I have a form whereby I have Hyperlink text fields for users to enter in a new hyperlink. For some reason an error appears as I hover & click on the hyperlink. The error is Unable to open http://www.blahblahblah.com. Cannot locate the Internet Server or proxy server. Any ideas? Smilla

The simple ones are the best - thanks

Tab Controls I've just been searching out for some good advice on making the tab controls a little more pleasant on the eye and I noticed your remark saying you can add labels etc with some code behind instead of the normal tabs. Could you give me a little more information please. I am a VBA...

Hello Doug I came across your reply the above message back in 2001 as I am interested in doing the same thing in my db. After days of searching for this peice of information, I asked myself why hasn't Microsoft enabled this to happen easier in the newer versions of Access. I am using 2000 and...

Hi there, I was just wondering if you still have that sample database. I have a request for users to check/uncheck fields they wish to report on. It sounds as though your sample would be ideal. Thanks Smilla