Search results

Hi -- I have a data entry form that contains 22 fields from six tables. The same primary key exists in all six tables (NestCode); five of the tables are linked 1:1 with the first (which happens to be tblNestLocation). This form is based on a query (qselMainDataFormQuery). The form also contains...

Thanks--the tip on making it two queries saved me a headache. I've now created a large list of parameter queries that allows the user to query by any one or any combination of island (based on the code), year (based on the code), and species. Now I'd like to try to figure out how to put dropdown...

I haven't given it much thought yet, but the only problem I foresee is that I'll want the full name of the island to appear in the query results. For instance, I know how to split the first two letters off to find all nests on an island. However, I need to figure out if I can use these two...

I get an error message when I put the code into the zoom box in "After Update," something about it can't find the macro. However, I'm going to put this whole process on hold for a bit while I sort out the queries I am going to want (or rather, the queries that the user is going to want). If I...

Hi, again-- I have a primary key, NestCode. NestCode is made up of two letters (which represent the island code on which the nest occurs), then three numbers (which represent the number of that nest on that island), then two numbers (which is the year code). For instance, LB00102 is the first...

Then the questions would be, why does the form appear just fine with the source tables/query empty until this subform is added? I mean, the purpose for this form is data entry--how does one enter data in a form that won't appear? I understand that there are workarounds, and I'll check them out...

This is one of the top five craziest things I've ever seen. I have a form with 26 fields that is based on a query. Also on this form is a two-field subform. All that is fine. However, when I add the final piece, a second subform with 8 fields, then move from design to form view, the entire form...

I have a ten-field excel spreadsheet with 6600 records. When I try to import it into Access, the "spreadsheet import wizard" text appears in the status bar, but nothing else happens. I have tried saving it out of excel as DBF and tab-delimited text as well. When I try to import these files, I...

Thanks, Pat. I didn't even know that "join type" was there, it fixed my problem (and most likely a similar problem I've been having with two other databases). I've just got to figure out which direction all those relationships should be pointing.... Thanks again--Adam

The problem is that these relationships are defined globally, not just in the query, so even removing the table not being used from the query view (in this case, the Observed table) doesn't fix the problem. I see what you're saying, but if I have to redefine the relationships every time I do a...

Yeah, you'd think that ( I did), but it's not true--all the fields that aren't turning up in the query are in fact in both tables. Here's more detail: Table 1: Species Number, Prediction (yes/no) Table 2: Species Number, Common Name Table 3: Species Number, Observed (number) Tables 1 and 3...

Hi-- I have a yes/no field in a table. In this field, 43 entries are checked 'yes.' When I query this table for 'yes', only 29 are returned. The table I am querying is involved in a 1:1 relationship with another table. If I remove the related table from the query, then all 43 come up...