Search results

  1. I

    Referring to table: Variable not defined

    Dear Access experts, here am I again with my new problem. I want to populate the RowSource for my combo box on a form filtering it by a value in the table field. I’m running the following Sub on the GotFocus event of the combo box (CBO) in the FORM. When I debug it, I get a compile error...
  2. I

    Very simple syntax issue

    Dear Access experts, excuse me for asking questions about primitive things, but this is really confusing when you only start using VBA. I'm trying to do something totally simple: Dim strString As String strString = "TEXT" "TABLE.Field1" = strString I keep getting a syntax error. I guess there...
  3. I

    What is instead IN statement in VBA?

    Dear Access experts, excuse me if my question is very simple, but I am entirely new to VBA. I need to write an IF... Then... Else statement where the conditions run the check whether a certain value is found in a table. Something like: If strString is IN [tblTable]![Field] Then But there is...
  4. I

    Saving choices from combo box

    Dear Access experts, I am a student of linguistics trying to build my first database with Access, and I'm looking for help, although I realize my problem is something very basic. I have two tables, tblDictionary and tblCorpus which are connected through their IDs. And I have a form, frmFORM...
Back
Top Bottom