change part of code - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

change part of code

Ludwig Willems

2 years ago

Hi, I just entered a number of 800 cabinets in my form with a cabinet height of 720 mm. Now this type of cabinet must be entered into the table again and again, but with a different height >> 780, 840, 910..., instead of entering everything again.
How can I best do this and how can I change the piece in the code "see print" 72 at Order Code" to 78. All codes are not the same and the '72' is not in the same place everywhere. It has to be searched for. in the code and then replaced. are there good videos here of where the knowledge can be used to do this.

	Ludwig Willems OP @Reply 2 years ago

	Adam Schwanz @Reply 2 years ago
If the prices are the same, you can just make a related table that shows the different options for the unit, if the prices are different, it's essentially a different part, you could still group them togethor under one part number and lookup the prices by the specifications but you'd still need to put an entry in for each option.

	Ludwig Willems OP @Reply 2 years ago
prices are all different, codes change depending on the height of the cabinets.

	Richard Rost @Reply 2 years ago
You could use an append query and just copy the records that you select and then make whatever change you want to make in the copy.

	Ludwig Willems OP @Reply 2 years ago
Richard, it is data records in access table with one to many and many to many. How can I copy this various data, adjust the height in the order code and paste it under the current records in the various tables.

	Richard Rost @Reply 2 years ago
Copying a record with all of it's related child records is something I cover in Access Developer 24, which you have. :)

Ludwig Willems OP @Reply

2 years ago

Ok, good thing I already have everything, I'll check it out. Thank you for the tip.
Since I have so much work to read all the questions and watch your weekly videos, I can't get any further in my modules. I'm still stuck on expert 17. I'm going to have to ask my boss for a holiday :) to catch up. At home they are already wondering whether there is still life outside of access... Pffffffffffffffffffff, a person is no longer allowed to have a hobby these days. And you are always present somewhere at home....

	Richard Rost @Reply 2 years ago
Glad that I can distract you from... myself. :)

	Ludwig Willems OP @Reply 2 years ago
and is there a video of changing a piece of "72" somewhere in a text with a condition regardless of where it is in the string of text... .

	Richard Rost @Reply 2 years ago
Replace Function

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View