Search results

Try www.pajant.co.uk

I think you have to set this up as an outlook template and then call the outlook template at the end of your send object command. I have tried this approach in Outlook 98 and it did not seem to work as I could not actually save a template???

I am not sure whether to post this in Queries or in Modules. My application has a situation where we generate an email or printed quote (for faxing). The quote includes stock, and labour. Some of the stock may have an extended description that is sales blurb type information. I can return...

I dropped the NZ functions to test this solution and that did not seem to fix the problem (I also dropped the single quotes by the ampersands). I am passing this SQL to another function that builds a tempoary query using ADOX. This code is reliable and is used throughout my application in this...

I think the data entry under this system is too cumbersome. So I think there is a better structure.

I think I have looked at this off and on for about a year, and I still cannot see the structure for setting this up. We have a contract to look after some swimming pools. There are four swimming pools, with various quantities of equipment which have a minimum of two readings each taken once...

I have the following SQL statement in my code. strSQL = "SELECT tblPoolOrderTreatment.ReportType, tblPoolOrderTreatment.Parameter, " & _ "tblPoolTestParameter.TestAcronym, tblPoolOrderTreatment.TestOrder, " & _ "tblPoolOrderTreatment.TreatmentOrder, tblPoolChemicalMessage.Introduction...

Not in this instance. In this instance the address is permanent, the contact is transient and can have as many phone numbers as you care to think of. Appreciate your help.

I have a form with two subforms on it. The subforms are connected to the main record by client ID. One of the subforms records phone numbers. The next subform contains address details. I am trying to force the tab key to go from the phone number subforms last entry to the first entry in the...

Thanks for the considered replies. The final decision was to have a seperate mailing table for the following reasons. Any client can have any number of pools. Any pool can have an address. Therefore the pool is resident to the address. The owner is not. The owner can have multiple...

Is it possible to have a selected letter on a button caption Bold and the rest normal text?

I am writing an integrated Word, Access and Outlook application. I have been using DAO in Access 97 for this project to import email and fax data from Outlook into a tempoary table. I would really like to link to the contact details however, every attempt I have made so far has not worked...

Try this approach. Group each related item onto one piece of paper. For example each Part would have a part number, a description, a cost. Each Kit would have a KitID, and a kit description. Each Kit could contain multiple parts to a preset maximum, etc.

Travis, even after cutting the code down - I still had too much code. This linking system I am using is truly amazing in its lack of code. The solution is / was to drop the search of the recordset. It appears this was causing a requery action on the subform that simply was not required. The...

Travis what is really confusing me is that the sub form loading behaviour is being trigerred by the recordset search behaviour. I can not see a reason why this should trigger any action on the subforms at all.

Sorry Travis I missed your last post. The database compacts and repairs on close. I imported all objects into a new database, compacted and repaired and the error is still present. I am starting to have an idea what the problem is, although at this time I am uncertain as to how to fix it. I...

This is the method I am using to load the pictures. This code runs in the current event of the sub-subform fsubClientPoolPic. Private Sub Form_Current() 'Change the image to suit If Not IsNull(Me.PoolPhotoPath) Then Me.imgPool.Picture = Me.PoolPhotoPath Else...

That code is wizard generated, as it was simplest. I changed the object to a DAO recordset. The error still occurs. However, it only occurs on records with pictures. Either loading the record with the picture or unloading the record with the picture. I am using linked pictures, not OLE.

Travis your answer provides more questions. I checked the call stack and it only lists the current procedure. This particular form has been predeveloped, and I have only just returned to it, as I am nearly ready to wrap the whole project together. The out of stack space does not occur all...

I have a multi subform, subform on a main form. If i am searching through records it dumps me out of access after giving me an out of stack space error. What does this mean? How do you control it? How do I stop it, or handle it in code?