Recent content by SeaRox

Success! Thanks odin1701!:D I removed the acCmdSaveRecord line and the Me.requery on the WeekOf field. (and got rid of the code from the other "duplicate record" buttons I tried.) Now it works.

Still frustrated I've read through Bob Larson's tutorial here: http://www.btabdevelopment.com/main/QuickTutorials/Easywaytorememberhowtoreferencesubforms/tabid/76/Default.aspx I've tried every combination I can think of to reference the sub form. Still no luck.

I'm not an expert but the VBA I've seen has had the DoCmd in front. If it works without it I'm not shure why it would make a difference but it may. DoCmd.RunCommand acCmdSelectAllRecords DoCmd.RunCommand acCmdCopy DoCmd.RunCommand acCmdPasteAppend

DB Posted Here is the portion of the DB. It took a little bit to get it small enough to post. Thank you for taking the time to look.:) I am really stumped.:confused:

I created a sub form to track labor hours. I designed it and tested it before I put it in the main form. It is a continuous form. I used the Command Button wizard to insert a button to duplicate the records. It worked better than I had anticipated. I have a default value in the date field...

llkhoutx, I am tracking labor hours and the job, project, customer, etc. are all the same. The only things that change are the date and number of hours worked on each job. It will greatly speed data entry for the employees if they can copy records and just change the hours they worked. I...

My duplicate record button works perfectly when the form is open seperately. When I open the form as a sub form the button no longer functions properly. It creates a new record but it doesn't copy any of the information. I have tried changing the code but to no avail. See code below. This...

Someone else could probably help you better with the exact code but if you put some code in the "Default Value" you can have it look up the value you want (maybe with DLookUp function) using the Date function (Date-1) as a criteria.

I tried taking the Me.Requery out. It still did the same thing. The link by Bob Larson that was suggested is a good one to bookmark. I tried several different combinations of the references but either I'm doing it wrong or they dont work for DoCmd. Since it wasn't the Me.Requery that was the...

Probably an easy fix for someone with a little more experience. I have a continuous form that I designed as a subform. I have a "copy record" button at the bottom. When I open the form by it's self the button works perfectly. When I open the main form and click the copy button in the sub form...

boblarson, I put in the command you suggested. The errors have ceased, but it still does't link the record being copied to the employee. I tried changing the Control Source and the Row Source around and I got it to link to the employee but then it didn't copy any of the information from the...

I've played with the suggested code: Me.txtTotal = nz([SundayHours]+[MondayHours]+[TuesdayHours]+[WednesdayHours]+[ThursdayHours]+[FridayHours]+[SaturdayHours]) If I put it in the form OnCurrent and AfterUpdate events it gives me the total for the record that is selected. I assume because I am...

DB uploaded I have pared it down so the file is small enough to upload. It opens to the form I am working on. To view an employees hours click on the drop down arrow (combo box) in the upper right hand corner. I want to be able to copy and paste (or use the copy button) and just change the...

Working on reducing the file size to post.

Rabbie, That is true. The record I am copying has a valid value in that field. So why when I copy that record is it telling me that it is not valid? I tried removing all the required fields and it gives me another error. I didn't copy the exact wording but it says that the records that...