Specific Item Tracking Database
Hello Everyone,
I've been looking at all the fine db samples and advice provided in this forum and they are giving me a huge boost in my new job as a DB Admin. :D
Since this forum has a very active group and you guys know and done it all, ;) I thought I would ask if anyone out there has done or could give me an idea on how to buid the following db:
I need to create a db that will keep track of a specific item from the moment it comes in 'til it goes back out. This could be weeks in the process.
What happens is that this is a program where people donate old worned out wheel chairs and they get totally overhauled. As the chairs come in they need to be tracked from start to finish to see where they came from (Somewhere in the USA), what process it took to overhaul it (ItemID and Current location [Storage, Repair BIN, Repair Table, Completed Tabe, Outbound Table, En Route to Destination, etc] and status [For parts, fixable, paint room, repair room, completed]) and where they were donated to, a city in some foreign country (Africa, Asia, Mexico, South America, Etc.).
If someone has something I can use would be great, but if not any idea on how to do it best, would be greatly appreciated.
Thanks!
René
View Complete Forum Thread with Replies
Related Forum Messages:
Setfocus On Repeating Item/accessing A Specific Item
I have a form that simply lists the items: DEPARTMENT_NBR and DEPARTMENT_NAME In the table: DEPARTMENT_TBL When I edit the field DEPARTMENT_NBR and it is in error (must be between 01 and 99) I want to put out a message in a MSGBOX and SetFocus back on the DEPARTMENT_NBR. I coded the MSGBOX with vbokonly and then DEPARTMENT_NBR.SetFocus, but after the message displays and enter is hit for the ok the cursor jumps to the DEPARTMENT_NAME on the current line. Is there a way to get the SetFocus to work properly on repeating items like this? I can never seem to get them to perform the same as they do on non-repeating items. Thanks for your help. HERE'S THE EXACT CODE: If IsNumeric(DEPARTMENT_NBR) = False Then If DEPARTMENT_NBR <> "00" Then MsgBox "DEPARTMENT NUMBER must between 01 and 99.", vbOKOnly DEPARTMENT_NBR.SetFocus GoTo DEPARTMENT_NBR_EXIT (exits the paragraph skipping other checks) End If End If Also, is there a way to look at a specific item in a list like that? IE. I want to reference the 3rd row's DEPARTMENT_NBR. Thanks.
View Replies !
Tracking Changes To Database
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 Replies !
Tracking Database Help
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.
View Replies !
Question-Database Tracking
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!
View Replies !
Issue Tracking Database
Hi 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
View Replies !
Employee Tracking Database
Would like to hear from anyone that has designed a database that can be used to track employee compensation on a year to year basis. I am current designing a database to do just that but I'm having a hard time deciding on how to setup the tables. What they use this for is yearly reviews so I need it to be able to pull data from prior years and the current year. I've designed one but don't think its going to work for me. Just interested to see if and how someone has done the same thing. Thanks, Chester
View Replies !
Simple Tracking Database
Hello, I am trying to figure out how to setup my tables. The tracking system i am trying to create will have these information: the Tables will contain these information - Package number - Received date - Sent date - How long have we had the package - Status (Sent or Pending) I will also need to figure out who received and sent the package - Employee name Please advise if I setup the tables correctly. I will also need to query these info: - all packages received 3 days ago - how many packages an employee received and sent - How many sent or pending Thank you for your help.
View Replies !
Newbie Needs Help With Tracking Inventory In Orders Database
I am developing a database for a friend and have all the relationships, tables, forms, queries and reports working well. I used the orders template to build this and just made a few changes. I have an orders form with an orders details subform that works beautifully. There is also customers table, employee table, products and inventory table. The inventory table has product ID, units in stock and reorder level as the only fields. I need an easy way to have the orders detail form decrease inventory as items are ordered and also some sort of way to enter restock. Can anyone offer advice that a beginner can understand in regard to this? I wrote an update query that he can run that will subtract the qty ordered from the units on stock for orders with order date >= whatever date he enters, but if he enters a date he's previously updated it will update those records again. I think this is not a good way to go but the only way I could accomplish. I have him using the same order entry form with customer name Restock to add items to inventory by putting an if then else statement in the before mentioned update query. This just adds to inventory if customer name="Restock" else the qty ordered is inventory units in stock -qty ordered. I'm sure someone can suggest a better way. A friend mentioned dsum function but can't explain how to apply it in this instance. Thanks so much!!!!
View Replies !
Looking For Free/shareware PDA And Cell Phone Tracking Database
Hi, I have a list of 500 PDA users, spread over 7 offices. I want to keep an eye on what happens with the devices and their SIM-cards. As they are often swapped between offices and SIM-cards get lost. I am pretty sure that I don't have to re-invent the wheel. Do you have any idea of a free/shareware tracking tool for PDA's and cell phones ? Thanks in advance !
View Replies !
Importing Daily Excel Spreadsheets Into Item Inventory Access Database
Hello, I am not sure how complicated of a job this is, but we want to be able to import our daily recievals of inventory into our existing inventory database instead of entering it by hand. I try using the wizard, however when I get to "finish" it says there was an error and it was not imported. I don't know much about access but I was hoping one of you could point me in the right direction.
View Replies !
How To Find Specific Database Object
I am wondering if there is a quick way to find a database object (table, query, form, report) other than having to scroll through them in the database window. E.g. I have many many queries and when I need to find one to make changes to it, it often takes me a while to find it when scrolling thru the queries in the database window. Has anyone ever programmed anything whereby you can type in the object type and name and then it will be highlighted in the database window? This would be a great time saver. Thanks, BJS
View Replies !
Question About Database Structure (specific)
Hi everyone. This is my first post here, I hope I'm making it to the right forum! I'm currently experimenting with databases with an idea to move them online in order to create SQL & PhP driven websites. I'm a long way off actually making them live, though, and have become stuck today on trying to create the best structure for a specific database. I've searched for example databases to see how other people might have solved this problem, but it's very hard to find another database with exactly the same issue. I hope someone can tell me the best way organise my data! I'm racking my brain trying to reduce data redundancy and make the most logical database I can. I'd appreciate any help, thanks! Basically my current database involves cataloguing a particular video game series. Each game title in the series has information attached to it (eg. platform, developer, trivia, data released etc.), but some games have spin-off titles with the same information stored about them. If someone is viewing a spin-off title I want them to be able to see that's it's connected to a "parent" title and vise versa (someone looking at a "parent" title can see all the spin-offs). This database is as much an exercise in creating a completely "correct" database as anything, so I want to reduce data duplication as much as possible (completely?). I've attached a picture of my database as it stands at the moment (with no spin-off information added), I hope this might help someone understand my problem. Thanks for any help! It's much appreciated! Databases make my brain hurt sometimes, and it's hard to know then "best" way to do something! - Johnny W PS - Here's the "key" to the diagram. tblTitles - Game information tblAlternates - The same game on different platforms (eg. PC, PlayStation, Nintendo Gameboy etc) Actually, I think the rest is pretty self-explanatory! Thanks for any help! -J
View Replies !
Exporting To A Specific Excel Spreadsheet, And A Specific Worksheet/cells
Hi, I have recently been doing a lot of work on this area. Im able to export to where i want to and run macros through the VBA code inside of Access to edit the spreadsheets. This is ok if your making a new excel workbook/worksheet. But what im stuck on is exporting to a so called template in excel. I can export to it at the moment but creating a new worksheet, in which i have to then cut and paste the data into the correct worksheets through code and then delete the worksheet that i had been working from (which is annoying because you have to confirm the deletion of this worksheet, which is why i couldnt really do the process this way). What i want to know is there a specific way of telling the data you are exporting from a table/query/querydef to go into a certain worksheet and into a certain cell. For example; a list of names, i want all the Surnames to go into a worksheet called "Claim_Breakdown" and start from cell "A15" downwards until they have all been exported into the worksheet. Anyone have any ideas on how i could achieve this? Thanks.
View Replies !
Pulling Specific Data For Specific Date Range
so i have an interesting question and im hoping that someone can help on this one. i need to pull date from a specific table, no problem, that's written and working fine, next i need to be able to join the data from another table by a primary key, again no problem. third, i need to be able to select the date (using WHERE) for a specific date range. (i.e. i enter the date range of 01/7/2007 to 15/7/2007) and the query comes back only showing the data from that specific time, not the data from before or after. this is where my problem lies, all the entered data is being shown after entering my date range. i am going to include my SQL statement, just so you can actually see what im really talking about. SELECT srealest.Name0, srealest.Dist1, SREpayments.Face2Pd, SREpayments.Penalty2Pd, SREpayments.[2paid], SREpayments.Face3Pd, SREpayments.Penalty3Pd, SREpayments.[3paid], SREpayments.Face4Pd, SREpayments.Penalty4Pd, SREpayments.[4paid], srealest.Map, srealest.Parcel, srealest.LeaseHold, srealest.TaxRebate1, srealest.TaxFace1, srealest.TaxPenalty1, srealest.TaxYear, srealest.BillNo, srealest.PdRebate1, srealest.PdFace1, srealest.PdPenalty1, srealest.DatePd FROM SREpayments INNER JOIN srealest ON SREpayments.BillNo=srealest.BillNo WHERE (((SREpayments.[2paid]) Between Forms![SD SRE]![Beginning Date] And Forms![SD SRE]![Ending Date]) Or ((SREpayments.[3paid]) Between Forms![SD SRE]![Beginning Date] And Forms![SD SRE]![Ending Date]) Or ((SREpayments.[4paid]) Between Forms![SD SRE]![Beginning Date] And Forms![SD SRE]![Ending Date])) Or (((srealest.DatePd) Between Forms![SD SRE]![Beginning Date] And Forms![SD SRE]![Ending Date])) ORDER BY srealest.Name0; any thoughts or ideas on how to accomplish this would be greatly appreciated!
View Replies !
Locking A Specific Field Of A Specific Record
Hello, I have just spent ages doing searches and reading everything I can on locking. But, I have yet to find an answer as to how I can lock a specific field in a specific record. e.g. Staff enter customer details, then at the end of the day the admin (me) checks it over and presses a big old button that stops them from locking certain fields in the current record only - they must still have access to the unlocked fields of the current record, and it must not lock any other records. I'm guessing there's some VB code in the form of fieldname.lock = true, but then it locks the field throughout the whole table! Can anyone tell me how to do this please?
View Replies !
Populating A Subform Item To Another Subform Item.
Hey all. I'm trying to get a combo box to populate the box next to it. Basically pick a project number in the 1st box and have the project name show up in the second box. I have it working, but the problem is that when it puts in the name of the project, it fills the whole column with that name, and not just the one box. Here is what it's doing: http://img156.imageshack.us/img156/2659/dbhm4.jpg Here is the code im using. Private Sub ProjectNumber_AfterUpdate() On Error Resume Next Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String ProjectNumber.SetFocus If ProjectNumber.Value > 0 Then strSQL = "SELECT * FROM ProjectList WHERE ID = " & ProjectNumber.Value Set db = CurrentDb Set rs = db.OpenRecordset(strSQL) If Not rs.BOF Then Me.ProjectName = rs("ProjectName") End If rs.Close Set rs = Nothing db.Close Set db = Nothing End If End Sub Let me know what I can do. Thanks!!
View Replies !
Project Tracking??
Don't know if this is the correct forum, but.... Does anyone know of a relatively inexpensive (maybe even free???) Project / request tracking system written in either Access or VB? I ;ooked and looked on the forums here, but couldn't find a thing. If anyone will just point me in a hopefully good direction, I would be grateful. Thank you!
View Replies !
Compliance Tracking
Hello. Does anyone know of a good sample database that can assist me with understandig the logic behind building a compliance tracking system? I have a need to keep track of customers who are required to submit certain documents at certain times. I would like the program to maintain an archive of which documents have been submitted late (or not at all) in order to analyze trends.
View Replies !
Trade Tracking
I am very new to using access, so please just bare with me while I try to explain my situation as quickly and clearly as possible. This database I have been working on for about a month now is to keep track of all of these game figures I have. When new sets come out I trade off some of my extras to get ones that I need to complete sets. If you would be so kind as to download my database (http://www.box.net/public/pjonkjmicy) and take a peek this would be much easier to understand. On the main interface that opens there is a "TradeTrack" button to the right. When that opens you see 2 boxes, the one on the left should list all of the figures I have listed as trades in the database. Then I would like to move them over to the right box to be traded to the trader listed in the dropdown above. If anyone knows of a database example or anything that does something like this, Im sure I could make it work. I have done allot of searching and came up empty handed. Thank you for looking! ps Sorry, about the box.net link. The attachment loader on the forum said my file was too big. I hope this isnt a problem.
View Replies !
Training Tracking
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!
View Replies !
Tracking Training
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!!
View Replies !
Tracking Training
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?
View Replies !
Equipment Tracking Db
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.
View Replies !
Tracking Synchronization
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.
View Replies !
Bug Tracking Solution
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 Replies !
Need Better Tracking With My Tables
I 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
View Replies !
Tracking Updates
I 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
View Replies !
|
TRACKER
