All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. You'll be able to ask any tech support questions, or chat with the community and help others. The only difference to yours is that if I run the access database normal with the Show Database window checked then i doesn't work, whilst if I allow the database window Yes I tried that as well unfortunately no luck. his comment is here
If you are comfortable with macros, you can stick with them with occasional references to VBA functions. About Us PC Review is a computing review website with helpful tech support forums staffed by PC experts. Advertisements Latest Threads BT tops UK broadband complaints list Becky posted Dec 20, 2016 at 3:44 PM 999 What is your emergency? My preliminary problem was that I was running out of temp disk space to add something like the command below.
Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... Stay logged in Welcome to PC Review! I have recently had cause to need to run this report from a PC that has Access Runtime (also 2010) and on that machine the export reliably fails. The following is the command: > > > > attach(0) = "c:\temp\Delinquent.snp" > > DoCmd.OutputTo acOutputReport, "rptEmpDelinquent", acFormatSNP, attach(0) > > > > The command works fine if executed once the
Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... It's very convoluted and why the designer did some of the things she did is beyond me. Set your splash screen to be teh startup form of the database... Stay logged in Welcome to PC Review!
That would make sense. Joe O replied Nov 22, 2011 The DoCmd statement might need time to finish its operation before executing for the next email address. Advertisements Latest Threads BT tops UK broadband complaints list Becky posted Dec 20, 2016 at 3:44 PM 999 What is your emergency? MyWeb « Previous Thread | Next Thread » Thread Tools Search this Thread Display Modes
We are using Windows XP SP3 and Office 2010 SP1Regards - Peter Tuesday, February 28, 2012 1:42 AM Reply | Quote Answers 0 Sign in to vote Update for anyone interested. I have just tried to recreate this on a db and it works fine and outputs the rpt. Tune in next week...I'm sure I'll find myself in another snag. The Visual Basic for Access group is no longer active. 4523332 Related Discussions Email Report of Current Record How to Find the Path to an Access Report Object required error in
You may have to register before you can post: click the register link above to proceed. Hello and welcome to PC Review. Run Time Error '2046' when Running DoCmd.SendObject acSendReport in Access 2010 George Jones asked Nov 22, 2011 | Replies (2) I have the following code: [code] Private sub cmdSendReports_Click() Dim MySet Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters.
Check out our E-book Question has a verified solution. this content Click Here to join Tek-Tips and talk with other members! Results 1 to 3 of 3 Thread: OutputTo command or action isnt available now Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Your name or email address: Do you already have an account?
It should be understandable alone, but I recommend reading the previous artic… MS Access Using a Criteria Form to Filter Records Article by: harfang Most if not all databases provide tools It works fine otherwise when specifying the exact File path and extention. Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business Intelligence C Languages Cloud Computing Communications Technology CRM weblink Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature.
Close Box Join Tek-Tips Today! All rights reserved. Dinh, Jan 4, 2007, in forum: Microsoft Access Replies: 1 Views: 1,071 Van T.
Is there a work around? Anyone know why? RE: Run-time error '2046' on OutputTo myknlat (TechnicalUser) 25 Jun 03 11:26 That makes it too easy.However, it does work.I thought it a conflict between a timer_interval in my automatic database Thank you very much!
More About Us... Action 'not currently available' Guest, Feb 7, 2006, in forum: Microsoft Access Replies: 0 Views: 512 Guest Feb 7, 2006 "The Command or Action 'SendObject' isn't available now error Guest, Apr http://forums.devarticles.com/microsoft-access-development-49/outputto-isn-t-avaliable-now-11771.html -Chuck ' turn the echo off DoCmd.Echo False ' show the db window DoCmd.SelectObject acTable, , True ' run your code ' hide the db check over here More About Us...
Home Products Services Learning Forum Contact Access World Forums > Microsoft Access Discussion > Modules & VBA [SOLVED] OutputTo Runtime Error '2046' User Name Remember Me? If I change the windows task on the PC using full access to call Access using the runtime switch, it fails there as well. could there be any code that connects your db to another system? Your name or email address: Do you already have an account?
tia Chad Z ccool View Public Profile View Extended RPG Stats Challenge This User To Battle Send a private message to ccool Find all posts by ccool Find all threads by I'm not sure what the issue was but I decided to go back to an older version of my project when it did in fact work. To confirm this I hardcoded the path and file name and ended up with the same result. Join UsClose MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Courses Vendor Services Groups Careers Store Headlines Website Testing Ask