Peter,
My answers in yellow First, if you need to create identical records then your database design almost certainly doesn't conform to basic principles of normalization. If you want to improve that situation, many people online will be eager to point you in the right direction. What do you mean basic principals of normalization, are you saying I am not using the Db to its best advantage? That well may be, this is the first time I have tried to build one in Access. I had been using Works previously and it is much easier to use but is not email compatible. Second, why can't you do it? Because you don't know how, or because you're getting an error message? I get an error message that says the data does not conform to the input mask for that field.but I am trying to copy the entire record with 178 fields.why is it editing one field To select a record in datasheet view, you can click the record-selector area, at the left side of the window, that corresponds to the record you want to copy. I can do that To copy the record, you can use the edit menu. I did that and that works To paste the data into a new record, select the blank row at the bottom of the datasheet (the "new record" row). This is where the error occurs Then paste the data, which you can also do with the edit menu. If you receive an error message, note the exact wording of the message, and post it here for more help. Good luck, Peter Hoogenboom --- In [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com, "CapitalLease" <[EMAIL PROTECTED]> wrote: > > I have a DB of customers some of whom I do business with multiple times > but for different reasons each time. I need to be able to copy the > record, "cut and paste" the record, to create a new identical record. > So far I am unable to do it. Any ideas? > [Non-text portions of this message have been removed]
