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

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

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

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]

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

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

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

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

I have the code below which takes (lngSampleSize or sample sizes) from QryIntertab and plugs the sample sizes into the strSql query as lngSampleSize. This works fine but now I want to add (lngSeedNumber or seed numbers)from QrySeedNumbers and have it plug the seed number into the strSql query...

I have a program that can do this but need to be able do this in access. Lower Range = 1 Upper Range = 9999999 I would like the module to select a random seed number, user specified or from the system clock between -2147483647 and +2147483647. Then, using this seed number, I want to select a...

This problem involves generating random numbers with a user supplied seed number. In this example, I have 3 different dollar ranges and a sample size for each dollar range. Dollar Range...................Sample Size.................Seed# .01 - 10000...

I have a database of 20000 invoices made up of 150 vendors. Is there a way to query for 5 random invoices from each vendor? Of course if the vendor has only 4 invoices then it would only be possible to query for 4. Thanks

Would anyone know of a Random Generator Function or how to create one where the user would supply the seed number instead of using the system clock to choose the seed. I need to be able to enter the seed myself so someone else could reproduce the results by using the same seed. Thanks

Hi, I am doing a basic random sample, querying for 100 random items from a 20,000 item table. I've tried numerous examples using Rnd and Randomize that work fine. In these examples though, the seed numbers are chosen by the system clock. Nowhere have I found a way to supply my own seed number...

I have a tblAmount with various dollar amounts and another tblRanges with beginning and ending dollar ranges. The query is supposed to look at each amount in tblAmount and throw the amt into the proper dollar range from tblRanges. The query gives totals by dollar range. The problem is when a...

I have 2 queries. The first query gives a square root calculation number and the second query gives a running sum of that number. I'm wondering if the two queries below could be combined into one. Thanks to anyone who can help!!! Query1 SELECT [Begin] & " To " & [End] AS Range...