General :: Finger Print Reader And Access
Dec 24, 2014
I have just finished putting together an access database as a payroll. It is working fine and it will now save the company a lot of man hours in calculations.
When the employee clocks in or out there is a form and the employee has to key in a unique employee number and a password, which of necessity is hidden from view. Of course the password can be divulged from one employee to another.
Consequently, eventually I will need to incorporate a finger print reader and use the information from this instead of the password.
View Replies
ADVERTISEMENT
Mar 18, 2015
Since converting to Access 2010, when I use the "PDF or XPS" button to create a PDF from a report, after the save dialog it opens the PDF in Adobe reader, and then after I close it there is another dialog with the option to save the export steps. Is there any way to just be able to save the PDF and go back to where I was without having to do the extra clicks to get back?
Back in Access 2000 I had created a custom button on a toolbar that would automatically make a PDF from the open report, but that didn't transfer over when I converted the database to 2010.
View 10 Replies
View Related
Dec 9, 2005
Hi,
One of users of supermarket is running my db successfully since long. But due to the change of time & his progress in business, he expanded his supermarket and it is becoming difficult to use the keyboard to enter the digits for the price.
Hence he asked me to make db able to read barcode on the items so the transaction would take very little time.
To be frank, I do not have any experience about barcode reader how to implement it with Access db.
What kind of barcode readers are available that would EASILY set with Access db? R They really work with Access db? What steps I need to carry out to implement it?
Please advice if anyone of you has any idea in this regard.
With kind regards,
Ashfaque
View 2 Replies
View Related
Mar 7, 2008
hi
I m new, and i want to make a meter reader in Access for daily use. i want to be enter only last reading every day at data entry form and that last reading must appear as first reading of the next day automaticaly in same table, because i have only one table in my database. fields are "date", "1streading", "2ndreading" & one data entry form and one report. is it possible in access, if so please help me. thanks
View 7 Replies
View Related
Dec 17, 2013
I have created an application. It has a split front end and back end. I plan to distribute the runtime version. I have used code throughout that "hides" the microsoft access shell for popup (modal) windows. In every form & report I have a function to show or hide the access window. Everything works great until I get to my reports. I open reports in print preview. I created a custom table (USysRibbons) and added a Reports print preview ribbon & xml. I assigned that ribbon to my report(s), and I assigned it in options as the default ribbon. If I test the ribbon (by working in the database using "shift" open) I see my ribbon. But, in when I open app without shift or or if I emulate runtime, I can't get the ribbon.
I have multiple popups forms, several non popup forms and a couple of reports.I just want to keep all the access background stuff hidden - except for needing the ability to print.
View 1 Replies
View Related
May 10, 2006
Hi all,
I am trying to use a barcode reader with an Access database. The raw data is a linked table to a Crystal Report Excel dump that is updated daily. My problem, the raw data “Asset Tag” field is numbers only. The barcode has the needed numbers but is preceded by “PC”.
Example:
Raw data Asset Tag “12064621”
Barcode Asset Tag ”PC12064621”
Is there a way to remove the “PC” from the scanned “lookup” field?
Objective:
Scan the barcode tag into the form, bringing up all related information on that Asset.
View 3 Replies
View Related
Apr 7, 2008
Looking at creating a database that looks up records based on a number from a magnetic card. Has anyone ever come across any code that will pull the info from the serial port? I have been looking for 2 days and not able to find anything. I have the card reader but do not have any software to get the info from the serial port and my limted coding does not even come close to what I need. Any help or a push in the right direction would be greatly appreciated.
Thanks,
Matthew
View 4 Replies
View Related
Aug 23, 2013
How can I show by query all the books that has not been borrowed by a chosen reader?
My query setup is:
Table 1 readers( name etc.)
Table 2 books (name etc)
Table 3 Table of borrowing dates linked by 1 to many link to tables 1 and 2
View 11 Replies
View Related
Jul 31, 2013
My desired output of this is to have a database to allow me to quickly check in and out equipment and personnel using a barcode scanner. I am using access 2013 and started with the asset tracking template downloaded from Microsoft. Where I am hung up right now is adding the personnel check in and out (each member of the team will have a barcode attached to their id) I want to be able to just scan their badge when they show up and again when they leave. At the end I will run a report that shows who was on scene (it is for a search and rescue team) during a certain day or time range.
I have added two new tables one check in and one check out the only fields are firedeptID and CheckIn or CheckOut a date/time field CheckIn and CheckOut Auto populatewith Now(). The first problem is that I think I need to turn off (if possible)the auto creation of a new record every time, when I scan in an ID right now that record gets the time stamp of the last time the new record was created IE.Last week when the last person scanned in and the new record was created. I assume I am going the same type of issue when I start working on checking out the equipment.
View 8 Replies
View Related
Jan 29, 2015
I am trying to design a form or report where I can print the records marked with Y/N, but not sure how to do it?
View 5 Replies
View Related
Sep 6, 2012
What i need to be able to do is write vba to find the value inside the comboxbox and then either:-
1. Run a macro with the same value that is in the combobox
Or
2. Run a set of reports and print them off but are linked to the combobox value.
The combobox name is ODTyper
The combobox control source is ODType which is a field in TblType
The combobox row source is SELECT [TblType].Model FROM TblType;
The value inside the combobox are in the format of TE4700
The name of the macros are in the format of TE4700
The Main form is called FrmOrderDatabase.
Plus somehow i need to get the value of the combobox and link it to print off the correct reports.
View 9 Replies
View Related
Oct 18, 2012
I've composed a table in Access 2010 that I want to use as an annex to a printed document. However, each time I try to print out a hard copy it includes the table title and the date of printing. How do I stop this?
View 2 Replies
View Related
Aug 22, 2013
Is there a way to get information in the print dialog box (File -> Print)? Like when i click ok or cancel? Or any other way that i will be able to know that the report is sent to printer or being printed.
View 2 Replies
View Related
Aug 17, 2012
While I have worked with computer all my life I am new to Access. I managed to create my database and the report I wanted to generate. However; I cannot get the Report Header to print on all pages. It only prints on the first page.
View 9 Replies
View Related
Feb 16, 2013
When I have the Home and Create default ribbons showing... then when I choose to Preview a report the Print Preview Ribbon is displayed and the Home and Create Ribbons are hidden or not visible.I have created a CustomRibbon and this CustomRibbon is not hidden when I choose to preview a report. The Print Preview ribbon is shown but the CustomRibbon keeps the focus and is not hidden.I would like for the CustomRibbon to not be visible.
View 2 Replies
View Related
Aug 19, 2014
Can you force print preview to open in zoom 100% mode with VBA?
View 3 Replies
View Related
May 8, 2013
I am using access 2010 and have made a simple database for the company I work for. This consists of the a table of the raw data and a form to make the data printable.
I have been asked by our admin person if I can make it possible to be able to print labels from it. I know it is possible via the wizard but very limited.
What we really need is to be able to select the people from the table that we want labels for.
I have added a true/false check box to the table called 'label?'
View 7 Replies
View Related
Sep 5, 2012
I wish to produce a delivery note which needs to print an empty box for manually ticking.
I need a box for each item quantity i.e 5 items on the job print 5 boxes. 20 items print 20 boxes.
I have been able to use very crude code if there is only a few items, using if qty =1 then / 1/ else if qty = 2 then / 1/ / 2 / etc etc ...
That works and prints the / 1 / 2 / which is ok but there must be a simpler way as it the job has more that it would be much better and far more useful for other reports to print a box or item.
View 7 Replies
View Related
Jul 9, 2013
How do I print the complete code of a project? If I select all the code with CTRL+A in the code window does it print all the objects of the project I'm in or I have to select each object from the drop down list at the top of the code window?
View 6 Replies
View Related
Sep 9, 2014
In attached Preview.png I can see the Dates. When I print the report (Print.png) the dates are substituted with "#Name?"
In the report the date fields are bound to
Control Source =CDate([Forms]![frmTransactionPopup]![dtmFrom])
where frmTransactionPopup is a form which is open but not visible.
View 9 Replies
View Related
Jul 3, 2014
I have report that i have in preview. In that report i have ribbon that has buttons close and print. Close works fine, with print it goes ok but when "printer selection" comes, i try to change printer it informs that not enough memory. All this code that is in ribbon buttons is in VBA.
What could be the reason for memory stuff or how could this be made that this inform wouldn't come.
Code below:
Sub EnnakkoMyButtonCallbackOnAction(control As IRibbonControl)
Select Case control.ID
Case "MyBtn1"
DoCmd.OpenReport "Tuotanto Ennakko", acViewPreview
[Code] ....
View 5 Replies
View Related
Aug 7, 2014
I'm trying to print a barcode to be used for data input into another system.
The data contains alpha number and some special characters like space, underscore, / and &
I want the form to print the bar code
128 and 3of9 don't handle this data.
View 5 Replies
View Related
Jul 2, 2012
I applied conditional formatting to a subform in a form and it works fine. The screen dispaly is showing the highlights but the print privew does not. It does not matter which printer I select.
View 2 Replies
View Related
Jan 30, 2013
Using Access 2010.I purposely disabled the Access Objects when opening my database for added security. This works.
The problem I'm having is when I use the print button (access macro) on one of my forms, as soon as i click the button, the "all access objects" window opens on the left side navigation. This window shows all of my tables, forms, queires..etc.Is there a setting that will permanately stop this from opening?
View 1 Replies
View Related
Jul 11, 2015
Im using a button to print a report based on a text box values on the form.the code for which is below
Code:
Private Sub SaveBtn_Click()
DoCmd.SetWarnings False
DoCmd.RunSQL "Update BookInTable SET DateBookedOut = '" & Me!DateTxt & "' WHERE BarCode ='" & Me![BarTxt] & "'"
DoCmd.RunSQL "Update BookInTable SET BookedOut = True WHERE BarCode ='" & Me![BarTxt] & "'"
DoCmd.OpenReport "Labels", acViewNormal
DoCmd.PrintOut , , , , 1
DoCmd.Close acReport, "Labels", acSaveNo
DoCmd.SetWarnings True
End Sub
The problem that I am getting is not only is the label printing but so is the form.
View 3 Replies
View Related
Sep 11, 2013
I have a button on a FORM to print the current record with the following code:
DoCmd.RunCommand acCmdSelectRecord
DoCmd.PrintOut acSelection
But what I need is that before printing, open the preview to set the margins and page size ... or at least to pre-configure so that when you press the button, and comes preformatted.
View 2 Replies
View Related