Search results

Well it only runs this if the user clicks "Add" so once they click that there is no backing out. What i really need to know is "how" to do this, i have thought of the logic behind it, but lack the syntax to implement anything :(

OK, I have a table which has the following fields of relevence to my issure. SamID, SamSeqNo. SamID is allowed to have duplicates, as well as sam seqNo BUT the combination of the 2 is unique 1|1 1|2 1|3 2|1 2|2 2|3 3|1 4|1 Etc, ETC... When a user enters something like 1|2 into that table, I...

I still seem to be getting the error with that. So what i've done is disabled all of the controls while the code executes. and then enable the specific ones at the end. Seems to be working except if i press enter really fast it "cancels previous action"

OK, Now I have this as my code: --------------------------------- Private Sub cmdNext_Click() On Error GoTo Err_cmdNext_Click DoCmd.GoToRecord , , acNext If Me.SamID = DMax("SamID", "tSample", "SamPhoto Is Not Null") Then cmdPrevious.SetFocus cmdNext.Enabled = False...

Thanks! worked great

hit refresh on ur browser and read above comment by old softboss :P

Ok, I am trying to make some sort of thumbnail preview form. The image appears in the imgBox no problem, and it is grabbing it from the field. When I use a combo box to navigate the records it works flawlessly HOWEVER, I would like my users to be able to press bckwds/fwds arrows so i made...

ok thanks for the help

well i want something like a control that says "cancell" that would "undo" thier changes. What it would actually be doing is just not writing them in the first place, and the close button would write it. But i'm not sure where to put the event ? before update ?

Hi, I have a form where i would like to bring up various records for editing. This part is not a problem. BUT. If a user accidentally changes something and doesn't know what it used to be then i need to have a "cancel" button which will undo the edit so to speak. I am not sure of the best...

not a problem

Make the query for the listbox rowsource group table and the criteria be the combo box. Then on the after update event fo the combo box, call listboxName.requery

WHen i auto generate an email, I want to attach a jpeg, gif , etc file. How is this done ? or where should i look?

not to be impatient, but ... BUMP THANKS in advance!

Hi I have set up some automated e-mail, My problem now is that when i bring up outlook to send email, I want the users to be able to put their business contacts on there from their address book. Meaning my program does not controll the TO, CC, or BCC... HOWEVER! I need to create a log of these...

Hi I have set up some automated e-mail, My problem now is that when i bring up outlook to send email, I want the users to be able to put their business contacts on there from their address book. Meaning my program does not controll the TO, CC, or BCC... HOWEVER! I need to create a log of...

Perfect, Thanks!

Hi, I am attempting to auto generate an e-mail, but i am unsure of how to begin a new line in VBA syntax so instead of Joe Shmoe, This is an automated email from ..... I want Joe Shmoe, This is an automated email from .... Does anybody know this syntax off hand ?

That bar is a part of the boarder. To remove it simply set boarder size to "none"

I thank you FoFa.... That is a HELL of a lot less work than what i was trying to do!