Hi
I have the following problem
I have a string that will contain 16 numbers , ones or zeros in unknown order
How can I find out if the string will have a zero or zeros between atleast two ones
for example something like 111011111100111 1
omozali
Last Activity: Jan 28 '07, 02:54 AM
Joined: Nov 26 '06
Location:
-
excellent thanks alot everybody... -
accessing sub from within
How can I call a sub associated for example with a button from inside my code?
for example
-------------------------
[CODE]private sub f_click()
I tried run (f_click()), but didn't workCode:end sub --------------------------- private sub s_click() f_click() <-- How I call this to run here? [more code] endsub
-
db size
Does Database file size usually grow in megabites easly?
My db file is around 400 GB which is amazing. Which part does it usually take most of space, tables or forms? -
Multi tab form
Hi,
How I can create a multi tap form. I used to remember how few years ago but not any more
I mean many forms shown on the screen and accessed by clicking on their tap just like in excel -
If found the answer
if Typename(mytext box) = "Nothing" WORKS...Leave a comment:
-
But if you set mytextbox2 as textbox isnull would still returns true even if you don't associate it to a valid text box...Leave a comment:
-
I found out that typename(mytext box) before association returns Nothing
and after association returns TextBox
The weird thing is this still produces error
if typename(mytext box) = Nothing then...Leave a comment:
-
testing for association
Hi,
How can I test if a variable was associated with an object or not
for example
dim mytextbox as textbox
if mytextbox = Nothing then <=== this produces error
mytextbox = textbox0
else
set mytextbox = Nothing
endif -
Thanks for everybody replies
Here is what I'm really trying to do
in a form there is option button 4 and option button 6
there are also 2 hidden text fields: text0 and text2
and a button
I want when ever an option button is checked and the button clicked then one of the textboxes would become visible depending which one is still invisible
so for example checking option button 4 would...Leave a comment:
-
variable field
Hi all,
How can I store field name into a variable and then access its properties?
for example field text1
I'm trying something like this
dim box as string
box = "text1"
box.visible = true
I always get error
I even tried [box].visible and ["box"].visible but non works
thanks -
Sorry for the late responce. my situation is ok now thanks...Leave a comment:
-
unfortunately, it didn't...Leave a comment:
-
one small thing when the code run a small window would appear saying
you are about to a append 1 row and asks for confirmation
any way to remove this annoying window?Leave a comment:
-
an update for those interested , this code works
Private Sub Command7_Click( )
Dim strUSER As String
Dim UN As String
Dim PW As String
UN = username.Value
PW = password.Value
strUSER = Nz(DLookup("[user]", "table2", "[user] ='" & username.Value & "'"), "nouser")
If strUSER = "nouser" Then
Rem CurrentDb.Execu te...Leave a comment:
-
I tried this
CurrentDb.Execu te ("INSERT INTO table2 ([user], [pass]) VALUES (username.value ,password.value )")
generates: too few parameters, expect 2
I also tried
CurrentDb.Execu te ("INSERT INTO table2 ([user], [pass]) VALUES ('username.valu e','password.va lue')")
Things get added to the table but instead the value of username I actualy get the text username.value...Leave a comment:
-
Unfortunately the code generated syntax error :(...Leave a comment:
-
Insert Into query using VBA
Can someone please tell me why INSERT INTO generates syntax error
Private Sub Command7_Click( )
Dim strUSER As String
strUSER = Nz(DLookup("[user]", "table2", "[user] ='" & username.Value & "'"), "nouser")
If strUSER = "nouser" Then
INSERT INTO table2;
VALUES (username.Value ,password.Value );
MsgBox "User added"... -
could you plz explain this code for me?...Leave a comment:
-
Select ... From
I still new to SQL think and trying to learn but its not easy
I have a table called table2, it has 2 fields user and password. In a form I have a textbox that will contain input
I want to do search on this table to find if user exist or not
How can I do that?
I tried
SELECT user FROM table WHERE box.value=user
but get error on 'user' saying expected: Case
No activity results to display
Leave a comment: