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...

That is correct. Each record in tbl_Surveys should get an associated temperature value.

Sorry for not being clearer. The Date I'm using is Date(ET) - what was the formatting error you found in query7?

Jdraw - thanks for replying. I realize that the tables are not related, because they will not be in the final database and I realize there are some formatting issues, but these are not my primary concern at this point. I just need to figure out the logic of these queries and I can clean it up...

I've attached the database with the 2 tables a 3 queries. I think I may just have to run a macro with the 3 queries..

Thanks Guus for replying. I'm not too concerned with the first 2 queries, the formula that I'm using now to calculate the date difference seems to work and I could combine them using a subquery. The real problem I'm facing is keeping the temperature data when I use the MIN aggregate query...

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...

Thank you for the responses. What I don't understand, however, is if the data is entered as 129.01 in the database, why isn't it stored as 129.010000000000? I tried running an update query to round the numbers to the decimal places. But when I export it to excel it still shows...

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!

Mstef, I tried inserting your statement again in my "on click" expression and that worked! Not sure what I did wrong the first time I tried it, but thanks!

No, it doesn't invoke a macro. It just opens up another form.

SiGill: Yes, this is my problem. Did you find a way to avoid having to click on another cell to get the table to refresh? It's annoying for my users to have to click on another record and then click the button.

Mstef: I actually tried putting that statement in already. I tried it in the "on click" expression for the button and also in the "lost focus" expression for the continuous form. Neither seemed to work.

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...

I successfully got the Search Tool to work! I realized I had forgotten to put in the Like "*" & [Forms]![frm_Plants]![Search2] & "*" In the combo box rowsource. No wonder why it wasn't linking! Hitting head... Thanks John!

I tried using the Search Tool, but for some reason can't get the search box to link to the listbox. Here's my code: Private Sub QuickSearch_AfterUpdate() ' Find the record by Common name that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[ID] = " &...

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"...