User Profile

Collapse

Profile Sidebar

Collapse
gozzer101
gozzer101
Last Activity: Dec 31 '06, 11:05 PM
Joined: Nov 27 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • gozzer101
    replied to Report - Openened twice
    in Access
    BUMP ;-)

    Any help is much appreciated.
    See more | Go to post

      Leave a comment:

    • gozzer101
      started a topic Report - Openened twice
      in Access

      Report - Openened twice

      Hello!

      I have a slight problem with a report.

      I have a report which is made from a query (User enters in PersonId) Then it comes up with a payslip. I want a msgbox to appear if the user opens the same persons report twice. Say person id = 1, payslip comes up. Then I want the user to know that they have already viewed(payed) this report.

      Is this possible? If so any help is much appreciated! Thank you in...
      See more | Go to post
      • gozzer101
        started a topic Grouping Data on reports
        in Access

        Grouping Data on reports

        Hello! I have a small problem with grouping data on reports.
        The situation is that I have an PersonIDnumber, PersonName, NoPurchases and ProductNumbersA llocated.

        The person ID is just any number, which I want to be sorted in the report (did this fine), however if I have a personID that has more than one prodcutnumbersa llocated, then it lists the PersonID several times.

        PersonID and PersonName is from "TableA"...
        See more | Go to post
        • gozzer101
          replied to changing colour
          in Visual Basic
          Well I don't really know what you mean by anwser....

          But If your answer checking system is something like:

          if textbox1.text = textbox2.text then
          msgbox("answer correct")
          else
          msgobox("answer incorrect")
          TextBox2.ForeCo lor = (vbRed)
          end if


          or you can replace the "vbred" for the colour code.

          You need to explain more...
          See more | Go to post

            Leave a comment:

          • gozzer101
            replied to VB - Select case
            in Visual Basic
            Ah ok. Thank you!...
            See more | Go to post

              Leave a comment:

            • gozzer101
              started a topic VB - Select case
              in Visual Basic

              VB - Select case

              Hello all. I have managed to get the select case statements working using the following code:

              Dim strwhichoption As String

              strwhichoption = ComboBox1
              ComboBox1.AddIt em ("Reina")
              ComboBox1.AddIt em ("Sorensen")
              ComboBox1.AddIt em ("Cudicini")
              ComboBox1.AddIt em ("Van Der Sar")

              Select Case strwhichoption
              Case Reina
              TextBox17.Text...
              See more | Go to post
              • gozzer101
                replied to VBA - Combo Box
                in Visual Basic
                Thanks for the reply!

                Still having trouble with this. VBA recognizes .rowsourcetype in the code, but how do i assign it to value list? I have tried the following
                combobox1.rowso urcetype = value list
                combobox1.rowso urcetype = "value list"
                combobox1.rowso urcetype [=value list]

                Nothing seems to work though.

                The .additem method I gave a go too. I tried combobox1.addit em ([Exampledata1,...
                See more | Go to post

                  Leave a comment:

                • gozzer101
                  started a topic VBA - Combo Box
                  in Visual Basic

                  VBA - Combo Box

                  I want a combobox in an userform which has a list of values already in the dropdown bar. Im quite new with vba and I'm stuck with this. I think I can use the rowsource property but this means I have to put some data into a worksheet, which I would prefer to avoid as I only want a userform

                  Thank you in advance for your help!
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...