Search results for query: *

Gotcha, well what you've given me so far is perfect. The error does show when I run the button on the first record, but that wont be a problem if thats the only error. Thanks

You mean if I want to copy the field in the very last record to my first?

Thanks! It works perfectly. Looks like the bookmark was missing. Thanks again, I have been trying to find the answer to this for over a week.

Sorry, let me clarify. I have been trying it only on the second record of my form, and am getting the error at re.MovePrevious.

Hey Remou, There is an error with my "rs.MovePrevious". Everything else seems to be fine. Do I need to program an event or a procedure for it? My code is the still the same as my last post.

Alright I made the adjustments, but when i click on the button now an error message pops up: "Run-time error '3021': No Current Record" Here is my code as it is now: Option Compare Database Private Sub Command37_Click() Set rs = Me.RecordsetClone rs.MovePrevious Me.Text27 = rs!Label28...

Thanks for clarifying. I am still screwing something up though... When I press the button, my VB explorer pops up showing the code and ".txt1 =" is highlighted and a message saying "Compile Error: Method or data member cannot be found" pops up. Here is my code: Option Compare Database...

Hi Remou, Thanks. How do I use this code as a button?

Hey all, Im creating a form right now that has several fields that users will enter information into. When they hit enter the info and hit next, another identical page will come up that they have to fill out the same way with new info. Sometimes there will be multiple entries that may have one...

Thanks, I will have to download Outlook 07 i guess

Hi all, I am trying to send certain selected fields from a database to several email recipients (similar to Mail Merge in Microsoft Word). When I go to External Data--> Create Email, it says I need Outlook 07 to use the function. Is there anyway to do this with Access 07 and Outlook 03? Or...