Search results for query: *

Thank you so much for your help! Coding is such a perishable skill, and after several years away sometimes even the easy stuff seems like a barrier to me. After I saw your suggestions, I realized that my problem stemmed from the concatenation operation in the string ... it took me some trial and...

Hey just wanted to thank all of you who responded to my post... I'm just now getting back to this because I had some out-of-state relatives show up at my door unexpectedly. All clear now :) Anyway, I will try out your suggestions when I get back to work and let you know. Just didn't want y'all...

Greetings Access Gods, I've been away from the IDE for several years due to a medical event and have recently started building a db while trying to re-learn as I go (my meager coding skills have atrophied significantly in the last few years due to lack of use). Anyway, I built an event by which...

Greetings Access Gods, I maintain a DB that tracks training dates. It's fairly large; my police agency has about 600 officers who are required to complete qualification training in several areas on an annual basis. For the sake of simplicity, I will just narrow it down to three: Pistol | rifle...

PHV, You are, of course, correct. Kind of feel like I wasted your time on that one - all those stupid trees were blocking my view of the forest... But thank you very much, and have a star.

There is no event associated with this issue. I may have not done a good enough job explaining the problem, so here is a watered-down, generic version of my DB... frmMain has: LAST FIRST SSAN DIVISON A tab control is on frmMain with subforms under each tab. The subforms contain text boxes...

Greetings experts, Stupmed on this one, and a good scouring of the internet has unfortunately turned up little. I am developing a simple DB in ver 2007. It consists of a main form which contains routine data like last name, first name, etc. On my frmMain is a single tab control with 3...

AceMan, I did step through the code as you suggested and it hung on the msgbox then opened up Outlook when I left the debugger. I also made sure that Outlook was not running in every instance before activating the cmd control. Problem still persisted. This db is in Access 2K. Here's the kicker...

Seriously guys, this is the only code for this event. I am building this db from the ground up - it is not an existing product being modified. And, I just started it - so it's way in the early stages yet and has almost no code in it other than what I wrote about here and a few wizards for Next...

AceMan, Thanks for the code, but my results are still the same with it. I re-read my original post and I don't think I presented this problem as clearly as I should've. Apologies. Specifically, here are the three possibilities that the end user will encounter (#3 is my problem area): 1. An...

Hi, There is no other code for this event. A "mailto:" hyperlink is created and autofills a new message in the default email client. It runs perfectly - only as long as there is an email entry in the corresponding txtEmail field. It's when the txt field is empty that creates the problem.

I have a field that contains an email address and a command button that will bring up a new Outlook email and autofill the receipient in the "To" block. Easy enough, no prob. If there is no data in txtEmail, the error message pops up as expected, but immediately upon closing the msgbox, a new...

I usually spend all of my Tek-Tips time in the Programmer's forum, so please bear with me. I needed to establish a crossover connection from my Win98 box to my XP box, and successfully did so by reviewing pervious posts in this forum from other users. But I do have a few questions about the...

Thanks for replying. True, a flat table database would work with this app. The organization that wants to use it provides funds to people in need via an outright grant or a loan. Naturally, they have to keep detailed and accurate records of their transactions in the event they are audited...

Exactly. I'm not looking to build a complicated app, maybe a few related tables is all. Just like in Quicken, Money, or Excel, I would like to display a balance at each transaction and then also an ending balance, like in this simplified example: 1/25/03 Opening Balance...

There is an organization at my work that is involved with non-profit charity work. They are currently tracking their funds using the paper register in thier checkbook. This method is not suitable for them because they are required to keep detailed notes on each of thier financial transactions...

After reading my post again, I suppose it can be interpreted in more than one way. That’s what I get for being opinionated at a late hour. :) In any event, all I was saying was that having some code to resize user’s forms was better than building several versions of the same app with resized...

Ben, I have to respectfully disagree with your assertion that resizing forms to the user's screen resolution is the height of arrogance. Your statement is based on the fact that computer users know and actually care what their resolutions are set at. It has been my experience that many who...

A component of my database allows me to record notes in a field. I set it as an OLE Object so that I would be able to enter large portions of text. It works fine, however, I would like to be able to use the mouse wheel to scroll through the lengthy text instead of clicking the down arrow on...

A component of my database allows me to record notes in a field. I set it as an OLE Object so that I would be able to enter large portions of text. It works fine, however, I would like to pop in some code to allow use of the mouse wheel to scroll through the lengthy text instead of clicking...