Reports

same problem 13 years later:
these VB-Codes don't work, have you an idea?
    '________________________________ T E S T S um den Standartwert AUTOMATISCH einzustellen _______________________________________________
    'SQLtext = "ALTER TABLE " & dtnamenstab1!Name & " ADD COLUMN ChangeDate2 DATETIME NOT NULL DEFAULT '" & Now() & "' AFTER preceding_col"
    'SQLtext = "ALTER TABLE " & dtnamenstab1!Name & " ADD COLUMN ChangeDate2 DATETIME NOT NULL DEFAULT 20241119143000 AFTER preceding_col"
    'SQLtext = "ALTER TABLE " & dtnamenstab1!Name & " ADD COLUMN ChangeDate2 DATETIME NOT NULL DEFAULT ""20241119143000"" AFTER preceding_col"
    'SQLtext = "ALTER TABLE " & dtnamenstab1!Name & " ADD COLUMN ChangeDate2 DATETIME NOT NULL DEFAULT 20241119143000"
    
    'SQLtext = "Alter Table " & dtnamenstab1!Name & " ALTER ChangeDate DATETIME DEFAULT set " & Now()
    'dbdatenbank.Execute "ALTER TABLE " & dtnamenstab1!Name & " ALTER Changedate DATETIME DEFAULT NOW() NOT NULL;"
    'SQLtext = "ALTER TABLE " & dtnamenstab1!Name & " Modify ChangeDate2 Datetime DEFAULT"
79230924
