Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JonEx

  1. JonEx

    list box showing reports ?

    Hey thanks again Andy but unfortunately its not working right for me .. ok orginally my reports started with qrpt but i renamed all of them to rpt after making them.. so when i click on a report .. say rptLongChap when im actually in the report the title bar says qrptLongChap as i made them from...
  2. JonEx

    list box showing reports ?

    Hey, thanks but i was hoping that i dont have to change the name of my reports... i dont want to put the rpt or rpf...is it possible to still get it work using Sysobjects?
  3. JonEx

    list box showing reports ?

    Hey, i was wondering is it possible to have a list box that shows reports ? without the reports having the rpt or rpf infront of it? and if it is possible how would i go about that ? ----------------------------------------------------------- list box name : 1stRep command button to preveiw...
  4. JonEx

    Linking Database to webpage ?

    Hey guys, im sorta new to this database thing and i have a question ... if i have a database and i wanted it to be linked to a website where .. for example in my database i have itemno and products id want to link this information to my website where i can insert and image next to the...
  5. JonEx

    Add.Attachments can this be linked to a variable?

    Hey, yesss ! it worked ! thank you so much luceze. It's amazing how easily we overlook stuff! thanks alot, regards, Jon
  6. JonEx

    Add.Attachments can this be linked to a variable?

    hey luceze, did that in the command button and i put the msgbox just before the call sendmsg function .. came up with the location of the file i had attached. but when i put the msgbox strattach in the actual sendmsg function the message box comes up blank.. is there a way i can send...
  7. JonEx

    Add.Attachments can this be linked to a variable?

    Hey thanks luceze, tried it .. still doesnt work. Same Response " System cannot find the specified path" could it have something to do with these other functions within this module ? ************************************************************ Option Compare Database Option Explicit '...
  8. JonEx

    Add.Attachments can this be linked to a variable?

    oh sorry about that ..had changed it up before posting it again code for sendmsg ************************************************************ Public Sub SendMsg(strSubject As String, _ strBody As String, _ strTo As String, _ strAttach As...
  9. JonEx

    Add.Attachments can this be linked to a variable?

    Hey eric, ok heres the code code for command button to send email ************************************************************ Private Sub cmdSend_Click() On Error GoTo Err_cmdSend_Click Dim lngCurrentRow As Integer Dim strTo As String Dim strCC As String Dim strBCC As String...
  10. JonEx

    Add.Attachments can this be linked to a variable?

    hey, but it doesnt work .. it says system cannot find specified path
  11. JonEx

    Add.Attachments can this be linked to a variable?

    Hey, ok i have a form that sends emails now i have added a textbox and a command button that opens up a dialog box asking what file to attach,and when you choose a file the textbox shows the location. example [c:\file.txt ] [Command Button] my question is .. since its a dialog box the...
  12. JonEx

    What could be wrong wit this ?

    hey thanks grtammi, but it still didnt work, access came up with this error ... the system cannot find the path specified.. what would i have to change ?
  13. JonEx

    What could be wrong wit this ?

    Hey, ok i have a form that automates outlook , it has a subject and a message body the only problem i have to face now is how to add an attachment field in the form as well. ive tried some stuff but i get this error One or More parameter values are not valid. can anyone examine this code...
  14. JonEx

    One or more parameter values are not valid? using outlook?

    Hey, ok i have a form that automates outlook , it has a subject and a message body the only problem i have to face now is how to add an attachment field in the form as well. ive tried some stuff but i get this error One or More parameter values are not valid. can anyone examine this code...
  15. JonEx

    attachment field using automation of outlook

    hey thanks robert, but what if i wanted to attach the file using a command button, this is what i have so far ************************************************************ Private Sub cmdBrowse_Click() On Error GoTo err_cmdBrowse Me.txtAttachment = GetOpenFile_CLT("C:\"...

Part and Inventory Search

Back
Top