Search results

Okay, you could do this one of several ways, but I want to simplify it a bit more to give you an idea. Suppose you added a couple of fields to your user table where the password and login are stored. One field is a LoggedIn (Yes/No) and another is called SecLevel (Text). For the security...

What you would want to do is probably do some searches on quantitative evaluation of frequent pattern mining algorithms. Basically what that means is that you are going to mine numerical data looking for patterns in the data that occur with regular frequency. The distinction in your case, is...

I don't think I am sure .. what if 1 person falls in the first 10 percentile and the other 2 falls in the other percentiles? Anyhow, what I think you want to search on the term 'ranking queries' to see if that guides you. HTH, -dK

Yes, you could create all 7 fields and form controls. In this manner, you wouldn't need to create any fancy coding for dynamic set-up of these. As a side note if you were to create a 'test order form', that is, someone creates the order for testing and selects which tests to perform - that...

Yes, it is possible to set and grant permissions to users. You can either create a login form and associated tables to manage the users or another method would be to use the environ("username") to detect the user name from the windows logon. Yes, you can use a form checkbox to manage...

Ahhhh ... hmmmm .... Yes, very counterintuitive like you said. Thanks alot for posting back your final solution! -dK

Ah ... I just learned recently that a subform can't receive the focus so there ya go. Glad it worked out for you. -dK

You could set up a query to refer to the input box when the user click's 'Go' and then use the result of the query to populate the form. Also, you would need to provide error-trapping for this if no records were returned to alert the user of this fact. The combo box idea has a feature called...

I would guess that these steps .... 'Replace record navigation tools with save/abandon new record controls DataEntryDisplay 'Remove the new record command button from the header cmd_NewRecord.Visible = False could be the issue. I am assuming that the DataEntryDisplay bit is a function that...

So once you had 1000+ records in the database, you would expect the user to get it right every time? So the expectancy would be that the user would have to memorize every entry in order to use the db? Or, you would right extra code to do a fuzzy search that responded with a Did you mean record...

Just a swag here ... is the button Default property set to Yes? If so, try setting it to No to see if that cures. -dK

Hmmm. Try explicitly declaring the recordset? Dim rs As ADODB.Recordset -dK

I think the detailed explanation uses something like this ... can't recall. If not, this link has an example in the first link on the page that is a great to use. I've used it to open records on the same form and a different form. The modification from one or the other should be clear once you...

There is a way and going to give it a go from the top of my head of how I have done it before. If the subreports are infinite size - meaning your report could span many pages, I would resized the subreports so that they are a thin line and set them 'to grow'. Then on top of the line, I would...

Just stabbing here .... why not use your code on the AfterUpdate event of Me.intVolume and Me.lng_Expected_Duration? In this manner, you're not dependant on moving records but only when either field is updated. Of course, you would probably need to use the Nz() function to wrap these in to...

You can use the built-in filters if you would like - you can search the Help files to get you on this path. It could be complicated if other people are going to use the database. Another way to 'search' is presented here with a sample database and lengthy explanation. I normally use something...

I'd probably start with the query wizard to set up unmatched records. If you run from the Orders table against the Customers table and perform an unmatch against the FK of the customer in the Orders table and PK of the customer in the Customers table, this should return all of of the customers...

Here is the best resource I've ever used. It is well documented and provides notes to know how to use. The first part will tell you where to call the function and to trap the error. HTH, -dK

Ah ... too much in '07 for me to go about trying to learn a whole new one. Besides, convincing IT departments to go to '10 (and companies to purchase) until there is a 6 months gestation on the first SP would be too big of a bull for me to wrestle. I know the ones I work with just went to...

I don't know him ... personally ... yet. :D -dK