Search results

Hi all, First some background: I have created a database for bird banding and breeding data with three tables and several data entry forms. I have also made a search form and used a command button to run a query based on 4 fields within my 14-field table. the idea is that if I only have...

That worked! Thank you for your help through the process, CL_London!

The code, as written, also didn't search. The band numbers imported from excel as text, I am assuming because of the dashes (their format is ####-##### or ###-###### depending on banding sequence)

This worked perfectly, thank you Now I am having problems with the search form itself. I set up a simple form using the form wizard and included all fields, and included one unbound text box for the search box. I added a command button and put the following into the code builder: Private Sub...

Ok, I just realized I can delete fields in the data entry forms I don't want to be displayed; that makes things much simpler! After I make one giant table, how do I make a search form where I can enter the band number of the bird and all information related to that bird pops up? I know I can...

Hi CL_London, Thank you for your response. The only issue with that is the data we collect are very different between adults and nestlings, so while many fields overlap, there would be many other fields left blank depending on what kind of record is being entered. You also have to understand...

Hi all, Not only am I brand new to this forum (Hi!), I am also new to MS Access (I just took training on how to use it all day yesterday). I am a biologist, not a computer programmer, so please use plain lingo since I am not able to understand much computer jargon! :p Background on my Access...