Hi everyone, small problem. I want to make a support / call logging program for myself to help me at work, but am stuck on the very first part!!!
As soon as access loads, a form is opened up. This form, when run, creates a table called "Week Ending :" & Date -where date is always the last day / Friday of the week.
Please can you tell me where the below is going wrong? I am trying to create a new table with Access DAO with 2 column headings.
Thank you every one
Code:Private Sub Form_Load() Dim Newfld As Variant, Newfld2 As Variant CurrentDb.CreateTableDef (Date) Set Newfld = CurrentDb.TableDefs("Week Ending :" & Date).CreateField("Customer", "text") Set Newfld2 = CurrentDb.TableDefs("Week Ending :" & Date).CreateField("Support Issue", "text") Set Newfld = Nothing Set Newfld2 = Nothing End Sub





Reply With Quote