Remove 3S From Scanned Entry
Aug 9, 2007
I am working on an access 2003 database for our Shipping Dept that is using tables created from odbc linked tables from a SQL Svr Database. The shipper will scan the BatchNo barcode to a field on a form. If the BatchNo Scanned follows the Format: 07317751 the number is found and the rest of the fields are populated and written to another table(Dock_. This will work fine as long as the 8 character BatchNo Matches. My problem is the Barcode has 2 leading characters (3S) that are inserted when the label is printed by "Bartender" for the AS/400 to identify. I need to remove these 2 characters in order for the "Select DistinctRow" lookup command string will populate the remaining fields. I am only a novice when it comes to programming and this is probably an easy job but I am stumped. I can zip a copy of the DB (With the Data lookup tables populated) to anyone needing to see the complete structure if it will help. My thanks in advance to all responders.
Bob
View Replies
ADVERTISEMENT
Apr 9, 2008
Dear Expertise..
How I can store scanned object in Access. Becuase I have a employee database. I have to store all employees signature in the database Also I have to verify thier signature with the previously stored in database when they are trying to log .
With Thanks
Polachan
View 2 Replies
View Related
May 16, 2013
I have 2773 equipment records, a form for each and each equipment needs to tested annaully. I use the form to update Test Date and Tester. Tester may change for each equipment. I need either a Combo box with 6 different scanned signatures or an image box that changes based on a combo box I already have that contains the Tester's initials.I can get a sample DB or step by step instructions.
View 1 Replies
View Related
Jun 25, 2014
How to filter between times that trays are scanned. I want it to tell me basically how many trays are scanned between 9:00 to 17:00 17:01 to 1:00 and 1:00 to 8:59 but not having any luck. I've been able to get it to show me everything from 1:00 to 8:59 but I've not been able to get anything else to work.
View 6 Replies
View Related
Jul 30, 2014
I found the IDatomation Datamatrix barcode in the ActiveX controls.
Is buying their software the only way to actually get this barcode to work?
Any other way to create a 2D matrix that can be populated with data and scanned once printed?
View 12 Replies
View Related
Apr 20, 2013
I would like to be able to add more than one scanned document and link them to one record.
If it is possible, I would like to have a command something like "Attach file" on the form displaying the record. The user could browse to find the scanned document and it becomes a link. The user could then scan and browse for another document, which becomes a second link, in some kind of list box.
View 14 Replies
View Related
Jun 8, 2015
I'm a access novice who is looking to create a database to store training records for permanent and agency staff, and contractors staff. I need the database to be able to produce reports on how many courses were trained over each month, and the total duration of the course completed (in hours).
View 2 Replies
View Related
Aug 6, 2014
I have a database that makes use of standing orders. That means that if a client has a standing order to receive products during for example 4 time as year (quartely at the end of the month). to automate the new entry by copying an old entry in the database.
Let's say I have a client where we will have to send a product at the end of June, it will look at a field where the next send date is, and when it reaches 2 weeks for that date, to create a new entry in the database based on that entry. This way, it will pop-up in our open cases and we are aware of it and also will be visible in our report.
View 1 Replies
View Related
Sep 8, 2013
I am working on creating an access database for tracking physical assets linked to locations. I need to make a combo box list to show items other than the current location of the asset. Basically I need it to refer to last enery of the user and define the new possible entries. so we have a unique relationship between location and asset. The assets and location will always remain fixed and there is never going to be any addition. I am creating a web form so that it can be uploaded into sharepoint.
View 3 Replies
View Related
Dec 7, 2006
Hi i have created a plotchart and at the bottom of the chart it is displayed as SUM of SUM of apr 05 etc for all the months is there anyway i can remove the sum of before each month??
thanks :)
View 1 Replies
View Related
Jul 24, 2005
Hi,
I just went through the User-level Security Wizard and added security. I now can't log on using a username I created.
How can I get my database back? I have the back up file but how can I get all the stuff back without this security on the database?
PLEASE HELP!!
Cheers
Bizzy
View 1 Replies
View Related
Oct 17, 2005
Hi
Need a little help with the following, running windows ME on a Compaq Presario Desktop, connected to Blueyonder Broadband, Blueyonder have provided a new anti virus and firewall package free of charge to broadband users, you need to remove your existing Virus and firewall package(McAfee) to load the new, which I have done, it appears that I still have remnants of a previous Norton Firewall, the only reference to it is when you access through the control panel and the add/remove programme, I have tried many times to remove it but the text is still there.
I have searched for it but nothing comes up as found.
Many thanks
Derek
View 1 Replies
View Related
May 20, 2006
I have an enormous Post Code Table 1.7 million records, which I must update every month into usable sectors for our carrier cross refs, the UK postcode is in the format CB6 3HQ, CB6 3HR, CB6 3HS, CB6 3HT, CB6 3HW etc I need to be able to remove the space then only use the first 4 chrs ie CB63, in the above examples I know I could do a search and replace " " with "" but I need this to be run automaticly where would be the best place to do this and if coded how?
Any help or alternative suggetions appriciated
View 6 Replies
View Related
Jul 22, 2005
:confused: I am importing a file from excel into access. The table has about 6300 records. Some records are duplicates or even triplicates. How do I write a querie to leave only 1 of of these records and rmove the duplicates.
Second, I will be importing new files weekly that after I do the above I will need to append to the first table and then remove duplicates. How dod I do this.
thanks
View 5 Replies
View Related
Sep 1, 2005
Hi All,
I have one serious emergency.
I have 2 options (2 qeustions) in front of me.
[1] How can I remove primary key and not the column
[2] How can I rename the column which is primary key.
Please help me.
Thanks in advance
Jigs
View 3 Replies
View Related
Oct 1, 2005
I have an access database and table name called student. The table includes field name such as identification_id and registration_no. The value in identification_id is 3434-34-213 and registration_no are 234/45. Can i query the field name so i can get both value without the sign - and / so the output will be 343434213 for identification_id and 23445 for registration_no?
View 5 Replies
View Related
Nov 4, 2005
Hi,
i want to replace spaces in my query, but there are a few hard parts in it.
I dont always know how many spaces. en second, the spaces that need to be replaced are after the first character. The rest needs to be removed.
i have:
----1----1----2
the "-" are spaces!!
and i want it to show
1.1.2
this is what i tried replace([MinutesID];" ";".") & " - " & [minutesTitle]
can someone assist...
thanks
View 2 Replies
View Related
Jan 11, 2006
Hello, Tried a search but could'nt come up with an answer.
I have a number field with an amount.
The format will always change as far as the LEN is concerned.
I need to remove the decimal.
There will always be 2 numbers to the right of the decimal but the left will always change.
Example:
21543.11 Need 2154311
11.20 Need 1120
Thanks in advance! :)
View 3 Replies
View Related
Mar 30, 2007
I have a big table with belgian tax numbers all in this format:
BE 401.031.867
I would like to remove the "BE" and the "." which are in this field so i have only the numbers.
Cant figure it out myself, any help would be greatly apprieciated
View 2 Replies
View Related
Apr 12, 2007
I have a query linked to a main frame database. One of the fields is [significance] and gets a number 1-20. Usually when this data is entered, it gets multiple significance numbers. This causes my query to return separate records for each significance number. For example if case number 123 is given significance codes 1, 5 and 12, then my query returns 3 records.
I need a query that will show all records one time that have a significance code other than 12. This would be easy if there were not duplicate entries for the same case number because I could simply say "Not 12". So in the example above, my query returns 2 records showing significance codes 1 and 5. But I don't want to see the record for case number 123 because it also has a 12 significance code.
So what is the best way to handle this?
I appreciate the help.
Jim
View 1 Replies
View Related
Jun 14, 2007
If have a table with billing occurances and one of the fields is "business name" how would I need to setup a make table query which lists unique occurances within that data?
Essentially, I want to remove duplicates. If ABC Pet Store has 5 billing occurances and XYZ Pet Store has 1... I want both to only be listed once.
I hope that makes sense. Thanks for any help as to how to set this up!
View 1 Replies
View Related
Feb 22, 2008
Hi,
Is there a way that i can remove the space in between the cahracters of the string.
like: 78- ASDGFKGJ OR 78-SJDHF AJSDFH TO RESULT IN 78-ASDGFKGJ / 78-SJDHFAJSDFH
THANKS SO MUCH
View 10 Replies
View Related
Mar 15, 2005
Is it possible to remove a filter using VBA.
I need to remove a filter on a form when a user clicks on a drop down box.
View 1 Replies
View Related
Dec 13, 2005
Hi
When I filter on a form on our database, I cannot then remove this filter. In order to continue working i have to exit the database completely!
Please help!
View 1 Replies
View Related
Sep 3, 2004
I would like to remove duplicates from the following query. I would like it to display only one record depending on the InvoiceID. So only show one unique record based on Invoices.InvoiceID. Thanks!
SELECT DISTINCT Invoices.InvoiceID, Invoices.CustomerID, InvoiceDetails.InvoiceDetailID, Invoices.InvoiceDate
FROM InvoiceDetails INNER JOIN Invoices ON InvoiceDetails.InvoiceID = Invoices.InvoiceID
WHERE (((Invoices.InvoiceDate) Between #8/1/2004# And #8/31/2004#) AND ((InvoiceDetails.DeliverBy)=0))
ORDER BY Invoices.InvoiceID;
View 1 Replies
View Related
Aug 18, 2004
Hi,
I need to remove the automatic (empty) new row that access produces under the last record in the table, because i
would like to remove it when i view a query.
Could any of you kind people suggest a way that i could do this??
thanks for you help.
View 2 Replies
View Related