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 IconStefan Östman and Axis joined MS Access Hints, Tips & Videos
16 hours ago
Steven_Vandeleene is now a member of MS Access Hints, Tips & Videos
Wednesday
Profile IconLadotec, Dimitrios Kostoulis and douglas joined MS Access Hints, Tips & Videos
Tuesday
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
Monday
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. "
Monday
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?"
Monday
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…"
Monday
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
Profile IconRaymond Thomas, Felipe Marta, Steve Petrella and 3 more joined MS Access Hints, Tips & Videos
Oct 16
Anthony A. Gaff updated their profile
Oct 15
Anthony A. Gaff commented on TØny Hine's blog post Adding a "Checklist" to your MS Access database
"I may be mistaken, but I believe that if you create a multi-field index and set that property to unique, you can also ensure no duplicates without having to write a function or a method. The way I've handled this in the past is to create the…"
Oct 15
TØny Hine commented on TØny Hine's blog post Adding a "Checklist" to your MS Access database
"Paul, I've done a Google Presentation "fCopyListToDataOnlyOnce" explaining how the function works."
Oct 15
TØny Hine commented on TØny Hine's blog post Adding a "Checklist" to your MS Access database
"Hi Paul, Thank you! Your feedback is much appreciated."
Oct 15
Paul Mejia commented on TØny Hine's blog post Adding a "Checklist" to your MS Access database
"Thank you for the time you took on this.. It was easy to follow and understand most of it.. I am still unsure of how your function to prevent the list to be added more than once works..  I have a similar scenario that I may be able to use your…"
Oct 15

utter access

Loading… Loading feed

 

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