Recent content by FUBAR

Copy paste is a solution...but not usually a good one especially if there are a lot of records that you are transferring from Access to Excel. I can think of 2 different solutions off the top of my head...one that doesn't need VB at all. Without...

I fully understand the lack of reusability with using arrays, but really I was just using an array as a simple example. My combo boxes are not actually named cmbBox0 (I practice good naming conventions) and the array can easily be turned into a collection or another collection-type object that...

Victory is Mine!!! Well after I saw the post that said it wasn't possible to create an array of combo boxes I gave up on the idea. However, today I stumbled upon some code that DOES allow for this and I'm kicking myself because it was a small error on my part that was preventing me from...

Never mind If anyone could actually understand my babble...for the most part I think I've figured it out.

Hello again, I'm attempting to import data from an XML file into Access 2000. From reading the few posts here and what I could find elsewhere on the net about this subject, I've learned that Access 2002 already has this functionality...too bad I have to use 2000 Also I have msxml.dll on my...

Thanks for the tip... Read and tested some of the Control/Tag stuff and know how I could use it to do what I want...but it's still not exactly what I want (I know I'm being picky) Is it even possible to make an Array of references that reference Combo Boxes (or for that matter Text Boxes...

Well if you look at my second chunk of code.... Say I had 20 combo boxes and I wanted to create a msgbox for each combo box value when the user clicks a button (not what I want to do but is an example) I would want to use the array as an easier way to reference the combo boxes on the form For...

Hello all, I have some code that I want to run on a few combo boxes located on the same form. Instead of copying the code for as many combo boxes I have, I wanted to load all of the combo boxes into an array, and then iterate through that array while running the code. Problem is I can't...

An automated database was made on a personal computer that is connected to a network. Part of the automation requires Access to manipulate Excel by creating a new workbook, creating a new web query and parsing the data from the query. There is error code in place in case the web query doesn't...

Anyone out there know where I can find some information (or better yet actual code) on how to make a function that would return a boolean on whether a file exists or not on an FTP? Thanks in advance, FUBAR