User Profile

Collapse

Profile Sidebar

Collapse
AkiMatti
AkiMatti
Last Activity: Oct 24 '06, 12:54 PM
Joined: Oct 13 '06
Location: Finland
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • AkiMatti
    started a topic Newbie problem! Cannot find advice for this anywhere.
    in Access

    Newbie problem! Cannot find advice for this anywhere.

    Hi!

    I'm making a form that has checkboxes and want to handle the checked checkboxes in code. The problem is that I don't know how to do it! Here is what I've tried so far:
    Code:
    Private Sub cmd_update_Click()
On Error GoTo Err_cmd_update_Click
    
Dim rowsToUpdate As String

    If check_a.Value Then
        rowsToUpdate = rowsToUpdate & "A"
    End If
    ...
    See more | Go to post
    • AkiMatti
      replied to Calling a module function from a form - Compile error!
      in Access
      Makes sense. Strange that the given error message didn't quite point to that direction, though......
      See more | Go to post

        Leave a comment:

      • AkiMatti
        replied to Calling a module function from a form - Compile error!
        in Access
        Actually, often when I try to call simply the function name, Access wants to create a new macro or sub, which would be set to call the function. I wonder why is this?

        Strangely, my problem got solved when I changed the name of one of my variables. I just changed
        Code:
         Dim instr As String
        into
        Code:
         Dim instru As String
        and the errors were gone. Still, I didn't even find any variables with the same name. I wonder what cause those errors...
        See more | Go to post

          Leave a comment:

        • AkiMatti
          started a topic Calling a module function from a form - Compile error!
          in Access

          Calling a module function from a form - Compile error!

          Hi!

          I'm using MS Access 2002 and have troubles calling my function in a module I've created. When I try to even write the call of the function, it instantly gives me an error saying: "Compile Error Expected: (" eventhough I have the '(' in there. Sometimes it expects a '=' symbol instead, wanting me to bind the call to some variable I guess. What should I do? The function I'm calling does not return any parameters.
          ...
          See more | Go to post
          No activity results to display
          Show More
          Working...