Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-16-2018, 04:52 AM   #1
Gasman
Access newbie
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 2,056
Thanks: 261
Thanked 307 Times in 292 Posts
Gasman will become famous soon enough Gasman will become famous soon enough
Form to show created/amended details?

Hi all,

I have started adding fields to my tables for Created Date, Created Bty, Amended date and Amended By.

Rather than have these take up real estate on every form, I was thinking of having a common form that would be opened from a small button on each form, as I would probably only want to see this data when something goes awry.

What would be the chosen/best way to approach this please. ?

TIA

__________________
Access novice. Sometimes trying to give something back.
Access 2007
Gasman is online now   Reply With Quote
Old 03-16-2018, 05:03 AM   #2
ridders
Newbee moderator
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 5,536
Thanks: 79
Thanked 1,373 Times in 1,282 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
Re: Form to show created/amended details?

How about a listbox of all forms.
Select a form from the list to open a report with the details

You could adapt the example in this link:
https://www.access-programmers.co.uk...d.php?t=295597
__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left and leave a comment.

New example databases:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


-------------------------
nil illegitimi carborundum est
ridders is offline   Reply With Quote
Old 03-16-2018, 05:07 AM   #3
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,190
Thanks: 54
Thanked 1,986 Times in 1,899 Posts
arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough
Re: Form to show created/amended details?

You can use Data macro. It diesnt need a form, transparent and akways git triggered.

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 03-16-2018, 05:09 AM   #4
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 2,928
Thanks: 0
Thanked 642 Times in 627 Posts
Ranman256 will become famous soon enough
Re: Form to show created/amended details?

i hide them as easter eggs.
usu there is a header label...CUSTOMERS...or whatever.
dbl-click the label ,and the window with that info pops.
Ranman256 is offline   Reply With Quote
Old 03-16-2018, 06:29 AM   #5
Gasman
Access newbie
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 2,056
Thanks: 261
Thanked 307 Times in 292 Posts
Gasman will become famous soon enough Gasman will become famous soon enough
Re: Form to show created/amended details?

Quote:
Originally Posted by arnelgp View Post
You can use Data macro. It diesnt need a form, transparent and akways git triggered.
Only have 2007 arnelgp
__________________
Access novice. Sometimes trying to give something back.
Access 2007
Gasman is online now   Reply With Quote
Old 03-16-2018, 06:34 AM   #6
Gasman
Access newbie
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 2,056
Thanks: 261
Thanked 307 Times in 292 Posts
Gasman will become famous soon enough Gasman will become famous soon enough
Re: Form to show created/amended details?

Quote:
Originally Posted by Ranman256 View Post
i hide them as easter eggs.
usu there is a header label...CUSTOMERS...or whatever.
dbl-click the label ,and the window with that info pops.
Ranman256,

It is how best to get the data into the new form, with the least code required in case of mods.?

Can I pass the record as an object, rather than 4 fields in OpenArgs

