Search results

This is absolutely amazing Thank you so much

By joining and not doing a union, would you still get the extra headings should the crosstab change?

Yeh, still not getting it Attached is my DB Please could you assist

When I do the 2 cross tab queries and the a union on the 2, I still get the same problem Maybe I dont understand your explanation

Yes I need the Qty and the Volume in the same row I am only working with about 100 line items, should not slow down that much I assume I will give this a try

This is my attempt

Oh yes, forgot to metion One cross tab querie is for Qty and the other is for Volume I suppose I need to make provision for the dummy control in each query

I tried the below code but got a lot of errors

Hi all, Is it possible to make a union query from 2 other cross tab queries?

Yes, that is what I am trying to do here Arnelgp has the solution here

I get n Object does not support the property or method run time error 438

There is no empty tables but you need to make a selection first before running the code If no record is selected and the user runs the code I get the no data error I need to stop the code if no selection has been made

I have the DCount() The code still runs The Save file to still appears You then need to cancel Then a box appears "The output action was canceled" I just want to stop the code if the user does not make a selection before running the code Before the code runs, I need to check for data I have...

Hi all, Please could you advise on how to stop below code if no data

I tried removing the =True before, did not make a difference Using just AllForms("Form_PurchaseOrder_Requisition") gives a Sub or Function not defined error

Hi all, On close current form, I an trying to do and action if another form is open It is not doing anything with below code and when I use the below code, I get a type mismatch error Please could you assist

Hi all, Has anyone encountered a Adobe Acrobat error 0:521 before? I have a form that displays the actual PDF of a record When I scroll through the records I can se the PDF Sometimes I get this error, when I select a different record and go back to the record that displayed the error, the PDF...

That is what I am trying to do, just time consuming to go through 30 000 odd record Was hoping to find a way to display the first record of a grouped duplications to either mark as keep or delete the balance below is 5 records which are duplicated, 4 needs to be deleted This is from the...

Hi have multiple records with airframe and engine as description, if i make the new table category as no duplicates, I will only have 2 records in the table, one for airframe and one for engine, the other 29580 records wont be copied

I have a PK in the master file If I add it to the duplicate query it wont show the duplicates, true