Forms :: Barcode Scanner To Launch Another Form

Mar 7, 2014

Still working on an meeting registration app in Access. I have a Main menu which contains buttons that allow search by Name, Phone Number, or Account Number. We are using barcode scanners if they have a registration card.

Currently I have an account button which pops up a query prompt window and when they scan the code it fills the prompt with their account number and a carriage return, pulling up an account registration form with their info.

What I would like to do is from the main form, if a barcode is scanned, to automatically lauch the account form passing the scanned account number.

View Replies


ADVERTISEMENT

Forms :: Barcode Scanner Stopped Updating Form

Nov 17, 2014

I am using Access 2003 and there is a from with barcode scanner to update the shipping data. This form has a sub-form which is working perfectly fine and updating data but the barcode scanner assigned with main form stopped working today. I tried different scanner too and different system too but its not working.

View 5 Replies View Related

Forms :: Text Box With Barcode Scanner

Apr 11, 2013

This question is related to a restaurant POS system design. Is there a way to allow a text field in a form to be filled by a scanner only, unless an event is triggered? Rather than using a magnetic strip ones for gift cards, we're thinking of using the bar code version. However, to prevent employees from fraudulently entering the six digit code, the code must be inputted by a scanner. We do also would like to allow user input with keyboard in case scanner malfunctioning, but would require a "manager" login first.

View 3 Replies View Related

Using A Barcode Scanner

Sep 5, 2006

Yep, I'm a newb.

I have a Symbol long range barcode scanner. Works great. I need to drop this in access and have it update as input (without hitting enter every time). I am reading barcodes with serial numbers and part numbers.

Anybody got anything to help?? Pweeease?

Thanks in advance!




RevJohnny

View 5 Replies View Related

Barcode Scanner Drivers

Nov 25, 2005

Help!!
Does anyone know where I can obtain a driver for a barcode scanner that has model details:

Metrolgic MS951 KB Wedge

If anyone knows a specific website that has the drive it would be much appriciated if you could post it here.

Many thanks

Regards
Jason_Hyde

View 1 Replies View Related

Barcode Scanner Input Question

Jun 17, 2006

OK... Did some searching and posted one question on forms... But still have one important question that has not been answered. First let me say I want to use a scanner connected via USB. ( I need to be able to use this app on a laptop, so keyboard wedge is not possible) Found a quote on a site "TalTech"... Something like that...... This one..
"1) Keyboard Wedge output or USB output

If your bar code scanner has Keyboard Wedge output or USB output you will not need special data collection software. Both these outputs will dump the data right into the foreground application on your PC wherever the cursor is flashing, as if it were being typed in. You do not usually get much control except for the addition of a trailing keystroke, such as an ENTER key, to your data. But these methods are very simple and work fine for many people."

Question is...... Is this true??? Will the USB input directly to the field I want it to?? I just need someone with some experience in this to let me know for sure.

Thanks
Curtis

View 8 Replies View Related

Search For Barcode With Scanner As Input

Oct 26, 2004

I have created a form that I would like to search for a barcode by using a scanner as an input device. Does anyone know how to go about doing this?
The form basically holds a subform of textboxes that have barcodes. I want the user to be able to scan a barcode which will then find that barcode in the subform and assign it with a DateOut = Date() ...

View 2 Replies View Related

Need Quick Answer To Barcode Scanner Question...

Jun 15, 2006

Didn't know where to post this one...... But forms seemed logical..... I am doing some experimenting with using a barcodes. I can create them now, no problem. My next step is using a scanner to input to a textbox...... Problem isn't with the forms..... But more with the scanners. I thought if someone has done one of these DB's they might know.
So........ I need a cheap scanner to test with.... Found a few on Ebay. The cheapest being a Symbol- "Hotshot" LS2100-I000.Says it has "DB9" plug. The ebay ad says "comes with NO software". Only thing I am wondering about are drivers. I've read in a couple places claims that this scanner "Needs NO drivers"
So my question is.... Would this scanner work with Access on a Windows XP system? No drivers needed?
Hope this question isn't too "off the subject" But I am dealing with Access and hoping someone has done this.
Thanks
Curtis

View 3 Replies View Related

General :: Text Box Event Coding - Jump To Next Field After Using Barcode Scanner

May 20, 2015

I am creating a inventory database for work. I am trying to get the cursor to jump to the next text box for data entry using a barcode scanner. I have a limit on how many characters there can be in this field but yet even after it is all filled the cursor stays in that same field. I am fairly new to access, especially in code building. Do I use "After Update" under "Event" in the "Property Sheet"?

