Pull data from table..

[VBABEGINER]

Hi Experts and all,

I have new and very 1st query on access db.

Table name "Data", contains 4th and 5th column email id's. I want to fetch that in variable. Can any one provide me select query, how to write that..

Many Thanks..

 

[bobsan42]

Use the Query Designer or the Query Wizard in Access. After you are satisfied with he result Open the query in SQL view and copy the query.
if it is to be used in VBA code - replace all " with ' (if any) .

 

[VBABEGINER]

Use the Query Designer or the Query Wizard in Access. After you are satisfied with he result Open the query in SQL view and copy the query.
if it is to be used in VBA code - replace all " with ' (if any) .

Im getting an error on this.. dont understand why?

Private Sub CreateCon()
Dim pwd As String
Dim stDB As String
pwd = Module2.GivePwd
Set cnt = New ADODB.Connection
stDB = Module2.GivePath
stCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & stDB & ";Jet OLEDB:Database Password=" & pwd
[COLOR=#ff0000]cnt.Open stCon[/COLOR]
End Sub

 

[VBABEGINER]

Can you please provide that select query, it will help great.. Thanks

Use the Query Designer or the Query Wizard in Access. After you are satisfied with he result Open the query in SQL view and copy the query.
if it is to be used in VBA code - replace all " with ' (if any) .

 

[Joe4]

Can you please provide that select query, it will help great.. Thanks

From your original posting, it is not clear to me what your data looks like, and what you are trying to pull out.
How about posting a small sample of your data, and let us know what you want the expected results to look like (based on that example)?

 

[welshgasman]

I believe you will need single quotes surrounding stDB and pwd ?

 

[VBABEGINER]

Hi Joe, Hi welshgasman,

Thanks both for your reply. Thanks for older post too..

I simply want select query which will fetch value from access table. This values are placed in "Data" table in col 4 and 5. These col contains email id's. I want this email id in 2 variable..

From your original posting, it is not clear to me what your data looks like, and what you are trying to pull out.
How about posting a small sample of your data, and let us know what you want the expected results to look like (based on that example)?

 

[Joe4]

Here is a link that shows you how to do Select Query with Criteria in Access: https://support.office.com/en-us/ar...-a-query-b00dd711-667e-4bf4-85d0-55da8049ce49
If that does not give you what you want, please do what I asked, and post a small sample of your data, along with your expected results.

In Access, you can simply open a Table or a Query and copy and paste the data here, like this:

1	Adam	Ant
2	Ben	Button
3	Carrie	Carne

<caption> TableA </caption><thead>
[TH="bgcolor: #c0c0c0"] ANo [/TH]
[TH="bgcolor: #c0c0c0"] AFName [/TH]
[TH="bgcolor: #c0c0c0"] ALName [/TH]

</thead><tbody>
</tbody><tfoot></tfoot>

 

[VBABEGINER]

Thanks Joe, for ur valuable time and this explanation.. I'm mentioning my scenario here..

**This is access related requirement.

I do have visual basic 6.0 software with me, where i have designed one of the form. On this form, there is control combo. Combo contains team names in list.

Suppose, employee A got shifted from Team name - US to Team name - UK, then I will click on that command button which is named "Updated Details".

This data will go in Access DB table "Data". This is pretty simple and successfully working.

Reason to ask my question - When I clicked command button which is named "Updated Details", it should also perform one more step of action, i.e. as follows --

"Data" table contains 4th and 5th column, email id's. when i will change team name on combo button, one of the variable should capture old team name and another variable name should capture the new team name which i will select.

When saving this data, e-mail should go on old team name and new team name respective mail id's..

This is what I'm trying to do.. and hence Im trying to capture 4th and 5th column data in variables. Hence asking for select query..

 

[Joe4]

I do have visual basic 6.0 software with me, where i have designed one of the form. On this form, there is control combo. Combo contains team names in list.

Why are you using Visual Basic 6.0 instead of just using the the built-in VBA for Access?
I have no experience interacting Visual Basic with Access (I have never had any reason to, as Access has its own VBA).