maj3091's Profile User Rating: *****

Reputation: 301 Architect
Group:
Expert
Active Posts:
1,787 (0.88 per day)
Joined:
26-March 09
Profile Views:
21,605
Last Active:
User is offline Today, 02:04 PM
Currently:
Offline

Previous Fields

Country:
GB
OS Preference:
Who Cares
Favorite Browser:
Chrome
Favorite Processor:
Intel
Favorite Gaming Platform:
PC
Your Car:
Who Cares
Dream Kudos:
0
Expert In:
VB6

Latest Visitors

Icon   maj3091 has not set their status

Posts I've Made

  1. In Topic: I want to change my Pos from vb6

    Posted 21 Oct 2014

    As modi123_1 has pointed out...You'll be future proofing your program to some degree.

    VB.Net would seem like the logical choice, albeit migration might not be as straight forward as you may think (reliance on ActiveX controls in VB6 etc.).
  2. In Topic: save as excel file in the date today

    Posted 4 Oct 2014

    You're not helping yourself...

    1. Look at how to use code tags, it's not difficult.
    2. Be more descriptive with what the actual problem is. "I'm having an error" and "it not the output I want" are not helpful to anyone to try and help you.


    When posting, look at it the other way around...would you be able to advise someone on this issue if they'd given you the same information as you're posting here??

    I'm not trying to get on your case, I'm just offering some friendly advice.
  3. In Topic: VB6 Loops

    Posted 2 Oct 2014

    That's because you need to sum up your total in the loop.

    TotalTime = 0
    race = InputBox("How many races have you completed?")
    For loops = 1 To race
      time = InputBox("What was your time for race " & loops)
      TotalTime=TotalTime + Time
    Next
    
  4. In Topic: VB6 Loops

    Posted 1 Oct 2014

    You're not storing your time anywhere?

    Look at how you store the number of races then have a look at what you've done when getting the time for each race.
  5. In Topic: save as excel file in the date today

    Posted 29 Sep 2014

    It explains how to use code tags in the background of the window you use to post....

    I'm not all that familiar with VBA in excel, but to create the filename with the date, you should be able to use something like you already have.

    dim strFilename as string
    dim strPath as string
    
    strPath = "C:\Temp\"
    
    'Create a full path using the date and time
    strFilename = strPath + format(now(),"YYYY-MM-DD_HHMMSS") + " MyFileName.xls"
    
    ' This should give you a full path like "C:\Temp\2014-09-29_192040 MyFileName.xls"
    ' You should then be able to pass this into the Save method.
    

My Information

Member Title:
D.I.C Lover
Age:
43 years old
Birthday:
June 12, 1971
Gender:
Programming Languages:
C#, VB

Contact Information

E-mail:
Private
Website URL:
Website URL  http://

Comments

Page 1 of 1
  1. Photo

    Coulee Icon

    02 Feb 2012 - 19:29
    Hi,I found your post Compiling on Win7x64 SP1 gives ADO Issue on XP....http://www.dreamincode.net/forums/topic/221024-compiling-on-win7x64-sp1-gives-ado-issue-on-xp/
    I met the same problem,can you help.
    I will really really appreciate it
  2. Photo

    maj3091 Icon

    20 Dec 2011 - 01:32
    Thanks raziel_, I didn't realise what you meant at first! I was hoping you knew my boss at work! :)
  3. Photo

    raziel_ Icon

    19 Dec 2011 - 09:24
    gratz on the promotion man :)
Page 1 of 1