Im New Here! - Barcode Input/ And Workstation Identifier

Jun 7, 2006

hi guys, i am slowly learning access by browsing these forums and using microsoft help and downloading example databases. problem is - i have no formal training in it and am just sort of poking around. how did you guys learn? is there a good book out there to read, or did you take a course in it?

right now i am trying to develop a database of tracking product through a factory. technicians would scan the barcode for a pump before and after every process. i made it a simple table coupled with a form where they input the barcode # and a timestamp was coupled with it. later, youd be able to graph the time stamps so you can see process times, how many are in work in process, etc.

my specific questions are:

when i use the timestamp feature, it updates the time when a new record is brought up, but i want the timestamp to register when they click the add entry button. so far i have the default value =Time() for one, and =Date() for the other ...

next is, i want each workstation with this open to have its own unique identifier. for example, one program in assembly station should automatically input "assembly" for where the record was added in, how is this done?


lastly, i have a barcode scanner that operates like text input, i have an area on the form for the barcode, so when it scans it enters the number. is there a way that once the field gets 8 digits entered into it, it automatically goes to the next field on the form? i would like for users to pull the trigger and not have to hit enter again ...


a big THANK YOU for all you access gurus, i have been browsing these forums learning a lot. i hope i can achieve your level so i can help others as well. Thanks again

- Dave

View Replies


ADVERTISEMENT

Barcode Scanner Input Question

Jun 17, 2006

OK... Did some searching and posted one question on forms... But still have one important question that has not been answered. First let me say I want to use a scanner connected via USB. ( I need to be able to use this app on a laptop, so keyboard wedge is not possible) Found a quote on a site "TalTech"... Something like that...... This one..
"1) Keyboard Wedge output or USB output

If your bar code scanner has Keyboard Wedge output or USB output you will not need special data collection software. Both these outputs will dump the data right into the foreground application on your PC wherever the cursor is flashing, as if it were being typed in. You do not usually get much control except for the addition of a trailing keystroke, such as an ENTER key, to your data. But these methods are very simple and work fine for many people."

Question is...... Is this true??? Will the USB input directly to the field I want it to?? I just need someone with some experience in this to let me know for sure.

Thanks
Curtis

View 8 Replies View Related

Search For Barcode With Scanner As Input

Oct 26, 2004

I have created a form that I would like to search for a barcode by using a scanner as an input device. Does anyone know how to go about doing this?
The form basically holds a subform of textboxes that have barcodes. I want the user to be able to scan a barcode which will then find that barcode in the subform and assign it with a DateOut = Date() ...

View 2 Replies View Related

General :: Print Barcode To Be Used For Data Input Into Another System

Aug 7, 2014

I'm trying to print a barcode to be used for data input into another system.

The data contains alpha number and some special characters like space, underscore, / and &

I want the form to print the bar code

128 and 3of9 don't handle this data.

View 5 Replies View Related

Date / Time Stamp On Barcode Input Form

Apr 29, 2014

I have a barcode input form. When a barcode is scanned, the value of the barcode, along with a date/time stamp using the now() function (hh:mm:ss) is entered into a table in the database as 2 separate columns. I need to make sure that I don't have any 2 barcodes with exactly the same date/time. They must be at least 1 second apart. How can I easily make this happen? I can't control how many times the barcode actually gets scanned.

View 3 Replies View Related

Forms :: Put Barcode In Field When Reader Scans Barcode / It Records Current Time

Nov 11, 2013

I want to be able to put a barcode in a field that when a reader scans the barcode it records the current time. Need it for access control to record who is in and out of the office. Reading other threads I understand it may be possible in Dlookup.

View 3 Replies View Related

Reports :: Barcode Font - Generate Number As Barcode On Report Records

Jun 8, 2013

I am using a barcode font in order to generate a number as a barcode on my report records. In order for my barcode scanner to read the barcode it needs an asterisk at the beginning and at the end.

So, if my record ID is 62 - in order for the barcode to be displayed correctly, it needs to be on the report as *62* .

Without digressing into a discussion on barcode methods in Access, how can I precede and succeed each ID number field with an asterisks?

View 4 Replies View Related

Workstation Service Slowing Access

Oct 30, 2005

Hi All,

When I open a query in design view it can take anything upto 20 seconds to open. Tables are also slow to show, with a marked "slowness" over all. I tried the same database on an old laptop & the tasks were almost instant.

