Search results

Yes, it is possible. The question is - (a) Are you creating the serial numbers on the fly and you create the metal stamp for the product then, or (b) is it going to grab them from somewhere else and then you dig through the boxes looking at the box labels to ensure you grabbed the right...

The only reason I didn't suggest that was if the record was completed, the box would still be grey ... so suggested the coloring happen on the OnOpen event (If Me.NewRecord Then Me.txtControl.BackColor = .... ). I think perhaps the 3 step process seemed to much of a hassle. Now, if someone...

I am not sure why it is not working. I've attached my screenshot where it works. -dK

That looks about right. I would assume most call for the OnLoad because OpenArgs is mostly used to pass something that the db needs to make a decision on about the form and it should occur at this stage in the processing of the form. It should work for by using Me.OpenArgs in your MsgBox ...

Hmmm. So it tested one way fine, but not the other. Might need to use a CInt(...) around those to ensure that they will be manipulated as integers. I will perform a check, too. -dK

Are those numeric fields you are working with? That is, declared at the table level as numbers? Or, are these some unbound controls on a form? -dK

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