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 June 24th, 2005, 05:47 AM
Friend of Wrox
 
Join Date: Mar 2005
Posts: 264
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to design a query for this bounded form

Hi Every body. I have Time Keeping datasheet form like the picture below.

http://i5.photobucket.com/albums/y180/method007/timekeepingform.jpg ( timekeeping form)

I want to create a bounded form for it but i do not know how to create the query for it and bound each fields to that query.Also since i want to keep the refrential integrity of my db i want to know what controle types should i use for each field such as text box or combo box,list box ...).I be happy if some expert teach me how to design and write the query for this form as it is my first attempt to make bounded form and i do not have much experience with designing bounded forms and tables joins in access 2000. Furthermore i only want total hours from hours a day part in my bounded form. Thank u and looking forward for some replies.

Note: My tables are in sql server 2000 and i linked to it

http://i5.photobucket.com/albums/y18...etionship4.jpg ( Table reletionships)





Similar Threads
Thread Thread Starter Forum Replies Last Post
In need help with query design.... seananderson MySQL 1 March 29th, 2007 10:02 AM
How to add constraint to access bounded form. method Access 1 June 28th, 2005 10:39 AM
Problem with bounded form query method Access 0 June 23rd, 2005 12:01 PM
Error updating record in bounded form method Access 0 June 19th, 2005 05:31 PM
How to delete current record in bounded form? method Access 0 June 19th, 2005 04:37 PM





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