Search results

OK --- Did some more hunting... Found this discussion... https://www.tek-tips.com/threads/exporting-an-access-form-to-a-text-file-vb-file.989746/ And it turns out - someone else happened to notice that this approach worked for everything *except* tables, for them. So, after commenting out the...

A couple other thoughts: > It seems like if this were to be leveraged to repair a damaged/corrupted file - then it would HAVE to be done remotely/externally, unless you could at least open the corrupted file and insert this code etc. > From what I've been able to find, there are really just two...

So - upon trying to use this approach - but tacking on the idea that the "application" is not local, but an external database, I'm getting: Run-time error '2847': The Object Type argument for the action or method is blank or invalid. This doesn't make any sense to me since the Object Type...

Well! That is how I thought it should be! (For some reason - when I first explored this approach - I thought I only found some of the object types but not all. I'm quite curious what is within each .txt file, so I'm anxious to give this a whirl. Thanks!!

Also excellent. Will see what I can find. Thanks!

Excellent - will give that a look! After just a quick initial look - it looks like I can't use that add-in, as it requires some things to be configured in a way that I cannot control. Bummer. Also, again - just based on a quick look - but it sure looks like that since they've created an add-in...

Hi, I'm trying to build a solution that can pull the pieces out of any specified Access DB (e.g., SQL And VBA for version control code management etc.) and then also the ability to perform the reverse of that, creating an Access DB from those pieces as well (as much as possible.) I'm...

Interesting background! I think your initial answers are succinct, and only lengthier as the details unfold. Seems appropriate to me. (You also exhibit the rarely seen quality of starting by answering the question - rather than criticizing or 2nd-guessing the OP's design. ;) - but I digress a...

Cool. I think I'm going to need to read that a few times! On the odd chance anyone else is new to doing this thing with adding a reference and trying to 'remove' it etc., I did also notice that upon performing this operation twice in one session, the system did not complain when trying to...

OK --- Cool. As usual - your answer is spot on! You've got me a bit nervous about the fatal crash thing - especially since the process of connecting that new reference apparently always triggers an error that we must skip. Kind of scary. If you can elaborate on what would constitute removing...

So - I've been able to carry out a command like: Application.References.AddFromFile strAccessDBPathFile ...where the strAccessDBPathFile is the full path to an external Access DB/file. And was then able to establish which VBE.VBProject index this new referenced one is, and then pull data from...

I just wanted to follow up with progress made on this during the course of today's work. I was actually able to get this issue resolved. It turns out that the example code in that Agilent document had some pieces that just didn't work for me. One was where they had a variable set to Integer...

I'm trying to do something very much like @nectorch references in their post: ("Challenges with Ms Access VBA with socket programming", at https://www.access-programmers.co.uk/forums/threads/challenges-with-ms-access-vba-with-socket-programming.318926/). I've made it through a few hurdles with...

Indeed!!! Ha!! :unsure:

Right - totally get it - in general. I just so happen to not be able to upload sample code easily. I'd have to spend more time than I have creating something I can/should/be allowed to upload - and then - it probably wouldn't end up looking close enough to the original to be worth inspecting...

True ---- In this case, I've described the problem. From what I can see here, the names of tables and fields is irrelevant - right? The problem is that the same query that works on *some* tables, suddenly doesn't work on others, and exhibits an error that is completely erroneous - talking about...

Just an FYI --- I tried running the same type of query on the two databases again, manually, with both of them open --- and now it magically works. This has me thinking that it may be a permissions issue of some kind, perhaps with an erroneous error message. It seems that if I create the DB...

I did a scan of that - comparing the fields in both tables, and they all looked the same. I actually created the external destination table using a query from an empty version of the source - so unless my empty version is somehow mismatched (which has definitely happened when I change a table...

In this case - No. The tables are relatively "normal". :)

OK - good to know. I vaguely recall being able to insert rows into a table with Autonumber, (including values for that field) but I also recall that things kind of got wonky sometimes - so my approach since then has been to either use Autonumber - and let it do what it wants, or don't use it...