My main machine links to a file server, but the database files are not server based.

After much troubleshooting I have dicovered that it is the XP Workstation Service that is dragging it down. If I stop the service, then Access is rapid!

I have read all I can find on the subject, but nothing that helps. With all the parameters in the Workstation Service in the registry, is there a setting that I can change to speed things up?

System details:

XP Home (SP2)
Access 2002 (SP3)

Many thanks!

Dave

View 4 Replies View Related

Access Databases Won't Open On A Workstation

Feb 22, 2008

I'm having a problem on a workstation that I've always used to create databases in Access. When I open any of my saved .mdb's I get a the error "end query expression" with the table name. The message gives me the option to click OK or Help and Help refers to "<Message> in query expression <expression>. (Error 3075)".

I've copied the .mdb's to another PC with Access installed and they open with no problem and I've removed and reinstalled Access on the problematic PC but still the same problem.


Also, I have a UPS Worldship shipping application that uses an Access database and when it opens it gives me a Micrsoft Visual C++ runtime error then closes, which may or may not be related.

I get the sense that something is corrupted in either Access or Windows XP but I'm not sure where else to look.

Any ideas?

Thanks,

Stuart

View 2 Replies View Related

Duplicate Identifier

Mar 5, 2008

hello,

In excel i used the following formula =IF(COUNTIF(U$2:U$900,U3)>1,"Duplicate","")on one field to find duplicate, but I cannot come up with similar formula on column fields in a table.

Any guidance?

Thank you in advance

Niri

View 1 Replies View Related

Create A Unique Identifier

Aug 22, 2006

Hi All.
Is there a way to index and create a unique identifier using a combination of fields (eg. User# + Provider + Date)?
Thanks.

View 1 Replies View Related

Relationships Identifier In Both Places

Jun 22, 2005

I have a database wit the following fields
have a database with the following Tables

tblCD/Main: CdID - autonumber, CDName - text ...anything else will be a lookup field that we will get from another table, so we will come back to this table

tblAuthorType - AuthorTypeID - autonumber, AuthorTypeName - text. author type name will have, as I see it, 3 types : Composer, Group, Artist.

tblAuthorName - AuthorNameID - autonumber, AuthorName - text, - the name of all authors, composers and artists that u will pick from later
tblecdtrackautonum-trackname track number
Each Artist will be the same for Each CD

the tblCDMain add a AuthorName - lookkup to tblAuthorName
The lookups I understand fine it's relating the identifier the same in both places. I want to have list boxes that display cd groups and cdname the cdnames related only to those groups

How do I try relating the cd name table
to the track listing on the field of cd identifier which is the same in
both places. IS the identifier the same for the primary key
Should put together a query between the two tables, and relate them on that
one field (cd id) then the query will pull the tracks which are listed for
that id and the cd names which are listed for that id.
I need help with this to figure out the identifier is it cdname and cd tracks?
Please someoen help I need a response based on tables for my database NOT ON A DATABASE FROM A BOOK WHERE I CANT SEE A CONNECTION LIKE A PLANTS DATABASE THEN I DONT KNOW IF PLANTS IS THE SAME AS FOR THAT ID. ANY HELP APPREICATED/

mikevds@optonline.net

View 1 Replies View Related

Forms :: Identifier Cannot Be Found

Mar 3, 2015

I have a database with several tabs. On each tab is a form in datasheet view. I have a field that when clicked, will open the corresponding form in a dialog. The code used to open the dialog is: =IIf(IsNull([SalesOps_ID]),"(New)","Open") This creates an underlined Open link which, when clicked, opens the dialog.

An embedded macro is attached to this code, telling it which dialog form to open...and a bunch of other stuff I really can't explain (I'm great at stealing shamelessly from other similar projects but don't completely know what the heck I'm doing).

