Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Use command button to import new records
I have to import and excel file with 3 columns, all of which match columns in access table1. The excel file is named newdata.xls and data is in columns a, b and c. Is there any way I can import this in to table1 with the user simply pressing a command button? I find that access frequently...- haygordon
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
Update query SQL error
In table1 I have a field "Teacher" and I want the data from row 4 to be inserted into table2 "outteacher" where the "yeargoup"= 6P I have tried this sql code: UPDATE Table1 SET Table1.Outteacher = Table2.teacher.[tbl2ID] = "4" WHERE (((Table1.Yeargroup)="6P")); Thereis an error but I can't...- haygordon
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
-
Getting rid of excess blank spaces.
I have a textbox that gathers information from many fields using the code: =[forename] & " " & [outcomment1] & " " & [outjoin1] & " " & [outcomment2] & " " & [outjoin2] & " " & [outcomment3] & " " & [outjoin3] & " " & [outcomment4] & " " & [outjoin4] & " " & [outcomment5] & " " & [outjoin5] & "...- haygordon
- Thread
- Replies: 10
- Forum: Microsoft: Access Forms
