Recent content by aphelps

Are you asking if it will delete the records in the "one" table? Because it won't. If you want it to, you should set your RI to cascade delete, and run the delete query on the "one" table...I think. That should delete the record in the "one" table, and any related records in the "many" table...

The following will export a form to Excel 97, hope this helps. I don't know how to get the thing to open, though I'm sure there's a similar DoCmd statement that will allow you to open an older Excel file. Let me know if you can't find it and I'll see if I can dig something else up--with the...

The only thing I can think of, and maybe this'll stimulate someone else to think of something better, would be to make a copy of your form that shows the ten rows you want to print. Then on your four-row-havin' form, put a button that opens this other form (it could say "Open printable version"...

Yes, yes, of course I can. I only need to ensure that there are no empty records for years with no data in there, or else they'd be counted as active years. I figured that there'd be a dead-easy way to do it, too. It's the options in the "Total" row in the query builder, I never remember that...

A three-legged dog walks in to a bar. Everyone gets nervously quiet. THe dog looks around, studying every face carefully, then says: "I'm lookin' for the man that shot my paw."

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

The resolution to this very civilly-toned discussion can be found here. Pat, I think what VBAhole22 was getting at was that there are multiple, complex solutions to what should be a simple problem, but he didn't necessarily get all or any of them from your post. Thanks for everyone's help, it...

I thought I'd post back here how I finally defeated the evil Access gods. I wound up putting textboxes on the main switchboard form where the user can enter up to three variables. S/he then must select the query they want to see. This gets me out of creating dozens of new forms (my main problem...

Fizzio--You said here that displaying the recordset is not a problem. If you can tell us how to display this DAO recordset, then the problem goes away--we can just display it after the inputbox gathers the variable, and after we test the recordset to make sure it's returning > 0 records. So, is...

Understood. I haven't tried the CreateQueryDef method, but a coworker and I have tried the following, in the same vein: ======================== Dim qd As DAO.QueryDef Dim rst As DAO.Recordset Dim strInput As String strInput = Inputbox("Enter a nest number, no hyphens:"...

In some cases, I do have the parameters selected on a form, generally for multi-parameter queries when a whole set of them have one or more parameters in common. However, I don't think it is any less appropriate to use the easier parameter query method in many cases, especially when only a...

Mile--- I gave it a shot, but as I suspected, there's a problem in that it's a parameter query and it's trying to read the query results without knowing the nest number. This will probably work for some of the other queries, but most of them require a parameter input from the user. By opening...

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

I realize that I can change the properties of each file in Windows to open in IE, but if anyone knows of a way to force the hyperlink issue anyway, I'd like to hear it.

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