Search results

Hold on. This is more tricky. I'll be back on this on Monday.

OK I'm a little stuck. Here's what I have so far: Dim stDocName As String Dim RecordToCopy As Integer Me.AllowAdditions = True RecordToCopy = Me.WorkRecordID 'Dupe the Main Record DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 2, ...

I think I understand the first half of what you say... I can create the queries, infact I have probably already have them done in some form on the reporting side of my DB, and they work. So a query for each subform... i think i get it. This is where my VBA experience falls off. How do I call...

I am working on a fairly complex many-to-many database and want to add a feature to allow a user to copy the current record as a new one by clicking a button on the form. It is set up as a main form bound to a query (to calculate time) and there are 6 subforms, each bound to a separate table...

I had the same issue... I just added Me.AllowAdditions = True before the code that is generated by the wizard and it took care of the paste append error. Note that this was in Access 2003, but sounds like exactly the same deal.

Argh......

Thanks for that... You are absolutely right, and this is essentially how the database is set up. I know that I am on the right track as far as the logic goes, and I know how to create the queries that will produce what i need to report on. My specific issue, is that there are many applications...

Thanks for your feedback. If I use table-driven ListBoxes (I can see where that's better) I would need to allow multiple selections. How do you put each item selected into it's own cell in the record, so they can be queried/reported on individually? I am sure this is not a big deal, but I...

I am creating a simple Access database that allows users to record the time they spend servicing an application, or set of applications. The form (ProTrak_1) is esssentially a set of check boxes for users to select the apps they work on. What I am trying to do is get the database to look (in...