|
||||||
New Access Web Seminar! By Richard Rost 15 years ago Attention Microsoft Access Students... Update 6/30/09 3am - I am FINISHED with the lesson videos. I just need to record the intro and review lessons, package the whole thing up, and put it online. I'm not going to write a FULL handbook for this seminar, but I am going to put together a separate printable guide with some critical screen shots and the source code (there's a bunch of it). I'm also going to include two versions of the database - one for Access 2007 users, and one in Access 2000 format for everyone else. Here's the complete course outline: 1. WebBrowser Control Adding WebBrowser in Access 2007 Adding WebBrowser in Access 2003 Adding WebBrowser in Access 2000 Command Button to Go To Web Page URL WebBrowser0.Navigate 2. WebBrowser Navigation User Input URL for WebBrowser Add Text Box URL Control Check if the WebBrowser Navigating? IsNavigating Check Box WebBrowser DocumentComplete WebBrowser DownloadBegin 3. Reading HTML & Page Text Show Current URL DocumentComplete URL Parameter Read HTML in a Web Page Read Text in a Web Page For Each Next Loop WebBrowser.Document.ALL OuterHTML OuterText 4. Parsing Page Data Understanding URLs URL Parameters (QueryString) Use Mobile Versions if Possible Parsing Page Data String Manipulation InStr, Mid Functions Reading Weather Data Finding the Current Temperature 5. Insert Data Into Table With SQL Create TemperatureT Table Append Query INSERT SQL Statement DoCmd.RunSQL DoCmd.SetWarnings 6. Insert Data Into Table With Recordset setup Recordset OpenRecordset Save Data Recordset Issues With Access 2000 Declaration Issues With Access 2003 Timing Issues With Access 2003 IsNull Problem 7. Automated Download With Timer OnTimer Event Timer Interval in Milliseconds Navigate Automatically Avoid Multiple Simulataneous Events Event Running Indicator 8. Separate Timer Form Create a Timer Form to Launch Events DoCmd.OpenForm Public Sub LoadURL While Wend Loop DoEvents DoCmd.Close 9. Recording Multiple Events Checking Temp in Multiple ZIP Codes Adding ZIP Code to Table Stop Timer Checkbox Recordset to Loop Through ZIP Codes Recordset While Loop rs.EOF rs.MoveNext 10. Checking Stock Quotes Copy Web Form Me Keyword Edit VB Code for Stocks Using Quote.com to Get Stocks 11. Working With Text Files, Part 1 Why Use Text Files? Analyzing Data Line by Line Creating a Temporary Text File Writing Text Files Open Text File for Output Problem with Windows Vista Security Reading Text Files Open Text File for Input Line Input Text File EOF Left String Function CSng Function - Convert String to Single 12. Working With Text Files, Part 2 Modifying our Recordset Saving the Stock History Data Invalid Use of Null Debugging Break Points Turn on the Debug Toolbar Step Into, Over, Out of Code Lines 13. Working With Text Files, Part 3 Replace Function CLng Function - Convert to Long Integer Switching to Stocks.mobi Viewing the HTML of a Web Page View Source Form Post Problem Converting Form Post to Query String Adjust Code for New Data Storing the Stock Data 14. Multiple Automated Stock Quotes Add Check Stock Quotes to Timer Form Create Stock Lookup Table Automate Lookup of Multiple Stocks 15. Acquire Data on Your Web Site Using Expression Web or FrontPage What if you use a different Web Editor? Using ASP (Active Server Pages) For More Info See my ASP Courses Also See Web Database Seminar Open my Web Site in Expression Web Create a SubSite in my Web for Data Collection Create an HTML Form to Collect Data Database Creation Wizard fpdb Folder Global.ASA File - Don't Touch It 16. Custom Data Collection ASP Page You can't just drop a database in your Web Clean up the Junk from the HTML Form Create our own Submit.asp Request Data from Web Form Perform Data Validation (Missing or Bad Data) Saving Data to the Database 17. Page to Display Collected Data ASP Code to Display All Collected Records Basic Security for Your Display Page 18. Download Collected Data to Access Create Another Access WebForm Modify Recordset for New Data Gather Data from Web Site 19. Delete Records from Server, Part 1 ASP Page to Delete All Server Records Modifying Access WebForm to Delete Records Specify Operating Mode AnalyzeDeleteRecords Sub Dealing with No Records to Display 20. Delete Records from Server, Part 2 Browser Caching Problems with IE Careful With Your IF/Then Logic 21. Virtual Page Data on Web Site Create a Virtual Page Database Modify Access Database on the Web Site Create a Virtual News and Sales Data Page 22. Local Virtual Page Database Create Local Virtual Page Data Table / Form HasChanged Event & Indicator 23. Post Data From Access to Web, Part 1 Build ASP Page to Accept Data from Access New WebForm to Post Data to Web Site 24. Post Data From Access to Web, Part 2 25. Posting Large Fields to Web, Part 1 Create HTML Web Form to Accept Data Give your HTML Form a Name Set Web Form Values from JavaScript in VBA Clicking a Submit Button with Code Converting Line Breaks to BR 26. Posting Large Fields to Web, Part 2 If this looks like gibberish - don't worry. I'm going to put together a full outline (with screen shots) tomorrow (well, later today) showing you exactly what this covers. That's just MY outline so I know all of the topics I covered.
|
||||||||||||||||||||||||||
| |||
Keywords: access asp web seminar database synch data PermaLink New Access Web Seminar! |