Hi there,
I知 new here so don稚 shoot me if I知 asking something that is inappropriate. I知 looking to make a DB for paper file tracking simular as you would expect in a law firm.
I don稚 want to reinvent the wheel so I知 asking if someone has built something like this before. I知 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?
Cheers,
Renoir
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.
Hi folks,
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?
Thank you,
Joe
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...
View 2 Replies View RelatedHi,
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).
Anyone doing this ???
Thanks
Mike
i have made table to store mcq questions. i need to know how can i select random mcqs from table and print using reports to take tests..
View 1 Replies View RelatedI 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.
View 1 Replies View RelatedI 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?
View 4 Replies View RelatedI want to set my paper size to user defined, but it not working,
<<<<<<<<<<<<<<<<<<<<<<<<<<
Set Application.Printer = Application.Printers("P1121E")
Application.Printer.PaperSize = acPRPSUser
Application.Printer.ItemSizeHeight = 9.35 Application.Printer.ItemSizeWidth = 26.9
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Showing "Run time error "2595"
"Cannot set this property when defaultsize property is set to true"
I try add "Application.Printer.Defaultsize = true or false" also not working
Does anyone have a sample training tracking system / database they'd be willing to share?
Or, barring that, can someone point me in the direction of where I might find one?
Thanks in advance! Looking forward to it!
Does anyone have a sample training tracking system / database they'd be willing to share?
Or, barring that, can someone point me in the direction of where I might find one?
Bee replied once, suggesting I look in the Samples Databases section of this forum, but I could not find anything even remotely related there.
All replies are gretly appreciated!!
I have a DB I'm using to track training for assigned people. Right now the training gets put in the DB at the end of the day by going through each persons record and adding the training that they did for the day. As you can see when training 30+ people a day, putting this in the system can take awhile. I'm trying to find a way to do a mass input to cut down time and could use some help with this.
My tbls are as such,
1st Table:EMPLOYEEtbl
EmployeeID
EmployeeName
(Other information)
2nd Table:CLASStbl
className
classID
3rd Table:CompleteClasstbl
EmployeeID
classID
DateTaken
What I like to do at the end of the is select the ClassID/DateTaken items once and then type in a just the 30+ list of employeeID's click a button and append it to the my 3rd table. Of course writing it out like this makes me think it should be easy but for some reason I'm lost. Does anybody have any suggestions?
I need help finding an existing or making a db. This db does not have much to it, so I am getting frustrated finding/making one.
My company has equipment that is stored in one of three places, customers, trucks of employees, and other(like warehouse, or out for repair). The db should be able to give me a report of where everything is on a given day, and a report of what was in a given customers property during the job(this is not for a single day, but for the duration of the job).
If someone knows of an existing db like this, I would appreciate a link. If you want to help, it is appreciated. At this point I would not mind paying someone to do this for me, as long as it wont cost too much.
Is there any way in access 2003 or 07 to track when a database was last synchronized with any one of it's replicas?
It would be useful to know and be able to store this in a table.
Hi,I'm looking for a bug/issue tracking solution done entirely in MS Access. Does such a thing exist?My requirements are that it must need only Access, and be accessible in a shared environment solely by opening a .mdb file from a shared folder. It must support various issue lifecycle related things, and the stuff those tracking systems do in general.It may or may not be commercial software.If anyone knows of such an available solution, please let me know.(And yes, I've searched on Google, and haven't found anything worthwile, so that's why I'm asking here now.)thx
View 5 Replies View RelatedI have a DB thats working fine, but (there always is a but) I now need to do something a little bit different. I need to be able to track my originators and who they have brought into the company. So I will have an originator and many down-line originators, and these people that come in down-line will have people coming in down-line from them and so forth and so on. I have a table that has all originator info and originatorID, but will I need another table or can I just add to the exisisting one. Here is the table structure:
Originators:
-------------
OriginatorID -autoNumber
FirstName - Text
LastName- Text
OrigSSN- Text
Address- Text
City- Text
State- Text
PostalCode- Text
HomePhone- Text
WorkPhone- Text
CellPhone- Text
FaxPhone- Text
EmailName- Text
BirthDate- Date/time
Level- Text
If more info is needed please let me Know.. Thanks in advance.
Scott
Is there a way to track changes made by different users to access tables? For instance if several users update or change data in various records is there a way to track when and what was changed (before and after data)?
View 1 Replies View RelatedI have read all of the audit trail stuff and searched on my subject but I think my solution could be simpler,
All I want to do is copy the values of the current record on my form into a history table with all the same fields.
Example Form:
[ID], [Machine], [Task], [Task Due], [Task Complete]
I want to put a button on the form that reads complete task and when the user pushes the button it copies all of the details for that specific record they are looking at into my History Table that contains all of the same fields.
This will give me basic history on when each task was completed for a machine and I can access for reporting
I consider myself an intermediate ACCESS user and can get around it with little trouble with the help of the internet and the help file.
I am trying to design a database that is fairly simple in design, it is for tracking the status of documents at our work center. Basically we have personnel reports that are passed around the different people and different dates.
I have a main form that has the info on the person along with dates that it is due.
Then a sub form that has the date sent and where it went to.
My problem lies in that I want to keep track of the whole history of the document but when i print out a report or export the data to excel to put up in powerpoint I need to have just the most recent date sent only item.
I have 2 tables one with user info and another with the routing info with its own primary key along with a identifier key to link the primary and sub form.
Of course it is easy to create a report with the data to show all the different routing steps but not just the one with the most recent date.
Thanks in advance for the help.
Hi,
I'm looking for a bug/issue tracking solution done entirely in MS Access. Does such a thing exist?
My requirements are that it must need only Access, and be accessible in a shared environment solely by opening a .mdb file from a shared folder. It must support various issue lifecycle related things, and the stuff those tracking systems do in general.
It may or may not be commercial software.
If anyone knows of such an available solution, please let me know.
(And yes, I've searched on Google, and haven't found anything worthwile, so that's why I'm asking here now.)
thx
I would like a field on my main switchboard that displays the last time the database was modified.
Simple question, and I can not find an answer anywhere.
Thanks!
I'm trying to set up a database to track a huge group of corporations. There is the parent company, then a bunch of subsidiaries below it. Some subsidiaries have another layer of multiple subsidiaries below it, some have none. Any thoughts as to how to do it???
View 1 Replies View RelatedI am tracking training for employees. I have a database that keeps track of the dates a particular training was taken. Employee training is ongoing from year to year. I have an Employee Training with a subform showing only the specific employee's training. I need a help with a few things. I need to keep track of training by the year. If I enter 2006 dates it will show in one line, if 2007 dates, another, all the way across the list of training classes for an employee. I also only want to limit a person enter more than one date for a particular class for a calendar year...Are these things possible. I have attached the database. Please help, make changes and suggestions. Thank you so much in advance.:eek:
View 3 Replies View RelatedHi team.
I've had a bit of a search around the forums and haven't found this anywhere.
Does anyone have a sample issue tracking database for an IT department?
I don't have too much Access experience so am looking for a little bit of a headstart on this. It seems relatively basic though.
The fields I think I will be needing are the following:
Log No
Status
Priority
Type
Project
Raised by Person
Raised by Department
Description of Issue
Status
1 Active
2 On-Going
3 Hold
4 Finished
5 Cancelled
Priority
1 High
2 Medium
3 Low
Type
1 Bug
2 Enhancement
3 Other
Project
1 Lotus Notes
2 File Maker
3 Tumbleweed
4 Windows
5 Microsoft Word
6 Microsoft Excel
7 Microsoft Outlook
8 Adobe Acrobat
Raised by Department
1 Research & Development
2 Customer Service
3 Finance
4 Data Solutions
5 Communication Services
6 Production
7 Stores
8 Operations
9 Other
My computer crashed and I lost my employee vacation tracking database.
Does anyone have an Excel spreadsheet or other tracking method they could share please? I really don't have time to build a new database.
Thank you for your help.
Im trying to design a tracking DB for phericals and ports located at workstations throughout the office. Theres over 200 workstations.
Ok this is what I have so far. Please tell me if im on the right track and any suggestions.
Ive never been good at doing the relationships. They are so frustrating at times.