Search results

Fair 'nough. Now we're back to getting a "sub or function not defined" error that highlights the first instance of "ahtAddFilterItem" just as before in the TestNEW function module... :(

I feel pretty dumb, but I still can't get it to work. Thanks for bearing with me. Here's what I have: A module as follows: Function BasFunctions() Type tagOPENFILENAME lStructSize As Long hwndOwner As Long hInstance As Long strFilter As String strCustomFilter As String...

This is driving me mad. Could someone please let me know how to incorporate this into my current module so that I can call it using a macro? I'm just trying to automate an import and am failing miserably. :(

I'd tried that before even posting here...seems like a really good way to go, but like many others, I seem to have a problem with it error'ing out in "sub or function not defined," though. The debugger highlights "ahtAddFilterItem." I have seen many people ask about this (just from searching the...

I am at the stage where I'm fine-tuning my module, and would like to enable the user(s) to browse for a file rather than tieing their hands by stipulating the specific path. Currently, I have the following to import the specific file, which works just fine the way it is, but could anyone tell me...

That worked beautifully - thanks so much!

I'm running into a problem that I've tried to solve two different ways without any luck: The table was imported from Excel, where the format was a custom (#,##0.0"EA"). I'm now in need of converting this to number type in Access to perform calculations on it, but have been unable to as changing...

I am an idiot...as I copied it over here, I realized what I did. I'm so sorry for bothering you. Thank you TONS for helping me out! You really got me out of bind. Have a good rest of the day!

It actually highlights the entire four lines of code... :(

Wow - that was FAST. Thanks so much! That does make perfect sense, and I'm more than thankful for the help!! After changing it to have leading commas and spaces, I'm now getting a Compile - Syntax Error. :( Thoughts?

Alrighty, so I dared to venture into the world of VBA coding, and have been RELATIVELY successful, but I'm stumped now. I have found many useful posts on this site, so I'm hoping someone will be kind enough to humor my (probably stupid and amateurish) question. I wrote the following module for...