Search results

act1 is a a combination of 2 text boxes with a value set when the form is open so the value is either act1-1 or act1-3. Activity 1 on first shift or third shift depending on when the form is open. act2 = act2-1 or act2-3 etc. etc. Table is set by the macro used to open the form, in this...

Still a damn date type mismatch. Have I actually stumped the experts? You guys are awesome BTW. Every time I come here for help I learn something new. Even if it sometimes is just that you can't do that.

Nope. Still a data type mismatch. I'm out of my depth. lol

I see what you meant about it not evaluating the last control. When I changed it to your example I still get the error but at least when I hover over each control they are showing the correct values so I'm one step closer. Now for the part I don't understand... concatenate the result?

I am trying to make a single form that picks up variables when opened by a macro. Easy enough. Now the problem part. when the form opens I'm trying to use dlookup to set values in some other fields. I have this..... Me.Text1.Value = DLookup(Form!act1, Me.table.Value, "[SCdate] =...

Yep, it was set property. Thanks so much.

Hi guys, I have another (probably) stupid question. I have a form with an unbound text box (text6). I want to open this form from a macro and set the value of text6 depending on which macro opened the form. macro1 text6.value = "rs1" macro 2 text6.value =...

Maybe I'm missing something but that post is about the Access window isn't it? I'm trying to find a way to, on a timer event, minimize an internet Explorer window. So basically instead of creating a new internet window how do I tell it to focus on the one already opened?

So I've learned how to open an internet explorer window using this.... 'Set objIE = CreateObject("InternetExplorer.Application") 'objIE.Visible = 1 'apiShowWindow objIE.hwnd, SW_MAXIMIZE But how would you minimize one that is already opened?

That works. Thanks.

Right... I got that. How do I make it generate and attach the report?

I have a report that I would like to set up to automatically send out at a certain time of day. I have been playing with code I found here and I have this so send an email invisibly... Private Sub Command0_Click() Email_Send_To = "email@email.com" Email_Bcc = "email@email.com"...

I finally just went the easy way (I think) and added a field to the table and the form to designate first/third shift and will sort them that way. Doesn't do much for existing records but going forward they'll be sortable and I'll figure out something else for the old records. lol. Thanks for...

I would rather not have to do this Criteria TimeValue(1/1/1999) >= #07:00# AND TimeValue(1/1/1999) <= #19:00# or TimeValue(1/2/1999) >= #07:00# AND TimeValue(1/2/1999) <= #19:00# or TimeValue(1/3/1999) >= #07:00# AND TimeValue(1/3/1999) <= #19:00# or...

So if I take the example from 2 and do this TimeValue(1/1/1999) >= #07:00# AND TimeValue(10/8/2015) <= #19:00# I would get records created between 7AM on 1/1/1999 and 7pm on 10/8/2015. when what I need is a wildcard day like TimeValue(*/*/*) >= #07:00# AND TimeValue(*/*/*) <=...

The query design grid for the report is where I am working.

The record source is a table with about 900 entries. What I want to do is see just the ones created on first shift in one report and just third shift in another. So I need to see records created between 7am and 7pm no matter what day they were created. If that makes sense.

I assume I need to change (MyDate) to something else but what do I change it to for all dates?

I need some help with a date/time query on a report record source. I want to return all record from any day that where created between two times. If I use >#7:00:00 am# and < #7:00:00 pm# in the criteria field of the reports record source I get no records at all. I'm pretty sure...

That's what I have right now. I just thought it might be easier when I do updates to only have to do them in one place rather than maybe several different places. Just thought that way might be easier on me if it was possible.