Search results

Here is what I am trying to accomplish I have a table with information that was imported from another program. The table has a quantity field and a price field. Example quantity is 3 and price $15.00. I need to end up with 3 records that has a quantity of 1 and at price of $5.00...

Need to sort by the Product name, what is the syntax:banghead: "WHERE fkProdType = " & cboProductTypeLookup & " And " & "tblProduct.discontinued = 0" & "" Thanks for the help

I have a form that uses a list box to select records. I have added a 2 radio button group that filters the records according to a check box What I would like to have happen is when selecting a radio button to filter the records I also need to filter the list box to match the list of records filtered

What is the best way to keep up with reusable code?

what is the latest version of access runtime 2007 Going to install access 2007 runtime and I need to what is the latest version thanks

I am trying to open a recordeset with the following SQL statement in VBA Getting the following Error message: (Too few parameters.Expected 1), and am not sure where the problem is. Set rs = dbinventory.OpenRecordset("SELECT [inv_item],[inv_In_Date] FROM qryInv WHERE [inv_item] = strInv_Item...

Is there away in access get notification when a table is updated or add to I am using Access 2007 front end and a 2003 backend, the backend is on the server. Thanks Gary Hull

I have a combo box that I use to lookup a record, It is giving me problems. Example of data in the combo box · Adjustable Leg: # P67490-2510 · Air Hose Bibb: 3/8 X 3/8 The first example does not return a record; the second example returns the correct record If I remove the # symbol from the...