Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
Function MakeData() Dim StrSQL As String Dim db As Database 'Current database. Dim lng As Long 'Loop controller. Dim rs As DAO.Recordset 'Table to append to. Dim lng1 As Long 'Loop controller. Dim rs1 As DAO.Recordset 'Table to append from. Dim ACCOUNT As String Dim YEAR As String Dim USER As String Dim REPEAT As Integer Dim TYPEREC As String 'StrSQL = "Delete * from tblPrint where user =" & fOSUserName() & ";" 'DoCmd.SetWarnings False 'DoCmd.RunSQL StrSQL 'DoCmd.SetWarnings True Set db = DBEngine(0)(0) Set rs1 = db.OpenRecordset("select * from ppPidList2 ;") Set rs = db.OpenRecordset("tblPrint", dbOpenDynaset, dbAppendOnly) Do While Not rs1.EOF ACCOUNT = rs1!ACCOUNT YEAR = rs1!YEAR USER = rs1!USER REPEAT = rs1!REPEAT TYPEREC = rs1!TYPE Set rs = db.OpenRecordset("tblPrint", dbOpenDynaset, dbAppendOnly) With rs For lng = 1 To REPEAT .AddNew !ACCOUNT = ACCOUNT !YEAR = YEAR !USER = USER !TYPE = TYPEREC .Update Next End With rs.Close Loop Set rs = Nothing Set db = Nothing Set rs1 = Nothing Set db = Nothing End Function
|ms/acceee link a subform to a control||9||23|
|Copy all data from a access table paste to the same table and change PK in access||17||42|
|MS Word Formatting||3||25|
|Report not displaying all of the data from 2 sub reports in Access 2010||6||17|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!