Search results

I have a tab control with a number of tabs based on the Infant table. My last two tabs on the tab control contain subforms with information contained on the Mother table. There is a one (Mom) to many relationship, with the Mother ID being a foreign key in the Infant table. May be a stupid...

I have 3 tables, Patient, Preg, Visits. Estab relationships bet Patient and Preg (1 to M) and Preg to Visits (1 to M). I have created a table with the primary keys concatenated in Patient and Visits, done a make table query with the existing Pat and Preg tables, and created relationships with...

Timer fixed Thanks so much for the help. I had the field in the table that was bound to the form set to TIME instead of number, as soon as I changed that, it worked fine. The attachment let me check all the properties and make sure I had them all set right. Thanks again!

Timer problem Followed all your instructions and rechecked everything. txtTime default value = 0 (on hidden text box). Timer interval 1000 on form. On timer event in form set with Me.txtTime=Me.txtTime + 1. txtTime's control is Time in the table bound to the form. Is there some code I need...

Timer event I made the txtTimer (hidden) textbox have the control property set to the timeinterval field in the table that contains all the data for this form ( the form is bound to the table). This DB is set up where each form = a table (note, I did not design this monster). For instance...

Newbee question re caption In table design view, you can name your field name something like id_no. Then in the caption area, you can use Employee ID # and that will be the column heading when you look at the table in datasheet view. It will also carry thru to a label if you use the form...

Caption problem I think you may mean the description part of the table. If you enter information in there it will display down in the status bar area below your table, and not change the column name. Is that what you wanted to do?

Timer Where did the txtStart come from, or is that txtTime (the hidden text box created?) On the onClose event of the form I would like to have the timer stop, the elapsed time (in the hidden text box???) to be recorded in a table (I set the control of the hidden text box to the elapsed time...

In the thread "timing an event " it was discussed how to time how long a person played snooker and figure their total time. My question is if I have a form and want to start a timer when the person begins to enter and end it when they exit the form, then send the record number and time spent...

In the thread "timing an event " it was discussed how to time how long a person played snooker and figure their total time. My question is if I have a form and want to start a timer when the person begins to enter and end it when they exit the form, then send the record number and time spent...

Code to use for time log? Could you give me an example of the code you would use?

Is there code that can be used for measure how long a record is being entered? My user hits a switchboard button for a particular form, and it opens in enter new record mode. She enters thru it, then hits a button that takes her on to the next form. Is there a time stamp that will log how...

I have a several tab tab control. On pages 1 & 2 when I exit the last text box and hit CTR+Tab I am taken to the next tab with information on the same person I have been working on. On pg. 3 however, when I exit the last textbox, I stay on the same page and am advanced to the next person's...

I would like to format a table field using the current year (2002) then a 3 to 5 digit number (some will have a three digit, some a five). This will be a text field. Any suggestions?

I have a non-relational db with entries for patients each time they have a procedure. Did a find duplicates query to find multiple times the person had a procedure. Would like to calculate the times between the two procedures. How can I say person ID procedure date 1 - person ID (which should...