Search results

Ok, I'm stumped! I have this in my timer event If Me.chkdone = True Then Me.Command170.Visible = False Me.Command171.Visible = True Else Me.Command170.Visible = True Me.Command171.Visible = False End If and it hangs on the first line saying it can't find the control. I can rem out these...

Done that too. But forgetting any other program can I actually use the scanner to set the focus to a specific text box?

Oh I can solve the facebook part easy enough. But it would still be nice to have the trigger pull automatically set the focus to the correct field. How would I call out a scanner in access? Something like 'If "scanner" = 1234 then me.text1 = 1234' wouldn't even need to set the focus.

Is there a way to set the focus to a specific text box when using a scanner? For instance, I was told today that a scanner wasn't entering data into a field. No, it won't when you're focused on facebook! Is there a way I can tell access that when the scanner trigger is pulled I want that data...

Don't know if this is even possible, but I had an idea for an assembly line where I work to connect a photoreflective sensor to a pc and use it to trigger a simple yes/no check in access. Has anyone here used a signal from either a usb port or a serial port to set a value in access? Is it even...

Thanks. I think that dynamic report site looks like it will be what I need. I'm actually considering just rebuilding the table. I guess the thought at the time was it would be simple to just add another table when you needed to expand so there are clntbl-rs1 thru 5 and you could just copy the...

Looks like it was set up this way so there could only be one record for each day as the ScDate field is set to no duplicates.

I have five tables with the same structure but different records. I don't know why but I inherited it this way. Each table represents a particular work area. Although now that you ask the question I'm wondering why they didn't just make one table.

I have a report that shows on a form and has this as the recordset SELECT [ClnTbl-RS5].SCdate, [ClnTbl-RS5].[act1-1], [ClnTbl-RS5].[act2-1], [ClnTbl-RS5].[act3-1], [ClnTbl-RS5].[act4-1], [ClnTbl-RS5].[Cletime-1], [ClnTbl-RS5].[Tigtime-1], [ClnTbl-RS5].[Tottime-1], [ClnTbl-RS5].[Operator-1]...

It actually turned out to not be working because the value of ctl1shiftstart was a default value. If I changed it to a lookup the code worked fine. As to the .value not being needed that is a handy little piece of info right there. Thanks!

I have a question about time. This works.... If Me.autotime.Value = #7:00:00 am# Then DoCmd.OpenForm "startup" but this doesn't..... If Me.autotime.Value = Me.Ctl1shiftstart.Value Then DoCmd.OpenForm "startup" even though me.ctl1shiftstart.value is 7:00:00 am. What is the reason for one...

I've just tried using this If Not IsNull(Text51) Then swhere = swhere & " or " & Text51 & "" If Not IsNull(Text53) Then swhere = swhere & " or " & Text53 & "" If Not IsNull(Text54) Then swhere = swhere & " or " & Text54 & "" If Not IsNull(Text55) Then swhere = swhere & " or " & Text55 & "" If...

Nevermind, looks like I can do the filter idea through the grouping options on the report.

Sweet. What about subreports? Can I filter them the same as a subform? I tried this... Me.boomsub.Report.Filter = "[Station] like 'b*'" Me.boomsub.Report.FilterOn = True but no luck.

I thought maybe I could eliminate it from the query altogether on demand but I did figure out how to just hide it on the report. It leaves some blank areas but it works.

No it is used in a report.

Better clarification on what I mean. How would I call this value in vba when opening the query?

another related question it would appear that I can set columns in a query to show/not show in a similar fashion as on a form with something like this If Forms!subfrmCustom_report!Check19.Value = True Then Query!customrptqry!column17.ColumnHidden = True but it doesn't work. How do I know...

Awesome, that did it. Thanks

I have a question about generating a report. In the criteria of the query my report is based on I have this... [forms]![subfrmCustom_report]![serial] which works great to look up the record for that serial number. Now is it possible to modify this so that if I leave that field on the form...