Search results

Hey all, I'm trying to come up with a way to generate 4 random numbers and then add the three highest numbers together to get a result. I can generate the numbers, but am not sure how to add just the three highest numbers while ignoring the lowest value. Any ideas?

This may be a simple problem, but I'm stuck right now. I have two different user forms. They each have a text box called strSearchCriteria. What I want to do is run a query based on the value of the strSearchCriteria box. I further want to limit the results of the query to be items that are...

I'm having a similar problem to other ones that have been listed, but mine is slightly different (at leas I think so). I have a table that uses three fields as its primary key: dtmOrderDate strUser strItem Basically, it is to make sure that the same user does not enter orders for the same...

I was wondering if there was a way to have the details listed in a horizontal list rather than vertically. Example: I have an item that can be ordered by more than one user. Currently I can get it to do this: Item........Catalog #...........User...

I'm hoping someone can help me with this. The short question: How can I pass a variable from a form to a query that is used to populate a list box on the form? The long version: I have a form...we'll call it frmAlpha. On the form there is a list box, lstItems. There is a text box called...

Help please. I have a form that when the button is clicked to update an order, it opens an input box asking for the order number that the user wants to update. Once the number is input, another form opens with the items ordered under that order number. This works great as long as the order...

I was wondering if anyone has any information on how to change the background colors on command buttons. From what I can see, Access uses the settings from the Windows display properties for the buttons. I want to distribute my dB to users but don't want the color of the buttons to be...