Search results

Ended up putting the me.refresh when the search box lost focus. Works. The me.requery didn't. Thank you!

OK. And where would I put that? On a LostFocus event on the text box didn't work

Forms!CustomerDisplay has a textbox BSearch and a combobox BsearchCombo Enter some text in BSearch, Click on the Combobox dropdown with runs a Query on Like Besarch Enter "mark" in Bsearch and all the records with "Mark" in it show up. Works great -- once. When I change the text in the BSearch...

arnelgp provided the solution in a private message, most likely because he didn't want to highlight my ID-10-T error for the world to scoff at. The reason I was having trouble with his modified solution was that mt ID field was not set to "Indexed: Yes (No Duplicates)" Once that was fixed, the...

My name is Mark Robinson. I live and work about an hour north of Boston. My company, Handicapped Pets makes, among other things, Wheelchairs for dogs. Been working with Access since 2000, formerly a dBASE III maven. Still a beginner.

I have a VB program that imports data from an excel file. There are frequent occurrences of fields that get truncated end, every time there is an import, Access creates and saves an ImportErrors table. Every week I need to go into Access and delete all the ImportError Files. Is there a way to...

I frequently need to examine or edit the Saved Import Specs, but can't seem to find where these are stored. Can this be done?

Strangely, every time I try to print a certain report from my VB script, it sends it Tray 1 of my printer (the manual feed tray). I can change this when I manually print and select printer, but it seems to want to default to tray 1. This is not the Windows default.

I would be interested in a discussion as to when it's best to use a macro vs. VB program.

Well put, Grandpa!

Thank you! Sorry for being such a noob. The 2017WooOrdersIn has 14 records with duplicates and 2 records with with double dupes. for a total of 34 records. After running this I am expecting 16 records to remain. Unfortunately, I'm still doing something wrong and running the query deletes all...

I got as far as this on my own. This compiles without error SELECT Count(*) AS Expr1 FROM 2017WooOrdersIn AS T1, 2017WooOrdersIn WHERE ( ( ( ([T1].[order_number]) & ([t1].[item_id]) & [T1].[Item_Name] & [T1].[Item_Sku] & [T1].[Item_Meta]) = ([2017WooOrdersIn].[order_number]) &...

Definitely like this solution best, but when I paste it into an SQL query, "Syntax Error in Query Expression". In the error message the query ends before "AS Expr1, *" The autonumber field is named ID

I realize that there have been several threads on this. I've looked through them can can't find a simple way to delete duplicates. Running a DELETE Query on a Find Duplicates query throws an error not solved by setting the Unique record to Yes. I found this online and I like the logic, I've...