Recent content by Access2000_JS1

I have a main form (A) with a subform that is another form with a datasheet(A_SUB) On the form A is an undo button which rewinds any changes that occur to A that I do not wish to commit. However when I make a change to A_SUB the changes are not rewound. I considered implementing an UNDO for...

You could consider a double click event to change the field from an edit into a search. On the double click event hide the text field and in its place display and set the focus to a previously hidden combo. On a change from this value populate the form.

What is autoname correct feature? Where is it?

SELECT [Promo count].PromoNo as PCPN,[Promo Executed].PromoNo as PEPN, [Promo count].[# of Demos], [Promo Executed].CountOfPromoNo AS [Executed Demos], IIf([Promo Executed]![CountOfPromoNo]=0,0,[Promo Executed]![CountOfPromoNo]/[Promo count]![# of Demos]) AS Percentage FROM [Promo count] INNER...

I have already encountered the same thing, with a different group by type and I also overcame the problem using multiple queries. Three weeks later, when I looked back at it, it made sense and that makes sense.

if you add another type you will get 6 then 7 etc. You could drop each in a detail section. However, you may also consider appending each to a next ie s = a + B + c ... and displaying it as text You may also hard code each field in your form and setting its visible attribute, or...

I have several reports in my system. Some are landscape and some are portrait. Occasionally the landcape ones switch to portrait taking up two pages each. In preview mode it is not so bad that the user can reset the page size, but when one is sent to print this is most certainly annoying...

Which ones are the best?

I am running access 2000 9.0.2720. I wanted to create an MDE file but every time I attempt I get the message 'unable to create an MDE file'. Any advice?

I had an identical problem the other day. Assuming you use the date in its 'correct' format I would suggest you try: INSERT INTO tbl_ImportCenceo ( [email id], process, type, changedate ) SELECT qry_email1.[email id], qry_email1.process, qry_email1.type...

The following statement returns NULL Dim str As String Dim n As Variant str = "RemitDate >= #" & Forms![Report Menu].FromDate & "# AND RemitDate <= #" & Forms![Report Menu].ToDate & "#" n = DSum("GSTPaid", "queryJobRemittance", str) yet however when I run the query ie SELECT sum(GSTPaid)...

No good. The records in my form are displayed in rows. This event occurs but only once for the first record. I want to trap the event that occurs on each and every row being whatevered. Perhaps it does not exist and the rows are created and then the form is populated - hopefully that is not...

Hi, I have a table in a form. I want to hook onto the event that occurs as each and every row is being loaded (ie to change the colour for a row). Which object and which event? Thanks

Sorted thanks INSERT INTO clientInvoice (InvoiceNo,clientName,dateInvoiceSent) SELECT DISTINCT jobInvoice.InvoiceNo, job.ClientName,format( [Forms]![CreateInvoices].[InvoiceDate], "dd/mm/yy") AS dateInvoiceSent FROM job INNER JOIN jobInvoice ON job.JobRef = jobInvoice.JobRef WHERE...

Hi, I am inserting records into a table where one of the fields I want to insert is a date value from a form. When I run the query without inserting it it works fine. When I change the value into some other type (a string) it also works fine. I have tried it with a date 05/05/05 so it has...