Recent content by TanMan

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

I am getting an (expected: end of statement) error at Order By tblProduct.[Product Name] tblProduct is highlighted

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

thanks Paul

Paul Inv_item is not Numeric, it is TXT

This should be celar the the post before Public Sub InOut() Dim dbinventory As DAO.Database Dim rs As DAO.Recordset Dim sql As String Dim strName As String Dim strDate As Date Dim strInv_Item As String strInv_Item = Forms!frmData.Inv_Item Set dbinventory = CurrentDb Set rs =...

Public Sub InOut() Dim dbinventory As DAO.Database Dim rs As DAO.Recordset Dim ingInv_out As Long Dim sql As String Dim strName As String Dim strDate As Date Dim strInv_Item As String strInv_Item = Forms!frmData.Inv_Item Set dbinventory = CurrentDb Set rs = dbinventory.OpenRecordset("SELECT...

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

Works greate, thanks for you help

Thanks for the code I get and error rst.FindFirst "[ProductName] =" & Me.cboProductSearch Syntax error (missing operator) in expression

I have attached a shot of my vba window to illustrate the problem I am having