I hope I can explain this right(and its in the right forum)....newbie....How do you distribute microsoft access 97 front-end program to several users on a network, along with printer properties for multiple printers? Any help would be greatly appreciated. Thanks :o
View RepliesGood 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?
Does 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 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
I've created labels in my database and when I print them on a label printer, I get a blank label in between my printed labels. I've checked the printer settings and properties and can't find anything. I've also checked the database properties and can't find anything. Is there something in the database that I'm missing?
View 6 Replies View RelatedI have recently changed computers from a WindowsNT to and XP. When using the NT machine, I am able to print my Access report. However, when I hook up the XP machine and request a report from one specific database, I get the following message....this message also comes up if I try to open print preview or page setup.
"There was a problem retrieving printer information for this object. The object may have been sent to a printer that is unavailable."
I don't think it is a printer error as the error is occurring in this one database. I have successfully printed a test page and can open up other Access databases and print. I also tried converting the database to the 2002 format....but that did not make a difference either. There must be a setting in the database that is causing the error.....
Does anyone have any suggestions???
I have a lovely report that includes a small color photograph. I'm sending the report to print on my HP Color LaserJet, but it is printing in black and white.
I can't find anything in the Properties that specifies whether this prints in color or black & white.
How to print this in color?
I am creating a CAD Drawing database / Distribution list. I can only seem to distribute one drawing i.e single field to one person.Is there a way to have multiple distribtion on one field without creating multiple distribution fields?
What I have is a database which contains Drawing Numbers - I need to create a report that shows where the drawing has been distributed to, with it's current revision status and the date is was sent.I am having trouble trying to use multiple revisions and mutiple people in the distribution list with one drawing.
Hi, I would like to change the properties of either the column heads in a combo-box or the column names for tables. I don't think there's any way to adjust the column head properties, and I'm doubtful there's a way to change the column caption properties.
Some of my column titles are long, and I'd like to be able to word wrap them essentially. Anyone know if this is possible? Thanks.
I have read every post here on "distribution" and "deploying" the front end to the users but can't seem to get how to do it. I see many posts regarding updating the front end and using the runtime version to distribute but can't seem to understand how to initially get the database out to my users.
I have a split db and need to distribute it to about 20+ people. The back end will reside on a shared drive that is mapped the same on everyone's machine.
I also have the FE on the same drive and am currently using a batch file run from a link on our website to open it, therefore we are all using the same front end which is what I am trying to eliminate.
Can I just zip up my FE and email it to my users? Will that maintain the links to the back end when they unzip it to their desktop?
Also, I would like to get some feedback on some software I am thinking of buying for pushing out my updated databases in the future. It is called Access Frontend Loader
http://www.frontend-loader.com/
Has anyone used this before? Would appreciate any thoughts on it or any other program you may have used in the past.
Thanks
Afternoon
Apologies if this is in the wrong place, but I've looked around and can't find anywhere else that's relevant.
Essentially, I have a large reference database that I'd like to send to a fairly large number of people, preferrably on CD. Copying and pasting information into another format, such as Excel isn't an option.
My question is, how could I setup the content of my CD so that everyone could access it, even if they don't have Access? Could I include a copy of Access Runtime on the CD? Would that enable people who don't have Access to view the data on the CD? If so, would there be licensing implications if I did this?
Sorry if that's convoluted, but I'm not technical.
Thanks
I have developed access application (front/backend) for my client. As client wanted they would be running on 3 comps on LAN. 1 comp would have the DB and the other 2 the frontends. How will I create installation (CD/package) so that it can be distributed in the clients site. Any suggestion would be appreciated.
Thanks in advance.
What's the best way to go about this?
Right now I have about 40 personnel using 40 different Excel files. Each day, each file needs to be copied and pasted into one large file. I've recently had luck replacing several of my personal Excel files with MS Access and now completely hooked on using databases. I would love to replace all of those Excel files with a Database on the network, at the end of the date, compiling everything together would be as easy as a query, and possibly an export (if we needed to send the Excel file out as we sometimes need to).
I've got the use of a Network, but here's the rub. I'm the only one with MS Access installed. I can not talk my boss into buying the additional licenses needed for Access on their computers.
My edition is also not a "Developer Edition" as I've seen where you can create a runtime version, so I guess that's out.
What would be a suitable "frontend" to do something like this. I'm pretty decent at Access, but certainly no expert. What is the best/easiest options that I should be looking at?
I'm willing to learn something new if I have to (which I probably will). I'm also willing to spend some of my own money to put something on my machine at home if it will help me develop something. I just need options because I don't know enough to make a decision about this.
Thanks in advance.
Howdy!
I split my db last week and put both front end and back end files in a shared network folder. I backup the db every day to a different folder on the network server and also to my laptop. I usually backup right after a form update so that the latest version of the form is available to users who want to update their local copy of the front end. I've been sending email alerts to the users.
My question is this: What is the best way to (1) make sure my backup updates the front end on the network server and (2) how can I automatically alert users to update to the latest version of the front end?
Thanks gurus!
bugleboy:o
On my development machine everything works great, but I know that I'm going to run into problems with distribution.
I don't think there is a way, but I'll ask. Is there any way to get around not having to install the ODBC MySQL drivers on each computer? One of the reasons I'm migrating to MySQL for a backend is the fact that I'll be going from 10 users to 150 users, each of which has a "locked down" PC, which would mean logging into each with Admin rights to install the driver. Not an impossible task, but a pain.
Is is possible to have a "shared" source for the driver? I have only a rudimentary understanding of that process.
Thanks in advance for any help that someone can provide, or some answers pointing me in the right direction.
automated per-record report distribution. In my system there is a report generated with a record for every person that must be sent out to them on a periodic basis. Ideally I would like to send them out in batch(5000+ records) so that each person receives theirs via E-mail. I am not too worried about the format. Each persons record contains their E-mail address so that should make things easier.
View 2 Replies View RelatedI am brand new to using access databases but I am in the midst of trying to set one up for controlled distributions of controlled documents.Essentially, I have three tables:
1) Listing of all our controlled documents and their properties (doc number, doc title, doc revision, doc type, doc status, effective date),
2) Listing of all our copyholders (name, location, phone number),
3) Document Distribution List which lists copy numbers, quantities, and medium to deliverable (paper, electronic, size, etc)
What I want to do is create relationships within the Document Distribution List (using 'add from existing fields') from the other two tables so when a request for a new controlled copy comes along, I don't have so much data redundancy.
For example, in Table 1, I have listed Document XYZ and copyholder Jane Doe from Table 2 wants to receive 1 copy of Document XYZ. I would like to have Table 3 have an added field from Table 1 where I can pull down the applicable document number, which when selected auto fills out it's corresponding details of title, revision, doct type, status and effective date in this Table 3. In addition, after I select the document Jane wants, I want to have another field added to Table 3 from Table 2 which lets me pull down Jane's name to assign her a copy number.
Is there a way of doing the above? I have several distribution lists (some >100 recipients) defined in Outlook, and would like to use the Docmd. Send Object command to send messages to one or several of them. I cannot find a way of defining a distribution list as any of the To, Cc or Bcc parameters.
View 2 Replies View RelatedI am with an educational organisation. Now we need to allocate various fields to students depending upon their merit, where the difference between the average percentages between any two groups cannot be more than 2% and that also implies equal distribution of talent. However, First few have to be given choice of field and also students recommended have to be given choice. The number of fields varies from 2 to 8. . Further the vacancies are also not equal in all fields. E.g. for 100 students to be divided in four fields the vacancies can be 35 for ZZSS, 24 for UYTE, 29 for OIUI and 12 for HGFT.
I need a solution preferably in MS Excel or MS access for the same with nil/ least usage of VBA.
Table examples
Name REg. No. Percentage
Aaa 986544a 89.3%
Bbb 547521j 87.2%
Ddae v44887y 95%
I was having trouble just setting each report with a particular print method - for some reason they just kept forgetting their individual settings and resorting to default on the machine.
This meant reports were printing on the wrong paper, or the wrong size paper, the wrong orientation and some times refusing to print if it couldn't find the paper (which is useful in runtime as it doesn't display error messages)
So I used Reports(rpt).printer properties (I forgot where I found this) to hard code the printer properties into each print command... this meant I had to use another function to insert the variables.
So all I had to do was say:
Code:
PrintMe("Invoice","InvoiceID",iID)
and a report would print to exactly how I wanted... but it's just too slow!
See attached for full code, I have a niggling feeling it may be the function: PrinterOK, to make sure the printer exists or not.
Code:
Function PrinterOK(sPrinterName As String) As Boolean
Dim MyPrinter As Printer
PrinterOK = False
For Each MyPrinter In Printers
If MyPrinter.DeviceName = sPrinterName Then
PrinterOK = True
Exit Function
End If
Next
End Function
I know it's the printing code, because if I stop the printing and just preview then it shows up almost instantly.
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
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 9 Replies View Related