Search results

Great idea, thank you The_Doc_Man. Listing the records in the SQL code has a practical limit due to difficulty in reading the list. But placing the list in a table is very clean, easy to read and easy to check for errors. That will be my "Heavy Duty" bulk record update method :-) Gale

That was it!!!! It worked beautifully :-) The final script looks like this... just to close this thread out gracefully... This SQL is used in a query to change the 'Status' field entry to 'Expired' in 48 specific records in the "Documents Table" Update [Documents Table] SET Status = 'Expired'...

Here is the SQL I entered in a Query shown with a reduced number of ProjNum's. But I received an error when I ran it saying the table could not be found. I hope I haven't made a silly mistake naming the table "Documents Table" with the two words separated by a space? Or maybe I have to do this...

Thank you, this totally makes sense but I am more interested in Admin type updates... something I can modify for other types of updates. Like running an SQL script or modifying the criteria in an update Query to suit the current needs. Gale

This is more of an Admin function. I think I need to be more specific... this Access database is replacing a Lotus Notes database I developed about ten years ago. I am still using the Lotus Notes database and keeping the Access database in synch manually. While doing some data "cleaning" in the...

Thank you, I will keep this in mind as the future of this database is decided. I am not sure how it will be used or even if it will be used. I am replacing a database that I developed in Lotus Notes and have used personally for over 10 years. But want to give the work this database supports to...

Thank you Bullschmidt, I want to use a "query (showing multiple records at one time)". If I can learn how to use SQL in an Access query I will have a very good method for maintaining bulk record updates... one I am already somewhat familiar with. Gale

Thank you Pbaldy & MajP... the light is turning on :-) To Pbaldy: "Well, the same IN clause will work in an update query. If you have an existing query that returns the 50 records, you can join to that query in the update query. " I may be missing your point but I think the key statement is...

MajP... sorry I didn't understand your comment at first... it's getting late and my head is spinning. SQL UPDATE ... Thank you :-) I have never used it but I know what it is... not sure how to apply it in Access? My SQL experience has been in extracting data for analysis and reporting... never...

"We're not overly picky about the forum a question is in, " Great :-) No, the 50 cannot be identified by common criteria, I have to list each one. Which brings me to my next question... is there an equivalent entry in the Search Query for "IN"... such as this example from one of my SQL scripts...

Thank you pbaldy. Update query... that sounds exactly like what I need. :-) I will move to the appropriate forum now to ask more questions. Gale

Hi, I'm not sure where to ask this question... so I'll try here first. I need to change the value of one field for 50 specific records in one table. The change is the same for each record... change status to "Expired". I was going to just manually do it through the main form but I would like...

Very interesting the_Doc_Man... thank you. In this case it would be overkill but the method is good to know and I appreciate the information. Gale

@ CJ_London "concerned that changing the datatype would require more space in the database " I was mostly concerned that changing the data type might mess up the table if I didn't do it correctly. But your point is still a good one and something to keep in mind for larger databases. @ moke123...

Thank you CJ_London. That makes it difficult to count characters... but the field will just truncate if the max number is exceeded... correct? Or do I have to detect that and stop the save? It's ok with me if the text is simply truncated. I really don't want to get into character counting if I...

Thank you Micron, I appreciate your comment. No, it isn't indexed and it's not part of a join. It's kind of a free form log area for manual entry of process exceptions and complications. Used primarily to detail the current state of a document if it isn't flowing smoothly through the process.

Thank you The_Doc_Man and moke123, that is what I hoped would be the case. Yes, I am sure I need more than 255 characters but I did not know there is a difference in versatility of the two data types... I'll need to look into that. In tis case I will not be searching for information in this...

Hi, I need to change a field data type in one of my tables from Short Text to Long Text. The data currently conforms to the Short Text character limit but I redefined the use of the field so it will soon require more room. Can I simply change the data type or is there something else required? Gale

Thank theDBguy, zeroaccess and Micron. I appreciate the help and I am off to read up on queries and reports now that the "emergency" has been squelched. She (the person who asked for help) is a real trooper, not experienced in any type of programming or database design but she is trying to...