Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 7th, 2006, 09:10 PM
Registered User
 
Join Date: Aug 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Use a frm based on a qry to update a tbl

Hello, I need to create a form that will automatically appear when I [put in a range of dates on a form] that will include checkboxes based on edition numbers between those dates. I have created a query that displays the edition numbers but can't work out what to do next. Any ideas will be greatly appreciated...
 
Old August 8th, 2006, 10:06 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

Brucifer,
So you want to create a dialog form that allows the user to choose edition numbers via check box and enter date paramenters? How much VB are you comfortable with? Have you met SQL?

Chapter 7 of Beginning Access 2002 VBA has some discussion about this and gives some examples.

HTH,
Loralee






Similar Threads
Thread Thread Starter Forum Replies Last Post
Open & save 1 frm witout closing the prvs frm anukagni Access 3 January 10th, 2006 02:42 AM
get latest record frm transaction tbl jyopallavi SQL Server 2000 1 June 9th, 2005 08:11 AM
update qry to run on page load wolfberg Classic ASP Databases 3 February 11th, 2005 01:23 PM
Update statement with EXISTS condition using 2 TBL simone_rossi@netential.ne SQL Server 2000 3 September 30th, 2004 07:16 AM
Prb: COUNT qry result NOT SAME as SELECT qry savoym SQL Language 5 July 2nd, 2003 04:44 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.