|Microsoft Access Forum||Db 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...|
|Microsoft Access Forum||Email 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...|
|Microsoft Access Forum||Nested 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
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...|
|Microsoft Access Forum||Menu 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? |
|Microsoft Access Forum||Prints 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? |
|Microsoft Access Forum||Prints 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...|
|Microsoft Access Forum||Nested 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...|
|Access Advanced 2 is Finished||welcome richard by jimmy: we hope to see you more often, and get more frequency new lessons.|
|Excel 2007 Basic 1||Excel 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.
PATRICK D. WEEDOR Reply from Alex Hedley: This is the place if you want to discuss. |
|Microsoft Access Forum||Membership 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. |
|Microsoft Access Forum||Email 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? |
|Microsoft Access Forum||Merry 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...|
|Microsoft Access Forum||Graph 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...|
|Customer Service Policy||Order 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? |
|Microsoft Access Forum||On 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...|
|Excel 2010 Expert 10||Excel 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. |
|Access Advanced 2 is Finished||Access 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...|
|Microsoft Access Forum||Batch 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...|
|Microsoft Access 324||More 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...|
|Microsoft Access 324||More 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|