User Profile

Collapse

Profile Sidebar

Collapse
sebtus
sebtus
Last Activity: Dec 2 '10, 07:03 PM
Joined: Sep 12 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • sebtus
    started a topic How to Edit Record In Ms Access?
    in Visual Basic

    How to Edit Record In Ms Access?

    I have the following code to edit an existing record.

    Code:
    If DCount("ID", "AssignLoc", "[ID] = '" & Me.ID & "'") > 0 Then
Set db = CurrentDb
Set rs = db.OpenRecordset("AssignLoc")
                        rs.Edit
                        rs("ID") = Me.ID
                        rs("AssignLoc") = Me.AssignLoc
    ...
    See more | Go to post
    • sebtus
      started a topic How to pass a criteria to Query from Form/via Button click
      in Visual Basic

      How to pass a criteria to Query from Form/via Button click

      I need help with this task...

      I have a form "myForm" which has multiple buttons on it, such as “John”, “Tom”.. etc, I have one Report "Parts Report" and Query "Parts Query" for that report, Query has a field "Owner".

      Case Example: when button "John" is click a report is generated and all entries with [Owner]="John" are listed

      When “Tom”...
      See more | Go to post
      No activity results to display
      Show More
      Working...