Search results

Thanks David, good idea I will give that a shot. :)

I am trying to use a program within Access if it's possible. It should be run from a command prompt (cmd) so I don't know if it's possible to do a shell alternative within an Access DB The instructions I found to run are: 1. You need to have FFmpeg installed in order to create the...

Thanls again. It's a shame I cannot seem to get Autoformat to work properley, as you say, looking at the Autoformat Templates they look good and would give consistancy. I cannot understand Microsoft, they seem to employ people who do not use or have experience with current software to make next...

Thanks. I just tried Auto Format. I had a form with 3 listboxes on, a couple of command buttons, and labels. I selected designs from the Auto Format menu, and many of the designs did not appear as suggested. A couple of choices made the listboxes invisible. I also tried the wizard, but again it...

Many thanks. I found I was going down the wrong road. First I created a blank database, then I put controls on the form and set there properties. I was unaware that to set the defaults I only need to click the objects in the toolbox (no need to put control on the form) Then after doing all...

Many thanks. So from what I quickly read through, it's a cut and aste job each time I want a form, if that the case then what a bodge. I hope I have read it wrong!! So going back to Object Designers, what are the boxes for Report and Form template names? Thanks again

I just made a blank database. I created a form. I put objects on the form, ie command button, listbox, textbox etc, and set then all as I want them as default. I saved the database as MyTemplate1. Went into object designers from fresh opening of Access, and made my form template name...

Thanks, I had looked there bofore, but it is so limited. Form Template and Report Template are set as normal. Have I got to make a form and use it as a template? I want to get rid of all future command buttons not using Themes, I want to get rid of all the hover over colors, double coloured...

Every time I create a new form, I spend ages setting control colors, text fonts and sizes, No themes on command buttons etc. Can anyone tell me if and where I can set all the defaults I want for forms. I don't want 2 colors per foreground etc etc. It's driving me crazy setting things up before I...

Many thanks for all te help. I had checked all my references, and LP listbox always appears to be filled with something. Good news is someone replicated my problems so I feel happy my db is not corrupted. They got me sorted out adding : Set rs = CurrentDb.OpenRecordset(Me.LP.RowSource) and...

Just tried my laptop. Downloaded fresh copy of your database, and on second attempt to fill Excell I got the runtime error 3420 Object invalid or no longer set, halted on line rs.movefirst. If I take out this line, then second opening of Excel is blank. It would have been good to have found...

Many thanks, and yes your database works perfectly? I tried the following. 1) Created a new blank database, imported my suspect table/form. Did not work, halted on the line rs.movefirst (Runtime error 3420 Object invalid or no longer set) on the second attempt to fill Excel. 2) Created a...

I did a basic database, and the Excel Application opened up every time. I then spent time taking everything off the tab control page and built a completely seperate form. It failed. So I removed everything from the form until it was very basic, but still not working. I have attached it and...

Did you see my last posting? I did a basic DB and your coding worked perfectly, proving there is something staying open in my main database. I don't know what it can be as although there are many forms on a tab control, only 1 form gets focus with what I am trying to make work (query by form)

I just made a form with a single list box, a button to derive SQL to fill the list, and a button to open Excel, and it opens and closes every time!! So something is staying open in my database. I will have to spend time looking to see why, will take some effort as a mutitab control with...

Thanks for the information. I will try and make something to send.

Thanks, sorry I did go in afterwards to edit the code to make it look better. Yes when loaded in the forum page it did look difficult. Thanks for the link I will read it. I did try the code without the Clone part, but Excel still opens up the second time empty.

Thanks, but still not working. It did not like RecordsetClone, Method or Datamember not found. I appreciate your time, and working in the blind. I think I must try and see what happens when the database is closed and reopens, something remaining open. Just hope it's not one more of many bugs I...

Many thanks, okay I will use your code. Mine does look a bit empty!! Thanks again for help

Thanks again. It would be a problem to chop out the relevant part of the database, it also may be a problem in my Excell2010?? . I will have to look around for other examples of how to send a recordset dynamically to Excel, allowing me to open Excel, print it, close it and then send another...