Search results

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

Thanks for posting.

I have worked it out... Private Sub cboPackageID_AfterUpdate() Me.PackageDescription = Me![cboPackageID].Column(1) Me.PackagePrice = Me![cboPackageID].Column(2) Me.Quantity = 1 Me.LineTotal = Me.Quantity * Me.PackagePrice End Sub I thought it would be more complicated. Thanks, Phil.

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

Thanks guys. Phil.

I came up with: =VLOOKUP(A2,STRUCTURESP5.xlsx!$1:$1048576,3,FALSE) So the column being compared in both files is A (ProductId). If a value in file 1column A exists within column A of File B then return the value in column 3 of file 2 (5) Does that sound reasonable. It is critical I do not...

Hi Paul, you were right. I changed to " Y" and it worked OK. How are you on VLOOKUP? I have 2 excel files. File 1: Products - 35000 rows File 2: Structures - 5000 rows File 1 has a product Product Type in column C of either M / P or T However if ProductId exists in column A in File 2 matches...

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

Bound Ha! Ha!. My dad is from Liverpool, I am a southern softy! I have redesigned the form (removed the combos that once were). Users can now search by supplier product where the supplier product category = software. They can then add a license........may not be perfect but it works. Thanks for...

Bound I did not give an accurate reason for the form layout! The Productescription field was added to display the ProductDescription after the user selected the ProductID related to the suppliers selected from SupplierID. Without this the field displayed the ident number (ProductID) of say 55...

Hi Hi there was a reason for that originally. After selecting supplier then product the product description used to dissapear (i.e. cmboProductID bound field 1 2 columns 0;6;). I think I will start again. Basically I want a form where users can select supplier & products supplied by that...

Bound Field Hi. How do I remove the bound field? What should I do to get it working? (start again!!).

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

Date Field The code works great and the formatting is now as expected. Many Thanks, Phil.

Date Field Thanks for the code update I will give that a try. The Data Types for the underlying tables: WarrantyPeriod (Number) DatePurchased (Date) Thanks, Phil.

Data Type Hi. The field in question does not have a Data Type as it is a calulated field in a query based on 2 other values: WarrantyExpiry: IIf(IsNull([WarrantyPeriod]) Or IsNull([DatePurchased]),"",DateAdd("yyyy",[WarrantyPeriod],[DatePurchased])) Can I define a Data Type? Many Thanks, Phil.

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

Perfect Adam not only was that quick but also spot on, many thanks. Phil.