Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #11 (permalink)  
Old February 16th, 2007, 02:04 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Go to the form's properties dialog box, select the data tab, and select the record source using the pull down menu. Once you do that, the fields will be available in the field list button menu.

mmcdonal
  #12 (permalink)  
Old February 16th, 2007, 05:58 PM
Authorized User
 
Join Date: Nov 2006
Location: Evergreen, CO, USA.
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I went to http://msdn.microsoft.com and downloaded the Access VBA Reference. Detailed information on VBA, but nothing on VBA SQL. I'm still looking for an SQL reference. Searching SQL in MSDN only brings up SQL Server references, searching VBA SQL finds nothing. BTW, I have a copy of Access 2003 VBA on my bookshelf. Followed then index entries for Events, but didn't get much info. My best reference is Robin Dewson's great Beggining SQL Server Programming (Wrox)

  #13 (permalink)  
Old February 20th, 2007, 08:30 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

When you say "VBA SQL" what are you referring to? You use regular SQL statements inside of VBA to create recordsets, and you use ADO in VBA to connect to the SQL server. So a SQL reference is good for recordsets, and the VBA ADO is good for connections. Does that help?


mmcdonal
  #14 (permalink)  
Old February 20th, 2007, 10:46 AM
Authorized User
 
Join Date: Nov 2006
Location: Evergreen, CO, USA.
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I seem to have moved this posting in a different direction.

Here's a note on where I'm coming from: I first encountered SQL in Adabas, a sort-of-relational mainframe DBMS (e.g. it allowed repeating fields and groups in a record). Then, IBM's mainframe DB2. I took two classes in Microsoft SQL Server. Now, Access. Each DBMS uses an SQL set that is modified for the capabilities of that engine. What I'm looking for is a succinct presentation of each element. When I F1 on SELECT, I get info on the VBA Select Case statement.

Your comment: "a SQL reference is good for recordsets, and the VBA ADO is good for connections." is worth posting on the wall. Thanks.

This forum has been of enormous help to me, since the organization I'm working in doesn't support Access.


  #15 (permalink)  
Old February 20th, 2007, 10:52 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Go to the SQL Server and select the books online and check out the references there. Those are probably the best you are going to get anywhere. VBA is not going to cover SQL syntax. In any event, Access is ANSI 89 whereas SQL Server 2000 is ANSI 92, so not quite the same thing. Use ANSI 92 in your VBA code since Access reads that as a string anyway and doesn't get confused by the difference in syntax.

HTH

mmcdonal




Similar Threads
Thread Thread Starter Forum Replies Last Post
Populate a text box from a combo box value dnf999 Access VBA 7 February 6th, 2012 02:24 PM
Combo box to display items from parent combo box Gini Visual Studio 2008 0 June 18th, 2008 12:30 AM
Count in combo box(display results in text box) mboyisis Access 4 April 4th, 2008 07:08 AM
Combo box choice creating filtered combo box stevensj5 Access 11 September 13th, 2007 11:33 AM
Populate List Box by Combo Box Selection mmcdonal Access 2 June 15th, 2004 12:08 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.