Capture.PNG
Capture1.PNG
Capture2.PNG
Capture3.PNG

View 4 Replies View Related

Forms :: Put Barcode In Field When Reader Scans Barcode / It Records Current Time

Nov 11, 2013

I want to be able to put a barcode in a field that when a reader scans the barcode it records the current time. Need it for access control to record who is in and out of the office. Reading other threads I understand it may be possible in Dlookup.

View 3 Replies View Related

Forms :: Using A Scanner To Populate A Form

Oct 22, 2013

I have a table which contains 2 fields. UserID and FullName..Each employee is assigned a barcode (UserID) and what I would like is when they scan their barcode into the form their name comes up. There is a second table containing records of documents and I am hoping that this form will allow an employee to scan their ID, their name comes up, scan a document and the title of the document comes up, there would be a current date box and then that whole transaction is saved as a record in another table. Long story short I want to know who is accessing what records and to have it logged.

View 5 Replies View Related

Forms :: Form To Select Name And Launch New Form

Feb 25, 2014

I am working on an access database that is a meeting registration database.You can search by Name, Phone, or Account Number and then mark the person as registered.

What I am trying to create is an enhanced search by name. I have created a simple form in datasheet format so that if I search by last name I will probably get a list of names with that last name.I want to be able to select the name I want, either by double click or highlite and press a button, and then it launches my form that I created for the account lookup / registration.The account form runs a query that prompts for an account number and displays that account.

how to launch the second form passing the selected record's account number.

View 7 Replies View Related

Reports :: Barcode Font - Generate Number As Barcode On Report Records

Jun 8, 2013

I am using a barcode font in order to generate a number as a barcode on my report records. In order for my barcode scanner to read the barcode it needs an asterisk at the beginning and at the end.

So, if my record ID is 62 - in order for the barcode to be displayed correctly, it needs to be on the report as *62* .

Without digressing into a discussion on barcode methods in Access, how can I precede and succeed each ID number field with an asterisks?

View 4 Replies View Related

Opening A Form Just One Time On First Launch

Dec 29, 2007

Hi all! I am looking for some help in how to get a form to open just once on the first launch of the database. This information is the company information of the one using the software. I have a button that one can click if they want to edit or add this information later. Thanks for your help in advance.

:confused:

View 2 Replies View Related

Combo Box On Form To Launch All Available Reports

Jun 29, 2006

My goal is to have one form which will be used to launch any of my reports. I'd like to be able to group my reports (Customer Service, Accounting, etc.).

There used to be a great sample of this on the forum but I can't locate it...perhaps we lost it in the hack.

So my question is what is the best way to create a form that will allow the user to select from a list of all available reports?

Thanks everyone.

View 2 Replies View Related

Forms :: Reference Table Being Updated When Launch Edit Routine

May 18, 2015

Currently running Access 2010.

I have a small database where we enter audit log data. In my add add screen from the switchboard, one of the fields is the user the audit is assigned to. So that our group wouldn't be typing their names a bunch of different ways I created a reference table called "Ref Data 005 - Contact Name". So i pre-populate the Contact Names such that they will be more consistent.

The add works perfectly. I built all my screens using the forms wizards.

Now for the modify routine. If the user wants to go in an modify one of the other data elements, I force them in the wizard to do this modify by choosing thier name. Therefore, when i built this screen using the wizard I reference the "ref table" mentioned above. I then throw open another form displaying all of the fields based on the records that it finds for that user when they choose the name from the Ref data 005 table. Hope that makes sense. Ie.. they choose the records they want to possibly modify by first choosing their name from the ref table.

It correctly pulls the records for whatever user you choose. However, when you make the update and save, it is changing the Ref table name as well.

So for example if three users were in my ref as :
bill
joe
john

And you launch the form, lets say joe shows up in the list, when i change it to bill to retrieve bill's records , it will do that but when i make the change, then Joe is changed to bill in the reference table.

View 4 Replies View Related

Reports :: Button To Launch A Form From A Report

Mar 1, 2015

I have a fairly simple report which lists rows from one table with a little bit of logic. At the end of each row, I want an action button, which when you click it, goes to a form with the correct ItemID for that row.I tried the VBA code like this on the View button on click method:

DoCmd.OpenForm "CreateCAF", , , "[ItemID] = " & Me.ItemID

