Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-11-2018, 02:47 AM   #1
hazell
Newly Registered User
 
Join Date: Jul 2013
Posts: 54
Thanks: 4
Thanked 0 Times in 0 Posts
hazell is on a distinguished road
Buttons To Record # of Contacts

Hi All,
I am trying to set up a simple form for our receptionist to record where she signposts callers to, and wanted her to be able to just click a button on a form that says Dept A or Dept B etc. I don't need to record any details except the date, which is updated automatically and a counter for each department.
Any ideas on the best way to do this?
Thanks

hazell is offline   Reply With Quote
Old 10-11-2018, 04:02 AM   #2
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 9,465
Thanks: 358
Thanked 774 Times in 739 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Buttons To Record # of Contacts

You should be able to do this with a single table and two update queries and a Form.

Have fields in the table:- ID, Department, fCount...
ID would be an auto increment field,
Department Text
fCount I reckon an integer would do

Place in the first department field an "A" to represent department "A" and in the next field "B" to represent department "B" ... Have the default value for the count field to be 0..

Now open the query builder grid and select your table "tblDeptCount" create a select query which returns the row containing "A" Now change the select query to an update query and under the fCount field is an area for calculations. I think it's called "Update To" ... You need something like:- fCount = fCount + 1

Now create a form:- frmCountDept
On the form create a command button have the "wizard" selected and you should have the option to select a query. Select the query for updating "A"
Create another button just the same to run the query for updating "B"
__________________
Code:
                 |||||
               @(~‘^‘~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Old 10-11-2018, 04:06 AM   #3
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 9,465
Thanks: 358
Thanked 774 Times in 739 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Buttons To Record # of Contacts

It's not clear how you want to record the date, whether you want to record the date for each button press or whether you want to record the date for the totals for each day. I assume the second. However thinking about it, you would be better off recordings a date for each key press and then summing the results. If that's the case then you would need a different set up!

__________________
Code:
                 |||||
               @(~‘^‘~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Old 10-11-2018, 08:42 AM   #4
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 9,465
Thanks: 358
Thanked 774 Times in 739 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Buttons To Record # of Contacts

Seeing as you have not yet replied. I Went ahead and did a sample based on guessing what you want.
Attached Files
File Type: zip Buttons To Record # of Contacts_1a.zip (323.0 KB, 3 views)

__________________
Code:
                 |||||
               @(~‘^‘~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Next record/previous record buttons not working moehrchen Forms 2 01-09-2013 06:12 AM
Multiple Contacts as a single record cmadams General 3 08-27-2010 08:46 AM
Record buttons Bee General 4 09-13-2006 06:40 AM
[SOLVED] New Record, Delete Record, Next, previous Command Buttons virodriguez Macros 1 07-25-2005 04:39 PM
Round buttons or Oval buttons instead of the normal square buttons Tommy_Hilfiger Forms 2 05-30-2005 02:52 AM




All times are GMT -8. The time now is 05:57 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World