Recent content by nancier

I have a combo box that is set up so I choose from a table field list. Is there any way to have another value or a default value that isn't on the list? Thanks

Thanks to both of you, terrific job!!!!!!

These two functions have alot of repeated code. Anyone know if I could combine these somehow? Thanks Option Compare Database Option Explicit Dim MyModule As Module Function Command5_Click() Dim StartLine As Long, StartColumn As Long Dim EndLine As Long, EndColumn As Long Dim...

Thanks, worked great.

Hi, I have a text box on a form called Text2. I'm trying to get the module below to find the form on this line but am getting an error "External Name not defined" on this line. How do I fix this? Thanks strNewText = "tblAmount.[" & Text2 & "]" Public Function Command5_Click() Dim...

Hi, Now that you got it working for the Num-1 text box, I'd like to be able to have 5 text boxes, Num-1 through Num-5 that I could fill in. Then when I hit enter, it would change the Module Code in 5 places. Would you know how to set it up so it could search and replace 5 items instead of just...

Worked Great!!! Thanks a Million

I want to be able to type a word like "FREIGHT" in a text box on a form and have the word "FREIGHT" be automatically entered in the form code after tblAmount. Anyone know how to do this? Thanks Form Event Procedure Code strNewText = "tblAmount.[FREIGHT]

Sorry for the confusion. I am trying to create a table to be exported based on the Data file and the other information I have. But it has to be in the exact export data layout that I specified in the first post. And you are right that the names being different in the Input and Output is a...

Hello, I'm looking for a better approach to this problem and would welcome any guidance. I work with different data each week, the data contains mostly similar fields though the field names are always different, ie. Invoice-Date versus Inv-Date. Some data includes a Freight column while other...

I thought this would be easy but it's not. I want to change part of the code of a string in a module. I need to do this by clicking a command button on a form. I need to make this change. "tblStupload.[NUM-1]" Change to this "tblAmount.[NUM-1]" Here is the code also for the form's event...

Hi, That would be fine having the toggle switch. Do you know how to do it? Thanks

Hi, I'm trying to change the Str-SQL in a module by clicking a button on a form. I need to make this change when the form buttom is clicked. tblStupload.[NUM-1] change to tblAmount.[NUM-1] I'm trying this code but it's not working. Any idea what's wrong? Thanks Option Compare Database...

Thanks, works beautiful

I have a table with 10,000 various negative and positive Amounts. I am trying to do a query where I get 1 positive Total, 1 Negative total and 1 Absolute Value Total. It seems I can only get one at a time to work. If I use a union query, I can't get it to work because I can't seem to use the Amt...