That said, all the other dialog forms work splendidly using this same type of embedded macro, except one very stubborn dialog form that is giving me fits! Interestingly enough, this form has a subform (all the other forms don't). The form opens, I can edit data on the main part of the form, but if I enter data in the subform, when moving to the next record, I get the error message: The identifier [Tasks].[Project ID] could not be found.

Interestingly enough, I don't have any tables, forms, queries, macros or fields that contain anything like [Tasks] or [Project ID]. If I move off the main record, then return to the record, the data in the subform does not display (however, it is in the table - just not displaying). As if that isn't interesting enough, when I open the dialog form on its own, without using the Embedded Macro from the datasheet form, all that data shows just fine and the form works like it's supposed to.I wish there was a way to simply copy all the text from the macro here, but I can't seem to figure out how in Access 2013.

View 14 Replies View Related

Modules & VBA :: SQL Date / Time Identifier?

Mar 3, 2015

i am having an issue with sql in vba using a variable for a date time field.

i know you identify date variables with #
i know you identify text variables with '

But now i have a date time field that is set to date but when i run the sql it does not find a match. i have confirmed that both rec and ercd match.

Also, when i change the table to text, i am able to match with single quote but i would like to keep the table as date if i can.

Below is the sql statement in question

isql = "SELECT * FROM Table1 WHERE from = '" & nm & "' AND rec = #" & ercd & "# AND sub = '" & esub & "'"

View 5 Replies View Related

General :: Unique Identifier From Different Sources

Nov 27, 2014

I'm looking into create a small unique identifier to put on top of each invoice generated by the database. (.MDB A2010)where '000' its just 3 zeros added for extra badassery, '1' is the actual ID from the database table and -2014 its the current year when the record was added...So maybe I have info from 2 fields (ID, YEAR)... but How do I add the ceros to the ID field... so its 0001 not 1 or 0135 not 135... ???.

View 5 Replies View Related

Tables :: Unique Identifier Over Two Fields On A Table?

Jan 22, 2015

Any way on a table that I can have a unique identifier over two fields? E.g.I have a login ID and a Domain field in a table with sample data below.

Login Domain

John Test
Jane Test
Fred Live
John Live

The login names need to be unique to the domain so the integrity cannot be breached. This has to fit into one table (although the domain is actually being pulled from a look up table so is in fact a numerical value) for ease of form creation.

View 2 Replies View Related

Unique Identifier - Append Primary Key Record

Dec 9, 2014

I have a database in Excel that contains farmers who can be identified by a Unique identifier: MZ-01-0001. The registration details for these farmers are not always up to date. Now when I try to append the data for the farmer with MZ-01-0001; with the primary key set on the Unique identifier, Access does not want to do it since there is already a record in the system. When I remove the primary key it doubles the record, which is also not what I want. So I am wondering what I need to do to append the record while keeping the primary key intact.

View 4 Replies View Related

Tables :: Unique Identifier - Increment For Duplicate Records

Jul 10, 2014

I'm currently in the process of doing a an overhaul of the database including a table, some odd 17,500 records long.

What I need to do is to create a unique identifier from the existing part number, almost like an autonumber, but it only increments when there are duplicates. What I mean is that there would be for example, there would be five records of say, part 000135.

What I'm trying to get at is, how I would have to code to grab the existing part numbers (all formatted to be 6 digits), add an extra 2 digits to be its unique identifier, and then save it all to a Unique Identifier column, that I created.

An example of what I want is say, I have part numbers 000135 and 000136. The numbers would go up from 000135-01, 000135-02, 000135-03, 000136-01, 000136-02.... The dash is not as important as implementing the 2 digit unique identifier.

View 5 Replies View Related

Forms :: Filter Multiple Criteria - Unique Identifier

Jun 20, 2014

I have a large table with information about different cars, called "Car Metadata". In this, each car has a unique identifier ("Car Code"), the make ("Manufacturer Name") and the model ("Short Model").

What I want to do is create a form with dropdown menus.I have a first combo box with all the makes in the Metadata table.

What I am having trouble with is that I want a second combo box underneath which would only show the models which correspond to the make selected in the first box.E.g. someone could select Ford in the top box and the second box would only show Fiesta, Focus etc.

Once it has done that I want it to be able to write the Car Codes for the records which match up to the make & model selected to a new table. Just to complicate things further, there can be multiple records with the same make and model but different Codes, I want all these multiple codes to be written to the final table.

View 4 Replies View Related

Tables :: Automatic Numbering System - Identifier Of Task

Jul 30, 2013

I like to have a Auto number field in my table (tbltask) that use below codification

B10000001

Where B = Base code and 000001 = Identifier of the task.

The identifier of the task is a unique 7 digits number

View 5 Replies View Related

Adding A Unique Identifier Field To A Table With Lots Of Data

Jan 9, 2007

Hi,

I wonder if someone can help with what must be an easy solution to this problem.

I have a table with 350,000 records, but without a unique identifier field. I just want a simple incrementing number field to become the primary key but dont know how to add this in. I cannot add an autonumber as there are two many records - it falls over.

Ive tried exporting it all to excel, but as well as being cumbersome, something went wrong and so I'm back to square one.

I think there must be a way to add an incrementing number either via a query or in VBA but I dont know how. Please can somebody provide a solution.

Thanks,
Adam.

View 2 Replies View Related

Tables :: Empty Date Field - Using As Unique Identifier In Index?

Mar 5, 2013

To prevent duplicate records, I use multiple fields indexes, which worked fine until now. I learned that each "empty" fields are consider unique by Access, so not the best in an index to prevent duplicate records. I managed to have it worked using the default value property to give each "empty" records the same value.

Now my problem is that I have a date field which is optional, but I need to use it as a unique identifier in an index. I could again use a default value, but since it has to be a date, I find it confusing. I would rather have a default value of "No date specified" or "-" or even better, "". Unfortunately none of those works with date fields.

View 7 Replies View Related

How To Add Auto-generated Unique Identifier Field To Existing Table

Jul 22, 2013

Have a table with data in it and I want to add a new field to uniquely identify each record (simple numerical sequence like 1, 2, 3, 4.....). I don't know VBA and don't know SQL.

Tried opening the table in design view, adding a new field with "autonumber" as the data type but get the following error msg: "File sharing lock count exceeded. Increase MaxLocksPerFile registry entry". The table has about 750,000 records in it.

View 1 Replies View Related

Combine Two Columns To Display Information In Third Column As Unique Identifier

Jul 23, 2015

So i have a access database with a main field that we can call vendor # (LIFNR) and another called Company code (BUKRS). There are multiple company codes under a single vendor #. Example:

LIFNR
BUKRS

0000010535
1010

0000010535
5060

0000010535
5610

0000010536
1010

0000010536
5060

0000010536
5610

What I am trying to do is create a 3rd column where i can have a unique row for each of these fields without it repeating. There is no unique identifier in this table and that is what i am trying to achieve.

View 3 Replies View Related

Risk Assessment Database - "rollup Risk Scores" From Workstation To Department...

Jan 3, 2008

I don't know if it'll make sense out of context like that.

I am working on a Risk Assessment database, where a factory can be assessed to see which risks exist at workstations/departments or the whole facility.

So Assessments can be either a Workstation, a Department or a Site level.

Within each assessment there are multiple risks, each of which receives a numeric "score" (assigned by assessors). Let's say that it's 1-100 scale.

I need a way to "roll up" (or summarize) the scores, so that the whole assessment can display a "total" risk score. But it's not just adding up of the individuals - there are "weighting" multipliers we use, because we want to emphasize high risks.

Also, multiple workstations' rollup Score needs to "roll up" to their department, so that a department's score is "made up" of individual workstation scores. Also using the same weighting multipliers.

Then, the departments are rolled up to the whole facility.

The database has a table of the weighting multipliers so if a Risk Score is 75 or higher, it's to be multiplied by 10, 50-75 - multiply by 8 and so forth.

I can't come up with a way to do this through queries or code.

thanks!

View 12 Replies View Related

Queries :: Two Tables To Result In Single Column With Field Name Identifier For Each Record

Apr 27, 2015

How to get this one to display in a single column.

I know how to do this wiht VBA. But, this output will need to reside on a SQL Server View. So I need a SQL language solution. If it can work in MS Access Query, it won't be too difficult to test then translate to SQL Server.

Customer Table with PK Customer_ID.

There are two tables with FK Customer_ID.

1. Table Lease1 - Has 3 Fields - the form code enforces No Fields -or All Fields. The red * indicate a Required field - These 3 are entered together.

2. Table Lease2 - Has 1 field with 0 to Many records.

Goal:

The Type shows up in a single column.

Each Type shows where the data comes from (Lease Type, Surface Owner, Mineral Owner, or Hz Lease Type)

Challenge:

Lease1 table has 3 fields that need to be transformed into a single column.

Lease2 table has 1 field to be appended to the single table.

Then, there is the column that identifies where the data came from based on the column name.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved