User Profile

Collapse

Profile Sidebar

Collapse
Shootah
Shootah
Last Activity: Feb 25 '08, 02:45 PM
Joined: Dec 1 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Shootah
    started a topic VBA - Automatically create relationships after importing Excel to Access
    in Visual Basic

    VBA - Automatically create relationships after importing Excel to Access

    Hi,

    I have succeeded in adding automated relationships with refference tables after importing an excel file created from a query to an Access database.

    However I have the following problem:
    When there are values in the excel file which was imported that do not appear in the refference tables because they are not entered yet, or in case they are misspelled, the code blocks and gives me an error message. As I...
    See more | Go to post
    • Shootah
      replied to Enter a variable input in a query
      in Visual Basic
      Found the solution: Needed to put ' " & Value & " ' because it needs 'value' and not just value
      See more | Go to post

        Leave a comment:

      • Shootah
        started a topic Enter a variable input in a query
        in Visual Basic

        Enter a variable input in a query

        Hi,

        I've managed to create this query
        Code:
        test = "Select * FROM table Where fieldvalue = " & value & " ORDER By
        This code works just fine if the value returned is a number (for instance 3)

        When it returns a text, it gives me the error message 3075 "Syntax error (missing operator) in query expression 'Fieldvalue = value x' " where x is the value chosen in a combobox
        ...
        See more | Go to post
        No activity results to display
        Show More
        Working...