Close

Results 1 to 2 of 2
  1. #1
    DF VIP Member drdude's Avatar
    Join Date
    Oct 2002
    Location
    Putney
    Posts
    949
    Thanks
    72
    Thanked:        40
    Karma Level
    327

    Default VB help required please

    My brain has turned to slush and for the life of me cannot work out what code I need to glue together to get round this problem.

    An image is provided to help explain my issue:



    The form is used to automate data entry to defined areas of a report using DocVariables.

    Waste procedures was very simple to deal with because all that was required was to finish off a sentence within the report. This was achieved using a simple if statement:

    Code:
    If MemoForm.WPOptionSkip = True Then
        ActiveDocument.Variables("WasteProcedure") = "skip provided."
    Else
        ActiveDocument.Variables("WasteProcedure") = "wait and load waste transport provided."
    End If
    Equipment schedule is fucking me right off.

    I am not looking to be spoon fed a solution, instead it would be useful if someone could offer advice on the right path to take, whether it be using a fuck load of 'If', 'ElseIf' statements, or whatever. My programming experience is practically zilch with the exception of HTML and CSS, so my VB knowledge has only been accrued by reading through other bits of code within this project. However there is plenty of spare time available at work for me to learn something new, so with a little prod from a knowledgeable member, I can start trying to work it out for myself

    Any help is GREATLY appreciated. If I am failing to explain myself clearly please flame away and then ask questions.
    Last edited by drdude; 19th July 2007 at 12:19 PM.

  2. #2
    DF VIP Member Unconected's Avatar
    Join Date
    Jun 2006
    Location
    England
    Posts
    332
    Thanks
    0
    Thanked:        0
    Karma Level
    240

    Default Re: VB help required please

    The way I would do it would be something along the lines of:

    Check to see whether box is ticked

    If it is convert text box to integer and store value

    if not go to next tick box.

    and so on.

    It would be something along the lines of
    If MemoForm.ESOptionHType = True Then
    HTypeNo = Textbox1.text
    cint(HTypeNo) //not really sure of the VB here
    End If

    or whatever. I think thats where you were going yeah? I assume you were just having difficulty with dealing with the value in the textbox. If this is way off then i should go back to working with Connectors

Similar Threads

  1. Telepui codes required ?
    By DeltamdX in forum Digital Satellite TV
    Replies: 1
    Last Post: 2nd October 2002, 12:29 AM
  2. Me55i@h-X required
    By BFG in forum Microsoft Consoles
    Replies: 4
    Last Post: 28th September 2002, 02:20 AM
  3. IBM T23 – CD-R/RW – Front Panel required
    By afrokiwi in forum PC Hardware
    Replies: 0
    Last Post: 17th September 2002, 06:53 PM
  4. Problem: Help required (tv issue)
    By brumbino in forum Digital Satellite TV
    Replies: 0
    Last Post: 17th September 2002, 01:51 PM

Social Networking Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •