Recent content by camromere

So I stand corrected. I looked at your formula for the DLookup and duplicated it exactly as far as I can tell, substituting my table/field names, and I'm still getting the #Name? error. Can anyone help me understand why this is not working? =DLookUp("[Product Name]","Products","[Product ID]=" &...

I tried the same exact situation with a purely Access database to test it and DLookup worked exactly as I expected it to. However, my application has a SQL back end and I've tried every combination of syntax I can find and cannot get it to work with the SQL back end. I get #Name? every single...

I've been doing more "googling" and it appears that DLookup may not work at all with a SQL Back end. That is quite troublesome. I may have to figure out another way to accomplish this.

@Pat Hartman I'm not sure where you mean to add the lookup fields exactly. The Control Source for the subform is the table

Ok the [Product ID] field is an Integer and if I replace the DLookUp formula criteria with a hard-coded number, it pulls the Product Name correctly for that Product ID. =DLookUp("[Product Name]","[Products]","[Product ID]=" & 498) I did manage to get the data extracted to local tables and...

It is not cooperating putting the database online to connect to it.

It's a SQL Server back end - let me give it a try.

I've tried all the following: =DLookUp("[Product Name]","[Products]","[Product ID]=" & [Me]![Product ID]) =DLookUp("[Product Name]","[Products]","[Product ID]=" & [Product ID]) =DLookUp("[Product Name]","[Products]","[Product ID]=" & [Forms]![frmModQuoteDetail]![Product ID])

Ok I tried that and here is what I have now. =DLookUp("[Product Name]","[Products]","[Product ID]=" & [Forms]![frmModQuoteDetail]![Product ID]) However, I'm still getting the #Name? in the field. I had hoped not to have to change the datasource for the subform because the updates happen...

I have a form with 4 dropdowns and/or listboxes which enables the user to quickly drill down to a quote to modify. Once they select the quote to modify, two subforms populate for that quote - the quote header and the quote details. The quote details subform is displayed as a datagrid because...

I kept googling too and found this which worked. cmd.Parameters.Append cmd.CreateParameter("@amount", adDecimal, adParamInput, 0, priceChgAmt) cmd.Parameters("@amount").Precision = 6 cmd.Parameters("@amount").NumericScale = 4 It is now inserting to the database :-)

That's exactly what I've run into. I tried adding it in the parameter definition, but that didn't work at all.

I have a stored procedure in SQL Server that accepts 6 parameters and will duplicate a quote and quote details. Depending upon the values checked, it makes an exact duplicate of an existing quote/quote details or changes the price by either a dollar amount or percentage amount. The field type in...