Ask Experts Questions for FREE Help !
Ask

Search:

Type: Posts; User: GaryStaunton

Search: Search took 0.00 seconds.

  1. Answers
    2
    Views
    1,144

    Hi "SELECT [Survey Questions]. * FROM [Survey...

    Hi "SELECT [Survey Questions]. * FROM [Survey Questions] WHERE SeminarID =" & intSeminar Why do you have a full-stop here "[Survey Questions]."? I'm guessing this is the problem.
  2. Obviously you need to handle the error. ...

    Obviously you need to handle the error.

    Content.SelectionStart = Content.Find(word)


    Try assigning the .Find function to a variable and check it first:

    lngWordPos = Content.Find(word)

    If...
  3. Hmm Maybe something like: Me.Left = 100...

    Hmm

    Maybe something like:

    Me.Left = 100
    Me.Top = 100

    A = 1 + 1
  4. Answers
    1
    Views
    266

    What's the code you used to increase the size? ...

    What's the code you used to increase the size?

    It could be something similar to that code with a couple changes to the values.
  5. Question: Visual Basic

    by GaryStaunton
    Answers
    3
    Views
    1,095

    Wouldn't you need to search the second table for...

    Wouldn't you need to search the second table for the value, if it exists, then save it to the first table?

    Eg query:

    SELECT * FROM TableValues WHERE FieldName = 'FindThisValue'

    So...
    ...
  6. Answers
    4
    Views
    610

    Would be nice to see an example of the output. ...

    Would be nice to see an example of the output.

    Try this:

    Label1.Caption = Label1.Caption & TextToDisplay & " "
  7. Answers
    4
    Views
    610

    Look up how to use the Checkbox in the help file....

    Look up how to use the Checkbox in the help file. You can use the Click event, for example:

    Private Sub Check1_Click()

    Dim TextToDisplay As String

    If Check1.Value = 1 Then TextToDisplay =...
  8. Answers
    4
    Views
    610

    Look up how to use the Checkbox in the help file....

    Look up how to use the Checkbox in the help file. You can use the Click event, for example:

    Private Sub Check1_Click()

    Dim TextToDisplay As String

    If Check1.Value = 1 Then...
  9. Question: Ceiling Fan

    by GaryStaunton
    Answers
    6
    Views
    520

    In that case, go for it - it shouldn't be too...

    In that case, go for it - it shouldn't be too hard to replace the capacitor if you've got the right equipment (which I assume you do). Again, my only concern would be the fact the it's melted/burnt,...
  10. Question: Ceiling Fan

    by GaryStaunton
    Answers
    6
    Views
    520

    There's only one way to find out - replace the...

    There's only one way to find out - replace the capacitor and see what happens. There still may be an underlying problem that caused the capacitor to burn out in the first place, I would assume that...
  11. Answers
    5
    Views
    561

    The error relates to the database field type:...

    The error relates to the database field type:
    qry = "select * from [heavy equipment] where codeno=" & Val(txtsearchcode.Text)

    If the field codeno in the database is defined as being a text field,...
  12. Answers
    2
    Views
    703

    I'm not surprised that you get an error. Do a...

    I'm not surprised that you get an error. Do a little research on SQL queries, for example:

    search = "SELECT * FROM TableName WHERE [Quantity in Stock] < [Reorder Level]"

    Then apply this SQL...
  13. Doubt that you will get a answer for this, if I...

    Doubt that you will get a answer for this, if I knew how to do it - I would not share it. This type of "silent" installation/running could also be called a virus!

    Why on earth would you want to...
  14. Question: Ceiling Fan

    by GaryStaunton
    Answers
    6
    Views
    520

    Rather easy, simply take the unit down and throw...

    Rather easy, simply take the unit down and throw it in the bin, go out and buy a new unit.

    There's a reason that the unit is showing signs of something melting... it's faulty and for the price of...
  15. Answers
    5
    Views
    561

    Comment on GaryStaunton's post

    I have assumed that the database field is a TEXT field, if not, let me know. My example above is for a TEXT field.
  16. Answers
    5
    Views
    561

    Simply put (copy+paste friendly): qry = "SELECT...

    Simply put (copy+paste friendly):
    qry = "SELECT * FROM [heavy equipment] WHERE codeno= '" & txtsearchcode.Text & "'"

    Basically your code needs o connect to a valid data type... From the name...
Results 1 to 16 of 19