Recent content by HGCanada

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.