Recent content by hugh0177

Hi I fixed it! I don't know WHY this worked, but I just went through and changed every text field I had to the maximum number of characters (255) a field can have, and magically it worked. Maybe this will help someone else some day, although I have NO idea why it helped. Cheers, Kelly

thank you I have compacted and repaired occasionally, but not as often as every few hours. I tried that. nothing happened. I imported everything else into a new database, nothing happened. Any other suggestions? I really don't want to have to erase that table and start all over thank you...

Thank you for the info very very much. I didn't mean to sound mean in the last post. I meant to say it that way "IT has been decided, that it SHALL be that way." as a joke. Like I said, while I have been hired to make this database, I do very little of the designing, and major decisions...

Hi Thank you for your help so far. I know this is dragging on a lot longer than you had anticipated..., I hope you will continue to help me... OK so, I see what you are getting at, and I am glad that you offered to help, but the information you have offered me is NOT what I want. Beauty of...

Hi I have been working on a pretty large database for a while now, and it has been worked over many times. Just recently, I went into a table, and was trying to modify the properties of a field when I got the error message "Property value to large" and then it will not save. So I can not...

Sorry, I did not add this earlier, but in the query I created to work in the way you are suggesting, everything in the query saves to the underlining table EXCEPT the title of the site and the title of the organization, for which the purpose of this whole thing is. The titles autofill in by...

OK So I messed around with queries, and I found that some times when you enter information in them they save their information to an underlining table, and sometimes they don't. Why does this happen? K

OK, I looked how the properties of the subform and the fields of a subform are set up... I would have to assign the record source to the entire subform right? So I have some questions/points about that: 1) the subform is a form/table that is a connecting table in a middle of a many to many...

Thank you for a response: I tried that and it didn't work It said I have a syntax error. This time, it pointed to the first line of code to debug. I don't know why, it was fine before. Does it help to know that I am entering the information into this form as a subform? More specifically...

Hi When I enter one number in a field, I want that number to look up information in another table, and fill in some fields succesive fields. I would prefer not to use a combo box because I am afriad I will hit the limit for number of characters that can be in a combo box. Here is my code so...

Hi I have a form with a subform, and the subform is actually an intermediary form/table in a many to many relationship with another table/form. For user-friendly-ness the intermediary form/table includes not only foriegn keys, but the titles of institutions that are assigned that...

HI thank you for your help so far I hope we are talking about the same thing because I have only two tables I am working with and you were talking about three. I have one table with people and their contact information, and then another table with all of those people's connections. I do not...

Hi I know very little about access and I am still learning. I am trying to create a database that has some complicated things I don't know how to work out. I have a table of people and there contact information. They are professors and researchers in a field of science. I also have create...

Hi I am very new to access, and I am trying to figure things out. I have been charged with making a simple database. In some tables and forms I need to reference information (a few fields on the same topic need to be referenced in the same sense that one would reference a bit of information...