Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #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
Reply With Quote
  #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)

Reply With Quote
  #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
Reply With Quote
  #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.


Reply With Quote
  #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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 09:11 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.