Search results

Thanks. It doesn't seem possible to conditionally format all of them at once (I select them all, right click, and then there is no conditional formatting option on the menu that comes up). I'm a bit lost - not very familiar with coding or tags. Where do I enter this code, so that it applies...

It's a single form view.

Hi. I have a form with over 200 fields on it. I want to maintain the conditional formatting I've already got in there for specific values. I also want to add conditional formatting such that all the fields are greyed out when a new record is created, and they only turn white once data are...

Thanks June. So, to rephrase that in terms I understand: - AutoNumberID should be in all of my tables (primary key in my primary table, and foreign key in my 3 related tables) - I fixed the database relationships to reflect this. - I fixed my sub-forms so that master and child fields link by...

Thank you, June7. Much appreciated. OK, I've figured out how to do the update query. A couple of followup questions. 1) Does this sound like a reasonable plan? Create a single query that updates AutonumberID and ScreenID in each of the 3 tables - run them to update the values. (In the...

I have a database with 1 primary table containing records for hundreds of individuals, all of whom are identified by 3 unique IDs (they are complete for all records - no blanks or repeats so far): 1) ScreenID is a unique ID I made up for each person, and will remain this way 2) StudyID is...

Thanks. Will check my database tomorrow...

Thanks. I'm not sure if I'm explaining it properly. I use Autonumber all the time for those purposes, yes. The users won't be using the tables for data entry - I just check the tables to make sure the forms are capturing the information correctly. We'll be extracting the tables into Excel...

Thank you. I believe your assumption is correct, re: data entry yes meaning you can't view previously entered records, according to what I read. I cannot seem to replicate that issue. It's behaving perfectly now! Thanks for your input. I'll continue testing later this week.

And of course, now I re-tested it and it works perfectly. Of course... :rolleyes:

Thanks essaytee. I checked the form properties, and it's set to data entry - no. So, I just looked that up, and it seems that's what I want, right?

Thanks June. Actually, no, we just want text saved in the tables for now. The numeric ID field is just there to ensure that the text sorts how we want it to! The people who analyze the data later will create their own numeric coding after we extract the data. Our field options will likely...

I have a main form that is really crowded (and already has 4 continuous subforms pointing to separate tables). I need to enter test score data on a second form (not a sub-form - all the data on it come from the primary data table - there's just no room on the main form). I linked it to the...

Thanks very much. I had already added the field to the form as a combo box, and I could not see an option to add a second field and make it invisible. So, I tinkered a bit, went back to my single-column lookup table, added a second column that was numeric, and made that my primary key, but as...

Thanks - I will try that.

RESOLVED: Form field - want non-alphabetical display of lookup table values I have a single-column lookup table listing the values that I want displayed in a combo box on a form (we'll be using the same lookup table for multiple fields in the database, which is why I need the lookup table). I...

My team is planning a database that needs to be accessed by individuals whose computers run on different operating systems. I typically use MS Access, but this will pose a problem for other team members. They were hoping to use LibreOffice. I searched older threads, but couldn't find much...

Thanks. Good advice for future. In this case, we already had a set of IDs created, but I will try to set up with autonumber in the future. Thanks.

Thank you both! It is set to cascade add and delete. The subform was set with the wrong "Link Master Fields and Link Child Fields" properties. I fixed them. Unfortuantely, I now have to go and manually enter referralID for all the records entered so far, for which it was not accurately...

RESOLVED: Relationship not working Hi everyone. I have a database with 2 tables. I set a one-to-many relationship enforcing referential integrity, cascade updates. Table A is the primary table, with "ReferralID" entered as a numbered field (the primary key). Table B is populated via a...