Recent content by qweeqweg

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! :)