Recent content by JChase

Wow, thanks for all the help, folks! So, NauticalGent's first suggestion (adding ".Value") to my AfterUpdate expression worked! It makes complete sense too, and I'll definitely be able to use that for other things. I appreciate the hand slap as well, since you were polite about it! ;)...

My Apologies. See attachment for screenshot. Justin

Hi all. I'm relatively new to access and not a programmer. I have a database of forest pest species, with a main "Search" form that operates quite nicely as a dashboard for the whole database (there's a separate data entry form that works well as well). On the main search form, I'd like to...

Thanks for your insight, Mike! I expect your idea has a lot of potential, but I'm struggling a bit to get my head around how it would all work. I think I'll have to use the database as is for now, and come back to this for a "version 2.0" rebuild sometime I get a slow day at work :) I think...

Hey Ruralguy. So, I've setup the database so there's a set list of survey types (in "Survey types" table) to choose from to populate the Survey Type field of the "Protocols" table. See screenshot of protocols table. When we add a new pest record (via my Data Entry form, or by me going into...

Ok, I finally got the thing small enough to upload. I removed almost all records, then compacted, then zipped :) See attached. Justin

Ruralguy: let's see, it's Access 2010. My desktop has a 64-bit O.S., but apparently we're running a 32-bit version of Access... Seems to work fine though, but that's what our administrators installed for some reason.

So, the relationships are defined (to the best of my understanding). See attached pic of the relationships in the backend of my database (for some reason the front end shows them all as 1:1 relationships...). "Protocol_Types" is in it's own table because the corresponding field in the...

Great point, Ruralguy! Thanks for the link. I've attached a copy of the database. However, the database is split and this is only the front end (back end was too big). I'm not sure what exactly you'll see when you open it, but I'm guessing you'll see a sortof 'blank' version with no actual...

Thanks again! In response to your first question: The table "protocols", which has the field "Survey Type" is in the record source for both the main form and the subform (main form record source details in first attached image). To the second question: the Row Source of the select type combo...

Hi Ruralguy. Thanks for the quick response! See attached screenshot for the Link child/master properties. Number is a primary key in my "Pest List" table, which corresponds to individual pest ID's - this makes the subform only show data for the particular pest selected on the main form's...

Hi all. I'm relatively new to Access and am not a programmer. I apologize in advance if this question has been addressed in another thread. I'm compiling in-house information on forests insects and diseases in a database with a main dashboard form used for searching individual species (there is...