473,587 Members | 2,527 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

TableDefs and name

1 New Member
Hi Everybody,

I am srabani I am new to this site.

I am working on VBA DAO and come accross with a code

For Each tbl In CurrentDb.Table Defs
If InStr(1, tbl.Connect, "DSN=Speakers_B ureau;") > 0 Then

q1 = tbl.name

q2 = "*" & Mid(tbl.SourceT ableName, 5)
sql1 = "SELECT " & q1 & ".* " & _
"INTO [" & q2 & "]" & _
"FROM " & q1

DoCmd.RunSQL sql1
My question is What is CurrentDb.Table Defs is returning to tb1?
what is tb1.name returns to q1, is it name of each table that is currently linked with the datasource name Speakers_Bureau "
What is the difference betwn name and sourcetablename property?

Thanks .
Jun 16 '06 #1
0 1405

Sign in to post your reply or Sign up for a free account.

Similar topics

23
63658
by: stewart.midwinter | last post by:
No doubt I've overlooked something obvious, but here goes: Let's say I assign a value to a var, e.g.: myPlace = 'right here' myTime = 'right now' Now let's say I want to print out the two vars, along with their names. I could easily do this: print "myPlace = %s, myTime = %s" % (myPlace, myTime)
2
2729
by: Ravi | last post by:
My XML looks like: <abc> <def type="apple"> 1 </def> <def type="peach"> 2 </def> <def type="orange"> 3 </def> <def type="banana"> 4 </def> <def type="plum"> 5 </def> </abc>
1
2620
by: discomiller | last post by:
Mario Mueller: Hello *, radiobuttons belong to other radiobuttons by the "name="any_value"" attribut. Thats a fakt. I got the following XML: **************************************************************
21
11352
by: TheKeith | last post by:
I heard that the name attribute is deprecated in html 4.01 strict. Is it recommended that you use the ID attribute for images along with the getElementById method instead of the old way? Thanks.
1
4438
by: Todd Matson | last post by:
I am trying to diagnose a rather insidious problem. Yesterday, I tried to install the .NET Framework 1.1. That installation failed. No big deal -- I can live without it. Now, however, none of my MS Access applications work. I've researched the problem and found that whenever the DAO TableDefs.Append method is executed in code, I get...
2
2405
by: Shane Suebsahakarn | last post by:
Hi all, Does anyone have any idea why creating a table link across a network should be so slow? My front end app follows these steps when opening: * Retrieve all linked tables in the current database as a recordset from the MSysObjects table. * For each record: Check the existance of the mdb file that the table resides in. If the mdb...
2
2375
by: BUX | last post by:
I have to look in Index property of myTable, but Set myTableDef = myDB.TableDefs(myTable) is so slow .... Do you now any other fast way? thank you
1
5988
by: ivanet | last post by:
Hello everyone, I am trying to use the following Schema but I get the error "src- resolve: Cannot resolve the name 'ValuesList' to a(n) 'element declaration' component." at line 144. I have been reading http://www.w3.org/TR/xmlschema-1/#src-resolve, but I don't get what is wrong. Can anyone give me a hint? Thanks in advance.
2
2202
by: timmg | last post by:
The following code works well except I can't think of an elegant way of checking for the existance of the named field prior to creating it. Suggestions? Public Sub pNewField() 'Add a new field to every table in the collection Dim strSQL As String Dim db As Database, tdf As TableDef, intI As Integer Set db = CurrentDb
0
7920
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7849
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8215
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8347
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
8220
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5394
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3844
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3879
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1454
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.