User Profile

Collapse

Profile Sidebar

Collapse
Justair07
Justair07
Last Activity: Apr 19 '16, 03:28 PM
Joined: Apr 4 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Justair07
    replied to Looking for a program to handle performance metrics
    in Desktop Software
    Thank you both for your replies, I will certainly look into Birt. Access is unfortunately not the route I was looking to go. I have created several Access dbs and don't feel as though it will handle my needs the way I'm hoping without a large amount of maintenance. Not that it can't be set up to be exactly what I want just that I don't have the time to create it.
    See more | Go to post

      Leave a comment:

    • Justair07
      started a topic Looking for a program to handle performance metrics
      in Desktop Software

      Looking for a program to handle performance metrics

      Hello everyone,

      I'm looking for a software program that can generate custom graphs based on user data input.

      I work for a manufacturing company that measures Quality, Delivery, Cost, and Inventory.

      We measure these things for each of our departments, 12 in total.

      Each department measures said items in there own way. We give them the freedom to choose how they want to track them as long as...
      See more | Go to post
      • Justair07
        replied to Duplicated Records in Unbound Textboxes
        in Visual Basic
        Once my form is opened I use the onload event for the form to trigger a timer every second that calls the function. That's it for the code. Thank you by the way for your help with this.
        See more | Go to post

          Leave a comment:

        • Justair07
          replied to Duplicated Records in Unbound Textboxes
          in Visual Basic
          Hello Rabbit,

          Sorry for the late reply.

          Here is the code for my save changes button

          Code:
          Private Sub cmdSaveChanges_Click()
    
    On Error Resume Next
    
    If Me.Dirty Then Me.Dirty = False 'Force a save of the active record
    If (MacroError <> 0) Then
        Beep
        MsgBox MacroError.Description, vbOKOnly, ""
    End If
    If CurrentProject.AllForms("frmPDMonitor").IsLoaded
          ...
          See more | Go to post

            Leave a comment:

          • Justair07
            replied to Duplicated Records in Unbound Textboxes
            in Visual Basic
            Here is the code used in a standard module in access.

            Code:
            Public Sub LoadMyForm(frm As Access.Form)
On Error GoTo Error_Handler
'    Dim db              As DAO.Database
    Dim rs              As DAO.Recordset
    Dim x               As Integer

'    Set db = CurrentDb()
    Set rs = db.OpenRecordset("qryPDMonitor", dbOpenSnapshot)

    For x = 1 To 16
            ...
            See more | Go to post
            Last edited by Rabbit; May 7 '14, 08:46 PM. Reason: fixed code tags

              Leave a comment:

            • Justair07
              started a topic Duplicated Records in Unbound Textboxes
              in Visual Basic

              Duplicated Records in Unbound Textboxes

              Hello everyone,

              Attached is a sample of my project to help you see the issue yourself instead of me trying to explain. It's kind of confusing.

              Once you open the db. open up the frmQuoteLog and the frmPDMontior. You will notice one record is displayed in the frmPDMonitor (Justin Ryan). This is correct.

              Now to test out the issue leave open the frmPDMonitor and frmQuoteLog at the same time. Go to frmQuotLog,...
              See more | Go to post
              • Justair07
                started a topic Refrence a workbook by custom path
                in Visual Basic

                Refrence a workbook by custom path

                Hello everyone,

                I need to reference a workbook from a formula, for example:

                Code:
                ='[Daily Shipment Report 4_21_2014_DAVID.xls]WorkSheet'!$A$93
                But instead of the formula always having the full path I want it to look for the path with the date before today. For example I places this in a separate cell (S11):

                Code:
                =today() - 1
                I want to use this date to...
                See more | Go to post
                • Justair07
                  replied to How to move a rectangle in TabPage ?
                  in C Sharp
                  What does this mean???
                  See more | Go to post

                    Leave a comment:

                  • Justair07
                    replied to Word document changing to wordpad when e.mailed.
                    in Windows
                    Is the computer you are opening the email the same computer you are sending the email from?
                    See more | Go to post

                      Leave a comment:

                    • Justair07
                      replied to I need to know the code for spacing
                      in Visual Basic .NET
                      I believe you can simply put

                      Code:
                      Me.lblTime.Text = intTime & " " & intHour
                      Hope this helps,

                      Justin
                      See more | Go to post

                        Leave a comment:

                      No activity results to display
                      Show More
                      Working...