var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Updating Table with VBA
Does anyone know how to update a table in Access with a line of VBA code?
As an example...say you have a inputbox that asks for the users name...how can you pass that name into a table with VBA.
Thanks for the help.
To insert into a table:
SQLStr = "INSERT INTO [Table]([Number], [Name]]) VALUES (1, "Bill")
To update an existing record in a table:
SQLStr = "UPDATE [Table] SET [Name] = """ & Person & """ WHERE [Number] = " & Num
Beware of minor syntax errors I did this on the way out the door.
Hope it helps...
Also be careful not to violate any primary key rules and create dupliates and that sort of thing.