I really hope this is easy...I inherited the maintenance of an Access database from someone...I am OK with Access, but a complete novice at VBA.
My database needs to read manufacturing log files. Here's a very simplistic idea of what the files USED to look like:
Partition number: 1
Serial number: 1001
_________________
Partition number: 1
Placement #: 1
Part#: 12345
Partition number: 1
Placement #: 2
Part#: 23456
However they have changed the process so that the equipment builds several serial numbers at once, in different partitions. So a log file might look like this:
Partition number: 1
Serial number: 1001
Partition number: 2
Serial number: 1002
Partition number: 3
Serial number: 1003
_________________
Partition number: 1
Placement #: 1
Part #: 12345
Partition number: 2
Placement #: 1
Part #: 12345
etc...
The point of this database is to link Part # with Serial number. Since there was only one serial number per log file before, there is a
Dim Tile_Serial as String
statement in the front of the VBA code, as the parser expects to read one and only one serial number.
I am hoping to find out two things:
1. How do I change Tile_Serial into an array or something so that I can match parts to serial numbers? The serial numbers per build can vary between one and three.
2. Assuming I make it an array, how will it be treated differently from string variables? They are all I have so far. Basically I need to ensure that as the parser goes down the log file and sees a "Partition number", it stores that somehow so it will be linked to the Serial number through that Partition number.
I am really, really hoping this is easy to update. I just got put on an assignment I'm not yet qualified for, and it's taken me forever to decipher what this code actually does. Any help anyone can provide will be really appreciated!!
My database needs to read manufacturing log files. Here's a very simplistic idea of what the files USED to look like:
Partition number: 1
Serial number: 1001
_________________
Partition number: 1
Placement #: 1
Part#: 12345
Partition number: 1
Placement #: 2
Part#: 23456
However they have changed the process so that the equipment builds several serial numbers at once, in different partitions. So a log file might look like this:
Partition number: 1
Serial number: 1001
Partition number: 2
Serial number: 1002
Partition number: 3
Serial number: 1003
_________________
Partition number: 1
Placement #: 1
Part #: 12345
Partition number: 2
Placement #: 1
Part #: 12345
etc...
The point of this database is to link Part # with Serial number. Since there was only one serial number per log file before, there is a
Dim Tile_Serial as String
statement in the front of the VBA code, as the parser expects to read one and only one serial number.
I am hoping to find out two things:
1. How do I change Tile_Serial into an array or something so that I can match parts to serial numbers? The serial numbers per build can vary between one and three.
2. Assuming I make it an array, how will it be treated differently from string variables? They are all I have so far. Basically I need to ensure that as the parser goes down the log file and sees a "Partition number", it stores that somehow so it will be linked to the Serial number through that Partition number.
I am really, really hoping this is easy to update. I just got put on an assignment I'm not yet qualified for, and it's taken me forever to decipher what this code actually does. Any help anyone can provide will be really appreciated!!