Search results

SQL2VAR and IDBE tools "Query to VBA String Builder" both created Strings that look like this: 'append new data ' Created by IDBE Tools 2010 ' SQL Text from Query: "qryAppendPOMSTDT" MySQL = "INSERT INTO POMSTDT (...

Hi Colin, I "skimmed" the text of that article in the link, and may adopt that policy of deleting temporary objects. ===================================== My main purpose, and the reason for finding this old thread is that I am trying to recreate the functionality of an old utility called...

I also followed this, and got WAY too many results. Since I DO prefix my queries (the ones I want here anyway) with "qry", it was pretty easy to filter the list. SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Type)=5) AND ((Left([Name],3))="qry"));

This is ridiculous. Post #6

Holy ... Post #5

Jeepers ... this is post #4

I have "rolled my own" version of this using the code supplied in this thread by raskew combined with some of Allen Browne's code which does much the same. I was having some problems with raskew's code (I'm using Access 2016 and DAO)...

Seeing that it seems that we are talking about an Access Desktop Database here, I think that my approach to this would be to try to do it in VBA. Using the BeforeUpdate event, you could test for similar values, display a MsgBox with what was found, and ask the user if they would like to proceed...

This is great. I can't wait to give this a try when I get home. I'm also having the thought that you could create an index on a key data field that is unique, and would therefore prevent duplicate records from being appended. I use this technique in the desktop version of Access, and it seems...

Hi Folks, I'm active on many Access/Excel forums and thought: "Hey why not one more?":p I describe myself as an "Old, self-taught, Access hobby programmer (aka 'Hack')" I've been using Access since version 2.0 in about 1995, when I was tasked by my employer (NAPA Auto Parts Store) to make a...