Search results
-
K
Populating One Table With Another Data Using Checkbox
Ken - Copy and paste the entire code in which the error was generated. Thanks, Jim- ketbdnetbp
- Post #6
- Forum: Modules & VBA
-
K
Populating One Table With Another Data Using Checkbox
Ken - You could try something like: Private Sub CheckBoxName_AfterUpdate() If Me![NameofchkBox] = -1 then 'Checks that item was selected Dim dbs as DAO.Database Set dbs = CurrentDB Dim strSQL As String strSQL = "INSERT INTO TableB (FieldB1, FieldB2, FieldB3) " & _ "Values...- ketbdnetbp
- Post #3
- Forum: Modules & VBA
-
K
Export excel from access save field name as file name
Kannan - Google or search Access help for TransferSpreadsheet Method and see if that gets you going in the right direction. Jim- ketbdnetbp
- Post #2
- Forum: General
-
K
coloured text within the same text box
As far as I know, in A2003, the fore color property applies to the entire textbox. So, I don't think it is possible to have multiple colors within the same textbox. In so far as the multiple lines, that is possible. For example on a form, in vba: dim st1 as string st1 = "First Line" &...- ketbdnetbp
- Post #2
- Forum: General
-
K
Introduction...
Good Evening, My name is Jim, I'm from the US. As my username would suggest, I, Know Enough To Be Dangerous, Not Enough To Be Perfect. Thus, I seek to broaden my knowledge in every aspect of Access. My background consists of Governmental Compliance, Finance, Accounting, HR, Process Efficiency...- ketbdnetbp
- Thread
- Replies: 1
- Forum: Introduce Yourself