ERROR #3704: Operation is not allowed when the object is closed. Blog Comment History

If you can't explain it simply,
you don't understand it well enough.
-Albert Einstein
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
NEW Release: Access Advanced Level 4 and Level 5   dismiss

News      User Comments     History     Notify Me
Thu 12/15
7:15
Microsoft Access ForumDb Limit by John Miller: Our Access data base reached it's limit 3 days ago. I was able to off load enough data to get it up again. Now I have a problem when we go to enter orders into the order entry form or add notes on any previous order, it will not allow any typing from the keyboard and the save record menu choice is grayed out. It tells me that that choice is not available. It also  more...
Thu 12/15
7:14
Microsoft Access ForumEmail Seminar by Ray W: No Error message. It just will not send using Hotmail or Outlook webmail. It's like you need to set the allowing less secure apps to access my email.. Like you do in Gmail but Hotmail witch is now Outlook webmail now. I think Microsoft will not let you set that (allowing less secure apps to access my email) in the free version of Outlook webmail.  more...
Thu 12/15
5:35
Microsoft Access ForumNested IIf Functions by Stephen B: Hi Alex. I tried your suggestion and got the same error message in the query. I simplified it even more, using IIf([RoomID]=2,[BasicTourCost],"NOT CALCULATED") I got the same error message. I then changed the join type between the tables in the query to show ALL records from the TourT, irrespective of whether there was a booking.  more...
Thu 12/15
4:09
Microsoft Access ForumMenu by Toine van Oudheusden: I have al couple of tabels and some Queries but can not get them te work in en menu. I like to add a new recond (musicalbum) and then add the tracks (subform) but I cab not get it to display the album I just added. Reply from Alex Hedley: Are you wanting a continuous form that lists all your albums?
Thu 12/15
3:42
Microsoft Access ForumPrints form not report by Len J: Hi Alex. Yes print preview displays fine. The code is DoCmd.OpenReport "LabelLargeR", acViewPreview, , "LabelID=" & LabelID Reply from Alex Hedley: Is the form the current focus when you hit print?
Wed 12/14
7:13
Microsoft Access ForumPrints form not report by Len J: I have a small database that just prints parcel labels. On the address input form I have a button that uses VBA code to preview the label, this works fine. If I then use Ctrl P to print, it prints the label. However if the print button on the ribbon is used the 'form' is printed not the label. It does not happen in any of my other  more...
Tue 12/13
14:24
Microsoft Access ForumNested IIf Functions by Stephen B: I created a calculated query to evaluate the total cost of a holiday. It should be a fairly simple calculation, selecting a different price, depending on the type of room required. RoomID shows the different category of room. Below is the calculated query field which is causing an Error message each time I run it. I have thoroughly  more...
Tue 12/13
5:28
Access Advanced 2 is Finishedwelcome richard by jimmy: we hope to see you more often, and get more frequency new lessons.
Tue 12/13
5:15
Excel 2007 Basic 1Excel Discussion by PATRICK D. WEEDOR: I AM A LIBERIAN.I AM ALSO RESIDING IN THE SAME LIBERIA. I AM VERY,VERY HAPPY THAT THIS PARTICULAR FORM IS A FOR FORM FOR DISCUSSION ABOUT THE EXCEL LESSON. THANKS! PATRICK D. WEEDOR Reply from Alex Hedley: This is the place if you want to discuss.
Mon 12/12
13:16
Microsoft Access ForumMembership Table by Denise Magwood: I am establing a membership database with expiration dates. Is there a way to set up a notification 60 days out that membership dues are upcoming Reply from Alex Hedley: The DateTime Seminar covers notifications.
Mon 12/12
12:53
Microsoft Access ForumEmail Seminar by Ray W: I can get Gmail and Yahoo email to work fine but Hotmail or Outlook email will not work? I know about the: allowing less secure apps to access my email account? But Hotmail or Outlook will not allow this.. Any Idea? Reply from Alex Hedley: What error messages are you getting?
Mon 12/12
5:46
Microsoft Access ForumMerry Christmas and a Very Happy New Year by Selby H: Dear Richard and Alex, I just want to wish you both a very Merry Christmas and a Very Happy New Year for 2017. Thanks Richard for all your Access Lessons over the years, I continually refer to those. All the best. Selby Reply from Alex Hedley: As always Selby very kind words, and the same to  more...
Sun 12/11
17:28
Microsoft Access ForumGraph in Access by Brad W: Is your only graphing lesson just in the Access Payables Seminar? Sure would be nice to not to have to buy the whole seminar for just the graphing portion.... I do have Access Expert 1-30 but have only been through lesson 7 to date. Reply from Alex Hedley: Expert  more...
Sat 12/10
8:28
Customer Service PolicyOrder laid but no lesson by Josephine N: I hv paid for access advance 1 but lesson is still not uploaded. Reply from Alex Hedley: Advanced 1 was uploaded on 9/20/2016 Are you not seeing it in the Theater?
Fri 12/9
20:12
Microsoft Access ForumOn Double click open a specific form by David B: OK. I don't think explained my question well...so here goes again. I have many different forms (about 200). I have the names of these forms stored in a table and I have a form associated with that table. I want to be able to build a macro so that when the viewer is looking at the list of forms they can  more...
Fri 12/9
9:45
Excel 2010 Expert 10Excel 2010 Expert 10 by Richard L: Will you be doing any VB with Excel, like you do with Access? Reply from Alex Hedley: It's on the waiting list, not sure how much interest there is atm. Is there anything in particular you'd like to see, I might be able to write up some tips or longer articles.
Fri 12/9
0:57
Access Advanced 2 is FinishedAccess Advanced 2 is Finished by Otto: Would it be possible in Advanced 3 to include how to copy an order, make some changes and then add it as a new order? (I have repetitive orders with many lines with some minor changes and I would like to avoid to type in each line again for a repetitive order with the risk of misspelling.) Reply from Alex Hedley: Like  more...
Thu 12/8
17:54
Microsoft Access ForumBatch Barcode Reader by Stephen B: Hi, I was wondering what is the best way to deal with data from a batch barcode reader and import into appropriate fields in Access. Data strings are in txt file format from the barcoder and are for several functions including Stock Move, Potting on, Stock Death, tag request, split batch, stocktake etc. Examples of the data strings in the  more...
Thu 12/8
16:12
Microsoft Access 324More than one record by Gary C: Debra, It's 3 1/2 years later but just in case you find this --- I wrestled with the same problem for about an hour before I could even find out what was happening. The code behind the payment button ended with [ Me.Requery ] I changed it to [ Me.Refresh ] and I got the results I wanted. The focus stayed on this record and updated as needed!  more...
Thu 12/8
15:58
Microsoft Access 324More than one record by Gary C: 12/08/2016 Debra I ran into the same problem. I used Me.refresh instead of me.requery and it worked perfect

See More Comments...


See Complete Blog History

Change Layout


News      User Comments     History     Notify Me
 
 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP