Search results for query: *

It's a clunky two step solution but I would suggest encapsulating a function that first saves the report in rtf format and then via automation invoke Word to import the rtf, save it as a doc file, delete the old rtf and voila you are done! Since you can bring up word invisibly so nobody will...

Guys, I'm curious too about saving in the pdf format. I am wondering about some of the freeware and shareware PDF file solutions out there. I did a search on google for "freeware pdf printing" and got blasted with quite a hitlist of selections. Maybe one of them will work for you...

Hi Guru's I am writing a documentation application that requires granting the user the ability to show their file selections by dragging and dropping files onto an Access Listbox or Textbox so that the full pathnames of a file can be obtained. I know it can be done in Visual Basic. But I'm...

I spent a bit of time trying to find out how to do this. Actually found this example in the Access 2002 Help File. Just wanted to share. [thumbsup2] Ted -------------- Compacts and repairs the specified database (.mdb) or Microsoft Access project (.adp) file. Returns a Boolean; True if the...

Saad, Making sure that all of the workstations have identical MS Office setups is a pretty good surefire solution. There is possibly one other solution for you should this happen again. It's not pretty but it works. (At least for our company) Licensing issues aside. Simply put the missing...

Hello Malaviya, On Microsoft's MSDN Online, I found a helpful explanation of the different ways to manipulate images with Microsoft Access. Perhaps you would care to have a look? Please have a look at the following documentation: Store Images in your database...

FancyPrairie DUH !!! Forms![frm_ToDo]![mySub_ToDo].cmdFirst should be Forms![frm_ToDo]![mySub_ToDo].cmdFirst_click I think it was too much ice cream and soda. Thanks for the reality check. Ted

DUH!! Solved. I found that I used a REAL Form as a subform instead of a Report as a subform. Thats why I couldn't get rid of the formatting! Ted

Can anyone please tell me... how do i get rid of the ugly formatting borders and shading that appear in the sub-report section of my Access 2002 reports? Any help on a solution is very much appreciated. Ted

Here's my code. Forms![frm_ToDo]![mySub_ToDo].SetFocus Forms![frm_ToDo]![mySub_ToDo].cmdFirst The first line is no problem. At least the correct form is being referenced. But when it gets to the second line I get the error: "Object doesn't support this property or method." Any...

Hi MaxEd Try these web sites for the information you want. http://www.hitmill.com/programming/vb/Hungarian.html http://visualbasic.about.com/library/weekly/blhungarian.htm Hope it helps Ted

Ok I will tell you what seems to work for me. I like using customized dialog forms hovering over a maximized main screen. The trick is setting the type of form to dialog, and popup. This will prevent the form from reverting to maximized. As a bonus both forms are totally independant of each...

Maybe try something similar to this: '------------------------------- if Not IsNull(DLOOKUP("ID","TrainingDetails","[ClientID]='" & tblCLientSelect.ClientID & "' AND [Date of Training] = #" & Me![lstClient].Column(2) & "#" )) Then...