Recent content by jibb

Hello, I want to run some code when a user presses the Enter key on a form - how do I do this? Thanks

No... I have got a form with a list box on it and from that form I want to run a query but only show the records which are selected in the list box.

Hi All, I want to limit the results in a query to the selected items on a list box - how do I do this? :confused: Thanks

I'll try explain better... It's a lookup form for customer pricing - some customers have up to 4 price breaks but if there isn't a price it currently tries to debug and if you just click end it stops any of the rest of the price lookups working.

Thanks. There are 4 fields which have a dlookup that can show the error but I only want to clear the fields that show the error - is that possible?

Hello All, Probably an obvious one...I have got a form with a couple of dlookups on it, when they return an error it pops the debug message up and if there is a value in the field already it just leaves that value there. How can I supress the message and clear the field and move on to the next...

Perfect, thanks. There is a perfectly good reason for the design of my form but it would be a little complicated to explain! Thanks for your help.

Hello, I have got a combo box with a product code in it, and depending on which code is selected I want the data to come from one of two different tables. Is there any way I can do something like a match formula in Excel to see if the stock code is contained in a table? Any ideas would be...

Looks like this is a 2013 problem...tried in 2010 and there are no problems...

Just trying that now...it will take a while! What reference should I have set?

That fieldname is in an ODBC linked table that can't be changed - it hasn't ever affected a query before

That was only opening the query, not the form...it has the same problems! I'll try importing everything into a blank database now

Its the same as the form...it will open the first time after a compact and repair with no problems but if I shut the DB then open it again it crashes. The query that is in the main query doesn't have any problems...

I don't have any startup routines running on the form, all it does is display the query results. SELECT qryLowi15StockCodes.stcode AS [STOCK CODE], [desc_] & " " & [desc2] AS DESCRIPTION, [reordlev]*1000 AS OPTIMUM, [STSTOCKDETAILS]![LEV]*1000 AS ONHAND, [outorders]*1000 AS OUTSTANDINGSO...

No...that hasn't sorted it.