We're trying to print a barcode (characterset "3 of 9 barcode"). If we print the data starting from an Excel-document on a Dymo-printer there is no problem to "read" the barcode with a scanner. However, if we print the same data starting from an Access-database, the barcode cannot be scanned. Does anybody have a clue how to solve this ?
View RepliesI am using a networked database built by somebody else. I have added a networked DYMO labeller which runs via a simple report in Access 2003.
The probelm I am having is that the default label type I specified in the report (30321) keeps changing, it will change intermitantly and to any available Dymo label listed in the paper size. Nobody else has access to the reports to change it.
One day I come in and the label has changed to a Video Top (30326) label the next day it is a File Folder (30330) label.....the Dymo is having no probelm in any other applications and it doesnt seem to be a probelm in any of the databases I have built which are also networked.
Any ideas would be appreciated....getting sick of wasting labels and resetting the default all the time.:mad: :mad: :mad: :mad: :mad: :mad: :confused:
Hi
I have just been having a look at some of the past threads and I am hoping that what i want to do is possible however I am just wanting to check that it is possible and how hard it is?
I already have a database which controlls all of our stock however the quantaties have to be manually updated so I would like to give each item a barcode and use a handheld scanner so that the users can just scan what they have taken and then at the end of the day upload it to the database and all the quantaties will change.
My questions are is this possible and how hard would it be for a beginer?
Thank you
I want to add a bar code feature to my database for the following reason,
I want to use it as a search facility when looking up a member, each member will have a unique ID which I would assume would be turned into a barcode font.
When I scan the members ID card I would like the details for this person to be displayed.
Are there any idiot guides or useful reference points for me to get started with this, I have never used this method before so therefore know nothing about where to get started.
Have located a hand held scanner to use, it is a datalogic Dragon Scanner
Any help would be great
Cheers
Andy
Hey everyone,
I am trying to make a custom Access database, and I would like to have the ability to integrate barcodes into the database.
Basically, what I want to do is have the database open and when I scan a particular barcode, it will bring up a record associated with that barcode in a Form. I am wanting it to bring up the record pertaining to that specific barcode to allow for quicker retrieval of records ... Is that possible? Anyone know of how to do that?
Thanks!
Jason
I want to add a bar code feature to my database for the following reason,
I want to use it as a search facility when looking up a member, each member will have a unique ID which I would assume would be turned into a barcode font.
When I scan the members ID card I would like the details for this person to be displayed.
Are there any idiot guides or useful reference points for me to get started with this, I have never used this method before so therefore know nothing about where to get started.
Have located a hand held scanner to use, it is a datalogic Dragon Scanner
Any help would be great
Cheers
Andy
I am newbie to barcode but I need to generate barcode for my invoice with the invoice something likes W12675679. Just want to know how to generate barcodes based on that type of invoice number, and how to store barcodes in ACCESS 2003!
View 14 Replies View RelatedI'm looking to create a database in order to scan a barcode on a packing slip to be automatically entered into database and update an inventory file.
View 4 Replies View RelatedI have an inventory access program that a sales outlet uses.
Since the barcodes of the same group of items are always changing, I want to figure out how I can scan all related items into one textfield, where at selling point, any item code can serve for that group without recording each one differently.
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.
Is there a one PC solution?
Hi,
we ran into quite a serious problem the other day whilst batch printing a large number of reports from Access 2000.
For some unknown reason the print job got interrupted part way through, resulting in a large number of reports not printing at all.
Our database uses an sql fragment to set the field 'isPrinted' to true upon sending reports to the printer. This is primarily to prevent records being printed more than once.
However, if, as above, the print job doesn't successfully complete the db still, as expected, marks the record as such. This provides us with a somewhat flase account of the status of the print job.
My question is this, is there a way in vb that Access can verify the success/failure of a print job?? Are there modules or code examples available that might help us interrogate the printer and perhaps abort on error?
* Standard Disclaimer:
VB Noob! Gentle brow-slapping only please!
I wish to send a report to the PDF printer driver but DO NOT wish to switch the default printer settings. Having found some helpful code on this forum that changes the default printer to the PDF driver, prints the job and then reverts the default printer back to the original printer device.
I am still using Access '97 and although in the code, the default printer does revert back to what it was originally, the Default Printer status 'tick' no longer appears under Start/Settings/Printers.... Consequently, subsequent print jobs outside of Access go to another device and not my DEFAULT printer.......???
Any ideas would be gratefully appreciated.
Oh - in case I wasnt clear - I want to do this in code NOT using the Print dialog box.... !
Hi All,
I know I am not alone on this one, as I have seen this problem posted elsewhere before.
We have installed Access 2003 on 2 workstations in a Windows Server 2003 domain, and on both these workstations, when you mouse over the print icon in the toolbar, it reports "No Printer" and indeed, we cannot print to the network printer from Access 2003, even though a printer is installed and working.
All other Office applications print to the printer OK, its just Access that doesn't seem to find the printer.
Has anyone come across a fix for this problem?
Cheers,
Alan
Hello, i develope with ACCESS2003, i used the printer object : dim xxxx as printer, it works fine but when i install my program on my client PC which doesn't have ACCESS2003 but only ACCESS RUNTIME2003 i have an error (error c++ ... run-time terminates abnormaly), this PC have ACCESS2000 and when i run my base through ACCESS2000 to debug it i have an error (undefined object) on the dim instruction. I was thinking all aplication developed with A2003 was running with run-time2003, apparently no, is something missing ?
Thanks in advance for any help.
VINCENT
Hi,
I used the code below to hide all the toolbars and then created my custom ReportToolbar so the user can print the report. All works OK; however, the PRINT button on my custom toolbar sends the report imidiately to the printer. How can I create a button that I could add to my custom toolbox which would open the dialog box that allows to choose the printer, number of pages to print, etc.. (same action as I can get by going to File->Print)?
PS> Also, is there any way to remove the drop down arrow from my custom toolbox? I disabled Customize Toolbox but the pulldown arrow still appears. I found making an MDE would take care of this, but was wondering if there was another solution.
Code used to hide toolbars:For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i
Good morning,
I've created a pretty powerful Access Database that pulls information out of some ODBC tables we have on our local server. Of course, I created the database and all the forms and reports on my work computer here. But, when I was finished, I sent that entire database out to probably 20 or 30 people in the company. On a daily basis, they run the same program from their own computer and they like to print/export/etc. the reports that are produced. However, I don't understand why those reports print our on my personal printer (the printer is on the network). If they have a default printer at their site, why wouldn't it print there? Also, I haven't included any printing macros or VBA coding. I'm tired of having 30 or 40 sheets of paper print out on my printer daily. Any suggestions?
I designed a query, opened it and printed it. But the margins were too wide and I needed it to print in landscape also. So I changed the settings and it worked fine, but I can't get it to save the settings. Is it possible to save the printer settings for printing a query, both the margin and the landscape settings. If so, please tell me how. Thanks.
View 4 Replies View RelatedDoes anyone know if there is a way to setup a button on a form that when pressed, will print to a specific printer (that's not the default)? For example, I have one button on my form that prints 2 copies to the default printer, then I want the other button on the form to print on another department's printer.
Thanks!
I have a button that I click and it gets a value from my form and opens a query linked to a report, grabs the records, populates the report, and previews the report.
What I want to do now is Run the Query, dont show it, but print it to a deisignated Printer.
1. How can I run the report, not show it, but print it?
2. How can I force a print to a specific printer on my network?
Thanks..
IT guy quit. New forms printer installed and unable to relate/find form or query that default printer is pointing to
to change to new printer. Non programmer. Clueless.
program is 10MB and database is 2.3MB
searched through forms/reports/ and queries.
too much **** to look at
I have an access POS application which prints receipt on a receipt printer. I do not have a specified length of the receipt as sales vary in the quantity of items . Does anyone know how I can code it so that the last text is the end of the report and the paper is cut off right there? And also the printer is connected to Parallel port so i want these print commands to go to this particular port...
I wonder whether this could be done with printer driver installed.......... If so how the page length of receipt template has to be set. the width is ofcourse limited to 3 inches but as I told u guys length is unkown.....and dont think stillwe can resolve printing to specific printer issue(having driver nstalled).
thanks
This may take a while so please try to stay with me on this:
I have set up a query and a report (using label wizard) so that I can print a label of the current record viewed in a form. This seems to work until I get to the actual printing stage.
The printer I am using is an Epson LQ-300, printing onto a continuous sheet of labels (Avery's I think. 1 across. Dimensions 1 7/16" x 4").
When I press print I get the following code at the beginning of the label:
@EJL 1284.4
@EJL followed by endless blank labels. From what I can find on the net this is a driver problem but not sure how to fix it.
Also, in the label preview, should it be showing the single label as a full page report with the label text stuck in the top left? I have a similar report to print multiple labels and this also shows each label on a separate page. Doesn't seem right to me. Am I doing something wrong in the wizard set-up?
Any advice on this is most welcome. Thanks.
Hello,
Is it possible to get Access to open the print dialogue box instead of printing direct to the default printer when using the print command?
Thanks
Hello,
Is it possible to get Access to open the print dialogue box instead of printing direct to the default printer when using the print command from a button?
Thanks
How can I setup my form print button to print to a specific printer, and then to a specific tray? We need to use different colors depending on the item we're printing. This is possible by changing the printer settings as I print each form, but I'd like a more automated way to do this. Help please. Jolene
View 2 Replies View RelatedI had made MS Access application for a company.
After a while they asked me to connect that application with fiscal printer.
I don't know how to do that.