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 derfloh 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: *

  1. puppygirl3939

    Suppress OLE Object

    I am using an OLE object in a crstal report to display contact photos. These photos are located in a folder on our shared directory. The photo is named the exact way it is named in our database. If it finds a match it displays the photo but when it does not find a match crystal reports...
  2. puppygirl3939

    Adding Multiple Records with a CheckBox

    Several months ago I posted this thread and I still need help with it. The answer to the questions posted by KevCon are: 1)is your tblCountySent table linked (one-to-many relationship) to your tblReferral table? YES 2)if so, is the subform linked (master/child) as well? YES 3)How comfortable...
  3. puppygirl3939

    Adding Multiple Records with a CheckBox

    I have 4 tables tblLead, tblReferral, tblCountySent and lstCounty. One Referral can be sent to one or up to 67 counties. Lead Table - LeadID,LeadDate,Source,Company Address Referral Table - LeadID,ReferralID,DateSent,Statewide CountySent - CtySentID,LeadID,ReferralID,CountyID County -...
  4. puppygirl3939

    Adding mulitple records based on a checkbox

    I have 4 tables tblLead, tblReferral, tblCountySent and lstCounty. One Referral can be sent to one or up to 67 counties. Lead Table - LeadID,LeadDate,Source,Company Address Referral Table - LeadID,ReferralID,DateSent,Statewide CountySent - CtySentID,LeadID,ReferralID,CountyID County -...
  5. puppygirl3939

    Sending Multiple Reports in one email

    I am going to try to write a .net app to accomplish this since I don't want to purchase a third party software. I am new to .net so it might take a while. The cost for the APOS Booster is to high. Thank you so much for replying to my thread.
  6. puppygirl3939

    Sending Multiple Reports in one email

    I am trying to send 3 reports in one e-mail. I tried creating and running an object package, but if a package has 3 objects associated with it, when it runs it sends out 3 seperate emails. Ideally, I would like to have only one email sent per object package, with the multiple object outputs...
  7. puppygirl3939

    Add multiple records to a subform/table based on user input

    The line that is hightlighted is "tblAdd.MoveNext" I moved the End If after the End With and I still get the same error message.
  8. puppygirl3939

    Add multiple records to a subform/table based on user input

    I have been working on this for two days!!! Based on what the user selects on a combo box on the main form I want the system to add the matching tasks to a subform/table. This is the code that I am using and I am getting the following error: Run time error 3704 Operation is not allowed when the...
  9. puppygirl3939

    Calculations based on a Date Range or Date Parameter

    IT WORKS YOU ARE AWESOME. THANK YOU! THANK YOU! THANK YOU!
  10. puppygirl3939

    Calculations based on a Date Range or Date Parameter

    Unfortunately I am force to do this with only one parameter field {?DateSales} I tried using the parameter field but I got an error message indicating that a "number,curreny amount, date, date-time or string is required here" and it places the cursor after the if. if {?DateSales} in...
  11. puppygirl3939

    Calculations based on a Date Range or Date Parameter

    This is very hard to explain but I am so desperate for help. Hopefully someone can understand. Currently our fiscal year is July 1st to June 30th and our goal is 29,000 in sales. Basically I need to show what "I need" and what "I have" in sales on a weekly basis. This is based on the date of...
  12. puppygirl3939

    Date calculation - adding years

    Wow!!!! One line of code in the LostFocusEvent and it worked. You guys are my heroes.!!!!
  13. puppygirl3939

    Date calculation - adding years

    Hello! This seems rater simple but I have tried my best to accomplish this to no avail. I would like to be able to add two years to a date. Example I have a Date Requested field which the user will enter and I want to automatically have the system complete the Expiration Date field based on...
  14. puppygirl3939

    Mail Merge and Grouping

    It has to be done in word in order to use the template with our logo and formatting for our board books. Excel wont' work.
  15. puppygirl3939

    Mail Merge and Grouping

    Correct, I am trying to create a word template in order to generate a directory based on a public contact folder from Microsoft Outlook. Currently our receptionist updates the employee contact folder in outlook and then she has to update the contact list template in word. This way she only...
  16. puppygirl3939

    Mail Merge and Grouping

    I was wondering if by any chance anyone has been been able to create a mail merge in microsoft word with 2 groupings. Example Data: Country City Name Title USA Dallas John Manager USA Dallas Brian Assistant USA Florida...
  17. puppygirl3939

    Mail Merge and catalogs

    Thank you for posting this information. I was wondering if by any chance you have been able to create a mail merge with 2 groupings. Example Data: Country City Name Title USA Dallas John Manager USA Dallas Brian Assistant USA...
  18. puppygirl3939

    Send access report to more than 1 person by email

    I have been able to get this to work only if I enter the e-mail address directly into the code. How can I have the code lookup it from a query and send to more than one person. The query must be filtered by the referral ID# on the form then is should loop and take all of the contacts on that...
  19. puppygirl3939

    How to prevent Duplicates

    I have a main form containing the companyID and a subform to enter the counties where I am sending the company info. The subform contains a combo box with all of my counties. How can I prevent the user from selecting the county twice? Example Main Form - CompanyID = 25 Sub Form - Counties...
  20. puppygirl3939

    How to refresh subform

    Please help! I have two subforms in one main form. Subform 1 called county and subform 2 called region. The region form is populated by what county the user selects in the county subform. The code below is working fine by adding the region to the region table but I have to exit the form and...

Part and Inventory Search

Back
Top