Search results for query: *

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

Thanks, I changed it to this. Not sure if it works but now need to know how to go about getting the results into a table or query. Anyone know how? Thanks Option Compare Database Function GetRandomBetween(ByVal lngMin As Long, ByVal lngMax As Long) As Long On Error GoTo ErrHandler...

Hi, I reversed the rs and rs2 and it still find the sample sizes but not the seeds. It must be the punctuation. Anyone have any idea what the problem is? Thanks

Hi, the seed numbers aren't coming into the Str-SQL query like the sample sizes. It give an error message, Too few parameters, Expected 1. It highlights this line: CurrentDb.Execute "TestingRandom Query". I'm not sure if the punctuation is wrong on & " ORDER BY GetRan (lngSeedNumber,[id]))" or...

The code below generates a seed value and 3 random numbers that appear in the immediate window when the code is run. Instead of having the number 3 hard coded, I'd like to have a form where I could select the number random numbers I'd like to choose and then create a table or query which would...

Hi, One query holds the sample sizes and the other query holds the seed for the corresponding sample size. They will each have the same number of rows. Thanks