Marshall Brooks
Member
- Local time
- Today, 13:16
- Joined
- Feb 28, 2023
- Messages
- 630
I have a simple table in my front end - 1 record, two fields. Used for the version date.
I can read the values via:
strFE = Nz(ELookup("[fe_version_number]", "[tbl-fe_version]", "[ID] =1"), "") & ""
How can I write to the field.
I saw:
and tried:
But it didn't seem to work, and I also saw:
Which I haven't tried yet, but seems complicated for only two values to be changed.
Thanks in advance!
I can read the values via:
strFE = Nz(ELookup("[fe_version_number]", "[tbl-fe_version]", "[ID] =1"), "") & ""
How can I write to the field.
I saw:
Access VBA Tables - Update, Count, Delete, Create, Rename, Export - Automate Excel
This tutorial will teach you how to work with Access Tables using VBA. Access VBA Tables To start we will demonstrate the simple commands for working with Tables in Access. Later in this tutorial we will show you full professionally developed functions for working with tables in Access. Create...
www.automateexcel.com
and tried:
Code:
DoCmd.SetWarnings (False)
DoCmd.RunSQL "Update tbl-fe_version SET tbl-fe_version.fe_version_number = Format(DueDate, 'mm/dd/yyyy') WHERE (((tbl-fe_version.ID)=1))"
But it didn't seem to work, and I also saw:
Update field in a table using VBA ?
I need to update a field in a table based on what another field is Now_month Count 1 1 1 2 1 3 1 4 1 5 2 1 2 2 What I need to do is insert incremental values in...
www.access-programmers.co.uk
Which I haven't tried yet, but seems complicated for only two values to be changed.
Thanks in advance!