Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 06-13-2019, 02:28 AM   #1
penchalas
Newly Registered User
 
Join Date: May 2019
Location: india
Posts: 26
Thanks: 1
Thanked 0 Times in 0 Posts
penchalas is on a distinguished road
VBA to load all the tables with sql server data

Hi,


Below is my requirement


1. I have 5 tables created in Access (T1,T2,T3,T4,T5)
2. I have a button click event for each table which loads the data from SQL server

3. Now i need a single button which does this, instead of having multiple buttons


A single button which loads the data from SQL server DB to access tables. This should be handled in the click event only



How to achieve this

penchalas is offline   Reply With Quote
 

Tags
multiple buttons , vba

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question Code Error when load data from server n3wguys General 2 06-06-2014 01:44 AM
Question Load data from two tables babaroga General 3 12-30-2008 02:38 PM
Upsize = good on server, but client won't load tables gomikem SQL Server 1 06-27-2008 02:56 PM
Load data from SQL Server into combobox (too slow) dealwi8me Forms 7 06-24-2008 04:36 AM
Getting data from SQL Server Tables from Access BigMikey Modules & VBA 1 07-29-2002 05:35 AM




All times are GMT -8. The time now is 06:52 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World