Unanswered: The easier question of Access I was made...
I have a little trouble in Access, I want to populate my textbox from a query object in Access (2002), yes, only that but sincerelly I missed how can I do that. I could use access direct method (an assistants-hit or something) but I want to use code, because I want to populate this textbox based on an specific sql search, I failed miserably ... plz help
Option Compare Database
Private Sub cmdActualizaActualizar_Click()
Dim MyConn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim strName As String
Dim strAddress As String
Dim strPhone As String
Set MyConn = New ADODB.Connection
MyConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\DAVIDG\Escritorio\new1\Data.mdb;"
Set rs = MyConn.Execute("SELECT Demanda, Punta FROM tblTarifas")
Me.txtDemandaAnterior.Text = rs!Demanda
I know this could be easy for u, but I really hard for me... ,
Thnks for ur help
I have solved this stupidity, just by change text for value in the code, also I have another interesting question regards Textbox...
I have a two combobox (one for the month and the other for year), that I want is to take the values of this combos and "joint" into onte textbox stores the first day of the specific month and year (my date format is DD/MM/YYYY)
for example I put in the combo1 - September and combo 2- 2004
And I want to textbox shows.
"01/09/2004" or "01/september/2004"
I think I first need to set combo1.text = string, but before that I don't really know how can I do this.