Search results

I have previously copied examples from Books on custom properties. I am trying to make a custom property for a form. My aim is to create a generic form that fires on the not in list event of a combo box. I have a module which is working if I pass in the name of the form. Function...

Try another query Select * from crosstab Then run your ADO against that.

I don't know if this is the best solution but it should work: tblModels --fields-- ModelID ModelName etc. tblMotors --fields-- MotorID MotorBrandID MotorName etc. tblBrand BrandID BrandName etc trelModelMotorBrand ModelID MotorID BrandID In this model many models can have many...

Just a thought, why not set up a template with the signature on it and merge the data to the template?

I think from what you have said I would go with the two query approach. One returning just the last record and do something to calculate the dollar value. The other with the same fields but not returning the last entry. Then create a union query of the two by going to SQL view and copying the...

From the queries I have done that return false records the problem is invariably in the joins. FROM (Polici RIGHT JOIN Premii ON Polici.Npolica = Premii.Npolica) LEFT JOIN Vnoski ON Premii.Npolica = Vnoski.Npolica A Left Join is unusual perhaps try this as a right join, or alternatively both...

I have a table set up called tblServJob, fields are: JobDate Who (Booked) Client (lookup) Address (lookup) TimePromised (startTime) AllocatedTime (hours allowed e.g. 2.5) JobDescription ServPerson(Lookup) Discount Access(lookup) Payment(lookup) I have another table tblServPerson that has the...

I have an application where I need to pass the form object to a sub. It works great if I hard type the form, and if I pass in a simple form, however, when I pass in a sub sub form it returns object not found error. The code looks like this strForm="frmClient" else...

I am at the edge of finishing and working on the cosmetics. My main form takes about 4 seconds to load on my system, I imagine it would be slower on other systems, so I thought I would add a splash form to cover the time for my main form to load. Then I thought it would be nice to add a...

I like using VBA in reports. However, one of the things I have never quite worked out is why when you use statements like: If Me![HourTypeCode] = "L*" And if Me![WC4] Not "GL*" Or If Me![WC5] Not "GL*" Then It never seems to work properly. I know it should and I know that the books say it...

I have a rather complex series of tasks I complete to develop the attached forms. The Outcome I am trying to acheive is that if the query has a value then the related text box has a width, else, it doe not. I kind of half have it working see the sample, however, if there are not records for the...

Thanks for the replies. However, I have not perhaps been clear in communicating this design and how it impacts on the balance of this application. The reason for Text1,2, and so on is that the records are not bound to a name at all. The name is only manipulated in ADO not the control source...

For Access 2000 and 2002 set the compact on close option on the backend will compact the backend on closing the front end.

It is not normal in Access to store a calculated value. Rather these are calculated on the fly, in queries, forms and reports or what have you. If you require the storage for tax purposes or some such, then why not add a field to the input form and store the result from there?

In my current application I am trying to open up the options to the user. I am trying to decide the best approach to this issue. The user can set up a group of water tests they want to make on any swimming pool, these could be Standard, Green, Stain etc. Any of these groups could require...

I have the following SQL statement in my code. I am trying to use this in a ADO recordset as set out below. SELECT tblPoolOrderTreatment.TestOrder, tblPoolOrderTreatment.ReportType, tblPoolTestParameter.TestParameter, tblPoolTestParameter.TestAcronym, tblAdminTestUnit.TestUnit...

Create an image by clicking on the image tool in design view of the form. This will open an annoying wizard, that ties the image to an image somewhere on your drive. That's fine, work through that. Set the image to be the size you want, and set the properties to stretch or what have you. In...

Attached is an example form based on the Pajant tool, which is significantly cheaper than the one you are loking at. You will need to set a reference to pajant in your VBA. The code is all enscapulated in the form. This form is designed to acquire images from a scanner, however, you could...

Take another look at Pajant, I believe it has this capability, although I do not use it this way. It certainly will pop up a form with a button on it, although you have to make the form and file the image into the path where you want it. It comes down to twain compatible drivers or not.

Thanks, but this has to be done in code. A report won't work for this at all.