My First Field is in Sequential Order. How Do I get a subsequent Field also in Sequential Order?

[mcalder4]

It's only been a few minutes since my last posting, but already I have noticed something different with my new database. There are two tabs at the top: "Table" and "qryMusic". I can toggle between these to view my original database and the database with Field 3 (Track Number) in correct order. However I don't understand the point or significance of this. All I really want to be able to do is three things: 1: View my database with Field 1 and Field 3 in order (naturally Field 7 should show correct Song Title - i.e. as it was originally entered for that Track number) 2. Be able to add more entries to the database 3. Do Find/Replace and Filter.

By the way in my previous post "humankind" - on reflection this must be a cross between "humanity" and "mankind" - what a silly person I am

[ItsMe]

Q1. Is there any way that I can make Table default to showing Field 3 in correct order when I open the db?

To be honest, I am not sure you can sort more than one column in a Table Object. Even if it was, it is not advisable to do this kind of thing in a Table Object. This kind of thing is accomplished with Query Objects.

Q2. Over the last 3 days or so I have been adding records (many various changes to Field entries as well as new records added) to my original db. These changes were not included on the db file which you modified. Is there any way I can incorporate these recent changes into the new db you made for me (without disturbing anything else)? e.g. copying from old and pasting into new?

As an aside, it is advisable to make future edits to your new DB. I will try to make you more comfortable with your new DB in a subsequent post. To answer your question(s), you can replace table Music with an updated version table Music from another DB file. Depending on the changes you made, it may have an affect on the results the search form produces. I can produce details on this later and how this (small) issue can be resolved. It is OK to delete the table Music and replace it with another table Music.

I can toggle between these [table and query objects, Music and qryMusic] to view my original database and the database with Field 3 (Track Number) in correct order. However, I don't understand the point or significance of this

The purpose of a table is to store data. It is there to define fields using data types and names. Another purpose is to define Key fields (Your DB does not need Key fields). Queries are used to ask questions of your data. Queries help to manage the data that resides in tables. For instance, if you want to sort your data in a particular order you will rely on a query.

[ItsMe]

I made some changes to your original DB. In order to accomplish your desire to sort multiple columns, I added a query object. In addition, I added a Form Object. The purpose of the form is to provide you with a way to interact with your data and not have to worry about making changes to the underlying data. Also, the form provides searching and filtering capabilities. You can use the form to search for Keywords. The form will search for the Keyword(s) you provide and display a filtered result. This functionality would replace and surpass the Search and replace function (without the capability to edit).

You can see your original table illustrated in the following screenshot.


The following screenshot illustrates the Objects you will not have a need to interact with. One object you will not need to interact with is your original table (Music). The other objects you will not need to interact with are objects I added to support the Form named frmViewMusic. The objects you will not need to interact with have an arrow to the right of them.

If you need to edit data, use the Query Object, qryMusic. You can use this query to add records, delete records, and edit existing records. It will sort the records in a desirable order.


I changed how your DB opens. When your DB opens, so does a form. You can use this form to search for records within your DB. The following screenshot shows this form object. You can double click it from the navigation pane to open it. You can open this form without any fear of changing the data in your table.


You can open the form and type in Keywords to search a Keyword's respective field/column. The arrows in the following screenshot illustrate the fields you can type your keywords into. You can also use the Radio Buttons on the left to choose between Vinyl and CD's. The radio buttons on the right will determine whether the keyword you type might be at the beginning of the field, in any part of the field, or the keyword needs to be an exact match.

[ItsMe]

.
.


In your DB there is a field/column named, Type/Style. You can select an option from the Combo Box/Pull Down Menu and filter available types and styles.








After you make selections and enter text via the drop down menu, radio buttons, and search fields, you can interact with one of the three buttons at the top of the form.

[mcalder4]

To ItsMe: You have supplied me with a lot of useful information and images which I will need to study and digest. I think the following will be the last of my questions for the time being (actually it is more of a clarification of a previous question I asked and your answer):

Re Posting #15 I asked in Q2: Over the last 3 days or so I have been adding records (many various changes to Field entries as well as new records added) to my original db. These changes were not included on the db file which you modified. Is there any way I can incorporate these recent changes into the new db you made for me (without disturbing anything else)? e.g. copying from old and pasting into new?

You answered in Posting #17: To answer your question(s), you can replace table Music with an updated version table Music from another DB file. Depending on the changes you made, it may have an affect on the results the search form produces. I can produce details on this later and how this (small) issue can be resolved. It is OK to delete the table Music and replace it with another table Music.

Do you mean I can simply delete the existing Table Music in the new modified db and replace it by importing a (now updated) copy of my original db? I have learnt how to import thanks to directions given by ssanfu in Posting #13

I may have answered the question myself and am almost at the point where I am prepared to try this (after first making a backup copy of the new db). (It seems to me that if I have a backup copy then really I have nothing to lose).

[ItsMe]

I may have answered the question myself and am almost at the point where I am prepared to try this (after first making a backup copy of the new db). (It seems to me that if I have a backup copy then really I have nothing to lose).

I think you have a solid grasp on the idea of deleting the table Music in the new DB and importing a new table Music from another DB. As for clarification on the question/answer ...

The new DB should function just fine with an updated table from another DB. I am aware of reasons why the search form may not function as expected, if a new table is imported. I am choosing to not share that information with you, right now, in order to keep things as concise as possible.

As you mentioned, there is a lot of information here and you did not ask for all of this functionality. So it is to be expected that you would feel overwhelmed. Just keep an eye on your table and which copy has the latest desirable version of your data/table. If and when you choose to interact with the search form, we can visit the search form topic at that time and see how it suits you. Use the table that you desire to use.

[mcalder4]

To ItsMe: You are a clever guy, not only with your knowledge of Access, but in your method of communication. I have had an academic background over many years (now just retired) so with humility, I think I am in a position to make that judgement. I will leave you in peace now, but thanks once again for all the time and effort you have devoted. How will I contact you If I wish to contact you again in the future? I don't expect you to keep an eye on this post forever so how can I make contact? My personal email address is given in Posting #3 of this topic. I would like to telephone you and thank you personally. I (or should I say my wife) has Skype on her iPad and I use this occasionally to make overseas calls at minimal cost. Would you consider emailing me your telephone number so that I may speak to you?

[ItsMe]

You are welcome to email me regarding your Music database. Simply, reply to the email I sent you with 'Music Database' as the subject.

[mcalder4]

I am trying to contact ItsMe again. I have sent an email from my personal email account to his email as per Reply #23 above and am waiting for response.