Is this possible?
I have a Mitutoyo device that can be connected to a variety of Mitutoyo measuring instruments (in my case, it's a micrometer.) When triggered, the device obtains a measurement value from the instrument. One can view this value via serial communication in a program like HyperTerminal.
Is it possible to input these values directly, or indirectly, into Access?
Thanks ahead.
Hi.
I am new here, and looking for some help.
My problem is:
I have some sensors connected to Rs232 and i want the data to get directly to access. Today I use a solution that goes through some C++ program i made to a textfile and then I manually import to access.
The input looks something like this:
001 , 1688 , 789 (lots of them ;))
(id----nr-----nr)
And I want it to go directly to a table in access.
I am pretty new at access, so I am not sure what to do. help me please!
Does anyone know how to get input from a com port and parse it into access?
View 1 Replies View RelatedI am importing a table from a Clarion TPS database which stores several types of data in a "IDVAL" field. The field next to it, "LBLNUM" defines what the data type is. This creates a problem, as IDVAL is a text field, which means all data stored in it (no matter what the type) is then stored as text. This includes date fields. Since they are stored as text, they end up as 5 digit serial dates, similar to how excel handles dates (with each day after 1/1/1900 being +1).
So I have a union query which derives all the values stored in IDVAL for each unique record. My query which creates my export combines this data with several calculated fields to create my final export.
Everything looks great on this final export except for my date fields, which are all 5 digit numbers (like 77945).
I have been searching for a date function that will format this back to a standard date, however I have yet to find anything that works. Is there no way to format a 5 digit serial date back to a standard date within access by using a function? Every answer I find says to redefine the table to a date field, however I don't have this option since the field in question stores a lot more than just dates.
Hi
Is any body know how to retrieve the manufacturer's hard disk serial No.? I want to use it in my access application to avoid piracy. At present I am useing a code which gives me Volume serial No., which got changed when ever my user format his hard drive. Instead of HDD firmware serial, code for retrieval of any other permanent No. like mother board or CPU firmware serial can help me to solve my problem
Rahul
I've searched through the forum looking for what i want to do with no luck so hopefully one of you kind people could help.
I'm setting up a DB that logs in a batch of parts to which i generate a batch no.
As the batch progressess through the works when a problem arises we generate fault records (I've set up another table for this and linked the batch no fields together). I want to put a serial no. on this form consisting of 'year' 'batch No.' and ?'Auto number'? From reading posts is it best to put the 3 items in seperate fields (less hassle)
My 2 questions are
1, how do i extract just the year from a date field?
2, This is the main problem. The auto number. If i use auto number to generate a unique number to log the record the number will be massive in no time at all. This is fine as the unique identifier for the record in a table but not for the serial number of the printed report. Idealy I want to have the batch number then a serial number that resets to 1 on a different batch No. For example
21098/1
21098/2 Batch No./serial No.
21098/3
22309/1
22309/2
22309/3
Just some more info this database is a multi user database split front and rear.
I hope i've explained this well enough, many thanks for your help in advance
cheers
EQ
I want a field to be a serial number made up of a letter of the alphabet followed by 3 digits. I want the digits to increase by 1 in each of the following record. For Example the serial number in the first record would be A001, then followed by A002, A003, ....., A142, A143, A144 & so on. I am fairly new at Access but I have experimented with AutoNumber, it won't work if the Field is not a pure mumber, can't get autonumbering to happen if I treat the field as text. I don't know where to go from here.
Any help is much appreciated.
Rob Shakesbeer
I have the following code for the text field (Before Update)
If IsNull(Me![DyNo]) Then
Me![DyNo] = Format(Nz(DMax("[DyNo]", "[tblAllDet]", "[TheYear]='" & Year(Date) & "'"), 0) + 1, "00000")
End If
Me![DyNo] = Format([DyNo], "00000")
The code starts giving numbers from 00001, 00002, 00003 and so on. The problem was that when I have to search, I have to type the zeros before the number i.e. 00007, 00008 etc. otherwise the search form doesn’t show the relevant record. Ideally, I would like the numbering system to be 1, 2, 3, etc. (without the zeros). I tried changing the code to “0” but with the single “0”, I am unable to insert records beyond No.10. Is there a way to change this code so that I get only 1, 2, 3 etc and not with preceding zeros ? Grateful for help.
Hi, I have been trying to make a datbase so I can input the serial number of an electronic device (cell phone boards) , and also would like to be able to add additional info about the device. Most importantly I have to be able to "search" for the device by typing the serial number in a search box.
So lets say I have serial number 11111, 11112, 11113, 11114 listed in the database as "intermittent power failures", before I use the device I can type the serial number in the database and be able to recall the details. So if I type in 11119 and no hits come back, I know that one is not in the system yet; meaning it ethere does not have a problem, or the problem has not been discovered yet. If I type in 111111 for example, it would come back as a hit, saying it has an "intermittent power failure" problem. I have spent about 4 hours messing with access, I used it a while back in office 03, however I have never did anything like that, and to make things further complicated we now only have office 07. Does anyone have a template which is similar (I can modify the values) or know how to assist me to be able to create a database like this?
I'm in the process of streamlining the process to maintain our various access reports and queries.
My company's accounting software stores all record dates in Gregorian Serial format (don't ask me why). Currently for our reports we have a local hard-coded table that is manually updated periodically with dates in MM/DD/YYYY format and the coresponding Gregorian serial date number. To go from date to serial is a fairly straightforward access function of:
(Datediff('d','1/1/2000',[Date to convert])+730120)
For example if [Date to convert] was 2/7/2006 the output would be 732349. That's all well and good, however I am in need of a query I can build that will on the fly generate a list from say 1/1/1997 through 1 year after day being run just to be safe with two columns, one with date and one with the serial date equivelant so I can link to the accounting tables for date restrictions.
This way I just have to have the equation in one query instead of a hard coded table or do the calculation in every form or query that needs to look up these tables.
Unfortuantely I've been staring at accounting data (and am not an accountant) way too long and my brain is fried, suggestions?
I have seen some API that gets the serial of the hard drive, but this information is not unique and changes when the volume is formated.
Does any one know of a way to return the orignal manufucture's information/serial which is unique(GUID) to the volume.
Any Idea will be highly appreciated.
Hi,
I have a table that uses SerialNo as primary key. From time to time (its a long story...) I need to go in and update the SerialNo by adding x to it. Here's the problem: lets say the table has SerialNo's 1,2,3,4,5, and I try to add 1. I get 4 KV error's because of course, 2,3,4,5 already exist in the table. (So I would end up with 1,2,3,4,6 instead of 2,3,4,5,6.)
I really thought that Access should be smart enough to figure out that there really won't be any key violations after the updates are done, but I guess not.
So, what's the easiest way to deal with this?
Thanks for any suggestions.
Hope someone can help
I have a small test database which I'm doing for our dispatch dept.
It contains: Order No. / Customer / Ship_Date / Serial numbers (multiple)
I'm looking for a way to create a search query that will search though all the records to find a particular serial number.
There fields in the table are:
Shipping_Date
Customer
Order_No
Pallet_ID
Serial_1
Serial_2
Serial_3
Serial_4
etc
I need it to come back with the order number and pallet that it was shipped on.
Any ideas?
Thanks,
Paul
I would like to produce a serial which will have 4 members.The first, the second and the fourth members will be always CAPITAL Letters and the thirth one is always NUMBER.Here is an example for the format: AC3H
Each member will change in any line and never match... I would like to produce it by a button or a button for each one.The last important point for this issue is; I would llike to identfy the total number of serials.
Using MS Access 2010 I'm attempting to put together a simple database mainly tracking dates and availability. That said I'm just not smart enough to figure out why I cant get one date in a form to display as a serial date.
Example date picker included in Access 2010 places the date of 3/20/2013 in one field and I want another field to look at that and show the serial date ie.. 20130320190912. I've achieved this in Excel somehow long ago.
I want to create Customized Serial Primary Keys and dont know how to go about it.
View 7 Replies View RelatedI am working on a database,
Structure of database tblaccounts: glcode,description.
tbltransaction: transaction ID, glcod, tranxtype, amount, trandate
Everything is going well, when i make a transc ,transcid generated
i,e 1,2,3,to 47,48,49,50 and so on. In this case there are minimum 50 transaction on daily bases,
Here i have an idea that daily after 11.59pm, I mean after changing date, when I make a transaction, transaction id or sequence no start from 1, and my last day data will also remain safe .
This is what I am trying to accomplish I need to be able to create a serial number which automatically resets every day so I may use it to easily know how many records were created per day, without running a report.
I have a table that has a field for SerialNumberStart and QtyRequired, from those two I have a calculated field for the SerialNumberEnd.
I want to print a report from this table that if for example I have StartSerialNumber 34 and SerialNumberEnd 40 prints one report for each serial number.
I am working in ms access database form. I have a form with detail section. In detail section i would like to make sr.no field auto increase each time new quotation is created. Using AutoNumber didn't work because because it doesn't start the serial number from 1 for each new quotation.
Snap shot is also attached.
I have a simple database that I put my execptions in for the day for scanning. Is there a way that my serial field on my forum can check to see if someone already scanned that serial for that day using the "On Lost Focus" event.
View 7 Replies View RelatedI am using an access program with a form with detail section. I would like to create auto sr.No when i am creating a new quotation. Using Autonumber didn't work because it start numbering from last quotation.
Snap shot is also attached.
does anyone know how to get a serial cash drawer with kick back interface to open through Access?
any help or a point in the right direction will be hugely appreciated
I am attempting to modify some code that is used for reading content in an Outlook mail and need to catch and move the email if certain content is duplicated in the email.
The code reads the email that is in the attached image format:
As seen, this email contains 2 devices, but the Serial No in both is duplicated.
In the code, I need to capture this and rather than reading the contents, I need to just move this email to a separate "Manual" folder to be dealt with separately, so not to write the information to the database.
The current code is as follows:
Option Explicit
Private ns As Outlook.Namespace
Private sEmailAddress As String
Private sPerson As String
Private dReceived As Date
[Code] .....
I have two tables that I want to append to each other.But in one of them the date column has the yyyymmdd format and in the other it is a serial date number.How can I make them consistent by either converting yyyymmdd to date number or by converting the date number to yyyymmdd?
View 1 Replies View RelatedUsing Access 2010
How do I send the command "^G" to a device connected via serial port (RS-232) number 3?
I am trying to construct a system in access where I can have a user type in a part number, revision of a part, job number, serial number quantity, and generate a serial number based on the quantity that they need.
I am getting hung up on even how to construct the tables effectively to accomplish this, let alone the forms, queries, etc.
The numbers have to be in the following form. XXXX-XXXX
For an example:
I have part ABC and I need 5 serial numbers.
I need to be able to create a batch of serial numbers automagically that reads like:
9001-0001
9001-0002
9001-0003
9001-0004
9001-0005
Then for the next part XYZ I need 3 serial numbers. It would be constructed like this:
9002-0001
9002-0002
9002-0003
With the goal of eventually being able to search a part number and revision, or a job number and return all serial numbers assigned to that.
Is this possible in MS Access?