Recent content by toptech

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.

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...

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.

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...

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...

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...

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.

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...

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...

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.

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...

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...

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...

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...

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...