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...
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...
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 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.
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.