Search results for query: *

Could any please explain why the following isn't working? It seems to fail on the Where clause of the SQL when attempting to open the recordset. However in debug [Forms]![frmMainBuildBOM]![ProductID] has a value. The code is executed from frmMainBuildBOM - ie the form is open. Error message...

Hi I have the following tblProduct ProductID PK ProductDescription tblConponent ProductID PK ParentProductID FK Quantity tblPrice PriceListNameID PK ProductID PK FK CostPrice PercentageMarkUp Essentially as I understand it this is a Bill of Materials A product/component may form part of...

Hi I have the following tblProduct ProductID PK ProductDescription tblConponent ProductID PK ParentProductID FK Quantity tblPrice PriceListNameID PK ProductID PK FK CostPrice PercentageMarkUp Essentially as I understand it this is a Bill of Materials I have the primary key in tblPrice on...

I am trying to automatically populate a nested form with records each time the parent form has a new record. The nested forms record source is TblPrintColour. The only way that I have been able to do this up till now is to create a duplicate table (TblPrintColour2) and use an update query to...

We have: frmMain1 & frmMain1!frmSub1 Both forms are based on queries. frmSub1 is in continuous view with only 3 text controls (out of a possible 14) for each record. The text controls are covered by a label. I had planned for the user to double click the label and open a new form (frmMain2)...

Is it Possible to turn off the flashing of a cursor (or preferably render it invisible) on entering a textbox and reset the properties to default when the textbox loses its focus? Thanks LouiseJ

I have a Form with an unbound control txtABC, cmdOK and cmdCancel. txtABC has an Input Mask and cmdCancel closes the form, acSaveNo. Situation is that a user starts to enter data into txtABC and then decides to cancel (cmdCancel) with out completing the required Input Mask string – Result: The...

I am trying to create a Recordset from a query. The query has a reference to [Forms]![FrmAvalibleAccountNumbersNext]![txtAccountNumber] “txtAccountNumber” is an unbound control on the Form. If the Query is run from design view it works no problem (“FrmAvalibleAccountNumbersNext” is open when...

I have the following code which is producing an error at ‘RecordSet.Open’ with the following message; Invalid SQL statement; expected ‘DELETE’, ‘INSERT’, ‘PROCEDURE’, ‘SELRCT’, or ‘UPDATE’. I am assuming that an SQL statement is expected instead of “QrySalesEnquiries&Customer". However I can...

This seems as though it should be very to do. How do I set a variable to FieldABC of the last record returned by a query. (the query is sorted on two columns.) Have been trying to use Dlookup but I don't seem to be able to set the criteria. Thanks Louise J

I have problem which I can’t quite balance in my brain as follows; TblDesigns Customer Account Number}Composite (duplicates allowed) – FK Design Number }Composite (duplicates allowed) - PK TblCustomers Customer Account Number - PK TblOrder Order ID – PK Customer Account...