how to take queries of DBGrid to DataReport?
any idea?
gman_00ph
Last Activity: Aug 28 '06, 01:06 PM
Joined: Jul 14 '06
Location:
-
DBGrid to DataReport, How to
-
this one filters the textbox from any non-numerical values:
"If IsNumeric(text1 .text) = false then..."
this one filters the keypress in the textbox: (you can press backspace and enter)
Private Sub Text1_KeyPress( KeyAscii As Integer)
If KeyAscii >= 58 Or (KeyAscii <= 47 And KeyAscii <> 8 And KeyAscii <> 13)_
Then
KeyAscii = 0
End If
End Sub
hope... -
What if there is a value in B
and i want to put a null value in B
at this point i cant update it
not unless i use to insert this value=" " to B...Leave a comment:
-
Just to let you know DATA Component doenst have database password under the property window. So im still hoping for that code......Leave a comment:
-
I open my access97 and set "mypassword " to mydbase.mdb
and then i re-run, i got this:
Run-Time error '3031': Not a valid Password.
help needed please...Leave a comment:
-
it doesnt have to do with textboxes.
i just the need the way to acces my Database using "Data1" -- Data Component.
Private Sub Form_Load()
With Data1
.DatabaseName = App.Path + "\mydbase.m db"
?????.Password= "mypassword"??? ?? <--- something like this or other way
.RecordSource = "Select * from usertable"
.Refresh
End With
End ...Leave a comment:
-
ops wrong spot, sorryLeave a comment:
-
VB6.0 Database Password HELP!!!
Private Sub Form_Load()
With Data1
.DatabaseName = App.Path + "\mydbase.m db"
.RecordSource = "Select * from usertable"
.Refresh
End With
End Sub
--------------------------------------------------------------------------------
"mydbase.md b" is created in Access97
im using a standard Data Component for "Data1"... -
Private Sub Form_Load()
With Data1
.DatabaseName = App.Path + "\mydbase.m db"
.RecordSource = "Select * from usertable"
.Refresh
End With
End Sub
--------------------------------------------------------------------------------
"mydbase.md b" is created in Access97
im using a standard Data Component for "Data1"...Leave a comment:
No activity results to display
Leave a comment: