Search results

Let's say I have 10 saved update queries that I use to manipulate imported data. These queries update a "Cost" field in order of the quality of costs I have available. The query logic is as follows: Update "Cost" if i have a cost in "Cost1" If "Cost" is still empty, Update using "Cost2" If...

Hello! I have a query that returns unique values of one field. There can be from 1 to 10 unique values that are returned. Ex. 099 and 010 could return one day. And 002, 110, 956, 010, 099 could return another day. I want to be able to put each returned value (however many) into an...

I do not know what is wrong with my code and thought I needed a different set of eyes. When I run this code, it opens up the form, but filters to show a blank record instead of the matching record. I'm guessing, for some reason, what I'm searching for doesn't match anything in my records. Any...

In this instance, I use Access to manipulate data, not create a normalized database. My problem is that everytime I run through my saved queries, I have to manually redo my last update query because the field name changes. The field name that changes always begins with "BRC" then followed by a 3...

Hello All - Ultimate Goal = Exporting Query results to Excel Problem = Run-Time Error '-2147217904 (80040e10)' No value given for one or more required paramters The error occurs on red highlighted line in code below I know the problem is referencing my form control value as the parameter in SQL...

Before the experts ask why I would want to add fields via VBA, I am not building a typical database. I am importing large amounts of data into Access, having Access manipulate the data via queries and such, and exporting out. I use Access for the same steps pretty much everytime. (Bare with...