Search results

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.

Hi All, I've got a very confusing problem, I'll try explain as best as I can! I have written a query in Access 2013 which has data from a couple of different sources and displays information on a form. I can open the form and it will run fine and if I close the form but leave the main Access...

Got it...someone had put a 'select object' the macro... Thanks for your help!

Hi All, I've got a database that is locked down for all users with forms so they can navigate the system and the navigation pane is hidden. On a couple of the forms there are buttons to print the form and when that button is clicked it unhides the navigation pane...??? Any ideas how to stop...

I need to do a DSum with criteria that picks up a previous month based on todays date, I have got the following but I don't know how to format the last part of the criteria. If I take out the Month(DateAdd("m",-13,(Date()))) and replace it with 6 it works fine...

I have a button on a form that runs DoCmd.SendObject to email as a PDF and I want to add a link to the email as follows 'click here to download...' with the 'here' being a link to a document on our website. How can I do this? Any ideas are greatly appreciated. Thanks :)