MS Access Hints, Tips & Videos

This is the stuff they don't tell you in books...

Tony Hine spent years answering MS Access questions in forums. He noticed many problems boiled down to misunderstanding how MS Access worked

Latest Activity

Profile IconForumsub, Rajaonary David and Ian Norman joined MS Access Hints, Tips & Videos
15 hours ago
Profile IconRob Adams and Mike Feldman joined MS Access Hints, Tips & Videos
yesterday
Ben Ben is now a member of MS Access Hints, Tips & Videos
Tuesday
Paul Mejia posted a blog post

In Need of guidance. "How to return "one" record from a group, if all other record meet a criteria?"

Hello everyone, I am in need of assistance I have tried to go on this on my own for a while now and no googling or blog reading has got me any closer to the end result and I hope anyone here can help. my problem as follows:I have included a test DB at the bottom with fake everything but with the problem in hand. As you will see with my failed approach I can see the 5 employees listed "5" times each with theirs Training Status displayed as "All Good" or "Expire"In this small DB the only employee…See More
Sunday
Paul Mejia commented on Steve Ingram's blog post Update required
"Hi Steve I am no expert in fact I am more of a newbie, I took a look at your problem and since I am in need to learn I attempted to make it work as close as you want it.. here is what I came up with, I hope it helps you a little bit.. FILE LINK"
Sunday
Profile IconPaul Steel and Anton joined MS Access Hints, Tips & Videos
Sunday
Profile IconStefan Östman and Axis joined MS Access Hints, Tips & Videos
Oct 25
Steven_Vandeleene is now a member of MS Access Hints, Tips & Videos
Oct 22
Profile IconLadotec, Dimitrios Kostoulis and douglas joined MS Access Hints, Tips & Videos
Oct 21
TØny Hine posted a blog post

Adding Multiple Checklists to MS Access

Following on from my last blog "Adding a "Check-list" to your MS Access Database" it's a simple step to add multiple Check lists. Adding Multiple Checklists to MS Access 1 Time --- Description0:35 Sample Data a "Wedding List Spreadsheet" found on the web 0:42 Fancy Spreadsheet modified so it will import ok. 0:57 This is the original list 1:17 The Imported Data 1:39 The "Group" Column is "Text" it needs to be a number 1:44 A Number like this Column "listSets" 2:19 Extract the "Text" into a new…See More
Oct 20
TØny Hine commented on TØny Hine's blog post Adding a "Checklist" to your MS Access database
">>>Did I get lucky<<< I'm not sure, I always use "Option Explicit" and that tells you you have an error. "
Oct 20
Paul Mejia commented on TØny Hine's blog post Adding a "Checklist" to your MS Access database
"Thank you Tony.. I never noticed I forgot to Dim the rstRSTTable & rstTrainingList.  Is it normal that even if not Dim The code still ran with no errors? or did I just get lucky?"
Oct 20
TØny Hine commented on TØny Hine's blog post Adding a "Checklist" to your MS Access database
"Replace the first few lines of your code with these:- Private Sub btnPopulateRequiredTraining_Click() Dim rstRSTTable As DAO.Recordset Dim rstTrainingList As DAO.Recordset Dim sSQL As String Dim rstFindRecord As DAO.Recordset Dim sSQLFindRecord As…"
Oct 20
Michael Hutcheson posted a discussion

vba postcode lookup

Hi all,I wonder if anyone could help. I've found an access postcode lookup database here:http://www.access-programmers.co.uk/forums/showthread.php?t=216444But it doesn't retrieve any info?  Looking at the code it appears to send a string to 192.com then performs a WinHTTP request to read the page but this is not retrieving anything?Regards,MichaelSee More
Oct 19
Profile IconMichael Hutcheson, ali kashani and Chris van Straalen joined MS Access Hints, Tips & Videos
Oct 19
Souvik Kumar Panda updated their profile
Oct 18
Paul Mejia commented on TØny Hine's blog post Adding a "Checklist" to your MS Access database
"Hi Tony, I took a look at your presentation and I know understand how your function works.. Unfortunately I don't think I can apply it to simplify my code.. I have included a copy of the Function I use on a "Button"HERE: I will msg…"
Oct 18
Profile IconSouvik Kumar Panda, CRISPO, Mariel Lobo de Souza and 1 more joined MS Access Hints, Tips & Videos
Oct 18
TØny Hine and Paul Mejia are now friends
Oct 18
Raymond Thomas updated their profile
Oct 16
 

Forum

vba postcode lookup

Started by Michael Hutcheson in Questions Oct 19.

Email via Google 2 Replies

Started by Andrew Thorpe in MS Access Resources. Last reply by Rocky Swartz Oct 15.

Names displaying as numbers on Combo box column 9 Replies

Started by Alan Dawson in Questions. Last reply by Michael Guoji Oct 14.

Blog Posts

Handling Multiple Controls

Posted by TØny Hine on July 25, 2008 at 23:30 — 7 Comments

MS Access your Data with Sub-Forms

Posted by TØny Hine on November 4, 2011 at 10:30 — 2 Comments

Excel in Access (Part 1)

Posted by TØny Hine on March 15, 2008 at 16:30 — 3 Comments

 
 
 

Badge

Loading…

Members

© 2014   Created by TØny Hine.   Powered by

Badges  |  Report an Issue  |  Terms of Service