sorry sir,..can you show me how to make it(code in vba)?
i think i only need to make control textbox and assign the value after i create code for loading recordset so the form look such as datasheet.
n3wkid
Last Activity: Sep 3 '14, 03:01 AM
Joined: Jun 1 '14
Location:
-
Can we assign the value without bound in the form (assign the value with vba)?Leave a comment:
-
Control textbox to load data
Dear All,
I have question about control textbox.
example,
I have two textbox and have placed in the form(datasheet to show all table of data).
design layout if i use control source on the form such as the mention below
| number | status |
-------------------
| 1 | ok |
| 2 | ok |
but now there I want to make unbound... -
Thank you so much... :)Leave a comment:
-
thanks so much..I waiting this..Leave a comment:
-
twinnyfo,
I have face error..and I don't understand full to change it
with ADO
maybe you can totally re write if you want to help me?Leave a comment:
-
Convert to ADO from DAO Method
Dear All,
Good Morning first.
I have code in DAO Method such as
...Code:Function delete_tb(name_of_table) Dim rs1 As Recordset Dim db As DAO.Database Set rs1 = CurrentDb.OpenRecordset("SELECT MSysObjects.Name" _ & " FROM MSysObjects WHERE MSysObjects.Type= 1 And MSysObjects.Flags=0" _ & " and MSysObjects.Name='" & name_of_table -
I have change with your declare but new error show again in line
...Code:Option Compare Database Option Explicit Dim db As Database ----- cut code Private Sub show() Dim at As Variant, bb As Variant, url As String Dim bc As Variant, bd As Variant, be As Variant, j As Variant, bx As Variant Dim i As Variant, t As Integer Dim tbb As Variant, tb2 As Variant cut code
Leave a comment:
-
Subscript out of range in vba
Dear Master
I face error in vba code ms access 2010.
and message error is "Subscript out of range (9)"
and normally I can't to solve this is.
this the code
...Code:Private Sub show() Dim at, bb, url As String Dim bc, bd, be, j, bx As Variant Dim i, t As Integer Dim tbb, tb2 As Variant For i = 0 To 10 Me("p" & i).Caption = "" Me("p"
No activity results to display
Leave a comment: