Recent content by jlathem

Trying to edit a record, the edit form has a file input that could upload an image but doesn’t have to. When I try to process the form I send it to an action page and get error 'Element CLIENTFILE is undefined in CFFILE.' Any suggestions? Thanks, James <cfif not...

Heu Guys, I got this one worked out. Thanks for your help! James

MajP Thanks for pointing that out. Dropping the “-“ minus sign is just a typo. James

ZmrAbdulla, I only put the comments into the code above for posting purpose so anyone reading the code would know what was going on. The actual code being used doesn’t have the comments in it. But I do thank you for pointing it out. I didn’t think anything about putting the comments in at the...

Hey Guys, I am still very new to VBA and hope someone here can help me out. I am getting an Application-defined or object-defined error” running the SQL below. I am trying to Update a table field call CD_Closed (Y/N Boolean) when a control on the parent form called Amount_to_Disposition...

Ah, ok. Thanks for the info. James

If that's all then there really isn't any point in using the On Lost Focus. Hummmm Thanks for your help. James

Hey Thanks! I’ll give that a try! Ok in the interim, what’s the difference between “On Exit” and “On Lost Focus”? I know it’s a newbie question! Thanks for the advice and the help! James

Ah, well that makes dollars and senses! Thanks for clearing that up for me. Have a great day, um night! James

Hey Guys, I am having a problem with SetFocus. What I am trying to do is check to se if the control Payee_ID is Null, if so give a MsgBox and SetFocus back to the Payee_ID control. When I run the code below, I get the MsgBox and the curser blinks once or twice in Payee_ID before moving to...

Hi MajP, Thank you for your reply and the directions! I knew there had to be a something like the .addItem but didn’t know enough about VBA to know what to ask for. The second way is interesting and I will save both of the pieces of code for future reference too. Thanks again, James

Can someone take a look at this code and let me know what I am doing wrong? I am trying to create a dynamic list of values for a Combo Box to list week numbers from the Start_Week to the End_Week and display each week number in the combo box as an option to select. Any help is much...

Thanks, I will see what I can figure out. Jms

Duane, I got the unique index for multiple records working but when an attempt to enter a dupe record I get a MsgBox that doesn’t really tell the user what they did wrong. Is there a way to create a specific message when the index catches a dupe record? Jms

Ah, I never knew that was possible! I am reading about that process now. Thank you so much for taking the time to help me. Jms