Recent content by cj1997

Hi. Thanks for your reply! Sorry for being sloppy with terms! Ok. So I am using the Access 2010 Navigation Form. This then embeds the forms I believe as subforms in a window, navigating to each when you press the navigation button. I have zipped and attached the database below. The main...

Hi, Did you get a solution to this question? I have posed a similar question in another thread but haven't had a response yet. I am also trying to figure out how to navigate through the subforms with the navigation buttons of the Access 2010 Navigation Form, while defaulting to the same record...

it also had a link to this page which may also pertain? http://baldyweb.com/Bookmark.htm

So after reading around, I am wondering if this post would apply: Re: Access 2010 "Navigation Form" VBA code to Click a tab ...perhaps I can scrap the embedded macro and put an On Click event in for the button instead. The syntax might be simpler. After some Googling I think its probably...

I am not clear what you mean here? My first 3 forms contain fields all taken from the main table. Does "bind"ing them include a separate action (beyond just containing fields taken from that table)? The remainder of my related tables are included as subforms, but I was unsure of what to do...

Hi Want to preface by saying I'm brand new to Access. Have NO experience with codes. I apologize in advance if that makes it difficult to explain! I have set up my main data entry form as a navigation form with 5 tabs/pages. The first three all contain fields from my main data table, the other...

Thank you for the advice! I have used the number sign in a number of cases to indicate fields that are primary or foreign keys (and therefore also numbers). Does this then make it more difficult later on with Access? If so I could always go back through and change each instance to 'Num'. I will...

Thanks for the advice! I will put it all in one main table, and simply split up the form for entry. I have been struggling a bit with the Furum/Astr issue. I was going to do a related table, with all of the descriptors given a autogenerated primary key (which would then be put in as the...

Thank you very much for the link! I am still tinkering out structure issues. But good to know that I can add tracking features down the road! thanks again!

Ok, so I have included a link below to a screenshot of the relationships of the majority of the tables in my db. The main ID table is called "ID". The other tables that currently house the information I was interested in including with the same primary key are "Treatment," "Material," and...

Thanks for the reply! Every record will have values to be entered in both other tables. It was really so that I could avoid having 40-50 fields in the main table. In terms of structure, would it then be better to keep all fields in one main table, and simply split the fields up on...

Hi everyone, Quick question - just building my first database (so. much. pain). Will take >1 year to collect/enter thesis data. Eventually I want to make it open to others/make changes as new research is done. Can I add change-tracking etc. later (perhaps once I know ANYTHING about code...

Hi Really sorry if I have duplicated an earlier question (I have been looking and looking, but may have missed it)! I am VERY new to Access, and am in the process of creating a database for my thesis. I have mapped everything out and built it in Access (but haven't entered any data yet). My...