Recent content by quest4

Bingo, I got it working. Moved the procedure to the textbox BeforeUpdate event and added and Me.Undo and it works. Thanks one and all and have a great day.

Thank you for the responses. Gus, you are right about the way things happen, but I was trying to keep this simple, with just two buttons, save and cancel. Trust me on this one, the fewer the choices/buttons the better off I will be. A dozen people will have access to this and wheter or not I...

Thanks for the response, Gus. PartNumber is the name of a field in the subform where I am going to enter data, in this case part numbers. GotFocus is the name of the event, there is one thing that I must state here, this is for new ECN's ONLY, I have several other data fields that MUST be...

Zephaerie, DLookUp uses the actual data in the table, it can also be used in a report, just change the destination form to the destination report, in the procedure I pasted. There is a lot of info in the posts here about DLookUp, I think once you have tried it you will like it, I used it alot on...

Good afternoon, folks. I have been looking at this procedure for three or four days now and I can not see what is wrong with this procedure. I have a form with four checkboxes on it and a subform, I want to have at least one or more of the checkboxes check before I can enter data in the...

Good afternoon, if I understand you correctly, you want to select from a combe box an engineer and have that diplay two textboxes of info about the engineer which is stored in a table. Is that about what you are trying to accomplish? Can I assume that this is just displayed data? If so, just...

Floydski, I agree with Omega36, by what you are discribing at the end of your post it sounds like you may have caught a bug, and there are enough of them around. I personally use Norton for my virus protection because they also have extraction tools for the latest viruses, also goes to MS, they...

Have you tried the install as the Administrator? I have not worked on XP yet, but I have hear that it is supposed to be stripped down NT, but it is supposed to run pretty good I have been told. Also, have you run a virus check, with the latest update? Do you have the latest service packes...

Are you on a NT network? If so, the answer is permissions. Do all of the PC's have the most resent service packs installed? Is the error occuring on one maufactures brand of PC, like Gateway? Just a couple of things to look at, isn't debugging fun? I just finished one where the drives where...

Good morning, I have a procedure in which I am using SendObject to send an E-Mail message to users when a command button is clicked. Most of our users have Outlook on all of the time, and they have no problem, but a few don't turn on Outlook at all. My question is if a user, who does not have...

Sklambert, in the end I used just DoCmd.SendObject and it pickup Outlook on its' own, so to speak. I stop using the Dim and everything started to fly for me. Hope that helps. Good luck and have a good day.

Thank you Cosmo for the information, maove or less it was just a thought I was playing with for after people don't need to see instructions. Thanks for everything. Thank you RoyVidar for your assistnace. I appreciate haveing an alternate method of of doing putting in instructions. This is the...

CosmoKramer, one last parting question, is there a easy way to increase the duration of the pause before the pop-up comes up? Thank you for all of your assistance.

Thank you for getting back to me. I just experimented with it, using the Textbox's GotFocus event and it appeared to work, a little further to the right than I liked but it appeared to work. Is there any additional commands I can add to change font size and text justification? Is there any...

Thank you again, CosmoKrammer. I will give it a try, but I have a lot of checkboxes and textboxes that will need these, about 12 or so per page and up to six pages per form, won't the OnOpen event get a bit crowded with all of that text being entered? Also it will make it a bit hard to modify...