User Profile

Collapse

Profile Sidebar

Collapse
TGVisser
TGVisser
Last Activity: Jun 20 '14, 11:23 AM
Joined: Mar 3 '14
Location: Drachten, Friesland, Netherlands
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • TGVisser
    replied to Copy a selected row from a subform to a new table
    in Access
    Figured it out.

    Code:
        Dim db As DAO.Database
    Dim rs As DAO.Recordset
    Set db = CurrentDb
    Set rs = db.OpenRecordset("FetchTable", dbOpenDynaset)
    
    rs.AddNew
    rs!Aantal = Forms!MainForm.FetchAantalBox.Value
    rs!Omschrijving = Forms!MainForm!SearchTableControl!Omschrijving
    rs!Locatie = Forms!MainForm!SearchTableControl!Locatie
    ...
    See more | Go to post
    Last edited by Rabbit; Mar 3 '14, 05:13 PM. Reason: Fixed code tags.

      Leave a comment:

    • TGVisser
      replied to Microsoft Access Searchbox
      in Access
      The AccountSubform is a datasheet form?
      If so, can't you use a filter?
      Something like:
      Code:
      DoCMD.ApplyFilter "FilterName", "[AccountTable].[ACName] LIKE '*" & [txtSearch].[Value] & "*'", "The name of your subform control"
      See more | Go to post

        Leave a comment:

      • TGVisser
        started a topic Copy a selected row from a subform to a new table
        in Access

        Copy a selected row from a subform to a new table

        Hello all,

        This is my first post/question on here, hope I can make myself clear :)

        My employer wants me to build a storage management system which shows him his current supply of parts.

        What I am trying to do is this:
        I have a datasheet-subform on a normal form.
        This subform shows data from a table (named searchtable).
        The mainform has some controls to filter the data in the subform,...
        See more | Go to post
        No activity results to display
        Show More
        Working...