Transferring Excel Sheet To Access

[Dal Jeanis]

athyeh - can you tell us what the wand/scanner actually does? Does it act completely as if the lines scanned are typed in, or what? And, is there one or more physical buttons on the wand that can send messages to the computer? If so, how are those buttons "perceived" by Access?

The data entry process should be able to use the wand as a powerful and effective interface tool, if we can identify how the wand actually interacts with the computer. For instance, if buttons on the wand send the equivalent of hitting (tab) or (enter), then you can make entry pretty easy. If they are programmable so that the buttons can send any arbitrary keystrokes, then you can make it very easy.

[athyeh]

June07 and DalJeanis, thank you both very much for your replies. Both of your posts have been critical to bringing me to this point.

Right now:

I have frmFORM with 4 fields: LID, Op, Time, Process

I am using an AfterUpdate with following code to: "freeze" desired fields, create new records, after a user uses the wand to scan into LID

Const cQuote = """"
Me!Op.DefaultValue = cQuote & Me!Operator.Value & cQuote
Me!Time.DefaultValue = cQuote & Me![Time of Production].Value & cQuote
Me!Process.DefaultValue = cQuote & Me![Process Type].Value & cQuote
RunCommand acCmdSaveRecord
Me.Requery

My question is now: How do I get a a "ticker" or "count box" on the form that records how many LID's people are scanning in for each "Time"?

Is it a query attached to a textbox, that queries the time in "Time"?

[Dal Jeanis]

Instead, I'd set a temp variable to zero when the user selects any of the relevant values on the main form, then I'd add 1 to the temp variable at the beginning of each time your above code runs. Whether or not you display the value is up to you.

I posted the syntax and examples of using tempvars on this thread https://www.accessforums.net/code-re...ars-36353.html

[athyeh]

Instead, I'd set a temp variable to zero when the user selects any of the relevant values on the main form, then I'd add 1 to the temp variable at the beginning of each time your above code runs. Whether or not you display the value is up to you.

I posted the syntax and examples of using tempvars on this thread https://www.accessforums.net/code-re...ars-36353.html

Hi Dal Jeanis,

Really appreciate your reply, but your linked post is way over my head. Can we walkthrough it/break it down? Right now I'm looking at Greek.

[Dal Jeanis]

Might be easier for you to just add another text box on the form. For instance, you could call it txtcounter. You can set its Visible property to No if the user doesn't need to know how many he's scanned.

In the After Update event of LID, Op, Time, Process, you have a line that says

txtCounter = 0

It wouldn't hurt to do that in all of those fields, but probably Time and Process are the only two that are necessary. Depends on how you expect the screen to be used.

Then, in the code that kicks off when each one is scanned, you put code like this:

txtCounter = txtCounter + 1

That's it.

[athyeh]

Code to carry forward the selected values to new record: http://access.mvps.org/access/forms/frm0012.htm

Probably code in the 'scanned' textbox AfterUpdate event can move to new record: DoCmd.GoToRecord , ,acNewRec

What about carrying forward a "Yes/No" value?

Const cQuote = """"
Me!Operator.DefaultValue = cQuote & Me!Operator.Value & cQuote
Me!Process.DefaultValue = cQuote & Me!Process.Value & cQuote
RunCommand acCmdSaveRecord
subLastRecord.Requery
Me.Requery

Does not Carry forward Yes/No Checkbox value..

[June7]

Y/N field is not text type. Don't use the cQuote variable. Worked in my test.

Don't need to specify Value property. Value is the default property of data controls.

[athyeh]

Thank you.