Search results

Well ... not detailed help - people like me go to other people for help, too. :D In this case, Allen Browne. This link has a potential for helping you out. It includes a search form and sample database along with detailed description. HTH, -dK

Well ... never did this before but if it was a text box I could envision setting the default value to "Enter text here" and in the OnOpen event of a New Record setting the control background color to grey. But then you would have to validate the control to ensure they put something in it or...

Just swagging here .... If Time() > #7:00:00 AM# AND Time() < #2:00:00 PM# Then 'do enable Else 'inhibit enable End If This might be dependant on the way the system date/time is setup. Just throwing out a guess for you. -dK

You can do this by storing the string in an unbound control (hidden) on the calling form, in a variable with full scope, or by the use of the OpenArgs function. The simplest implementation would be the OpenArgs piece. HTH, -dK

You are welcome! I would guess that the subreport doesn't have any data in it. Only things I can think of is checking the Parent/Child links on the subreport properties if those are required, or setting it all up in a big query to check that I am getting the data I actually want and possibly...

On the AfterUpdate event of the checkbox, try ... If Me.chkCheckBoxName = True Then Me.cboComboBoxName.Enable = True Else Me.cboComboBoxName.Enable = False End If Then on the OnCurrent event of the form, use Call Me.chkCheckBoxName_AfterUpdate HTH, -dK

If your report is driven from the query, then whatever you used as the VariantName - set that to the control source of the control you want it to display in. If not, then you can use the IIF function in the control source, too. -dK

So you want ... -x + +y +x - +y In a query column try something like ... VariantName: IIF([fldFieldx] > 0, [fldFieldx] - [fldFieldy], [fldFieldx] + [fldFieldy]) I should add that what happens if one of the fields are blank or empty? You could use the Nz function on each of the fields to...

Without looking at the efficiency in terms of operating speed, etc., - IMO it is easier to administrate value lists. Just write a simple form interface and give permission rights for the form level access. In this manner, noone is bothering you to update them at the table level - you have...

You can do this programmatically or using creative lines. For the vba side, there is sample code out there so use your favorite search engine to start there. To use creative lines, I will attempt to explain by setting up lines around the table. You essentially want to create a box ... in 3...

Not sure what you mean by query routine. If you set it all up in VBA (using TableDefs) then you should be able to use ... CurrentDb().TableDefs.Refresh -dK

The bound column of the combo box is on the CustomerID so this is the only data the query will see. You will need to bound the combo box to the column of the last name. I would also set the view of the combo box to show the last name (and not the first) since this is what the basis the user will...

Try putting the source name (table/query) in front of the [Ship To #].[Street Address Line 2] reference for qualification. For instance [tblTableName].[Ship To #].[Street Address Line 2] -dK

I use the following to check for both conditions, a null or zero length string ... Len(Nz(Me.txtControlName1, "")) = 0 So you might be able to use something like ... If Len(Nz(Me.txtControlName1, "")) = 0 And Len(Nz(Me.txtControlName2, "")) = 0 Then .... HTH, -dK

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