Search results

Hi to all. I have the code below that opens frmSalesOrders when clicked from frmCustomers. I have other buttons that utilize code DoCmd.Close acForm, Me.Name and they function as required. In this instance frmCustomers remains open behind the form called frmSalesOrders. Am I missing something...

Hi. I would like to open Form B when a field is clicked in Form A. Form A = frmCustomerOrderHistory1 (OrderID) Form B = frmSalesOrders When user clicks OrderHistory (OrderID) I would like frmSalesOrders to open displaying the corresponding Order. I have tried: Any help much appreciated. Phil.

Hi. I have a search button on a form (calls a macro). I have followed: https://www.youtube.com/watch?v=wCPs4aE5I2w to create the search box. The WHERE condition is: I have the following issues: OrderID values exist 1000 to 1008 If user searches 1050 (does not exist) the search opens a...

Hi to all. A query is returning #Div/0!. The sum is as follows: Line Total = 0 CostPrice = 3.32 I thought the addition of Nz would resolve this but maybe I am adding incorrectly. Margin...

Hi to all. The code below returns a zero if no payment has been made. I would like it to return the value for Sum([tblSalesOrderDetails].[LineTotal]) (i.e. whatever the order value is). Query code - SQL SELECT qrySalesOrders.OrderID, qrySalesOrders.CustomerName, qrySalesOrders.OrderDate...

Hi to all. In the attached database I have calculated fields on frmSalesOrders 'Order Balance' and subform frmPayments 'Total Payment' 'Order Balance' and hidden field 'SumPayments'. At present users must enter a blank payment for the calculated fields to populate (see attached Payment Form...

Hi to all. Its been a while since I worked with Access. I have attached a sample database with some dummy data. frmPackages frmPackageSubform User Input: User enters Package Master Record User enters Package Details. The user can select a ProductID from a combo box. This then updates...

Hi to all. I have one form that is not displaying min/max buttons even though option is set to 'Both Enabled'. Every other form displays them ok. Any idea regards what settings I may be missing (Access 2007). Thanks, Phil.

Hi to all. I have been renaming forms after combing 2 separate databases. On rename of frmSalesOrders to Sales Orders on open I receive error 'You cannot open this form as a standalone form'? I want to rename: frmSalesOrders to Sales Orders frmSalesOrderDetails to Sales Order Details Sample...

Hi to all. In the old days I had a form that allowed users to select values, click OK and then call a report. The underlying query criteria values as follows: #1 Like "*" & [Forms]![frmOrderAnalysisByServiceType]![cmdServiceType] #2 Between...

Hi to all. I have a report with label 'Receipt' + 'Receipt Number' + 'Order ID'. I have added a label 'Payment Due'. When the order balance is >0 I want to hide label 'Receipt' + 'Receipt Number' + 'Order ID' and display 'Payment Due'. When order balance is 0 I want to display label 'Receipt'...

Hi to all. Many moons ago I implemented a calendar module written by a chap called 'Mile-O' from this very forum. I know it worked in Access 2003. In Access 2010 the calendar does not display (There is no object in this control). Is there something I need to enable under 'Tools' References' or...

Hi. I have been modifying an old access database to give it a new lease of life. I have a Sales Orders from with sub form Sales Order Details. When user selects a package (Sales Order Details) from cboPackageID the remaining fields are updated. The form is based on a query’s ‘qrySalesOrders’...

Hi Access World Forums, it has been many years since my last post :) I have a Order Form (continuous) that allows user to select a product. After selection 2 text boxes are updated (Description and Price) see code below: Private Sub cboPackageID_AfterUpdate() Me.PackageDescription =...

I have a formula as follows: =IF(D2="Y","T",C2) So if column D has a Y then set the value of column E to T else make it the same as the value in column C. However the function simply returns the values from column C in column E even when column D has a Y? Any ideas? Thanks, Phil.

I have developed an aspx intranet site and was looking to control access to certain pages based on the users role. I have added a web.config file to each folder and configured similar to code shown in post. Code: ?xml version="1.0" encoding="utf-8"? configuration...

Hi. I have a form 'Display Details' that contains 8 sub forms. The user populates the sub-forms by selecting either a UserID or ComputerID from 2 combos in the form header. The form then displays Computer Details / User Details / Installed Hardware / Installed Software etc...I would like to...

I am receiving error: "Control can't be edited - Bound to auto number field 'field name' " I have attached scaled down sample database (Access 2003 format). The Form(s) ENTRY_SOFTWARE_LICENSE_FORM & ENTRY_SOFTWARE_LICENSE_SUB_FORM are supposed to allow users to enter a License Key for a...

Hi. I am attempting to format a date field on a report to display font in 'Red' background 'Grey' if the field value is less than Date() (i.e. today's date) The underlying query lists computer details with a field for WarrantyExpiry. The report data displayed is dependent on date range entered...

Hi. I have a query that works OK. However I would like to replace a couple of records returned with an alternate value. I would like to replace 0.0.0.0 with text "HP Procurve". I have the following that is incorrect: IP: IIf(="0.0.0.0"([qryDISPLAY_NWP_COMPUTER_SWITCH_MAPPING.IP]),"HP...