User Profile

Collapse

Profile Sidebar

Collapse
chrismaliszewski
chrismaliszewski
Last Activity: Nov 6 '09, 08:19 AM
Joined: Sep 26 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • chrismaliszewski
    replied to [Access-VBA] How to create form which record source are FEW (not only one) tables?
    in Access
    Sorry that I told 'you're wrong'. I wrongly read 'Lastly, there is nothing to indicate where this code comes from.' (i read comes to). I apologies you.

    You said:

    It is because I have two ideas to solve my problem:
    1) Create unbounded form and bound ONLY controls on it (form)
    2) Create bounded with first table form and next change record source table/query to another.
    Code I showed you above is working...
    See more | Go to post

      Leave a comment:

    • chrismaliszewski
      replied to [Access-VBA] How to create form which record source are FEW (not only one) tables?
      in Access
      You're wrong.
      Below I give you me newest version of a code of this module, which work (create form) FOR 1 table. You can use it in every database and it'll create you form of name nazwaFormularza value.

      But before it, im asking - how cant i change this code to create form of more tables?
      I tried to create unbound form with bounded controls using code below:
      Code:
       'Formularz.RecordSource = nazwaTabeli ' UNBOUND form
      ...
      See more | Go to post

        Leave a comment:

      • chrismaliszewski
        replied to [Access-VBA] How to create form which record source are FEW (not only one) tables?
        in Access
        I tried to change RecordSource of a form while the form is already in creation but after that there were error in form (unrecognisable source of data).

        I was thinking about query, but I dont know how to place query as a record source. I know how to do that in graphical interface but not in VBA :( Could you re-write part of a code below to show me how to do this?
        Code:
        'Creation of new form
    Set Formularz = CreateForm
        ...
        See more | Go to post
        Last edited by NeoPa; Sep 27 '09, 08:55 PM. Reason: Please use the [CODE] tags provided.

          Leave a comment:

        • chrismaliszewski
          started a topic [Access-VBA] How to create form which record source are FEW (not only one) tables?
          in Access

          [Access-VBA] How to create form which record source are FEW (not only one) tables?

          Hi.

          I created code which makes dynamically form with bounded controls for all columns. I show it to you below.

          My problem is, how I have to change this code to create form which record source are few (e.x. 2) tables?

          Thank you for help

          If you want to use this code, you only have to change value of:
          - nazwaTabeli (table's name of which you want to create form)
          - nazwaForlumarza...
          See more | Go to post
          Last edited by NeoPa; Sep 26 '09, 10:10 PM. Reason: Please use the [CODE] tags provided.
          No activity results to display
          Show More
          Working...