Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
T curser?
- Thread starter bigandfat
- Start date
I do know if there are Pdox commands that will tell you that. May be someone here might know.
You could, however, use the table record’s arrive and depart methods to track when the user enters and leaves a record. The downside is there could be performance hit and you may have problems tracking multiple users.
I guess you should ask yourself what exactly do you want to accomplish here? Why do you need to know who is at what record at any given time?
You could, however, use the table record’s arrive and depart methods to track when the user enters and leaves a record. The downside is there could be performance hit and you may have problems tracking multiple users.
I guess you should ask yourself what exactly do you want to accomplish here? Why do you need to know who is at what record at any given time?
- Thread starter
- #4
Additional info of reading user record position:
I have a master table indexed by a timestamp. I want to link a second table to the master using the timestamp field. To make an entry in the second field I want the user to select the time from the master table, and I will code this field into the second table. ( entering the time and date correctly was a problem. I have them copying and pasting the timestamp now, but this also has its problems.
I have a master table indexed by a timestamp. I want to link a second table to the master using the timestamp field. To make an entry in the second field I want the user to select the time from the master table, and I will code this field into the second table. ( entering the time and date correctly was a problem. I have them copying and pasting the timestamp now, but this also has its problems.
- Thread starter
- #6
The master table timestamp is generated when a process control system dumps out 240 variables when a roll of paper is made. The second table contains quality testing information done on this paper. Not every roll of paper is tested and it may be tested at a later time. I would like the user to select the timestamp of the paper roll ( in the first table )then double click to enter this timestamp in the second table. I later will display test results and sensor readings in a chart.
I hope this explains things a little better.
Thanks
I hope this explains things a little better.
Thanks
First question, the second table will contain only the timestamp?
Second question, does your form display multiple records from the master table or a single record?
If you only need the timestamp in the second table, and you have only a single record displayed on your form, then my solution would be best, although I would just make a button for them to click that would enter a new record into the second table, which if linked by timestamp will automatically enter the timestamp into the second table.
On my test form, I display one record from the master table at a time and a blank field from the secondary table (in this case a dummy field named tested). I named the dummy field from the secondary table as tested. Then the button has the code:
tested = "X"
test.postrecord()
Since the timestamp is the key field in the secondary table, it is automatically entered. I couldn't get this to work with just the timestamp field, I needed at least one other field in the secondary table that got a new value.
Second question, does your form display multiple records from the master table or a single record?
If you only need the timestamp in the second table, and you have only a single record displayed on your form, then my solution would be best, although I would just make a button for them to click that would enter a new record into the second table, which if linked by timestamp will automatically enter the timestamp into the second table.
On my test form, I display one record from the master table at a time and a blank field from the secondary table (in this case a dummy field named tested). I named the dummy field from the secondary table as tested. Then the button has the code:
tested = "X"
test.postrecord()
Since the timestamp is the key field in the secondary table, it is automatically entered. I couldn't get this to work with just the timestamp field, I needed at least one other field in the secondary table that got a new value.
- Status
Similar threads
- Locked
- Helpful tip
- Locked
- Question
- Locked
- Question