Search results

Thank-you will give your suggestion a go the next time I use this function.

PDF or Snapshot is no good as the report is actually a standard letter with a diagram on it. On some occasions the user will need to manipulate the text. Might have to set up a word template with the diagram on it and merge it with the data or give the user the data on a form for them to...

Hello all. I have a report in Access 2010 that my users will sometimes view in MS Word. I have recently had to add an image to the report only to find that the image does not appear in word, I presume because the report is converted to rtf before being opened in word. Does anyone know if...

Not sure if there is a quicker way to do this in 2010 yet as I'm still navigating my way around it, but here is something like what I do. (Sorry if not posted correctly, I always forget how it is meant to go in here) 'Behind a comand button save the report as PDF file DoCmd.OutputTo...

I have a database designed in 2k that contains a WebBrowser activeX control that, at one point, is used to display and print a PDF file on a web server. This has worked fine when using 2k however our organisation is changing to 2010, a big jump. While the control still works to display web pages...

Now that makes it much easier to find some info :). View Only was what our IT department called it, no wonder I could not find anything. Many thanks again

Many thanks guys. Thats about what I wanted to know, and thought would be the case, just was not able to find anything on it. I will have to wait to see if any of my dodgy VBA will be rejected by the 'View Only' version. Thanks again for the info.

Morning All, I was hoping someone could point me in the right direction for some info on the 'View Only' version of Access 2010. Our company is moving from Access2k to 2010 later this year and in it's wisdom is going to restrict many users to 'View Only' and only purchase limited full access...

Not sure if this would be helpfull or not, you could set all your controls to display on screen only so if they do print via the file/print method they only get a blank page.

if vField has a name property,vField.name, that returns the name of the field does it also have a value property, something like vField.value, that returns the value of vField.

does something like this work? strName = "a" & Replace(vField.name, " ","") rs.Fields(vField.name) = strName

Not sure if this will help, have you tried using DoCmd.SendObject? That is if it still works beyond 2000. I believe this will work with the users default email program, so long as one is installed on the users PC. You just do not have much control over what goes into the email. This way you...

Sorry for not responding earlier, labor day long week end here and I do not have access at home. Your web site is a little more difficult to read as the tables are not as well structured. I have made some changes to my original program and re-loaded it for you to have a look at. There is an...

Not sure if this would work but you could try to use a where clause within your line DoCmd.OpenForm stDocName, , , stLinkCriteria you seem to have turned it off in your code sample. Set the strWhere to filter just the 3000 series if "ABC" is selected or 5000 series if "JKL" is selected...

Not being a legal person I'm a little confused with your formula Statutedate =DOB +SOL + 18 To me this means if your daughter was born in 2000, the accident was in 2010, and the SOL was 4 years then the answer you would get is 2022. If the person was over 18 then the answer would be 2014. (2010...

OK, good to know as we will be changing to access 2010 late next year. One more thing I will have to change.

How about a tab control instead? Put each subform on to a separate page on the control and the user simply selects the page they wish rather than trying to hide subforms.

Wow way to make things easy. :eek: These two example files are different and would need to be dealt with differently. There seems to be some anomilies with the actual data, the second file seems to contain " between more " so the import throws up errors. Also you forgot to tell people there is...

Yep your right in relation to the first version. It puts the HTML code of the page into the string crap and then manipulates that to find the country and subsequently the values of the type, buy and sell prices. In the last version I just ran it a few times to figure out that your table...

Your welcome. I have had a bit more of a play with it to tidy it up a little, although when doing it this way you need a reference to Microsoft HTML Object Library, this file already has it. I have re-posted again for you to have a look.