Recent content by ronc

Hi Dub I'm not sure I understand what it is you are doing when you get the error you are describing. Can you please advise the error you get and what you are doing at the time. Separate thing, why do you have a text primary key for apartment? I tend to go for autonumbers so there is no issue...

Hi Sue When using a table for looking up values, you store the line ID from the lookup table in your main data table then on forms and reports you link the two tables and show the description from the lookup table. that way if the description changes all of the records with that description...

Hi FF I'd be inclined to put the person's position/job title in the personal members table rather than creating more fields in the org table. Then if you want to know who the treasurer is for a particular or you link the two tables and filter based on the member.position. I would then have a...

Hi DubSouth Are the snags related to the apartment or the activity? I could see it going either way. I agree with putting in an aprtmentID field in the snag table. it needs to be the same data type as the apartmentID as in the apartment table, most likely number as I'm guessing your apartmentID...

Hi Sue When you create a relationship between two tables access requires something in the related field that matches one of the values in the primary table. Couple of options depending on the purpose of the link: Drop the relationship between these two tables then use the ObservationTBL as a...

Hi Cass.scag The short version is you need a table in between your two tables that provides the many side of a one-many relationship. it will contain a field to record the areaID and another to contain the routeID. Ron

Hi Terry I hope you have found your solution but just in case you haven't.... This works for me in Access 2010 Add the following to the form_open code for my sub form for each field: me.<fieldName>.ColumnWidth = -2 Thanks to the post from jleval The fieldname I used is the text box name, for...