Search results

Hi everyone, I'm trying to set up code in a report to print using a specific printer (since there is more than one printer on the network). Can anyone point me in the right direction? Any help you could give me would be greatly appreciated.

Hi everyone, What code would I use to change the text colour of a text box when a checkbox is ticked? I need to change the text colour to red to alert the user when they enter an item where the discontinued box is checked. Thanks for any advice you can give.

Hi everyone, Is it possible to start a sheet of A4 mailing labels from other than the first label? Any advice would be much appreciated.

Hi everyone, I have a form with a control to calculate VAT, however since books are zero rated for VAT I need to calculate it for some items but not for others. Here's the code I used: If [Books] = False Then [VAT] = [LineTotal] * 0.175 Else [VAT] = 0 End If [Books] is a...

I couldn't open this file - unrecognised database format (I'm using Access 97)

No joy - still get #Name? Isn't there any other way to reference it than using DLookup? Thanks for trying

OnHand2 is based on OnHandQry which is in turn based on several other queries (gets complicated!) I don't understand why the DLookup works when you open the subform on it's own but not when it is part of the main form? Thanks for your help

Sorry Ken here it is again

I have pasted the relevant forms etc into a new database and attatched it ( the whole database is too big)

I just want to view it

Hi Ken, Tried that, this time I get #Name? when I open it as a standalone as well as on the main form. Thanks for trying.

Hi Ken, Thanks for your reply. This works only when I open the subform as a standalone. When it is opened as part of the main form I get #Name? Any other advice you could give would be appreciated.

Hi everyone, I have a subform [frmOrderDetailsSubform] on which I am trying to use DLookup as the controlsource for a field to look up the [OnHand] field in my query [qryOnHand2]. =DLookUp("[OnHand]","[qryOnHand2]","[Code] = Forms![frmOrderDetailsSubform]![Code]") This works fine when I open...

Hi Ken, Thanks for replying. Basically, I have two queries GoodsIn and GoodsOut which calculate what comes in and what goes out. A third query calculates GoodsIn less GoodsOut and comes up with the OnHand figure. What I'm trying to do on my form is reference the OnHand figure for the...

Hi all, How do I reference a field in a query from a form?

Thanks! That worked.

Hi everyone, I have a query with the following SQL statement: SELECT GoodsInQry.Code, GoodsInQry.Qty, Inventory2.SumofQty, [GoodsInQry].[Qty]-[Inventory2].[SumofQty] AS Onhand FROM GoodsInQry INNER JOIN Inventory2 ON GoodsInQry.Code = Inventory2.Code; Is it possible to show all records from...

Thanks for your advice Vince, I'm not sure I understand how to do what you suggest though. Could you be more explicit? (fogive my ignorance) Thanks

Hi everyone, I have 4 tables tblOrderDetails tblTradeOrderDetails tblReturnDetails tblExchangesDetails these are all related to tblProducts and all have the same three fields -Code (primary key) description and qty. I am trying to create an inventory tracking system by calculating the goods...