Search:

Type: Posts; User: swatty

Page 1 of 13 1 2 3 4

Search: Search took 0.53 seconds.

  1. Replies
    7
    Views
    1,164

    Re: VBA - Skipping every other cells

    a= 1
    For i = 1 To LVW.ColumnHeaders.Count

    Sheet1.Cells(1, a) = LVW.ColumnHeaders(i).Text
    a = a +1
    Sheet1.Cells(1, a) = "|"
    a = a +1
    Next i
  2. Replies
    19
    Views
    2,387

    Re: incorrect syntax near 'where'

    I think you are missing a point.
    no need to do an update when there is nothing to be updated.
    Better to put in a test that assures u there is data to be updated.
    if not no need to execute the...
  3. Replies
    4
    Views
    1,304

    Re: Run-time error '424' (object required)

    The way i should do it, is to set the value of the one sheet equal to the value of what you want to copy
    Made ur code of 6 lines in one line. Just be sure of the range where u want to paste it.
    ...
  4. Replies
    3
    Views
    493

    Re: innaccurate result

    Take the 8 digits at the right of your variable.
    This would help.
    The problem is when you add to many hours, so it becomes another day the date is shown also.



    label1.Text =...
  5. Replies
    5
    Views
    537

    Re: Help with searching?

    Smells like school project.

    We can try to help many people , but won't make another one's work.


    Could give u plenty examples , but i could put in many errors 2.
    Try to look in the lessons...
  6. Replies
    4
    Views
    789

    Re: Combobox Auto complete

    I think your problem resides in following line.


    For i = 0 To ComboState.ListCount


    Think it would be better to change it to


    For i = 0 To ComboState.ListCount -1
  7. Replies
    11
    Views
    734

    Re: Migration code not working

    Can't you put in an extra test on mvarNumber



    If Not mvarNumber Is Nothing And mvarNumber <> "" Then
    com.Parameters("@Number").Value = mvarNumber.DBCode
    End If

    And maybe check on...
  8. Re: [Access] Getting data from Excel Spreadsheet into Access Table

    You've got your button.
    Only thing to do is loop through the excell file till end and update your access table where studentID equals with the studentID from excell table.

    Show what you got...
  9. [RESOLVED] MS Access multiple grouping proper presentation

    No help needed anymore, have created a report through code who writes to Excell, and it looks like I wanted it.

    Anyone who can help me with grouping on report with proper presentation ?

    I got...
  10. Replies
    4
    Views
    618

    Re: [RESOLVED] Enum value according variable

    Thnx, will do with the collection.
    No need to read from table.
    Prefer this

    For iCount = 1 To oXLees.Worksheets.Count
    strSht = oXLees.Worksheets(iCount).Name
    iTxt = InStr(1,...
  11. Replies
    4
    Views
    618

    Re: Enum value according variable

    Like I said, did not want to use select case.
    Because i have to put in two select cases .
    If my enumerator expands it is easier to adjust then add into my select cases.

    To answer your question,...
  12. Replies
    4
    Views
    618

    [RESOLVED] Enum value according variable

    Hello,
    I have made an enum to work properly.
    Now i've found a problem on choosing the right enum.
    can someone point me in the right direction ?
    I'am reading an excell sheet, and need to convert...
  13. Re: Simple question on sum (MS Access)

    There is no need, to store the total in your table.
    Each time you want this total , use your query.
    If you store the total, each time a value changes in a sp column the total must be recalculated...
  14. Replies
    5
    Views
    471

    Problem starting pc

    when i want to startup my comp it only beeps. Every few seconds it gives a beep. Nothing else happens.
    I think that it is missing something, and gives the beep for it. But i cant find what it could...
  15. Replies
    8
    Views
    1,696

    Can you be more specific , like the Hiker asked....

    Can you be more specific , like the Hiker asked.
    Your question is incomplete.

    Are you trying to delete the program from the drive.
    Or are you trying to stop the program from running ??

    The...
  16. Thread: String help

    by swatty
    Replies
    7
    Views
    633

    If you know the word, you can use instr to check...

    If you know the word, you can use instr to check if it exists in your string.
    If you know how long a particular word is , you can use left$ or right$

    Test them out, so you can see how they work
  17. Replies
    9
    Views
    687

    You should check if the drivers are installed in...

    You should check if the drivers are installed in ME.

    You found no problem on XP because the drivers are installed there, otherwise you couldn't wrote that program.

    I think you need to ad MDAC...
  18. Resolved

    Forgot to put script tag in front of function
  19. Execute a function by click on image (Resolved)

    Hi folks,

    I try to execute a function by clicking on an image.

    I have a table with in the last column an image.
    By clicking in this image (trash can) the table must be remade but the line...
  20. All answers i found on this topic telling to use...

    All answers i found on this topic telling to use BinaryWrite.

    Seems in my project it won't work properly, i don't get an error the only thing i see is an image object with the X in it.
    Just like...
  21. Tried this, doesn't work, i only get an image box...

    Tried this, doesn't work, i only get an image box with no image in it.

    Will keep on trying it this way, if there are other ways to get them images please reply.
  22. Get image out of access db in asp (Resolved)

    Can someone tell me how to retrieve an image stored in an access db and show this through asp ?

    Many answers tell me to store the path into the db, but that is not an option.

    Tried with...
  23. Replies
    3
    Views
    517

    First try to use vbcode tags in your question, it...

    First try to use vbcode tags in your question, it will be better to read for others.
    Try to understand you're no longer working in Access.

    Try to copy and paste this code in your form,
    adjust...
  24. Maybe you could remove this thread , cause it...

    Maybe you could remove this thread , cause it won't help anyone anyhow
  25. Replies
    1
    Views
    404

    How to write own HELP

    Someone who know's where i can find a good tutorial in writing my onw help in VB ?

    Advanced thanks.
  26. Replies
    50
    Views
    1,470

    What is it you have problems with ?? If you...

    What is it you have problems with ??

    If you have a question you could always ask here . :p :p :p :p
  27. Replies
    50
    Views
    1,470

    He never will . :D :D :D :D :D

    He never will . :D :D :D :D :D
  28. Replies
    59
    Views
    4,000

    going to take a

    going to take a
  29. Replies
    59
    Views
    4,000

    blubbing around the pool

    blubbing around the pool
  30. Replies
    50
    Views
    1,470

    Here's yours

    Here's yours
  31. Replies
    50
    Views
    1,470

    Hey you're Not e Me try this Debug.Print...

    Hey you're Not e Me try this

    Debug.Print Chr(72) & Chr(111) & Chr(112) & Chr(101) & Chr(32) & _
    Chr(116) & Chr(111) & Chr(32) & Chr(115) & Chr(101) & _
    Chr(101)...
  32. Replies
    50
    Views
    1,470

    So Jamie, forget about the Bar then. If you...

    So Jamie, forget about the Bar then.

    If you can change your mind in 8 minutes, sure no one can rely on you then.:D :D :D :D :D
  33. Replies
    50
    Views
    1,470

    Remember the nun in France when we were taking...

    Remember the nun in France when we were taking over the Eiffle tower .

    Loved creating that coded msg.
  34. Replies
    50
    Views
    1,470

    Jamie Like i've replied to the dogrunner, if...

    Jamie

    Like i've replied to the dogrunner, if I am in your country we could search a bar and get a lot of drinks.

    For Jamie to pay all of it.


    Untill then , ;)
  35. Replies
    24
    Views
    658

    Looking at your name, from the moment you know...

    Looking at your name, from the moment you know the time and place you're allready somewhere else at another time.
  36. Replies
    50
    Views
    1,470

    I can't find the beer ???

    I can't find the beer ???
  37. Replies
    50
    Views
    1,470

    The US will be justified to rule the universe...

    The US will be justified to rule the universe from the moment I am gone, meaning gone from this Universe.

    Untill that day , they won't ass long as I live.
    :p :p :p :p
  38. Replies
    50
    Views
    1,470

    Be sure the day i come to the UK , I'll bring the...

    Be sure the day i come to the UK , I'll bring the nun and let him f the dog.
  39. Re: Wow..

    The error comes from objectname which isn't the field you want.

    change it to


    records.Open "select * from table1 order by table1.object", access, adOpenKeyset, adLockOptimistic, adCmdText

    ...
  40. Replies
    50
    Views
    1,470

    I knew there are some ......... over here too. ...

    I knew there are some ......... over here too.

    But hey , if they weren't it wouldn't be so exciting over here.


    Dim iCount As Integer

    For iCount = 1 To 1000
    Debug.Print "CU...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width