|Microsoft Access Expert 7||Sorting by Alex Hedley: Hi Janet,
How are you adding the item to the combo?
Is the combo based on an underlying Query that has a Sort on it? You could just refresh, requery the datasource and then it will be sorted accordingly.
|Microsoft Access Forum||making ACCDE file by MUBEEZI M: Dear Kenneth,
It is possible that there is an error in the VBA of your project. Unfortunately, Access may sometimes not give you useful feedback. I would suggest that you go to the VBA editor-->Debug-->Compile. Any errors will pop up as you compile. After correcting the errors, you will be able to create an ACCDE file.
Good luck in your more...|
|Microsoft Access Forum||making ACCDE file by Alex Hedley: Try compiling it in the VBA Editor first.
|Microsoft Access Forum||2 Subforms in 1 Report by Ramona: Since this post I have figured it out. I needed to add sub reports for invoice detail and invoice location. Then add the sub reports to my main invoice report.|
|Lots of New Stuff Coming Soon||Florida move by Norma H: Congratulations Richard! I'm sure you are going to love FL. I live on the east coast in a little town called Sebastian. It's located midway between Jacksonville and Miami and 3 miles from the Atlantic. I am also from upstate New York (Albany area) . Lived out in the country (Helderberg's) , so I also know what snow is. The best to you and you family . Norma more...|
|Course List Added||Course List Added by James Fisher: Hi Richard.
when can we expect to see some new classess |
|Microsoft Windows Forum||sudden shutdown of windows 7 by Mubeezi M: dear Richard,
I have used my laptop for since Nov 2011 (about 12-16hours every day). it has always worked OK. over the past 2 weeks, it suddenly restarts, shows a blue screen and claims to be dumping some type of memory. could this be a virus? how do I get around this?
|Microsoft Access Forum||making ACCDE file by Kenneth B: Is there a limit on the number of forms, reports,macros,tables? because I get this error when i try to make a ACCDE file
This error is usually associated with compiling a large database into an MDE file. Because of the method used to compile the database, a considerable number of TableID references are created for each table. more...|
|Microsoft Access Expert 7||Sorting by Janet G: 4:36 - Combo box sort - How can I sort the people that are already listed in the combo box table - I understand how to sort the drop down list to pick from but they themselves do not sort once added to the list - I'm replicating this in my db whereby I have several "customers" attached to our "Client" - when searching if a customer belongs to our Client it would be more...|
|Microsoft Access Expert 13||Disabled Mode by Brauna: Hi again Richard,
You could ignore my question. As it turns out the database I was working with at the time was not in a "Trusted Location" It is fixed now. Thanks again.
Your tutorials are great, by the way. I have been able to create a database for a doctor's office and is now functioning very well. |
|Access 2010 Beginner 8||LimitToList by Janet Gangl: Hi Richard - 8:45 Lesson 2 Beginner 8; I've been thru all of the beginner and expert videos and am now working on my own database. I have a similar table to the lead source table except that I'm using an ID field therefore my combo box has the two fields. If I change "Limit To List" to No - I get the following error - Access can't set the LimitToList more...|
|Microsoft Access Forum||2 Subforms in 1 Report by Ramona W: Hello Everyone! Access 304 create a printable invoice, which I have done. It included Invoice Query for the totals & the created a Report.
I have added a LocationT, LocationDetailT, and LocationDetailF to my database. I created another subform based on my LocationDetailT to my InvoiceF. (Looks Great! LOL) Then I added My more...|
|Access 2010 Beginner 7||Navigation Form by Wayne Ayotte: I'm going through this lesson (Beginner 7 Video 1 time 5:34)for a second time now using access 2013 and I'm having trouble dragging the Customer Form to the [Add New] it doesn't seem to be adding to the navigation form but instead creating new form.|
|Microsoft Access Expert 13||Disabled Mode by Brauna Rosen: Hi Richard,
I tried to correct name fields to Upper and Lower case but I got an error message: 'This action or event has been blocked by Disabled Mode" Do you know why that is happening?
|Microsoft Access Forum||Blocking IP addresses by Selby : Dear Richard,
I know that there are ways of blocking IP Addresses using Windows Rules and that sort,(and various programs) but it seems all over the place, would be great to have all the unwanted IP addresses stored in a table.(IPAddressT). Can you block an IP Address using Access and some VBA?
Just a thought, but if possible would make a more...|
|Microsoft Access Forum||Thanks Alex by Willie: Thanks, Alex Hedley
Like Richard you are a life saver.|
|Lots of New Stuff Coming Soon||Congrats on the move by BJ North: Florida is really awesome. I would love to live there someday. No more snow for you in the winter. Bet you'll really miss that. NOT. Well, congratulations on the move. I hope you and your family will be happy down there. Are you moving to the gulf side by any chance? That was my favorite area except for the Keys of course. Happy more...|
|Microsoft Access Forum||Access DB Permissions by Tina: Ugh! Embarrassing moment. You were correct. It was a "Network" permissions problem not db permissions. IT gave him access to folder but excluded the backend files. I am very new to the dba position and this one was a new error for me. Thank you for your assistance.|
|Microsoft Access Forum||Is Null Vs by MUBEEZI M: Dear Richard,
I fixed it. I looped through all the fields in the affected tables and changed every field whose value was "" to Null.
|Excel 2010 Beginner 1||Comment by Susan: How to print when part of the work is out of the page?|