Re: [MSAccessProfessionals] Add lock key to records..

Perfect, thank you so much..

I am so glad that I asked questions.. 

Take care,

Mike the Plumber

Sac City Plumbing

On Sunday, December 28, 2025 at 10:58:02 AM PST, Paul Baldy via groups.io <pbaldy=gmail.com@groups.io> wrote:

My first thought is to toggle the Allow Edits property of the form based on that field, in the current event. 

Paul

Sent via mobile device

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of michael simpson via groups.io <saccity101=yahoo.com@groups.io>
Sent: Sunday, December 28, 2025 10:20:23 AM
To: msaccessprofessionals@groups.io <msaccessprofessionals@groups.io>
Subject: [MSAccessProfessionals] Add lock key to records..

 

I would like to add a lock to records once an invoice is sent out.. to prevent accidental changes.  

My first thought is to add a field (Lock) to each record and then add a before update procedure on each field, many of the fields also have after update procedures, 

Can I use both Before and After update procedures, 

Is there a better way to lock down records. 

Take care,

Mike the Plumber

Sac City Plumbing

._,_._,_

Re: [MSAccessProfessionals] Add lock key to records..

My first thought is to toggle the Allow Edits property of the form based on that field, in the current event. 

Paul

Sent via mobile device

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of michael simpson via groups.io <saccity101=yahoo.com@groups.io>
Sent: Sunday, December 28, 2025 10:20:23 AM
To: msaccessprofessionals@groups.io <msaccessprofessionals@groups.io>
Subject: [MSAccessProfessionals] Add lock key to records..

 

I would like to add a lock to records once an invoice is sent out.. to prevent accidental changes.  

My first thought is to add a field (Lock) to each record and then add a before update procedure on each field, many of the fields also have after update procedures, 

Can I use both Before and After update procedures, 

Is there a better way to lock down records. 

Take care,

Mike the Plumber

Sac City Plumbing

._,_._,_

[MSAccessProfessionals] Add lock key to records..

I would like to add a lock to records once an invoice is sent out.. to prevent accidental changes.  

My first thought is to add a field (Lock) to each record and then add a before update procedure on each field, many of the fields also have after update procedures, 

Can I use both Before and After update procedures, 

Is there a better way to lock down records. 

Take care,

Mike the Plumber

Sac City Plumbing

._,_._,_

Re: [MSAccessProfessionals] Conditional Number formating

Thank you both - great suggestions.

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116720) | Reply to Group | Reply to Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Re: [MSAccessProfessionals] Conditional Number formating

The solution I have seen at a former employer was to have a second field to store the precision (# of decimal places). 

Duane

Sent from my mobile

On Dec 5, 2025, at 9:18 AM, Jane via groups.io <jcross=crossproducts.plus.com@groups.io> wrote:



Hi

I have a numeric field (double), which I need to save/ display exactly according to how the user entered it.  I don't want to change it to a text field as the system does use it for calculations. Also general formatting to 2dp for example will show all numbers the same. 

eg 

User Enters	Currently Displays	Required Display
10.50	10.5	10.50
11	11	11
10.0	10	10.0

 

Any suggestions?

Many thanks

Jane

Re: [MSAccessProfessionals] Conditional Number formating

Hi Jane,

 

In some cases, it is OK to store a number as text, and then use it in numerical calculations. VBA or the Access Expression Service (if using a query) will do the type coercion for you.

Example:

Dim d As Double

Dim s As String

s = "10.50"

d = s + 1

Debug.Print d

 

This will print the number 11.5

 

You can also write the calculation as:
d = CDbl(s) + 1

This makes the type coercion explicit. That would be my preference.

 

If for some reason this is not good enough for you, then consider adding a text field to the table for the user-entered string, and turn the current numeric field into a Calculated field with the expression:
CDbl([yourTextField])

 

Best Regards,

 

-Tom van Stiphout.

Microsoft Access MVP

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Jane via groups.io
Sent: Friday, December 5, 2025 8:19 AM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Conditional Number formating

 

Hi

I have a numeric field (double), which I need to save/ display exactly according to how the user entered it.  I don't want to change it to a text field as the system does use it for calculations. Also general formatting to 2dp for example will show all numbers the same. 

eg 

User Enters	Currently Displays	Required Display
10.50	10.5	10.50
11	11	11
10.0	10	10.0

 

Any suggestions?

Many thanks

Jane

[MSAccessProfessionals] Conditional Number formating

Hi

I have a numeric field (double), which I need to save/ display exactly according to how the user entered it.  I don't want to change it to a text field as the system does use it for calculations. Also general formatting to 2dp for example will show all numbers the same. 

eg 

User Enters	Currently Displays	Required Display
10.50	10.5	10.50
11	11	11
10.0	10	10.0

 

Any suggestions?

Many thanks

Jane

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116717) | Reply to Group | Reply to Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_