Search results

the operators tables look like this scdate, date/time day, calculated act1,short text (q if scheduled s if completed) act2,short text (q if scheduled s if completed) act3,short text (q if scheduled s if completed) act4,short text (q if scheduled s if completed) act5,short text (q if...

That is my constants table.

I believe we are miscommunicating. Here is the structure of my table. ID, autonumber Station name, Short text act1,short text (M/D/2-6) act2,short text (M/D/2-6) act3,short text (M/D/2-6) act4,short text (M/D/2-6) act5,short text (M/D/2-6) act6,short text (M/D/2-6) act7,short text...

So I only create 4 records and 10 fields rather than 10 records of 4 fields. Won't that make it more difficult to add operators later? Right now I can just create a record and input the data without having to modify the table. For some reason it just seems backwards. Well, let me read that...

Ok, I have a table called constants. In this table are 10 records, operator-1 thru operator-10. Each of these have 30 fields called act1 thru act30. Act1 thru act30 contain either a D for something the operator should do daily, an M for something the operator should do monthly or a 2 thru...

The problem isn't one of visibility but more awareness. When the operator moved the form from the center he no longer noticed that the msgbox was opening there. I changed from a msgbox to a form with an onopen event of DoCmd.MoveSize Forms!frmoperator.WindowLeft + 5000...

so now the question is how can I do this from a button on form1 docmd.openform "form2" with this argument docmd.movesize, form.windowleft, form.windowtop so that on the click of a button it opens form2 in the same position as form1?

just tried out something. form.windowleft gives me the left side so I should be able to set the msgbox to always open in position relative to the form. I think.

Today was a perfect example. The form is about 4 inches wide and it is centered on the screen. The operator moved it to the right side and opened facebook so they didn't see the msgbox pop up and told me it wouldn't let them enter any information. "it just locked up" lol

I have posted a couple questions her in the last week and have gotten tremendous help from the community. I have learned a number of tricks that I either didn't know or didn't think of. With that in mind I'd like to post several more little things. First, is there an easy way to keep forms...

Yep, that did it. Thanks a lot.

also for the case.. for x = 1 to 35 Select Case Me("code" &x).Caption Case "s" Me.safety = Me.safety + Me("time" & x).Caption Case "i" Me.inspect = Me.inspect + Me("time" & x)Caption Case "t" Me.tighten = Me.tighten + Me("time" &...

A bit cleaner for sure. How about this one... For x = 1 To 35 If Me("label" & x).Value < Me.run.Caption Then Me("label" & x).BackColor = 3329330 Next it works except it seems to pick up the first number. If run is 6 the 1 thru 5 are green but so are 10 thru 35. Should I just double the x...

I can! That is awesome. I've been doing a lot of things with code justr because I was more comfortable with it. This is definitely a lot easier.

Could I do something similar with this block.... If Me.Text1.Value = "u" Then If Me.code1.Caption = "s" Then Me.safety.Value = Me.safety.Value + Me.time1.Caption If Me.code1.Caption = "i" Then Me.inspect.Value = Me.inspect.Value + Me.time1.Caption If Me.code1.Caption = "t" Then Me.tighten.Value...

Cool. that would be much simpler. Haven't learned loops yet. Guess that's what I'm learning today.

a question about color coding a form. I have used this before If Me.Text27.Value = "t" Then Me.Text27.ForeColor = 858083 If Me.Text27.Value = "p" Then Me.Text27.ForeColor = 55295 If Me.Text27.Value = "u" Then Me.Text27.ForeColor = 15643136 now the question.. is it possible to set a value for...

I like the table idea. Here's a funny thing though. One of my reasons for going with dlookup was to keep forms to a minimum. I've used subforms before but it actually NEVER occurred to me to use the same subform and just change it's recordsource on the main form. I've had seven subforms all...

BTW I figured out the answer to the original question. It's this Me.text1.value= DLookup("[" & act1 & "]", "[" & table & "]", "[scdate] = form![date24]")

Ok. Here's what I have in those tables. Each activity is in a field act1-1, act1-3, act2-1, act2-3, etc. each record is a day. 1/1/2016, 1/2/2016/, 1/3/2016, etc. the form has 7 columns with 10 rows each. There is a value in each box, p, on the day the activity should be done. so the operator...