Recent content by zoobeeda

personal circumstances: I am working on a project on my own. This project is simply a database to store and manage data about the software I've accumulated. This database will become a model for further databases I will create to store and manage data, presumably just personal matters unless...

I'm working with an Update Query using a Switch function such as follows. Switch([field_1]="red", "01", [field_1]="yellow", "02", [field_1]="blue","03]) The problem is that if the condition is false, meaning the value is neither red, yellow or blue, the Switch function will actually delete...

From what I can tell, the reason that I got the weird multiplying of rows was because I put two tables into a Query without there being ANY Join between the two tables. Correct me if I'm wrong. I think I have some idea of what a relational database is—maybe not a tremendously good one. I was...

Thank you for the replies! Galaxiom and arnelgp offered two methods of approach. I'm a newbie and both solutions seemed a bit daunting. After thinking about it overnight I thought I might be able to do something with Galaxiom's suggestion: > Try putting the colour to number translations in a...

Problem: dealing with Switch formulas that are too long. step 1: The following Switch formula will work in an Update Query. Switch([field]= "red","01", [field]= "yellow","02", [field]= "blue","03", [field]= "orange","04", [field]= "green","05", [field]= "purple","06", [field] Is Null,"x")...

I am working with a form containing about 12 tabs. I tried to move some field boxes from one tab to another in the form by cutting and pasting. Those field boxes subsequently appeared on all tabs, which I didn’t want. Then I cut and paste the boxes again into the same tab and this solved the...

I have NumberRank in both tables because: 1. in MainTable, values in NumberRank will vary from record to record 2. RankTable lists all possible values for NumberRank and the corresponding values for BarRank, which gets sourced/copied into MainTable. I don’t know how to otherwise do what I...

Please see attachments.

please see attachments

I think I would like to know how to configure the autopopulation feature several ways so I have more flexibility on how I present and manage this feature. The bar rating (eg. O I I I I O I I I I O) I prefer for visual display and the number ranking (eg. 10) I want so that doing range searches...

I'm speechless!. I've applied the new code to my main table and have the autopopulation working there as well. Wonderful! Thank you! There is one more action I would like performed. It occurred to me that this really isn't necessary, but I guess it's nice to still have the choice of including...

The last code didn't work either. As per request I'm uploading the file. I assume that the file to upload is the database where the autopopulation is supposed to go. This database is a small one reduced to primarily the autopopulating elements.

The reply to the questions in the last two posts by GinaWhipp are in the PDF file that is attached with this post. I have also created a PDF giving an overview of the issue and a summary of the development in the thread (to a specified point in the thread) and attached it to the first post in...

Please post the Rwo Source of the Combo Box here... I was going to ask what a Rwo Source is. I even googled Rwo. It occurred to me that GinaWhipp meant Row Source. If GinaWhipp did mean Row Source then the Row Source of the Combo Box is: Row Source = RankTable I was wondering if it’s possible to...

Adding cbo to the name referencing the form's combo box does not make a difference. The autopopulation still doesn't happen. I may try creating a new Access database that is small, having primarily the elements involved in the autopopulation. It might be easier to pin point problems in a...