Search results for query: *

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

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

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

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

Hi There. Does anyone know how to set more than 1 copy when a report is printed. This must be inbedded using VBA. Thanks in advance for recommendations. 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. My question is: I am printing an Invoice on a pre-printed Invoice form that has many detail lines. I have put in a line counter to count over the group. I would like to force a new page after 14 lines of details. Any info on this would be appreciated. Thanks in advance. Jeff...

Hi There. My question is as follows. I am running MSAcess 2000. I am running an accounting system that is MSACESS based. I have a materials module that re-links the tables for this module. However, everytime you the user starts the material module, it takes approx. 7 minutes to re-link...

Hi There. Need help setting up a Macro to run at midnight. I can create the macro to run a couple of queries, but I need it to run in the middle of the night. Any help would be appreciated on how to set this up. Thanks in advance. Jeff Top Tech Systems If you help 3 people and each one...

Hi There. I have been using MSAccess since inception. I just begun to use MSAccess 2007. I inherited a 2007 application that had the Tables as part of the App. I split the app to separate the data from the app. I then linked the tables. I can view the tables,no problem. However, when I try...

Hi There. My problem is as follows: I am printing the page header on my report - works fine I have a field that displays the warehouse name on each page. That is great too. On the last page, I have grand a grans total for my report, but the page header has the most current warehouse...

Hi There. Does anyone know how to skip a line when printing. I would like to print line1 all the time, but not print line2 if it is blank. Any help would be appreciated. Thanks in advance. Jeff Top Tech Systems If you help 3 people and each one of those help 3 other people and so on...

Hi There. I have a hyperlink address stored in a field of a table. When I print the rest of the info of the record, I also need to print the actual document that the hyperlink is pointing to. Does anyone have any ideas of how I can trigger the printing of the hyperlinked file. Thanks in...

Hi There. I have added a hyperlink filed to my form. If I click on the link it opens the link. The link is a diagram. My question is: is there a way when printing the record in a report, can we print the item that is linked. ie. print the diagram when printing the report. Thanks for your help...

HiThere. Does anyone out there know how to make the cursor blink when you Tab into a field. Thanks in advance. Jeff Top Tech Systems 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 am trying to create a variale that can be used in a report for adding numbers based on criteria. I would have these statements in the detail section: if cost<200 then cost1=cost1+cost else cost1=cost1+cost end if I would like to show cost1 in report footer section...

Hi There. I am trying to insert a word document into an Access2000 report using ole. However I am getting the error: ole not registered. I found Norton Antivirus had the script blocking set and I removed it. I still have the problem. Any suggestions to resolve this would be appreciated...