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

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

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

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

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

I am not sure if I am using the correct syntax for Nz or even if I am using the function in MS Access 2003 properly. I got the example from http://www.techonthenet.com/access/functions/advanced/nz.php but can’t get it to work form me. In a subform I am getting a Sum of a Control called...

Can I create a permanent filter by using the Form's Attribute “Filter” so the records returned only show a specific value? I have tried this but it didn’t work for me. ((Cash_Record.Current_Assignment=2)) Cash_Record is the table Current_Assignment is both the Table’s Field name and the Form...

Can anyone suggest how I can keep a record from being created in a comment table if if the “Comment” text box is blank or only has blank spaces in the text box?

I am rather new to MS Access Forms and need Syntax for an issue I am having in a form. I need to trim leading and trailing spaces from text coming from a control box called “Comment”. I don’t want someone to be able to just insert blank spaces and call it a comment! Normally in my web...