User Profile

Collapse

Profile Sidebar

Collapse
ginge6000
ginge6000
Last Activity: Mar 29 '08, 11:51 AM
Joined: Feb 12 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ginge6000
    replied to Close Explorer windows
    in Access
    Sorry, I thought it was an Access issue as I am trying to do it in Access VBA. Ah well, back to google I go........
    See more | Go to post

      Leave a comment:

    • ginge6000
      replied to Close Explorer windows
      in Access
      Anybody able to help?
      See more | Go to post

        Leave a comment:

      • ginge6000
        started a topic Close Explorer windows
        in Access

        Close Explorer windows

        Hi,

        I have an app which creates batch files to transfer stuff around a network. As part of the batch files they disconnect the networked M:\ drive. Unfortunately if a WIndows Explorer/My Computer window is open showing the M:\ drive then the batch file bombs out (can't disconnect network drive while in use) and the VBA gets stuck in an endless loop waiting for the batch file to announce that it has finished.

        How can...
        See more | Go to post
        • ginge6000
          replied to SOLVED:Sub expects a (
          in Access
          Solved! strComp is a funciton in itself! Can't have astring by the same name!
          See more | Go to post

            Leave a comment:

          • ginge6000
            started a topic SOLVED:Sub expects a (
            in Access

            SOLVED:Sub expects a (

            Hello,

            I'm probably being stupid (staring at the screen too long!) but here's my problem....

            I have created a subroutine in a module called Transfer_Batch with a number of arguments. When I try to call this sub from another it brings up the error "Compile Error: Expected(" I don;t get it! Here's the sub I'm trying to call

            Code:
            Public Sub Transfer_Batch(Exam As String, UCN As String, P2UCN As String,
            ...
            See more | Go to post
            • ginge6000
              replied to CreateReport using template
              in Access
              That's my problem....ther e are no stored queries used in the production of the reports. Only VBA that creates a table and then a report based on the table. I've done a (Ctrl+F) search in the code for "Number" and it doesn't appear (except in comments!) I'm very confused!
              See more | Go to post

                Leave a comment:

              • ginge6000
                replied to CreateReport using template
                in Access
                Sorted the strange numbering issue - just created set the OrderBy value at the same time as the record source. Now i just need to find this misterious parameter! I would still like some understanding as to why createreport doesn't work!
                See more | Go to post

                  Leave a comment:

                • ginge6000
                  started a topic CreateReport using template
                  in Access

                  CreateReport using template

                  Hi, I'm trying to create a report using a template and then set it's recordsource. I have tried

                  Code:
                  Set rpt = CreateReport( , strTemplate)
rpt.RecordSource = strQTableName
                  but even though the template report exists and I have spelt it correctly I always end up with a blank report.

                  So now I have tried

                  Code:
                  DoCmd.CopyObject , strQReport, acReport, strTemplate    DoCmd.OpenReport strQReport,
                  ...
                  See more | Go to post
                  • ginge6000
                    replied to If is being ignored!
                    in Access
                    I so knew that! Man it's been a long ole day! Thanks for your polite response (I would have been much more sarcastic!)

                    Ben
                    See more | Go to post

                      Leave a comment:

                    • ginge6000
                      started a topic If is being ignored!
                      in Access

                      If is being ignored!

                      I've put this line into my code

                      Code:
                      If Me.Text3 = Null Then
    MsgBox "Please enter the date of the exam", vbExclamation, "Date Missing"
    Exit Sub
End If
                      but every time I run it just seems to skip the if statement and keep going. This happens when I change the Null to "" or even to a value and then enter that in the text box. Am I going mad?
                      See more | Go to post
                      No activity results to display
                      Show More
                      Working...