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...

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 all, How do I reference a field in a query from a form?

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...

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...

Hi all, I have a command button on a form which appends details on the form to 3 tables - tblchargebacks tblChargebackDetails tblChargeBackCustomers When I make a new form with these as the underlying tables I cannot enter data into the form, I can only display it. When I try to enter info...

Hi everyone, I have the following function: Private Function TradeShippingCalc() If [OrderSubtotal] >= 86 Then [Shipping] = 0 Else: Me![Shipping] = 5 End If End Function When I call this function - Private Sub TradeOrderSubform_Exit(Cancel As Integer) Call TradeShippingCalc End Sub It only...

Hi everyone, I have a calculated field on a form which adds together two currency calculated fields from two other forms. This works fine as long as there are values in both of the fields I am adding together, the problem comes when one of the fields has no value. If there is no data in one...

Hi everyone, I have a combo box from which you can select customer details. My problem is this - If you select a customer from the list it fills in the customer details automatically, however if you then change your mind and select a different customer from the list you get this error...

Hi everyone, I currently have a form with a date field, the control source for which is set to =Now(). This shows the current date, which is what I wanted, however, the date field is automatically updated every day with the new date, so that all records show todays date even though the record...

Hi all, I currently have a form which has within it an order details subform, what expression should I use on the main form to create a total price for the order when the price of each item is in the subform? Thanx

Hi everyone, I have a combo box which looks up customers in my customers table and fills in the customer details on my orders form. However, the customer information that it enters on the form isn't saved, each time I select a different customer from the combo box that customer's details appear...

Hi all, I'm trying to build an inventory form that will automatically reduce the UnitsOnHand total by the quantity ordered. Any tips on code to do this would be greatly appreciated!!