Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access project(.adp) - VBA and connection to SQL?

Status
Not open for further replies.
superdog4492

superdog4492

Programmer
Nov 14, 2002
12
CA
Hi there,

I have an MS Access project that connects me to a SQL Server database. My forms are all working fine, but I've been trying to figure out how to get at the data programmatically, using VBA.

I'm assuming that since the project is already connected to the database, that I don't have to connect in my code. Is that correct? If not, how do I connect? ODBC?

Any simple examples of a connection and creation of a recordset would be greatly appreciated!

Thanks, superdog

 
Status
Not open for further replies.

Similar threads

I
  • Locked
  • Question
How to get 2 codes to work together.
Replies
6
Views
465
hermanlaksko
hermanlaksko
Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
279
Xavierparkash
Xavierparkash
Modex
  • Locked
  • Question
How to Close Desktop Application Windows using VBA
Replies
3
Views
282
Andrzejek
Andrzejek
PrimoSteve
  • Locked
  • Question
Cannot add Image to Command Button?
Replies
9
Views
696
PrimoSteve
PrimoSteve
renigar
  • Locked
  • Question
Trying to add hyperlinks to pdfs through form entry
Replies
0
Views
407
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top