Pat Hartman mentioned in another thread (https://www.access-programmers.co.uk/forums/showthread.php?t=297855) that one did not need a control for the source, and I was trying to utilise that method to save having 4 fields, small and hidden on each form?
__________________
Access novice. Sometimes trying to give something back.
Access 2007
Gasman is online now   Reply With Quote
Old 03-16-2018, 06:37 AM   #7
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,190
Thanks: 54
Thanked 1,986 Times in 1,899 Posts
arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough
Re: Form to show created/amended details?

I think it exists in a2k7.

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 03-16-2018, 06:38 AM   #8
Gasman
Access newbie
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 2,056
Thanks: 261
Thanked 307 Times in 292 Posts
Gasman will become famous soon enough Gasman will become famous soon enough
Re: Form to show created/amended details?

Quote:
Originally Posted by ridders View Post
How about a listbox of all forms.
Select a form from the list to open a report with the details

You could adapt the example in this link:
https://www.access-programmers.co.uk...d.php?t=295597
Hi Colin,
No I was thinking more of just the records of a form with a button (or Ranman256 label) that would show the details for a particular record. I want to be able to see the details of certain records to find out why something has gone wrong.
__________________
Access novice. Sometimes trying to give something back.
Access 2007
Gasman is online now   Reply With Quote
Old 03-16-2018, 06:58 AM   #9
Gasman
Access newbie
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 2,056
Thanks: 261
Thanked 307 Times in 292 Posts
Gasman will become famous soon enough Gasman will become famous soon enough
Re: Form to show created/amended details?

Quote:
Originally Posted by arnelgp View Post
I think it exists in a2k7.
From support.office.com ?

Data macros are a new feature of Access 2010 which enable you to add logic to events that occur in tables, such as adding, updating, or deleting data. They are similar to "triggers" in Microsoft SQL Server.
__________________
Access novice. Sometimes trying to give something back.
Access 2007
Gasman is online now   Reply With Quote
Old 03-16-2018, 09:08 AM   #10
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,203
Thanks: 13
Thanked 1,364 Times in 1,300 Posts
Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light
Re: Form to show created/amended details?

You don't have to bind these fields to form controls. They only need to be in the form's RecordSource for you to populate them.

I rarely show these fields on forms because they just take up room. They are mostly for reference in case of a problem. If you want to give the user the option of seeing them but not waste the space, use a small button to pop up a message box that shows them if the user wants to see them.

MsgBox = "Changed By = " & Me.ChangedBy & " ON " & Me.ChangeDT
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 03-16-2018, 09:32 AM   #11
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Posts: 1,243
Thanks: 13
Thanked 236 Times in 234 Posts
Mark_ will become famous soon enough
Re: Form to show created/amended details?

Alternate approach is to use a separate table to save this type of data. Table holds Updated Tables name, Updated Tables Primary ID, Date of change, Who made the change, and "Add/Edit/Delete" to show what they did. You can then make a small global piece of code to do this and simply pass the appropriate values from any form that can modify data.

This keeps it out of the hands of users and allows you to quickly identify who is doing what to what as its not spread over multiple tables.
Mark_ is offline   Reply With Quote
Old 03-16-2018, 10:11 AM   #12
Gasman
Access newbie
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 2,056
Thanks: 261
Thanked 307 Times in 292 Posts
Gasman will become famous soon enough Gasman will become famous soon enough
Re: Form to show created/amended details?

Hi Pat,
I remember you saying that in another thread where you helped me.
I tried in work and it kept complaining it could not find the data, yet I've just tried it on a form here at home and it works as you say.
I recall I had this problem then.
I'll try again on Monday in work.

Also the MSGBOX will be adequate for my needs.
__________________
Access novice. Sometimes trying to give something back.
Access 2007
Gasman is online now   Reply With Quote
Old 03-16-2018, 10:26 AM   #13
Gasman
Access newbie
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 2,056
Thanks: 261
Thanked 307 Times in 292 Posts
Gasman will become famous soon enough Gasman will become famous soon enough
Re: Form to show created/amended details?

Quote:
Originally Posted by Mark_ View Post
Alternate approach is to use a separate table to save this type of data. Table holds Updated Tables name, Updated Tables Primary ID, Date of change, Who made the change, and "Add/Edit/Delete" to show what they did. You can then make a small global piece of code to do this and simply pass the appropriate values from any form that can modify data.

This keeps it out of the hands of users and allows you to quickly identify who is doing what to what as its not spread over multiple tables.
Hi Mark,
Something to consider for later. The MSGBOX approach would be adequate for me at the moment, but I was over thinking it with using a form.
It is just that I have to take values from other systems, and sometimes people change data after I have taken it and do not let me know.
__________________
Access novice. Sometimes trying to give something back.
Access 2007
Gasman is online now   Reply With Quote
Old 03-16-2018, 12:01 PM   #14
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,203
Thanks: 13
Thanked 1,364 Times in 1,300 Posts
Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light
Re: Form to show created/amended details?

Quote:
I tried in work and it kept complaining it could not find the data, yet I've just tried it on a form here at home and it works as you say.
The case is different with reports. Were you perhaps working with a report back at the office?

With reports - Access recreates your RecordSource and includes ONLY columns that are actually bound to controls on the report. Therefore, with a report, you have to actually bind every column you need to reference. You can make the controls very small and set their visible property to no but they have to be there. For reports, I make all these fields YELLOW so they shout at me when I open the form so I recognize that they are actually hidden.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 03-16-2018, 12:39 PM   #15
Gasman
Access newbie
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 2,056
Thanks: 261
Thanked 307 Times in 292 Posts
Gasman will become famous soon enough Gasman will become famous soon enough
Re: Form to show created/amended details?

No, purely forms.

Let me try again in work on Monday and I will report back.

Thank you.

__________________
Access novice. Sometimes trying to give something back.
Access 2007
Gasman is online now   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
Show field details access2010 Queries 2 10-26-2014 02:56 AM
Records don't show when created from blank form? ClearlyAnIdiot Forms 1 08-30-2013 10:35 PM
Access Noob! Details of previous record show on new entry form sparkly_fairy7 General 1 01-09-2013 11:31 AM
A record with Primary Key created in table but doesn't show up in form Mythblstr Forms 6 01-25-2008 06:15 PM
Multi-User - Can you assign which user created/amended a record? dazza61 General 6 08-04-2007 09:16 PM




All times are GMT -8. The time now is 08:58 PM.


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