Viewing 15 posts - 1 through 15 (of 32 total)
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...
April 16, 2019 at 8:22 pm
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...
April 16, 2019 at 3:44 pm
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...
April 16, 2019 at 3:20 pm
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...
April 15, 2019 at 9:43 pm
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...
April 15, 2019 at 6:24 pm
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...
June 28, 2018 at 6:59 am
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...
June 27, 2018 at 7:37 am
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...
June 26, 2018 at 7:33 am
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...
October 14, 2016 at 1:22 pm
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...
May 21, 2014 at 10:20 am
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...
May 20, 2014 at 6:57 am
Sean Lange (5/15/2014)
dim parm as ADODB.Parameter
May 15, 2014 at 2:50 pm
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 cmd as ADOBD.Command
May 15, 2014 at 2:34 pm
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...
May 15, 2014 at 8:34 am
Sean Lange (5/6/2014)
In the example I am working on, I am polling the data for specific...
May 14, 2014 at 1:58 pm