Of course, what happens is it opens the form CreateCAF with the first ItemID in the report, regardless of which row you click on. I want it to pick up the ItemId of that row.

View 13 Replies View Related

One User Of Split Database Front-end Can't Launch A Form

Jun 25, 2014

I have a 2007 back-end db on a network share and around 15 regular users who access it through their own front-end db/interface. One user on Windows 7 is able to launch and use his front-end copy fine except when he goes to launch one form for data entry.

This form clocks and freezes the entire application. I sat with him and was able to determine that the issue is that the form_load code is never running. He clicks on the button to launch the form (done in vba) and the code never runs. If he opens the form in design view first then changes to form view, the code runs fine and there are no issues. This is his present work-around, but I had to give him an unlocked FE copy to pull it off (not ideal!).

I tried this with him on different PCs, with different front-end copies, and even in the back-end copy. Same result each time. None of the other users have this issue, and he can replicate this issue on different PCs. I'm at a loss for what might be causing this since it really seems so user-specific.

View 6 Replies View Related

Forms :: Barcode Scanning Into Combo Box - MS Access 2003

Jul 31, 2013

I designed an inventory control software and we are managing our stock through barcode scanning, it is working well although i have a problem to solve that i have put a combo box for scanning code 39 barcode, upon scan the barcode a code is entered into combo box and then we need to press the "ENTER" key to go for new record, we would like to ms access form to automatically go to new record when a code input from scanner.

View 3 Replies View Related

Date / Time Stamp On Barcode Input Form

Apr 29, 2014

I have a barcode input form. When a barcode is scanned, the value of the barcode, along with a date/time stamp using the now() function (hh:mm:ss) is entered into a table in the database as 2 separate columns. I need to make sure that I don't have any 2 barcodes with exactly the same date/time. They must be at least 1 second apart. How can I easily make this happen? I can't control how many times the barcode actually gets scanned.

View 3 Replies View Related

Forms :: Scan Barcode To Choose Item From Combo Box - Populate Textbox With Result

Jun 14, 2013

I'm working on a project that uses a barcode scanner. The user will scan a barcode which will choose an item from a combo box. The result of what it enters will populate a text box. I have that part working fine.

The next step is to get it to open a form based on the value in the textbox. The textbox will have about 7 different possible values and each one should open a different form.

The way this is supposed to work:

User approaches a machine and scans the barcode. He is presented with a form giving him options based on the type of equipment the machine is. A compressor for example would present him with a set of options for compressors (gauge readings, maintanence, etc).

I have an unbound form with two controls:

cboAssetNumber
txtType

How to code this and which events to code it in. Users will be going from machine to machine and using the form over and over again so I need to somehow manage the clearing of the form to begin again with another barcode scan.

I saw another thread about a barcode scanner and one response was to program the scanner to send the barcode and then send an "Enter" press to move focus to the next control. I've looked through the documentation and haven't been able to find if that is possible. Right now it sends the number and that's it. It's a "Motion" Tablet.

View 14 Replies View Related

Bar Code Scanner

May 16, 2005

I'm in the US military. I would like to use the bar code on the back of the military IDs to populate an access database. Can you point me in the right direction as to how to get started?

Thanks in advance

View 3 Replies View Related

Business Card Scanner

Nov 17, 2006

I want to use a business card scanner, and use the data for my Access 2000 order database. Most card scanners, can send data to Outlook, can you go from Outlook to Access? Any advise would be appreciate it . . . THANKS!:o

View 2 Replies View Related

General :: Integrating Scanner Into Inventory DB?

Aug 7, 2015

I have scanner (Unitech MS335-1G) and my end goal is to scan a product number bar code on a box into a field on a form. Then from what is scanned into the box run a query on another table that has all the info on the product. Then populate other fields on the form.

View 2 Replies View Related

Launch Email

May 22, 2007

Can I open an email to send filling in the To or the BCC field but maintain my outlook signature page???

Currently I open email, but my signiture is missing???

Thanks

View 3 Replies View Related

Launch Application

Apr 6, 2005

I have a command button on a form, and on its onClick event i have placed the following statement in order to open a specific word document:

Call Shell("C:Program FilesMicrosoft OfficeOffice 10Winword.exe C:TempTest.doc", vbMaximizedFocus)

This works fine, however I noticed that if the path for the specific document contains a space, it does not open up successfully but i get a msgbox saying "the document name or path are not valid"

Any suggestions please ?

Thank You

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved