Recent content by Michael Auer

Can anyone help me with this? Moniker was kind to write the code, I just am not quite sure what to do with it at this point. As I stated earlier, I would like to put a button on the form to run this code to copy the contents of fields 6-10 of the current record and paste them into fields 1-5 of...

Moniker, I would like to use a button on the form I created to run this code. I tried pasting your code inside the button's code, but I get an error message that says: "Compile error: Expected end sub." Will a button on a form run this code? Thanks! Mike

Thank you so much, Moniker! I will try it and let you know how it works for me. Mike

Unfortunately I do not have access to the database right now. For argument's sake, let's call them Table1 and Field1, Field2, etc. through Field10.

Thanks, KeithG. The database was created by someone else, and I am trying to help him with this challenge. The data is probably not normalized. The form shows one record at a time and is sorted by date. There is no autonumber field. One could use the navigation buttons to go from record 27 to...

Thank you, Mike375 and Moniker. If, for example, I am looking at record 27 in the form, I would like to copy the contents of fields 6-10 of that record and paste those contents into fields 1-5 of the already existing record 28, of which fields 1-5 are empty before the paste.

Is it possible to create a query and/or macro to copy fields 6-10 of the current record seen in a form to fields 1-5 of the next, already existing record in the table? The typical append query wants to create a new record, but I want the fields to be copied to the next record which already...

Hello. I would like to create a button on a subform that would copy the contents of, for example, fields 1 & 2 of the current record and paste them into fields 3 & 4 of a new record on a different subform. Both subforms are used to enter data into the same table, just different fields for each...

Thanks, Uncle Gizmo. I'll give that a try. The other thing I thought of is to change the font color to white in the text boxes, etc. I like your idea better though. Mike

Hello. I need to create a report that will be printed and used as a paper form on which people will enter information to eventually be transferred to my database. The source will be a table, and the report will need to show all fields from the table, even when more fields are added to the table...

Here is the link to the Microsoft web page: http://support.microsoft.com/default.aspx?scid=kb;en-us;285353 I have not solved the problem yet of the alphabetical order of the names in the drop-down. Please let me know how yours turns out. Mike

Hello, all. I am new to this forum and am impressed with the knowledge and support offered here. I have just added a search drop-down to my DAP and added the necessary code to allow me to click on a name in the drop-down to show that record. It works great in finding the records except that the...