Hi,
I'm in need of some help on what seems like a major, complex experiment that I'd like to try out in a access database. I lack the coding skills to do this myself though, so any help would be appreciated.
The idea is to have a database with a standard form with one or more text input boxes in it and a button linked to the process mentioned below.
The idea would be to have a form that has one or more text input boxes in that I can input various strings into it and in a sense update for example table 'A' in column 'A' 'B' or 'C' accoring to the standardized text that's input into the text field on the input form in sequence on "Enter" button or a [Event procedure] form button.
Here's an example of the ideal situation.
Eg.
A) To begin with I'd like to add a new record to table 'A' If i enter a string:
115OC001325202100000000005102762
and press enter (or click a button) it will identify the beginning text "1" and store or send the following text input... "15OC00132520210000000000" to column 'A' and" 5102762" to column 'B' in table 'A' when I press a button (or automatically) and furthermore clear the text field for a new entry.
or
B) in the same table entry if i enter a second string in a second box after the above one like:
200100501000Z0030902
and press enter (or click a button) it will identify the beginning text "2001" and send only the "00501000" text to column 'C' and "Z0030902" text to column 'D' in table 'A'
and
C) if i enter a string in text box 3:
200301000400Z0030702
and press enter (or click a button) it will identify the beginning text "2003" and send only the "01000400" to column 'E' and "Z0030702" text to column 'F' in table 'A'
or if I only enter specific info like topic A) and B) before pressing the button it only updates columns 'A', 'B', 'C', and 'D' and fills the remaining fields with 0 values before moving to the next line item.
So in a sense I'd have 3 text boxes I can update (that auto tab to the next text box after character limit is reached) and then identify text in the said boxes text input and update a table with specific values from the text entered on [Event procedure]?
IS there a way that access can identify text input in specified text boxes (If I enterbegin with 1 or 2001 or 2003 it creates different events) on the text following that text and transfer "specific" values of that string in accordance with the contents to any given table/column?
The process of doing something like this is way beyond me and I hope I've explained everything in a manner that can be understood.
Thanks
I'm in need of some help on what seems like a major, complex experiment that I'd like to try out in a access database. I lack the coding skills to do this myself though, so any help would be appreciated.
The idea is to have a database with a standard form with one or more text input boxes in it and a button linked to the process mentioned below.
The idea would be to have a form that has one or more text input boxes in that I can input various strings into it and in a sense update for example table 'A' in column 'A' 'B' or 'C' accoring to the standardized text that's input into the text field on the input form in sequence on "Enter" button or a [Event procedure] form button.
Here's an example of the ideal situation.
Eg.
A) To begin with I'd like to add a new record to table 'A' If i enter a string:
115OC001325202100000000005102762
and press enter (or click a button) it will identify the beginning text "1" and store or send the following text input... "15OC00132520210000000000" to column 'A' and" 5102762" to column 'B' in table 'A' when I press a button (or automatically) and furthermore clear the text field for a new entry.
or
B) in the same table entry if i enter a second string in a second box after the above one like:
200100501000Z0030902
and press enter (or click a button) it will identify the beginning text "2001" and send only the "00501000" text to column 'C' and "Z0030902" text to column 'D' in table 'A'
and
C) if i enter a string in text box 3:
200301000400Z0030702
and press enter (or click a button) it will identify the beginning text "2003" and send only the "01000400" to column 'E' and "Z0030702" text to column 'F' in table 'A'
or if I only enter specific info like topic A) and B) before pressing the button it only updates columns 'A', 'B', 'C', and 'D' and fills the remaining fields with 0 values before moving to the next line item.
So in a sense I'd have 3 text boxes I can update (that auto tab to the next text box after character limit is reached) and then identify text in the said boxes text input and update a table with specific values from the text entered on [Event procedure]?
IS there a way that access can identify text input in specified text boxes (If I enterbegin with 1 or 2001 or 2003 it creates different events) on the text following that text and transfer "specific" values of that string in accordance with the contents to any given table/column?
The process of doing something like this is way beyond me and I hope I've explained everything in a manner that can be understood.
Thanks
