2.9 Creating a Form from a Query in Access

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
48,411
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Mar 26, 2008

Using a query rather than a table to create a form and select records

Category:

Howto & Style

Tags:

License:

Standard YouTube License

  • likes, 2 dislikes

Link to this comment:

Share to:

Uploader Comments (Firchild)

  • hi can u let me know the query used in the seach there it wud be of great help to me thanks

  • @sweetjithu1985 Already have, it's in tutorial 2.7

  • I've got a table with one column labelled 'customer e-mail address' for thousands of records. How do I single out the customers with an email away from those without? Apologies, I'm a retard in this department.

  • @80slibertine Query the email field with 'is not null'

  • This is quite great.

    Now what I'm trying to do is use the first form to run the query, and the results show up in the second form.

    Am I right to use a macro somewhere in there?

  • Just base a form on the query results, that should do the trick (you can use a macro to open the form, but don't really have to)

see all

All Comments (13)

Sign In or Sign Up now to post a comment!
  • gr8.........

  • very cool. Nice one chief!

  • nice 1 helped out alot these last couple of weeks with my appretaship. thnx 4 the uploads

  • Figured it out today! =) thanks!

    oh & one more thing.

    really reall desperate.

    i've made a form where people input their details. this gets put into a table. now that table has a primary key, a unique number.

    how do i get this number to be displayed to the customer?

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more