Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Access

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-04-2008, 09:14 PM
Novice
 
Join Date: Oct 2008
Posts: 4
Sharron is on a distinguished road
Default Please could you tell me how best to set up form and table/s

Select staff member
Form shows ¼ hour increments down left side (starting at 9am and finishing at 3pm) and days of week across top
Cells inside these show the placement or empty if no placement listed for that timeframe
If a new placement required then
Select day, select starttime, select endtime, select placement
This will then update the table with a new record and update the form above to reflect the additions filling in the placement in all cells between starttime and endtime.
If a modification is required then
Click in cell with starttime
Combo for select day, select starttime, select endtime, select placement show the relevant info
Changes are made by changing the info in the combo boxes or by clicking delete this record to remove the entry all together.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show information from another table in this form Pires7 Forms 0 11-11-2008 04:15 AM
Update table from calculated field in a form BernardKane Forms 3 11-28-2006 06:48 AM
how can i access many table to one form T_777 Forms 1 11-20-2006 03:51 AM
Not able to add a record to a table through a form tigers Forms 0 06-30-2006 07:00 AM
I need to update a data field on a form and not on its table Wrangler Forms 2 03-15-2006 10:43 PM


All times are GMT -8. The time now is 03:02 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.