|Microsoft Access Forum||Finding Duplicates by Brent: I found the old post from ages ago ignore the last question unless you can add any more information.|
|Microsoft Access Forum||Duplicates by Brent: Is there a topic that covers finding duplicate records where two or more fields are identical?|
|Microsoft Access 321||Microsoft Access 321 by Alan L: OK, so I know 5 years have gone by since the last post on this forum. I have been trying, for hours, to figure out why I am getting a Run Time Error 6 Overflow when I try to delete items. I am fairly certain I followed your code verbatim except that I am trying to adapt it to a different set of records.
Private Sub DeleteSelected_Click()
|Access 2010 Beginner 2||Comment by Jim Ewin: In Access Lesson 2 Beginner 2 in for design view. How do I turn on my gridlines. I have the square blocks but no dots???
|Microsoft Access Expert 7||Comment by avrom s: Hi Richerd!
Thanks for all your teaching! I m putting in a lot hoers in your lessons & thanks god I m getting great Knowledge in access.
I sent you a question, & i got the answer between the rows of your lesson.
I m up to expert classes, at the 2nd lesson, i did everything exactly as explained in the lesson, but when i brought in the sub form in the big form it didn't work, i more...|
|Microsoft Access Forum||Control Audio Output by Kevin B: I'm looking for some VBA to select the audio output between my computer Speakers and Headset. Anyone have any ideas or did I finally find something Access VBA can't do?|
|Microsoft Access Forum||Instructional Label Inside of Text Box or ComboBox by simon b: Have not tried this with bound form fields but here is the example I used to test the code.
1. Create a form called InstructionF
2. Create 4 unbound text boxes called NameTxt, DateOfBirthTxt, AgeTxt, GenderTxt. Delete the labels.
3. Create a label on the form called more...|
|Microsoft Access Forum||Truncating Data within a field by David S: First, and most important, make a copy of the table in case everything goes wrong.
Then use an update query and the Left(String,NumberofCharacters) function.
Try it first in an ordinary query to see that it gives the right result, then change the more...|
|Microsoft Access Forum||Courses Wish List by Uriel Ramirez: Is there a wish list? Sometimes I see a course a want but forget about it? is there a wish list on the site just like the one in Amazon? |
|Updated Production Schedule||Database Distribution Seminar or mini Seminar by Uriel R: It would nice if you could make a database distribution/deployment seminar or mini seminar. The material on your classes is great, the way you teach and record your videos is very professional and easy to follow, not to mention when you leave "mistakes" in so that we can understand related more...|
|Access Relationship Seminar||Comment by Julie Martin-Beaulieu: You can disregard my last question. I just read another student's comments about not using the design form and now I'm back on track. Thanks!|
|Access Relationship Seminar||Comment by Julie Martin-Beaulieu: Hi. I am dropping the junction table into my "parent form" but it continues to show all of the data. What might I be doing wrong? I am following your video step by step so I'm not sure what the problem is.
Thank you for your help.|
|Microsoft Word Forum||Mic Office by Ken Major: I Recently got hold of an Apple macbook, is there any way to adapt Mic Office 10 to work on it|
|Microsoft Access Forum||Need Help With Database by Jason: I work for a Hospital and I really what to update my Whiteboard from Excel to Access. I need to create a data base that does the following things.
Add consultant to a patient
add the patients to a bay and bed.
Add a daily list of the nurses who are in charge of the bays
Also the i need to have a up more...|
|Access Relationship Seminar||Comment by Julie Martin-Beaulieu: Hi. I am making a database to store interventions and student support services for students. I think I need a one to many table so that I can identify the type of interventions (there are different reading and math programs) each student receives. Some students will receive multiple interventions. My question is: Do I need an intervention ID like you have a parent more...|
|Access 2010 Beginner 8||Comment by Chris Thompson: Please ignore my entry sent in today. Duh. :)
I was looking at Access 2010 when I answered the old question about tab order.|
|Access 2010 Beginner 1||Comment by Jim Ewin: I'm feeling a little inadequate. I just bought the 2013 Access and put it on my computer.
I went through all of Richard's beginner course before I looked at it. Alas. I can't even find the place to start. Seems like I need to answer a lot of stuff 1st. Down the left side there is new, recent , options , account etc..Red and White??????
Can any one give me a hint on how to get more...|
|Access 2010 Beginner 8||Tab Order AC 2007 by Chris T: Tab Order on AC 2007 can be found (while in Design view on the form) on the Ribbon. It is on the design tab beside the Property Sheet button, or while on the form in design mode you right-click your mouse and select.|
|Microsoft Access Expert 24||Comment by Patrick Russell: Thanks Richard for the Online SQL Server segment. I would love to see more both with SQL Server and SharePoint.|
|Access 2010 Beginner 8||Comment by Brian Merrick: I have created a vehicle checklist database. On the form, i have created a tab for each shift for example, Day shift, mid shift and Evening Shift. I created Three Separate form for each shift, but they are on the Vehicle checklist form at a tab so i can view them all at once. When I input data such as the date and driver and mobile number, everything is fine. When i try to more...|