Totally understood Steve.  I do understand the code itself.  I have run a few SQL statements, thought it was not formally trained, so, over the months of not doing any...

So how can I then initiate that code?  Sorry for being a bit on the slow take up on this, but again, most of this is new to me.  I...

thanks all for the input.  I have been doing other searches as well (not that I don't trust the advice here, but trying to get the whole picture before taking...

The server is backed up regularly, but I don't want to have to bother that team if I can do things safely.  I assume I would have to change the...

I have just been reading a bit on this, and the possibility of data loss.  This table does not hold a lot of data (about 15 entries), but this table...

Yes.  The odd thing for me was that this field is almost never used (in the past), but some are NULL and some are not, even though all such entries...

Well, there are a few with wildcards, but not all, so knowing the difference is a good thing.  Unfortunately, using <> and = gives the same results.  Well, really the...

This script is built in VBA for use in access 2016.

honestly, SQL is not my first language.  The base for the SQL statement was most likely an access...

I guess I could make different 'Heads' for each column that could be used for the sort. Really, I don't think it would be more than 3 or 4...

Updating the file is not too bad an issue. I could create my own batch file to do that. They all exist in the same place on each...

It is a front end that is duplicated across, but the changes being made are not to access, but to the access installation. Meaning if the staff managing the...

Sean Lange (5/15/2014)

---

jdasilva (5/15/2014)

---

ok. well lets go back to the original stuff Sean posted. He used 2 delcarations that don't work (user-defined type not defined):

dim parm as ADODB.Parameter

dim...

ok. well lets go back to the original stuff Sean posted. He used 2 delcarations that don't work (user-defined type not defined):

dim parm as ADODB.Parameter

dim cmd as ADOBD.Command

So...

I guess this now hits on an embarassing note... DAO vs. ADO... I beleive I am using DAO, though I am not 100% sure. Again, no background...

Sean Lange (5/6/2014)

---

jdasilva (5/6/2014)

---

How does SQL get the value of the variable from the form in access?

In the example I am working on, I am polling the data for specific...