Search results

Thanks for the quick reply... I took your advice (storing the autonumbered ID as a variable), and it seems like so far, it's working well. Thanks again...

This is probably a really stupid question, but I'm having a mental block and could use a hand. I need to run a query, called 'getnew' from a button click in a form called 'workitems' The end usage should be something like this: - Trouble ticket summary info is loaded into a table. Every...

Wow..thanks for all the feedback! So far I'm not having much luck, but that's likely due primarily to my own ignorance. Fortunately, nobody around me here has any programming experience, so the little I have gives me enough ammo to keep them at bay while I investigate and learn!

Thanks Gemma...or Mr. Husky I'll give it a shot. If I come up with anything, I'll let you know as well. Seems like this should be a bit easier to accomplish!

Hi... I'm trying to automate a process for grabbing files from an FTP site, unzipping them, and importing the data into an access db. I've not been able to get the string to work using the standard "Username:Password@hostname.path" approach (or any variations). So, I'd like to open the ftp site...

Wow...not sure how I missed that one. Thought I looked high and low to find it... anyway, I appreciate it. Works like a charm.

30 min into my first project with Access 2007 and am making decent progress, though it's quite rudimentary thus far. What I'd like to do is change the value of a combobox called Status which resides on a form called QueueForm to "In Progress" and immediately commit back to the db. The default...

Excellent...thank you so much for posting! I'll have at it and see what I can do. I'm sure I'll be back! :)

MS Access Version = 2007 Hi all - I'm somewhat new to all of this, but have created a few small applications using VBA in the past few months. Far from comfortable with it, but am learning more each day (and thoroughly enjoying it). I'm not sure if Access is the right tool for the next...