Recent content by HVACMAN24

Thanks. That way worked fine. I made this up a while back so I dont remember why I did it the other way. Thanks again.

Button code from form Private Sub btnPrinters_Click() OpenFile "M:\Engineering\Cooling Dev\Lab Printers\CoolingLabPrinters.vbs", Me!btnPrinters End Sub Function Code Public Function OpenFile(FileName As String, Cntrl As CommandButton) Set ctl = Cntrl With ctl .HyperlinkAddress = FileName...

I have a button that opens a script file which maps network printers to the computer. Everything works fine except when clicking the button Access open the script file twice. Any idea why that is and what to do to make it only open once? Thanks

I'm using the docmd.sendobject to send a report as a pdf file in an email, but I would like to be able to send a couple other reports in the same email. Is that possible?

Nevermind, I got it working the way I want now. I could have sworn I tried this earlier and it didnt work but now it seems to work everytime.

I've tried a few things but I still cant get it. I'm still fuzzy on the normalization part of it, I dont think my database would be considered normalized. But the combo box is displaying a project number and then a description. I do want both of these, once selected, to be seen in the box and...

I have a combo box that displays 2 columns when clicked. First Column contains a number and the second is a description. I want to be able to select the appropiate item and then show both values in the box and also store both into the table. How do I concatenate or get them together to...

Yea I went trough all that before posting on here but every combination i try doesnt work the way I want it to. I would think that from what the help says that, if string like " [a-z]"would work but its not.

How can i compare a string to check and see if it has an asterick in it? I know an asterick is a wildcard character for any number of characters, but I want to check and see if my string has one at the beginning of it then bold that particular string. The closest I got was bolding all my...

nevermind i found out that i can do a pdf format which will work fine.

Is there a way to export a report to word in a format other then RTF? I have a lot of stuff on this report and the RTF doesnt keep the boxes that I have in the report and they help break up the sections of the report. Thanks,

Is their a way to use special characters like "&" in a label on a form?

I added your code and its working like it should. Thanks a lot.

Another dept at work wanted me to look at a problem they are having in there database. I've fixed a couple of the problems but now I'm down to this problem regarding a SQl string, and recordset and could use some help if you can. I'm getting the error "Run-Time error 3464, Data type mismatch...

ahhh haah, That did it. Thanks a lot. That was driving me nuts.