Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

Please Help!! I am new at VB code and I am following the instructions from a book. Line 3 (dim dbsA As database) returns the follwoing error: "Compile error:User-defined type not defined". Can someone please tell what am I doing wrong. The code is: Private Sub County_Click() Dim...