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 IconDimitrios Kostoulis and douglas joined MS Access Hints, Tips & Videos
2 hours ago
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 0:35 Sample Data a "Wedding List Spreadsheet" found on the web0:42 Fancy Spreadsheet modified so it will import ok.0:57 This is the original list1:17 The Imported Data1:39 The "Group" Column is "Text" it needs to be a number1:44 A Number like this Column "listSets"2:19 Extract the "Text" into a new Table2:29 Select "Query…See More
9 hours ago
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. "
12 hours ago
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?"
12 hours ago
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…"
13 hours ago
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
yesterday
Profile IconMichael Hutcheson, ali kashani and Chris van Straalen joined MS Access Hints, Tips & Videos
yesterday
Souvik Kumar Panda updated their profile
Saturday
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…"
Saturday
Profile IconSouvik Kumar Panda, CRISPO, Mariel Lobo de Souza and 1 more joined MS Access Hints, Tips & Videos
Saturday
TØny Hine and Paul Mejia are now friends
Saturday
Raymond Thomas updated their profile
Thursday
Profile IconRaymond Thomas, Felipe Marta, Steve Petrella and 3 more joined MS Access Hints, Tips & Videos
Thursday
Anthony A. Gaff updated their profile
Wednesday
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…"
Wednesday
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."
Wednesday
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."
Wednesday
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…"
Wednesday
Rocky Swartz replied to Andrew Thorpe's discussion Email via Google
"I used the FMS Total Access E-Mailer utility for years, until clients decided to move on from Access 2007.  So I am stuck because the utility is version specific. I found this nice sample db at…"
Wednesday
Rocky Swartz updated their profile
Oct 15

utter access

Loading… Loading feed

 

Forum

vba postcode lookup

Started by Michael Hutcheson in Questions yesterday.

Email via Google 2 Replies

Started by Andrew Thorpe in MS Access Resources. Last reply by Rocky Swartz on Wednesday.

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