Search results

Well, I'm going to try to bone up on my Class modules (I have 3 VB books-ONE of them should be able to explain it right!) before I try anything else. I'm sure however that this won't be my last question though Talismanic, so don't think you won't hear from me for a while. <grin> Thanks again...

sorry to confuse you. I have snippets of code behind certain fields (Ex. if I want to add the date an issue was closed into a different field, I have code behind that combo box using something like "AfterUpdate"), as well as using a main module for a few public functions (like emailing the...

No I'm not...not to sure how that makes a difference though?

Ok...I think I figured out why I'm getting the gpf. I have my code in a standard module, instead of a Class module. Unfortunately, I know nothing of Class modules yet, so I guess I'm going to have to continue reading up on it.

Heh heh...guess I was too hasty. I tried to put that code in there, and I ended up causing Access to gpf with a kernel32.dll error. Guess my co-worker is right: I know just enough to be dangerous!

Heh heh...I got you beat. My first "computer" experience was Pong (of course); then I went to my mom's work (she worked at one of the better elementary schools) and was introduced to the PET computer (with 2k of RAM!) heh...after that, it was all over! I never could do programming well, so I...

Actually, I'm going to try to include as many fields as I can. I wonder though if this bit of code will take the currently displayed contents of, say, a combo box. I'll have to play with it. Thanks again! I never thought I'd say this (after trying to learn some type of programming language...

Ya, actually, I think I follow what you're trying to do. You've modified the SendObject statement to include the content of specific fields in the current form via email, right?

Yes and no. I was able to email myself the entire database, but as of yet, I've been unable to figure out how to email the current bug (Ex. I'm editing/creating a bug and because the contents have changed, I want to email the person (whose email address I've entered into one of the fields)...

Ok. I am able to email the entire form using the DoCmd.SendObject. Is there now a way to just email the currently selected record on the form instead of emailing the entire 1000+? Thanks!

Ok...I've incorporated it into my database, but here's the problem. When I call it, I get a message box that says "The expression On Dirty you entered as the event property setting has produced the following error: Out of stack space" and then I get gpf. Here's my code (I'm using it with "On...

Great! Thanks, I'll try that out.

Given my very basic VB skill level, would it be difficult to code a routine that would pull the email address out of a field and automatically send email based on the contents? The last question I posed was a little over my head, so I'm not sure if this will be any better, but what the heck ;-)...

Well, after looking at your code, I'm just as confused as when I looked at it the first time. Is there a simpler way to do this? I have the engineer list in one table and the primary responsibility list in another... Maybe I'm not ready for this yet =[

Got it. Thanks!

Wow...thanks! That's gonna take a little time for me to digest exactly how that all works, but it gives me something to do (heh heh). I really appreciate the help! Regards, Jerry Horgan

Hello All. I have written (rather sloppy) code to update two other fields on my form based on a selection from the first field. Example is below: If Engineer_Name = "Mike" Then Email_Address = "mike@nowhere.com" Primary_Responsibility = "Hardware" The thing is, I have tables already created...

Hi all. I am trying to figure out the code for the following problem: I have a "Closed Date" text box that I want updated to the current date and time ONLY when someone selects "Closed" from a combo box control on the same form. Anyone have any ideas how I do this with VB? I have what I...

Heh heh. I'm not even sure what that statement means, but I'll try it (ok, so I'm REALLY new to VB =]) Thanks Alot for responding-I appreciate it! Regards, Jerrold Horgan

So, I've been studying VB and I'm trying to do a simple update from one record to another-Ex. if I select "Elektrik" in one field, I want the email address in the next field I have to automatically select "elektrik@mindless.com" so I don't have to enter it. I figure out the right syntax (I...