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!

Register Log in
  • 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!

Search results for query: *

  • Users: JonEx
  • Order by date
  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:\"...
  16. JonEx

    attachment field using automation of outlook

    hey, ok i have a form in access that can send emails using automation of outlook. i can type a message and a subject and click send . and outlook sends it, now i was wondering if i can have an attachment field within this form as well? this is the module for the sendmsg function...
  17. JonEx

    Error message when trying to send email? using CDO?

    hey guys, i downloaded a sample dbase but it seems not to be working right .. i dont know what the problem is .. perhaps you guys can help me ? here's the sample code for the command button to send the email. Private Sub cmdSend_Click() On Error GoTo Err_cmdSend_Click Dim...
  18. JonEx

    gettin email address of a form from a query

    hey ... so what would the SQL string look like ? i dont know much about SQL
  19. JonEx

    gettin email address of a form from a query

    Hey Ken Reay, well no you didnt entirely missed the point i am just wondering how would i go about it ? for example the query name is qprtGrAt so would it be SELECT DISTINCT [qrptGrAt].[Email] FROM qprtGrAt ORDER BY [qprtGrAt].[Email] ive tried that but i get an exprs1 and then an...
  20. JonEx

    gettin email address of a form from a query

    hey im updating a current dbase and im having a problem right now i have a table for employess with there id's and email addresses , now i have a form with a combo box that shows these email addresses from the table SELECT DISTINCT [tblEmp].[Email] FROM tblEmp ORDER BY [tblEmp].[Email] now if...

Part and Inventory Search

Back
Top