Search results

Hi is there a way to use vba to close the currently open report on the screen without specifying its name Thank you

Yes That does the job Many thanks

Hi I Have a report which is an Invoice I have a details section for the invoice orders and i have a report footer for the total sum ect the idear being if the invoice is more than two pages long the report footer will always be in the correct place to display the total ect The problem is the...

Hi Many thanks for your help I am new to code Could you explain to me how this code works I dont see how it prints the report .but a step by step description of the code would be very helpfull Kind regards john

Hi I have a report which is an invoice I have a button on the report to reprint It . Now if this is a duplicate Invoice I need to add a background Image ,something like a duplicate stamp . I have added a message box which says" is this a Duplicate Invoice" .If the answer is yes then I want...

Thanks for your help .now understand

Hi thats done the trick . But I have a qustion Although I know it has changed the record souce .Becouse it all works . If I open the property sheet and look at the rocordsouce it shows the original record souce .I would have expected to see the new record souce in the proerty sheet

Hi I have a report that thats record souce is from a query run from a form I want to use the same report but run it from a different form using a a differnet query How do i automatically change the record souce when the report is opened from my new form code Private Sub Report_Current()...

Thanks to all .The on current event was the problem .but i have taken yhe other comments onboard John

Hi i have a form called Orders.I need to lock this form once an invoice has been printed I have a check box on this form ,that if ticked should lock that specif order This is my Code Private Sub Form_Open(Cancel As Integer) If Me.lockorder = True Then Me.AllowEdits = False End If End Sub The...

Hi tried that using the code but no good My checkbox Is called Iscancelled I have gone to its propertysheet and used on click Me.Iscancelled.locked=true But if i go back to the form i can still use the checkbox .This should not happen once ticked i want it to remain tickedl Thanks john

Hi I have a check box on a form,that when ticked ,Iwant it to lock that check box (basically i dont want that info altered after this time) I know its something to do with the property but cant get it to lock the check box) Many thanks John

Hi text referenced is total . Total: Sum([Soldatprice]*[quantity]) both sold at price and quantity are stored in my order details table

I have a query that runs great ,unfortunatelywhen ever i run it a parameter box shows .It refers to the total which is a calculated field . I am using grouping The calculated field is Total: Sum([Soldatprice]*[quantity]) and instead of group it shows Expresion

Re:SOLVED Query shows duplicate Yes you were correct I sum the total and all works well Thanks for your help

Hi thaidear whonks for your time Never used a group by query could you give a brief idear of how to do this Many thanks

Help please I hve a query that I want to total soldAtPrice *quantity This information is stored in my order details table and mus not change .I can do a calculated field to get the answer but the Problem is if there are 2 recodrs to be totaled the query displays 2 records if there are 3...

Hi all many thanks for your answers I will try all sugestions and let you know

Hi jdraw Thanks for your help That is a really useful site However it does not answer my current dilema I just need a button to press that takes the id from from the currently open form And uses that I'd to run the query Or auto fills a parameter box with the id

I currently run my query by inserting my orderID and run it I need to automate this With my orders form open I need a button that runs my query with the order I'd that is open