₦airaland Forum

i want my combo box to be seen data/record from another table, it work but only seen the first record in the table & not the whole record
See the code below



Private Sub Form_Load()
Dim con As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim Rs As New ADODB.Recordset

con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Air Plane\Airline.mdb;Persist Security Info=False"
con.Open ' myRecSet.Open
'cmd.ActiveConnection = con
cmd.CommandText = "Select * from addrecord"
Rs.Open "Select * from addrecord", con, adOpenDynamic, adLockOptimistic
' Set RecSet = cmd.Execute
With Rs '
combo1.AddItem !From
End With

bigafees:
i want my combo box to be seen data/record from another table, it work but only seen the first record in the table & not the whole record
See the code below



Private Sub Form_Load()
Dim con As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim Rs As New ADODB.Recordset

con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Air Plane\Airline.mdb;Persist Security Info=False"
con.Open ' myRecSet.Open
'cmd.ActiveConnection = con
cmd.CommandText = "Select * from addrecord"
Rs.Open "Select * from addrecord", con, adOpenDynamic, adLockOptimistic
' Set RecSet = cmd.Execute
With Rs '
combo1.AddItem !From
End With

DO WHILE NOT RS.EOF
combo1.AddItem !From
RS.MOVENEXT
LOOP

Thanx Man it work

@ LuckyCo, Please Assist me on this also

I want to save picture in my Ms-Access,

.Fields("FOTO" = img2.Picture

save correctly, but if i now search/retrieve for that person record to bring his picture maybe for Editing or something else, the following line of code gives error:


img2=!foto

pls help again

Hi bigafees,
You don't have to save the image file in the access database, instead, you save the image file in a folder you will create for staring the images. What you store in the database is the name of the file name image . Once you want to access the image , you retrieve the file name from the database and use the picture box 'load picture' method to view the image.