Search results for query: *

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

Like I said I am new to this kind of developing. I will include the table structure below. I thought that if you make any table field unique index that would mean that there could be no duplicate values in that specific field. If I understand what you are saying is that unique indexing will...

Thanks for helping me out with this. I am very new to VBA and designing forms so I may not have explained myself very well. I think this issue may be a methodology problem. I am storing all the payment requests from all the payees in one table. There are 100s of payees and each of them...

Duane, If I set a unique index on Payee, Year, and Week_Number wouldn't that keep me from entering a duplicate record with the Payee_ID or Year, or Week_Number?

I am very new to Access Forms and VBA and looking for best coding practice or methodology for what I need? I have a new project where I need to track payout requests by Payee ID and week number being requested. Each Payee is entitled to only one payment per week. But can request back payments...

Hey thank you for your help. I got it worked out. James