Search results for query: *

I have an Access 2000 form which runs off of a query. Often times, a series of records will be very similar with only one field differing. I'd like to copy the last record entered and then edit the one field that will vary. This field that I'm trying to edit, along with the record ID...

Good Evening (where I am...), I'm trying to set up an Access database for inspection/survey data. An inspector will conduct a survey where he or she will complete about 20 different checklists in 4 or 5 different categories, each checklist may have from 5 to 20 questions on it with possible...

I have a literature reference database with about 1000 technical journal references in it. I've established a form and the related query from which the user can select a date range, a category, and a geographic area, among others, from drop down lists. When they click on a command button, the...

Tracy, Thanks for the try... I've used up my own wild guesses so I'm definitely looking for others. I tried writing a new macro in a new database and the same problem pops up. The file extentions also look to be okay. Interestingly, if I have Netscape open already, it doesn't pull it up: it...

The plot thickens... A version of the described database on my laptop works with no problem. When I pull it into my desktop, clicking the command button opens the browser which is the problem. When I copy it (and scan it for a virus) and move it back to my laptop it works as expected. This...

I've compacted and repaired with no luck. I should note that I have 5 versions of this database, one for each of 5 users. All are exhibiting this problem, but the source database on my laptop appears to be running properly which makes me think virus. I'm doing a complete system scan know with...

While I know macros are often frowned upon, I have a database form linked to a macro through a command. When clicked, the macro runs a set query and exports the result via e-mail to an established e-mail address list. It's always worked fine until today. Now, when I run the query, something...

Duane My apologizes... I'm new to the site and posted my reply in the wrong location. It was intended to be in response to the procedure outlined in faq703-2696. Thanks Peter

When using this approach, does anybody know hoe to prevent the query from adding a new record to the underlying table. In short, I can use the search to find records that meet three criteria usch as the unput into three different field, but if I keep running the report, I notice the output...

I have an Access 2000 database which track two types of env. samples: air and bulk. I have it set up to send data to a preset e-mail address in Excel format (.xls). The air sample part of the database, with significantly more fields per record, runs the operation fine at 100 records a pop. The...