Search results

Could you please answer my question? Thank you.

Hello and thank you for replying. Unfortunately, I don't know VBA, so I wouldn't know how to go about doing that. Could you, perhaps, quickly throw something together that would work for the sample Database I provided? Yes, sir.

Hello again and thank you for your quick response. The information that can be collected varies depending a number of external factors. As a result, certain Fields will be completely left out, as they have no data. Also, in practice, there's a lot more than just 1 "Main" Table and "Updates"...

Hello kind sir and thank you for your assistance. I will try my best to make helping me as painless as possible. Please bear with me. That is a mostly accurate interpretation of my intended use. I have an Update Query designed to update a "Main" Table with data in an "Updates" Table. The Fields...

Hello again and thank you for replying. I appreciate you pointing that out, however, I am very well aware of this, as that is essentially the whole reason I'm asking for help here. I find it hard to believe that a language as powerful as SQL has no way of creating an Update Query with optional...

Hello and thank you for replying. It appears that my original post did not describe my end goal as clearly as I thought it would, so I made several changes to it and even added 2 database files to aid in understanding my problem. Please, have a second look and let me know what you think. I...

Automatically handling "Enter Parameter Value" prompts? EDIT: I think my original post may have been detailed to a fault and probably crossed-over into confusing. So I've all but rewritten my post in an effort to make it as clear and concise as the best of my abilities allow for. I apologize to...

Hi, my name is Barry and first and foremost, I want to thank everyone out there that helps out newbies like myself. You guys rock! Now I may be relatively new to Access, but I know the basics and have some background in programming C++, Java, and a tiny bit of VBA. I hope to expand here and...