Search results

I've got it. I'll try as you said and review Northwind sample. Thank u very much for your replies.

So, i've got a complicated table named "Quotation". In the table i have the following field: "Id","Project","Amount1","Amount2", "Amount3","Amount4", "Amount5","Amount6", "Ref1","Ref2", "Ref3","Ref4", "Ref5","Ref6","Date1","Date2", "Date3","Date4","Date5","Date6". "Amount1" is the amount for the...

Actually, what i want to learn is how to compile the right syntax of alter table add column. I've found some syntax in the internet but all of these don't work, just like the code i've shown above. I'm just a beginner of using VBA in access. Please help me to know how to write the right alter...

The table "Times" restore the amount for quotation. I have 2 fields in this table: "First" and "Second". However, in some case, i must send more than 2 quotations for one project. So, i just want create one button which add a new field automatically, because my colleagues don't know to use access.

Hi everyone, i'm very amateur in VB for Access. I'm just want to add a column into a table automatically. I've a table named "Times". Now i want to add a text filed into this table. I name the field "Third". What i write is: Private Sub Toggle8_Click() Dim SQL2 As String SQL2 = "ALTER TABLE...