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 Rhinorhino 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 toptech

  1. toptech

    Header printing issue when name is the same but address changes

    Excellent. Didn't think of that. Thanks for your help. Worked in a second. Toptech Top Tech Systems If you help 3 people and each one of those help 3 other people and so on, imagine all the people being helped.
  2. toptech

    Header printing issue when name is the same but address changes

    Hi All. Been a while since I have done this. I have a customer list. I have customers with multiple addresses. I need the customer header to print when the customer changes or when the address changes. I currently have 2 header and footer sections. Customer header and footer Address Header...
  3. toptech

    How do I pass form field into criteria of stored procedure

    Hi Jose, That is exactly what i did. Thanks, Jeff Top Tech Systems If you help 3 people and each one of those help 3 other people and so on, imagine all the people being helped.
  4. toptech

    How do I pass form field into criteria of stored procedure

    HI All. I am converting and MDB to ADP. I have a stored procedure that I created with 2 fields. PropID needs to have the value of a form field passed on to the criteria box. My Stored procedure is as follows(Qry_Append_Requisitions_Remove): ALTER PROCEDURE...
  5. toptech

    ADP View in MSaccess not sorting properly

    Hi All, I create a simple view with 3 columns: In MS SQL SERVER Management: VW_Property Columns: PropID,Property#, and Tenant I sorted it by: Property# - Ascending 1 Tenant - Ascending 2 When I run it in MS SQL SERVER Management it sorts properly. When I run it in mty MSaccess 2007 app, it...
  6. toptech

    Linking an excel spreadsheet

    Hi All. I am trying to link an Excel spreadsheet using a macro. This macro will link the spreadsheet if the file exists in a directory. Everthing currently works if I specify the exact range. Macro Looks like this: I am using: Trasferspreadsheet Transfer type: Link Spreadsheet type: Excel...
  7. toptech

    On Timer, Interval ???

    Hi Aceman1, The files are created at different times of the day from another system, so they are not available to be sent all in one shot. Regards, Jeff Top Tech Systems If you help 3 people and each one of those help 3 other people and so on, imagine all the people being helped.
  8. toptech

    On Timer, Interval ???

    Hi Aceman1. Thanks for your feedback. I thought about your response. My idea was to do without windows scheduler, I currently use windows scheduler to run some of my code that will email all my selected files each day at one particuler time. However, The idea is to check what time each file...
  9. toptech

    On Timer, Interval ???

    Hi There. Can someone tell me how this works. How do I use the on timer and interval to automate my app to execute an email at a certain time of day and the week every week. I have a table of records that contain locations of files that I would like to email on certain day and time of the...
  10. toptech

    VBA task scheduler

    Thanks for the info. I will check it out. Jeff Top Tech Systems If you help 3 people and each one of those help 3 other people and so on, imagine all the people being helped.
  11. toptech

    VBA task scheduler

    Hi There. I have a table that contains 5 records of files with their locations that I need to email at different times. I Need to schedual day of the week and time of day. Does anyone have vba code to this. Thanks in advance. Jeff Top Tech Systems If you help 3 people and each one of...
  12. toptech

    Send e-mail from different mailbox

    Wincey, can you show us your code. I am trying to setup code in msaccess 2003 to send an email and have had no success. I posted my code last night. Thanks in advance. Jeff - Toptech Top Tech Systems If you help 3 people and each one of those help 3 other people and so on, imagine all...
  13. toptech

    send email from msaccess 2003

    Hi There. I have been trying to send email via msaccess 2003. I have copied and this code from the tek site, but something is still not working. I have created an module with the following function. when I execute the function - I get no error message, but I receive no email either. can...
  14. toptech

    Invoice Total to Print only on last page at same position

    Skip. not sure what you mean by putting it at the top. However, my client is old school and is pushing me to duplicate what he had on old system. As we always say, "He who pays the bills, gets what he wants". Jeff Top Tech Systems If you help 3 people and each one of those help 3 other...
  15. toptech

    Invoice Total to Print only on last page at same position

    Hi There. I have created a report to print an invoice. However, I need to be able to print the invoice totals always in the same postion at the bottom of the invoice.(The invoice footer perhaps) If it goes over to second page, it should only print totals on bottom second page. These are being...
See more

Part and Inventory Search

Back
Top