Missing dates on copy

[Kila]

I am copying & pasting 2 records many, many times. However, everytime I paste the record, the date fields (2 in each record) come out 11/29/2020 (instead of 11/29/2004) or blank. Any idea why? It takes a lot longer to retype the information in.

Also, if I have to go back & edit the field, I have to change 2004 back to 04, even though the date input mask adjusts if back to 2004. This is probably related.

Thanks!

 

[EmmaJane]

Can I ask what you are copying/pasting and the reasons behind doing it this way ??

 

[Kila]

Database

I have a database with a list of students & residents. There is a subform on my form that I am updating for a number of students. It is not all of them, just a number of them on a list, so Ihave to go in to each one & enter their rotations. A number of them, 8 groups of 12-15 students, will have identical rotation schedules, so I am copying & pasting into each student's file.

 

[EmmaJane]

I have a database with a list of students & residents. There is a subform on my form that I am updating for a number of students. It is not all of them, just a number of them on a list, so Ihave to go in to each one & enter their rotations. A number of them, 8 groups of 12-15 students, will have identical rotation schedules, so I am copying & pasting into each student's file.

okay so do the students change groups, or are the groups static ?

 

[Kila]

No, the groups are static. There is a field with the group number....1 thru 8

 

[EmmaJane]

No, the groups are static. There is a field with the group number....1 thru 8

so couldn't you use an update query to add the info you want for each group

 

[Kila]

I could....

I suppose I could. I have never used an update query before. The information is in 3 tables....the demographic table, the promotions table (names in the update table get a new record annually as they get promoted to the next level...this is where the group number is saved, to associate it with their 3rd med school year) and the rotations table (contains the rotations, which change at various times).

Can you help me get started, as I have never updated before? I am trying to update all the quarterly rotations for each person for the rest of the year, which is 3 rotations. Any suggestions on how to add these 3 new records to the rotations table for the users in a given group?

Thanks for your help!

 

[EmmaJane]

okay confession time.... I never used one either but sounded good , but I would suggest that you post a copy of your DB and someone will point you in the right direction and if not we can try to muddle through

 

[Kila]

I love it!!

Too funny! True to form EmmaJane?

I don't have a solution but I admire the problem.

Anyway, it's no big deal. I'm about halfway done anyway. I was hoping someone would have a quick answer that could help now AND if I come upon the problem in the future. Anyway, The database is VERY big. It will take more time than it is worth to try to shrink it to zip. I suppose I will have to do it the old fashioned way...

Thanks for your suggestions though!

 

[Kila]

What about this...

I WOULD like to know about this part:

Also, if I have to go back & edit the field, I have to change 2004 back to 04, even though the date input mask adjusts if back to 2004. This is probably related.

When I origanally enter a date, I type it in as 9/2/04. When I leave the field, it automatically converts to 9/2/2004. However, if I go back and change the field, say, to 9/3/2004, I get the error message,

The value you entered isn't appropriate for the input mask '99/99/00;0;_' specified for this field.

I have to change the date to 9/3/04, and THEN exit the field, only for the computer to automatically convert it to 9/3/2004. Well, THAT is just downright ANNOYING! Any idea how to fix that? I shouldn't have to change the whole date every time. If the PC converted 04 to 2004, you would think it would recognize it later!

 

[Kila]

FYI...if a date has 8 digits...like 11/29/2004, when I paste it, it always converts the year to 2020, such as 11/20/2020. Otherwise (such as shorter date like 9/3/2004), the field is pasted blank.