Search results

Like you advised.. I created a new query using the form's RecordSource SQL statement, and set the query as the object to be exported. Works great. I do wish I could somehow include a title block for the spreadsheet... but I don't know how to do that.

The form is for end users. The Export is triggered by a button on the form, so that the user can export what they are seeing on the screen, should they need to. Im reading up on CopyFromRecordSet now.

I had thought about that, and I believe that would work,.. but I was hoping for a quicker solution which didn't require that I create a query. I don't like accumulating stacks of queries. I like everything neat and clean and uncluttered, with record source set within each form. Must be an OCD thing.

I don't have a query specifically built for the form. I just set the record source.

Thanks, but the record source for the form is based on 3 related tables with the combobox providing the filter... so, that wouldn't work.

How would I do that? I'm currently using DoCmd.OutputTo acOutputForm..

Hello Friends Is there a way to prevent my Combobox from exporting out to Excel? My ComboBox is situated in the form Header. I have a button which exports the form to Excel, but the ComboBox ends up as an unwanted column in the Excel spreadsheet. Some guidance on this would be greatly appreciated.

Thanks Isladogs! I have your examples. I'll look at them soon.

Hi DBguy.. I was looking at anchoring as a solution. I don't know enough about anchoring to quickly resolve my issue. I guess it's time to learn about it.

Thank you, MajP.. looking at the examples, I'm not sure this will help me. I'll look deeper into it, but it looks like a lot of work for such a little issue. My parent form is set to maximize on open. I just need the subform to auto center on the parent to accommodate different size monitors.

Hello Friends My parent form contains a control (sfctl), in which, there resides a subform. I have set 'Auto Center' on the subform and it is centered nicely within the control. However, I cannot figure out how to auto center the control on the parent form. There is no auto center option for...

Great! Thanks Again!

Okay.. so the 'RecordCount' would have been '1' if a match was found?

Yes.. I should have gone with the Navigation Control. Looks to be a lot easier. I filed that in my 'VB Tips' folder for future need. Thanks! :) This little project is nearly complete. Ran into trouble with the cascading combo boxes in "AddInventory", but I got it figured out. I wasn't including...

Hey! That works! Thanks DBguy! Im a bit embarrassed that all it took was to keep the subform control hidden. Simple solution. I should have thought of that. Very much appreciative of your time in helping me out. Very grateful. Thanks again! :)

Thanks very much, Dbguy. I have tried both your demos, (to include the navigation form), and they both produce a run-time error when I choose 'cancel' on the dialog box. That said, I'm pleased to report that the blank subform control no longer appears. Only 'Run-time 2467' appears. When you...

Yay! I figured it out. Both the main form and the subform being called were bound to the inventory table. I had copied the main form as a template and forgot to clear that out. After removing the inventory table as the main form's record source, it worked. Now (if you will) we can get back to...

DBguy.. something I have done with the tables in this db, which I never have is, some of the columns are the result of a query within the column property. Open the inventory table in design view and look under the lookup tab of 'PropertyID'. Could this be causing problems? Im pretty sure its a...

Thanks Micron. I've bookmarked this for future need. Much obliged.

Thanks DBguy I've reviewed your example and it is way different than the direction I took. Your query2 button fires off a report based on a query requiring a parameter value. My button fires off a form based query. I would think that mine should work.. but its not. Have a look at my attached...