User Profile

Collapse

Profile Sidebar

Collapse
swanny
swanny
Last Activity: Oct 22 '07, 02:44 PM
Joined: Jun 5 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • swanny
    started a topic Results in table form
    in Access

    Results in table form

    Hi all

    Can i have a results table for all search results and lists, so loads of new windows dont keep opening each search and be able to click on a record and flick back to form view with that reccord.

    Maybe a stab object with one tab as a results table......

    i know this is brief...if anyone has any pointers
    See more | Go to post
    • swanny
      replied to Date problems
      in Visual Basic
      the column in the database is date...so
      Code:
      WHERE date = #01/01/2001#  AND
      Nothing happening...i need it for the date stated to the present,what do the # symbols do?

      sorry to be a pain!...
      See more | Go to post

        Leave a comment:

      • swanny
        replied to Date problems
        in Visual Basic
        Hi Killer42

        Sorry 1st post

        I've taken over a work database and it has a access 2002 database sheet with a vb 6 front end.

        The line off code is:

        Code:
        rs.Open "SELECT * FROM JobBook WHERE bookedby = 'Alex'  AND status <> 'Cancelled' AND status <> 'completed' AND status <> 'Recalled' AND status <> 'Recall' AND status <> 'Recall - in Progress' AND printed = false
        ...
        See more | Go to post

          Leave a comment:

        • swanny
          started a topic Date problems
          in Visual Basic

          Date problems

          Hi

          I am trying to search for records after a certain date,new to code and require pointing in the right direction.


          Thanks
          See more | Go to post
          No activity results to display
          Show More
          Working...