Search results

That is cool but to take it farther...how do I set the sort number automatically? I'm doing something right now where I select items from the left listbox and a button click saves them to a table and they show in the right listbox. I can use an autonumber to get a sort value but I can't change...

No, still gives me an "enter parameter value" message box. Wait. I think that may have done it. Try some testing now but at least it's not throwing up the message box now. Thanks a million.

Hi guys. I'm having a problem with an update statement. It should set a yes/no field to yes but it asked me to "enter parameter value" when run. Do any of you see anything wrong with this statement? For x = 0 To Me.zlist.ListCount - 1 If Me.zlist.Column(5, x) = False And Me.zlist.Column(6...

Stupid question here. This tells me that my list box rowsourcetype must be set to value list. So how can I convert a select statement based on a value enter by the operator into a value list from a table/query?

Some things, such as changing sizes of controls in the onformat, don't show in a report view but do show in a print preview.

Hi, I would like to put a report on my form but I want it to display on the form in print preview mode instead of report view mode. Is this an option somewhere that I am just not seeing?

Abs gives me a "too complex to be evaluated" error. I've found a way to do it (sort of) by using expr2: Right([47-mura],4). That gives me a field without the negative and then I can sum that field. Thanks.

I have a field that saves minutes and seconds past a time limit as negatives. So my field has a value like -02:23. Now my question is how can I get a sum of the negative numbers on a report? Is this even possible? I have converted positive numbers to seconds, totaled them, then converted...

I had a docmd.openform "form name" on a timer to open the form from another form. Everything worked fine when opening the form manually or with a button click but using the timer it didn't work with onopen or onload. I imported everything into a new database and now it is working. Thanks...

I have a form that the on open event sets a couple of values in text boxes depending on what time the form is opened. This works fine when I open the form through a button click but when opened through vba it doesn't set these values. Any ideas why it only skips it when using vba?

I have a form called frm_ppi with a button to open subfrm_calendar. It works great.... But if I putt ppi as a subform of another form then the button opens the from but shows no data. Is this something normal? I just noticed it today and thought one of my tables had lost everything. I can...

There it is... Thanks gents.

So basically, if there is a value in column 4 then find the control with the same name and turn it red.

Exactly. But rather than type that line for all the controls I would like it to pick up the name out of a listbox column. So if one the rows in column 4 of the list box says "am060" then set the control with that names backcolor to 255.

I am trying to set the backcolor of a control based on whether or not that control shows in a list but I am getting stuck. I get a cannot find field error when I run it. Any idea what I've got wrong? For x = 0 To 30 'If Me.List61.Column(4, x) = "AM060" Then Me.AM060.BackColor = 255 If...

Okay guys, I'm having a brainfreeze. I have 2 tables. Parts and supermarkets. Supermarkets has 42 records. One field is superdesc and another is smname. Parts has thousands of records and they all have a superdesc that matches the Supermarkets table but no value in the smname field. How...

I believe I originally had it in the after update event for chkdone but it didn't work. Of course I need to retry it with the new, working, code.

I have it on the timer event because the op will hit a button on tbeir form and that tells a main timer that the ops are ready. When all the ops are ready it resets them all for the next unit. So it needs to keeps checking when a new unit has started so the op has a status of either "complete"...

ok. I got it to work! Used this... If DLookup("[done]", "[constants_stations]", "[id] = forms!frm_operator.id") = False Then Me.Command171.Visible = True Else Command171.Visible = False If DLookup("[done]", "[constants_stations]", "[id] = forms!frm_operator.id") = True Then...

yep. It's spelt correctly. I'm wondering if the problem might be in the table instead since I just tried this If DLookup("[done]", "[constants_stations]", "[id] = '" & Me.ID & "'") = False Then Me.Command171.Visible = True Else Command171.Visible = False If DLookup("[done]"...