Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.
Set TNAME = Form!frm_Staff.Form!FName & " " & Form!frm_Staff.Form!Lname"
Private Sub btn_AddtoTeam_Click() Dim db As DAO.Database Dim rst As Recordset Dim strsql As String Dim TNAME As String Set db = CurrentDb Set rst = db.OpenRecordset(strsql) strsql = "Select Top 1 * from Team" Set TNAME = Form!frm_Staff.Form!FName & " " & Form!frm_Staff.Form!Lname rst.AddNew rst!TeamName = TNAME rst.Update Set rst = Nothing Set db = Nothing Exit Sub End Sub
|How can I open a Sql file and run all the script in it?||9||28|
|Concatination in Query Problem.||38||46|
|update query variable with apostrope||7||16|
|Access User can't modify a record added to a linked SQL Server table||6||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!