Hi,
I think the problems lies with the a bit of confusion in the variables names used.
first you creat two arrays 'mystring1 and mystring2', then you re dimension 'mystring1'.
The next step is the confusion you try to place the variable 'searchby' into a variable called 'mystring1' - which is an array without telling where in the array to place it?, thus the confusion.
If...
AlanHill1965
Last Activity: Mar 12 '07, 01:34 PM
Joined: Feb 19 '07
Location: London
-
HI,
Just been nosing around and noticed this post.
The following code uses an image fram called Qpic and a button called start.
You wil see the comments show what happens at each line. the part you have missed is the part after where the Qpic picture is replaced.
here the object QPIC the command to LoadPicture after the '=' sign. This tells it to load a picture...Leave a comment:
-
Ok,
Step 1 , I have a database, which has a button
Step 2 , The button creates an email to send to a person.
Step 3 , The email arrives
Step 4 , The email link opens the same database
Step 5 , In the hyperlink you can have extra information which is split by the hash mark (#).
Step 6 , As the database opens the hyperlink used to open it is captured into a variable.
Step 7 , Using the variable...Leave a comment:
-
hi, noted your interest in serial coms from VB a good litle starter would be at the following link
http://www.bitwisemag. com/copy/vb/vb1.html
This will give you the basics of communication over the serial port from vb. Once you can talk you need to get the serial info seperated out to control the lines that will switch the led's on and off.
Hope this give an indicator (Shead some light...etc.)
...Leave a comment:
-
Hi,
An alternate would be to use the right command
this would return a piece of text with just three characters in with your number justified to the right.Code:public function RightJustNumber(n as integer) RightJustNumber = Right(Space(3) & n,3) end function
a little test would be as follows;
...Code:Public Function test() For a = 0 To 1000 Step 100
Leave a comment:
-
Hi,
Would it not be simpler to set you combo box source to a table/query type then set the rowsource to the SQl string, followed by a requery,
The following code works for me;
Private Sub Frame38_Click()
Dim a As Variant:
a = Me.Frame38.Valu e
Select Case a
Case 1
strSQL = "SELECT Cat.Index, Cat.Category...Leave a comment:
-
Hi,
The simplest method is to grab the sql text and paste into a new query, the go into query view, any errors will be highlighted for you.
If the query is an action query be arawe of the changes that may be made, going into the table view wil alow you to see which records are going to be changed.
If the query is built using variables, place a stop in the VBA window then rab the text from the Immediate...Leave a comment:
-
Hyper link capture
Hi All,
I have developing a database system for the last couple of weeks and got stuck on one part of the functionality. I have posted this question over at MSDN, but no joy, perhaps they got upset about the fact I had posted to the wrong area (VBE not VBA...).
Anyway The problem I have is in capturing the hyperlink used to open an MS Access database.
The database (Access 2000) is used to gather the results...
No activity results to display
Leave a comment: