Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jlathem

    CLIENTFILE is undefined in CFFILE

    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...
  2. jlathem

    I am getting &quot;Application-defined or object-defined error&quot;

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

    I am getting &quot;Application-defined or object-defined error&quot;

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

    I am getting &quot;Application-defined or object-defined error&quot;

    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...
  5. jlathem

    I am getting &quot;Application-defined or object-defined error&quot;

    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...
  6. jlathem

    A SetFocus issue

    Ah, ok. Thanks for the info. James
  7. jlathem

    A SetFocus issue

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

    A SetFocus issue

    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
  9. jlathem

    A SetFocus issue

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

    A SetFocus issue

    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...
  11. jlathem

    Trying to Create a Dynamic Loop for a Combo Box

    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
  12. jlathem

    Trying to Create a Dynamic Loop for a Combo Box

    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...
  13. jlathem

    best coding practice or methodology for tracking payouts byweek number

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

    best coding practice or methodology for tracking payouts byweek number

    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
  15. jlathem

    best coding practice or methodology for tracking payouts byweek number

    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
  16. jlathem

    best coding practice or methodology for tracking payouts byweek number

    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...
  17. jlathem

    best coding practice or methodology for tracking payouts byweek number

    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...
  18. jlathem

    best coding practice or methodology for tracking payouts byweek number

    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?
  19. jlathem

    best coding practice or methodology for tracking payouts byweek 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...
  20. jlathem

    Getting an #error when using Trim() in Form Control

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

Part and Inventory Search

Back
Top