Timeline for How can I turn each record on my Access table into 6 records?
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 27, 2017 at 23:02 | vote | accept | Exodus212 | ||
| Nov 23, 2017 at 7:24 | comment | added | C Perkins | Although Access macros include commands which can navigate open table views, such a DataSheet view cannot be manipulated like other programmable datasets (e.g. DAO.Recordset using VBA). Even after calling GoToRecord on an "open table", if you subsequently call RunDataMacro it is not provided any context for editing records. In other words, the data macro has no idea what record the datasheet view is accessing so it fails. If you insist on using macros, you should consider the ForEachRecord command within the data macro. Otherwise, i can't say much for macros and suggest using SQL instead. | |
| Nov 22, 2017 at 16:46 | comment | added | C Perkins | I wish you only the best in learning Access, but there are just too many details to "clarify". That is not to say that other questions / answers could not be improved to help someone learning like you, but clarifying such an answer for a newbie would essentially require writing an entire tutorial for Access. Such general tutorials already exist. It's impossible to guess which details you know and which you don't. What you're asking is not a basic task and so requires some advanced knowledge. I suggest testing and debugging each small part of your macros separately before trying the whole thing | |
| Nov 22, 2017 at 16:33 | comment | added | Exodus212 | I did not take a screenshot of the full macro. There are 4 more CreateRecords down below. | |
| Nov 22, 2017 at 16:31 | comment | added | C Perkins | Aside from the critical errors in the macros, the basic flow does not match what you intend to do. You repeat the SubMacro for each record in the table, but you only insert one new record each time. There is nothing which adds multiple new records for a single source record. You would need to run the macro many times, but then you would need to manually update the macro values and add filter criteria, etc. In summary, something is critically wrong with the logic of the macros and it is too difficult to explain how to fix it. There are better, alternative approaches. | |
| Nov 22, 2017 at 4:30 | answer | added | C Perkins | timeline score: 0 | |
| Nov 21, 2017 at 23:32 | review | First posts | |||
| Nov 21, 2017 at 23:38 | |||||
| Nov 21, 2017 at 23:32 | history | asked | Exodus212 | CC BY-SA 3.0 |