Just wondering if it is possible to populate a database by scanning in a form into a scanner? For instance, if I had a standard paper form with typed data inside of the paper form's fields, to place that form into a scanner and have a program extract the characters in each one of the fields and place them into the appropriate fields in a database. I have heard of some agencies doing this, but don't know the names of software packages that would make this possible. Can anyone suggest some software packages or methods of doing this?
Wondering if anybody has any information about this.
Backgound information: My access database information comes from a 'card' where somebody has manually put crosses in a number of boxes. This information is currently being manually inputted into the database...
I know you can get scanners to pick up information from a document...but is this possible with microsoft access?
I can use barcode scanning to track items through the process, on the condition that the relevant field on a form is highlighted.
The issue is I want the scanning/tracking with wireless scanners to be going on in the background while an operator can use the other functions of the database.
I'm thinking the solution is two computers, one to run the barcode scanning & tracking the other for the rest of the database functions. The problem is we only have one work PC and getting money for a new PC will be like pulling teeth.
Once a year we have a conference that has about 400 people attend. These people will participate in several classes, randomly, over a four day period. Each class hands out an evaluation form. This form has six categories and asks you to rate each from 1 to 5. This is done with a grid on the form labeled with 1 2 3 4 5 across the top and the attendees will put a checkmark or X in the appropriate box. This results in approximately 3000 evaluation sheets.
I will take these and manually enter the scores into a database I created in order to tally the results and generate reports. I have been asked to see if this process can be expedited by using a scanner to pull the scores from the sheets.
Is there any particular reason I would choose to use
DoCmd.RunSQL "insert into...
Versus
CurrentDb.Execute "insert into.... ??
I am using an unbound form on the front end of my database to populate the backend tables (multiple tables). Some forms only have a few fields, while other forms have about 15 fields with 3-4 tables updating.
I am okay using the DoCmn.RunSQL , but I keeping reading on the forum that others chose CurrentDB.Execute and it has me thinking.
My database is stored on a network drive with only on front end.
I have been asked to create a database very quickly for a small group that needs to scan multiple pages into an Access 2007 form. They they would like all scanned documents to be converted to PDF and stored on a shared network folder which can be accessed by their group. I have tried several ideas posted but, I have been unable to get any to work correctly. Any sample of working database that the scanning portion is working? I am so involved with other projects right now that I just don't have the time to create a scanning process on the database.
I’m new here so don’t shoot me if I’m asking something that is inappropriate. I’m looking to make a DB for paper file tracking simular as you would expect in a law firm.
I don’t want to reinvent the wheel so I’m asking if someone has built something like this before. I’m also looking at barcode ID which I have no experience with at all.
Is there someone out there that can put me on the right path?
My Access 2010 application has many reports. On almost every report, the user can select a new paper size. This paper size is remembered, so the next time the user selects the same report, he no longer have to set the paper size (I guess this is the default behavior for Access programs).One report does not behave properly. This report is a LEGAL size report. EVERY times the user selects this report, it prints on LETTER size, so the form is split in two pages. If the user selects teh LEGAL size paper, it works, but the next time the report defaults back to LETTER size paper.
I checked everywhere in the code, nowhere the paper size is set. In development, I selected the report, I changed the paper size to LEGAL, I ran the report. The next time I check the paper size of the report, it is back as LETTER size.After my OpenReport statement, I tried manally setting the paper size with "Reports(xxx).Printer.PaperSize = acPRPSLegal" but my report still defaults to LETTER size paper.
I need to have the last page of a report in access print to an 8.5x11 instead of 11x17 (the rest of the report has to print 11x17). No clue how to set it up so it's automatic...
Hi, I have a two page report (it is formatted to always be exactly two pages) and I need to print it on the front (page one of the report) and on the back (page two of the report) of the same piece of paper. The less user input the better.
Is this an Access thing or a printer thing (We have a HP 6P).
I am using the attachment field in my form in Access 2010. I downloaded a picture (a picture of paper clip) from the web to use it as the display image for the attachment field. When using the form, the paper clip picture is displayed so long as there is no attachment. When a file is attached, the display image changes to the type of file (in my case pdf). However, I want Access to display the paper clip icon.
I have a report that should print on labels ready to be stick on a book, but how can I tell the report to start from 3th row 2nd column so I do not waste any labels?
Hi I am using Access '97 (hope to upgrade at some stage)! Wondered if anyone can recommend any bar code generating software that easily integrates with Access 97?
I need to be able to run my database in the background but i still need to be able to input data from a barcode scanner is this possible. I have worked out how scan bar codes but when the application is minmised it no longer accepts the barcode data.
I am wanting to use a barcode scanner to input data into a field and bring up details based on the barcode. This is simple enough as long as the field you want to scan into has focus. Is there a method which will automatically populate the correct field with the scanned data no matter where I am on the form.
I have a table called Jobslog which contains records for my permanent jobs I have to do for customers in one week.Structure is like:
JobID TeamID DayName JobDescription Instructions
Each job is assigned to a team, but is following same schedule every week.Can I create like a module or query to autopopulate the table with next week jobs, but putting the date as well, not only day name.For example, each Monday job should have a date field which should be 8/12/2014, Tuesday jobs should have 9/12/2014 and so on until Sunday.Usualy they are more jobs for each day (not day and job).
I'm trying to build a database of car dealers while using Access 2010. They only sell three types of cars. Once the user select which car dealer they want to look at, I hoping to populate three radio buttons based on values from the database. From what I've read, it seems that the radio button, while using the option group wizard, that the radio buttons are meant to populate a database field, rather than having the database record populate the radio button.
how to do this, so that I am able to show three radio buttons in my form to show which three types of cars this specific car dealer sells?
My client is a baseball league who started a Kids Club which has membership cards that have a barcode and their own specific number to monitor the number of times that the KidsClub members come to the games. They don’t have any software to go with the cards though. They asked me if I could help. I created a simple table in Access to capture the name, address, telephone, email, number of games attended. The cards have a barcode on them, and they would like to be able to scan the card with a USB handheld scanner and have the number of games attended field to be updated by the scan. Each card has its own number that is programmed into the barcode, which could be the primary key for Access. Can you offer any assistance in how to get the scan of the card to update the "number of games attended" field I created based upon the barcode number?
Hi guys i wrote a vba code that supposed to go find all non system tables in access 2000 db and generate corresponded create table statements for them. Unfortunately when i run the program it misses one of the tables called committee members and also uses one of table names 2 time.Furthermore, instead of using table names it uses first columns of each table in generating table name for createing table statement.I be happy if some expert help me fix this bug in my vba program.Thanks
http://i5.photobucket.com/albums/y180/method007/tablereletionstenissvba1.jpg ( teniss club db reletions )
Code:Private Sub CreateTableButton_Click() Dim T As TableDef Dim db As Database, cont As String Set db = CurrentDb() For Each T In db.TableDefs If Left(T.Name, 4) <> "MSys" Then ' 'If T.Name = Me.ComboBox Then pk = Left(GetPK(T, db), InStr(1, GetPK(T, db), "<-") - 1) cont = cont & ShowFields(T.Name) & vbCrLf & " primary key " & pk & vbCrLf & vbCrLf ''MsgBox ShowFields(T.Name) & vbCrLf & " primary key " & pk & vbCrLf & vbCrLf ''End If End If Next T MsgBox cont Call createTextFile("C:createTableStatements.txt", cont) End Sub
I have a table that contains passive and active devices. I want to find correct active device to which passive device is connected. However passive device can be connected to another passive device and after that to an active device - could be endless times a passive device is connected to passive device and then in the end to an active device. So the code needs to plot the path from beginning passive device to the correct active device.
I will include excel table with data and wanted result.
The criteria for passive devices that need its active device found, is i think something like this:
Code: SELECT * FROM tablename WHERE [TYPE] = "D3P" AND NOT [Mark] LIKE "*ZUUM*" AND [Sort] = "Passive"
I got the result via doing excel function index-match for like 5 times and excel stalling. However I would like it to be done automatically.
