Search results

Hi all, I have a puzzle I've been trying to solve for a couple of days and can't come up with a solution. I have a table with counts of bugs (Bug_Counts) and a lookup table for the bugs (tlu_Bugs). The lookup table describes the taxonomic classification (Phylum, Class, Order, Family, Genus...

I have 2 tables: Table 1 (tbl_Temp) contains temperature data for a particular park at a certain date/time. Table 2 (tbl_Surveys) contains survey data that was conducted at a certain date/time I need to find the nearest date/time for each survey in Table 2 to Table1 and import the temperature...

I have a couple of fields in my database that are formatted single or float. I've noticed that when I export the data to excel it changes these numbers. For example if I have 129.01 in a field (format=single) in excel it will show up as 129.009994506835. Why is it doing this and how can I get...

I have a database that links individual trees to a plot. The tree table has a tree_number field that contains a numeric tag number. I'm trying to figure out a way to restrict the tag number so that duplicate numbers can not be entered in the same plot. Is this possible? Thanks!

I have a continuous form with with a button that links to another form. The continuous form is based on a query that brings together two tables: tbl_trees and tbl_tree_data. The linked form is linked to tbl_tree_data, but includes two additional subforms: xref_Tree_Conditions...

Hi, We have a database that will require replication and synchronization with tablet PCs and other desktop computers. As our company standard, we use GUIDs for the primary keys in almost all of our tables. Our database is and will remain in the Access .mdb format. I'm thinking about using...

Hi, I'm new to databases and SQL and I need some help writing code. I have two tables, one is a list of plants (tlu_Plants) that has a favorites column (Yes/No) and the other is a favorites list (tlu_Plants_Favorites) by Park name. They are linked by a Plant_ID number. When a user enters the...

Hi, I'm trying to create a combo box where I can type in "oak" and see every plant that has oak in it's common name. I would get southern red oak, willow oak, jack oak, etc. Ideally, the combo box would change choices as I typed. So if I type "al" I would start seeing "alderleaf"...