i've been stuck on this problem all day.
how can i use a variable name to set several textboxes to readonly?
While MyDataReader.Read
if MyDataReader.Item("FieldType") Is System.DBNull.Value then
' do nothing
else
if MyDataReader.Item("FieldType") = "Hidden" then...
in vb i could use code like this to get the field name from a database table and then hide the textbox with the same name.
if rs("FieldName") = "hidden" then
me("txt" & rs("FieldName")).visible = false
end if
but in asp.net using vb.net i can figure it out. the code below gives the error...
if i type 1 in a cell it changes to 100. it's like it's formatted for percentage but doesn't show the % sign. i've formatted it to be number and general but it still displays 100.
does anyone know what would cause this?
thanks.
is there a way to clear the command line arguement that is stored in Command$?
i've tried
Command$ = Null
Command$ = ""
i get this error "Function call on left side of assignment must return Variant or Object"
Set Command$ = Nothing
i get this error "Invalid use of Property
i get the little white circle with a green arrow in it then to the right there's a red wavey vertival line.
i can't figure out what this is, anybody have any ideas?
thanks
Doug
check a required field when record nav buttons are used.
i have a form that has 2 checkboxes. if i click next, previous, add new, last, first, i want to force the user to check one of the checkboxes before they leave. i've got the afterupdate on the checkboxes coded so if one is checked the...
is there a way to delete a file? i have a database that repairs and compacts a list of databases in a table and creates a new db as dbname_C.mdb that's been compacted, then i want to delete the non compacted version and the rename the dbname_C.mdb file. everything works execpt the delete...
i've posted this in the IIS forum but no replies (i guess not many read the IIS forum).
i've got a IIS server named k8 with a dynamic ip of xxx.xxx.xxx.101 and a static ip of xxx.xxx.xxx.13. when i ping the server using the server name k8 i get back the 101 ip address. but when i enter k8 or ip...
i've got a IIS server named k8 with a dynamic ip of xxx.xxx.xxx.101 and a static ip of xxx.xxx.xxx.13. when i ping the server using the server name k8 i get back the 101 ip address. but when i enter k8 or ip xxx.xxx.xxx.101 into internet explorer the web page doesn't show, but if i enter the...
i want to create an autonumber ID field in an existing table, but when i execute the code i get this error message:
run-time error '3293': syntax arror in ALTER TABLE statment.
Private Sub Command0_Click()
Dim tblName As String
Dim SQLstr, sql1, sql2 As String
tblName = "TCRM...
i have an adp that i finally got working right, but domain admins are the only ones that can run the adp and not have all the tables and queries have (dbo) at the end, regular domain users get tables and queries that look like this:
tablename (dbo)
viewname (dbo)
storedprocedurename (dbo)
i've...
i've imported my back end database to sql server then linked the from end tables to the sql. there are about 3000 record and the searches and queries are extremely slow. is there anything that will speed it up?
i have ran the upsizing wizard and had it create an adp but i can run the adp with...
I've got a combo box to select from and then it creates a stored procedure and tries to open it.
I get this error message when i select an item from the combo box: "microsoft access can't find the object 'zTest'. when i look at the queries it's not there until i hit F5 to refresh and it...
I've got a combo box to select from and then it creates a stored procedure and tries to open it.
I get this error message when i select an item from the combo box: "microsoft access can't find the object 'zTest'. when i look at the querries it's not there until i hit F5 to refresh and it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.