Search results

Good afternoon, I have a form from the Switchboard and when ever I click on a command button and go into a form everything is maximizing all right, but when I close the form, DoCmd.Close, the form I am using for the switchboard appears normal and not maximized. I have DoCmd.maximize only in...

Ray, I am getting a compile error: Expected: End of statement and it hilites the = and the entire line of code is red. Any thoughts on this? Thanks again.

Thanks again Ray, I will give that a try, after I amke a copy of the dbase. Se, mama did not raise a fool. Thanks again and I am now done.

Thanks again for all of the help Ray, I will try it shortly. I do have one last dumb question here, is the a way to make that full patname a globe variable so I only need to change it in one place? It is now used in almost a dozen procedures.

Thanks for the response Ray. but how do I check on a file outside of the dbase?

Thank you for your response, Bob. I will give it a try, but I never hear of kill in Access VB, but I used kill in UNIX scripts allot.

Good morning, I have an OnClick procedure, that creates a snapshot report document, which is outside of the dbase, but in the same directory, My Documents. I would like to delete it after it is e-mailed and I tried playing with DoCmd.DeleteObject but that appears to be for things inside of the...

Thanks for the response, I will give it a try. Oh, a few years ago when i used to work on and design this beasts, I used to know this stuff pretty well, but you know the old saying, if you don't use it you lose it. And that is what happened.

I tried this after putting in the subroutine in the reports OnClick and it errors out tell me it can not find things like Me.recipients and so on. Here is the OnClick code: Private Sub PrintqselReportData_Daily_Click() On Error GoTo Err_PrintqselReportData_Daily_Click Dim stDocName As...

Thanks again for the response. I modified the module like you said and it now looks like this: Public Sub Send(recipients As String, from As String, subject As String, smtpServer As String, Optional msg As String, Optional attachPath As String) On Error GoTo handler Dim iMsg As Object...

Thanks alot for the response lagbolt. I have changed the code to a late bind as above and I put them in a standard module called modMail. Now I have a standard switchboard with a cmdButton on it and that is how I run a simple macro which just prints the report and at that point I was trying...

Thank you very much for your response lagbolt. It has been a couple of years sense I last built databases and I am a bit rusty at it right now. I did understand what you said till you said put modMail in a reference library database. Do you mean put it in a separate database as a module or...

Thank you very much for the response lagbolt. Like I have said, it has been a minute or two sense I last did this and I am a bit rusty and I followed everything except the reference library database. Is the a separate dabe with modMail as the onlt Item or what? I have not used that method...

Good morning, I have a home based computer running XP Pro and Roadrunner Web Mail as the e-mail agent and Outlook is not on the computer. I found a script that says that it can do this, so I put it in a module and tried it but I can not get it to run in that macro, which is run from the...

Thanks again for the help, but I have a couple of unsolved questions. In references I added CDO for Windows and I am running on XP Pro, so do I have the correct Reference? I did put this in a module, but I can not get it to work in a macro using RunCode, so how do I get it to work? Last...

Thank you very much for all of these great responses. Forgive me here I have not done any code writing in over a year and I am very rusty. Lagbolt your code looks pretty good and I am going to try and us it but I have a couple of quick questions, first do I need to turn on any references...

Thanks again for the response, but I have tried Rich Text and it does not know how to open, both before and after e-mailing, until you select it then it opens. I have not tried to open HTML with a browser and I am not really sure how to explain it simply to some newbies. I di just find a...

Thanks for the response FoFa. I have not worked at all with CVS file and I have tried OuputTo, but with snapshot the file is not readable either before or after e-mailing it. With Rich Text and HTML I am being asked what program to open it with. The computer that this will be running on does...

Can not really explain it, but sometime large font text are better and then there is the use of colored text as well. Different is not always a bad thing.

Well, if the heights are all the same and the fonts are all the same, then just increase the font size of the text box by 1 point and see how that looks, repeat till you get the desired appearance. Hope this helps.