Search results

Hiya-- I have a table to which I want to append many records. Table looks like this: NestNumber (txt), year, occupied (Y/N), Active (Y/N), nest result (int). So a record might look like: AC0002, 2000, Y, Y, 210 For a given nest, there can be multiple records, but only one record per nest per...

Howdy-- I have a DB with many forms, each containing many canned queries (most of which have at least one parameter passed to them), attached to buttons. Many of these queries come up with no records (and should, that's not the problem). What I'd like to be able to do is, click a button, enter...

Hi-- I have a table full of hyperlinks to photos of eagle nests. When one is clicked, it opens in the default program, Paint (the photos are BMPs). I don't like the idea of users potentially being able to scribble on these photos then saving them, so I'd like to force the hyperlink to open in...

Howdy-- I have an "idiot-proofed" frontend. When the DB opens, the database window is hidden. However, I want to put a password-protected button on the main switchboard page that, when clicked opens a password form. With the right password and a click, then, it will open the DB window. This is...

Hiya-- I have the following fields: NestNumber (AANNNN), in which the first two are letters abbreviating the county in which the nest occurs, the next two are numbers indicating the year, and the last two are the number of the nest in that county that year. Ex: AC0301 would be the first nest...

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

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

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

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