General :: Scanning Barcodes To Track Items While Using Other Database Functions
Feb 5, 2013
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?
View Replies
ADVERTISEMENT
Oct 15, 2012
I'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 Related
Oct 21, 2013
Im trying to create a database so I can Monitor grocery items from different supermarkets in my area.
I have been doing this on Excel for a while now, and its time to do it properly.
The only issue I would have is when I enter data.
I want to be able to track the price changes on items. I have my own.
So for example. Each time i enter the price of an item, I want a time stamp with it. (being the date when i entered the item, should be automatic).
View 4 Replies
View Related
Jun 15, 2014
I'm developing a database that tracks monthly metrics of employees. These employee are at several different locations.
Here's what I would like:
A table of the employees and their location.
A table of the metrics.
A form that you can select an employee and it would autofill the location and then you could fill out the metrics.
the ability to change an employee's location without it effecting past records.
A report, by month and location of the employee's metrics. (pretty sure I can do this on my own, just can't get to this point.)
I've tried to use a auto lookup query but that then changes the employees location on past records.
View 4 Replies
View Related
Aug 14, 2006
Hy, I have this db where a user can purchase and item and total stock number needs to be updated.
I can calculate how many items are left but how to update the warehause table?
I can live without table updating, but if the same item is purchased multiple times my query return incorrect values as the number from which the formula subtracts is never changed.
See attached database.
View 1 Replies
View Related
Oct 21, 2013
Im trying to create a database so I can Monitor grocery items from different supermarkets in my area.
I have been doing this on Excel for a while now, and its time to do it properly.
The only issue I would have is when I enter data.
I want to be able to track the price changes on items. I have my own.
So for example. Each time i enter the price of an item, I want a time stamp with it. (being the date when i entered the item, should be automatic)...
View 6 Replies
View Related
May 11, 2012
I am trying to find out if there is a way to track the order in which items are selected from a list. I am a dabbler and any keyword searches that I can think of don't bring up what I am looking. So, here is what I am trying to do:
I have a table of symptoms with 3 fields (ID, Category, and Symptom).I have a combo box that will allows the user to pick a category (using select Distinct on category field). I then have a list box populated with all the symptoms that have a category of whatever the user selected. The problem I am having is that I need to somehow track the order in which the user selects symptoms and then save that order for future reference and to be printed on a report. The order is important because the most severe symptom needs to be listed first.
View 7 Replies
View Related
Jul 29, 2013
I'm completely new to Microsoft Access. This project was thrown my way. I have an accounting database to track payables, receivables, financials, and deliquencies/collections. Is there a way to generate a report for any of the items in the previous sentence that haven't been completed to keep track of workload.
View 5 Replies
View Related
Aug 3, 2015
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 Related
Jun 8, 2012
Im looking at creating an MS Access database for manufacturing items. Ill need to be able to create default items to be made and also use this to assign members of a team a list of items to make for a current day of the week which i can then input back into the database to keep it up to date with what they have made, have they kept to targets etc....
View 9 Replies
View Related
Mar 14, 2014
I want a good describe about how to create database for supermarket specially how to build a form for selling item, what is a structure of tables ........
View 1 Replies
View Related
May 18, 2005
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
View 2 Replies
View Related
Nov 21, 2007
Wondering if anybody has any information about this.
Backgound information: My access database information comes from a 'card' where somebody has manually put crosses in a number of boxes. This information is currently being manually inputted into the database...
I know you can get scanners to pick up information from a document...but is this possible with microsoft access?
View 6 Replies
View Related
Nov 6, 2013
Once a year we have a conference that has about 400 people attend. These people will participate in several classes, randomly, over a four day period. Each class hands out an evaluation form. This form has six categories and asks you to rate each from 1 to 5. This is done with a grid on the form labeled with 1 2 3 4 5 across the top and the attendees will put a checkmark or X in the appropriate box. This results in approximately 3000 evaluation sheets.
I will take these and manually enter the scores into a database I created in order to tally the results and generate reports. I have been asked to see if this process can be expedited by using a scanner to pull the scores from the sheets.
View 1 Replies
View Related
Jan 24, 2014
Is there a way to directly access a TWAIN compatible scanner directly from a form button in Access 2007/2010 so that it will add one or more images to the specific table?
View 2 Replies
View Related
Jul 31, 2013
I just want to know how to manage items in set and individual item. Suppose my product list are
individual items = A,B,C,D,E,F,G,H,I,J,K
and 5 pc set = A,B,C,D,F
and 3 pc set = G,H,K
How should I design the table. Previously I designed the table for individual items and whenever orders for set is placed user had to enter individual items with quantity.
E.g. order is for 5 pc set = 3000
A=3000
B=3000
C=3000
D=3000
F=3000
Now I need to just say 5 pc set and it should be automatically populated. And also if order have combination of individual and set items.
View 3 Replies
View Related
Mar 15, 2006
Hi guys,
Im fairly new to MS Access and have recently created a simple database to track the details of people in my department.
The database is on a shared drive and the idea was that when the details of the individual change, they open the database themselves and edit the appropiate field.
However, is it possible to track the changes that people make over a certain period (ie every month).
Thanking you in advance,
Jonny
View 1 Replies
View Related
Feb 16, 2013
I am writing a database to track our (and others) wine collections. i'm wanting to track what bottle is where. so i can look up what i have, look up where i have put it and away i go to get it, simple right?
just to complicate things i want a system in place. where the end user and use forms to add/remove or modify wine racks.
assuming that all racks are rectangular i would like to be able to add a rack and call it rack 1. rack 1 has 4 shelves all able to hold 5 bottles. the database would then say that bottle X is in rack 1 shelf 1 position 1.
if possible there will aslo be a screen that is auto generated by the database showing a simple grid with grrn and red squares denoting if the position if full or empty. the ability to click on a position to see what is in there or to add a bottle there would be amasing but not fussed if that can't be done.
View 2 Replies
View Related
Jul 7, 2014
I want a field in my table (called 'ContactTotal') that tracks the total number of times the date was changed in the field 'LastContacted' - through either table or a form, but it should exclude any changes made on the same day.
I'd also like a second field (called 'Popularity') that does the same thing, but multiplies any changes made in the last 3 months by 3, the last 3-6 months by 2, the last 12 months by 1 and anything before that by 0.
View 14 Replies
View Related
Sep 19, 2013
I am new in Access 2010 and need table design schema. I am creating a database to track budget changes within our organizations.
1. We have 3 division (West, East and Central).
2. Each division will have 5 Organizations (Office, Campus, Operations, IT and HR)
3. Each Organizations will have multiple sub-organizations
4. The budget start with the sub-organizations - which is break down by cost center and sub cost center.
This is the design I came up.
tblFiscalYear
tblDivision
tblOrganizations
tblSubOrganizations
tblCostCenter
tblsubcostcenter (budget table)
tblDivision --1 to Many --> tblOrganizations
tblOrganizations --1 to Many --> tblsuborganizations
tblsuborganizations --1 to many --> tblCostCenter
tblCostCenter --1 to many --> tblsubcostcenter
Is there a better way to design this?
View 4 Replies
View Related
May 8, 2013
I have been using Excel to keep a daily track of when people are in to work, but the number of persons employed has increased and it is taking too much time to manually input data into the sheet.
I am looking at Access and I would like to know if what I want is possible.
The fields I would need are , Name , Date , Time worked(1 for a full day and 0.5 for a half) , Reason worked, and funded by(inside/outside organization)
I would like to make a template of form that has the following options.
1. The ability to select a date (possibly through a calendar selection)
2. Select one or multiple different persons from a list
3. Possibly two check boxes (full/half day) - that when selected input a 1 or 0.5 into the database
4. A text entry for reason worked.
5. Another check box for inside/outside funding that reflects the time worked in step 3 and that can be queried to see how many total days funding was given.
View 2 Replies
View Related
Sep 14, 2013
Trying to modify this calendar database to track employee leave. I need the calendar form (frmCalendar) to show all employee leave on the calendar using the "Show All" command button on click event. This works if I specify a uID (UserID from employee table) in the code, but only for that specific employee. I need all employees at the same time up on the calendar so I can see if there is more than one employee off on any given day.
Events or leave is populated on the form through "Private Sub DisplayEvents" and the mdlCalendar module.
Using Access 2010
View 2 Replies
View Related
Nov 20, 2012
I have a form based on a query. I've disabled "Navigation Buttons" on the form and am trying to recreate their functionality in a little more user friendly way. I've created next / previous record buttons and have those working great.
I'm now trying to re-create the record counter / tracker. I'd like to setup a box that shows which record I'm on (this can simply be based on the order the query returns them, the same way the navigation buttons does it when they are enabled. ), and how many records there are total in the query.
I tried messing around a little bit with =DCount but wasn't able to make it work I suspect because I'm counting the number of records returned in a query, not in a table.
View 14 Replies
View Related
Sep 10, 2012
I'm trying to design a billing and invoicing database and can't seem to figure out how to link the tables and track the payments made by customers. How can I proceed to track the payments and make payments applicable to certain line items or invoices? If the line item hasn't been paid, it needs to show up on the next invoice and be included in the total due.
View 14 Replies
View Related
May 11, 2015
I have a login screen that works fine but I need to lock some part of the system from normal users but I can't figure out how to track if the user who is logged on is security level is high and can authorize the transaction!!!
I have users table and in it I record the users, passwords, security level. So when someone logs on I have no way of knowing who they are and in order check their security level. I did it in the past by setting the C drive VOL into a value and search but as we use Citrix XenApp this is not possible the C drive is the server drive and if multiple users login to to that server then the VOL value would be wrong.
View 3 Replies
View Related
Dec 3, 2012
We have a db to register permits that count for one calendar year. This since 2012. For next year, permits must be renewed. How can we keep track of all permits per year per user in the same table ? We would like to produce annual statistics as well ? Easy solution would have been to copy the existing table for the year 2012 and paste as a new table for year 2013 but we don't know yet who will renew his permit ...
View 3 Replies
View Related