User Profile

Collapse

Profile Sidebar

Collapse
ilikebirds
ilikebirds
Last Activity: Mar 1 '10, 09:27 PM
Joined: Oct 10 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ilikebirds
    started a topic Combo with Select Row Query with Multiple ID numbers.
    in Access

    Combo with Select Row Query with Multiple ID numbers.

    I have the current code for populating one combo box off another combo box:
    Code:
    Private Sub Combo110_AfterUpdate()
  With Me![Combo112]
    If IsNull(Me!Combo110) Then
      .RowSource = ""
    Else
      .RowSource = "SELECT [Root_Cause] " & _
                   "FROM xRoot_Cause " & _
                   "WHERE [ID]=" & Me!Combo110
    ...
    See more | Go to post
    • ilikebirds
      replied to Require Selection in Combo before Running a Save Macro.
      in Access
      Before Update

      I applied the before update event procedure.

      I used a Cancel Event with Condition is Null and then Msgbox to warn then did a GotoRecord Next if condition is not null.

      Works out well.

      However the issue arises if I have a hidden form in the back. It doesn't pick up the active forms components.
      See more | Go to post

        Leave a comment:

      • ilikebirds
        started a topic Require Selection in Combo before Running a Save Macro.
        in Access

        Require Selection in Combo before Running a Save Macro.

        I would like all combo boxes to have require data before the following macro is run from a button:
        Code:
        Private Sub Command128_Click()
Dim Msg, Style, Title, Help, Ctxt, Response, MyString
Msg = "Please Verify Work Stream and Process"   ' Define message.
Style = vbYesNo + vbInformation + vbDefaultButton2   ' Define buttons.
Title = "Verify Data"   ' Define title.
Help = "DEMO.HLP"
        ...
        See more | Go to post
        • ilikebirds
          replied to Summing Hours from Date Field by Last date and on
          in Access
          Thanks it worked out. Still some complications with Hour and Time calculations but we were able to find the information needed!
          See more | Go to post

            Leave a comment:

          • ilikebirds
            replied to Summing Hours from Date Field by Last date and on
            in Access
            Does this code look corredt to you?
            Code:
            SELECT [emp],[process],[timemodified],(select Min([timemodified)])
FROM [Dtime] as tTi
WHERE (tTi.Emp=tTo.Emp)
AND (tTi.timemodified>tTi.timemodified)) AS  [FINISHED]
From [Dtime] as tTo;
            See more | Go to post
            Last edited by NeoPa; Jan 14 '10, 01:23 AM. Reason: Please use the [CODE] tags provided

              Leave a comment:

            • ilikebirds
              started a topic Summing Hours from Date Field by Last date and on
              in Access

              Summing Hours from Date Field by Last date and on

              I have the following table make up:

              Employee | Signin| Task|
              Bob | 10:01| Build|
              Bob | 10:44 | Fix|
              Bob | 11:23| Answered calls|


              Now How can I automate that build took 43 seconds, Fix took 79secconds, and Answered calls is still open.
              See more | Go to post
              • ilikebirds
                replied to Search String for Return Value
                in Access
                DonRaynor, Thank You - I will give it a try.

                ---

                NeoPa, I understand your concern as I addressed them myself. They have told me that they will validate their data beforehand. I have to try and make it work unfortunately.

                Thanks - I will update will any results.
                See more | Go to post

                  Leave a comment:

                • ilikebirds
                  replied to Search String for Return Value
                  in Access
                  In case others were wondering, I got it to work with:

                  Code:
                  Color: IIf(InStr([Description],"Brown")>1,"Brown","Miss")
                  It will return the Color into a new field.

                  However, this does not address the issues when another color is there, since the return values are Numerical.

                  Any ideas?
                  See more | Go to post

                    Leave a comment:

                  • ilikebirds
                    started a topic Search String for Return Value
                    in Access

                    Search String for Return Value

                    I once again come before you all to request assistance.

                    I have a lengthy String of Data Of which I would like to create new Columns for.

                    Example:
                    [Description] = "1, Bob, Brown, 58, Argyle, Big Jacket"

                    I would like to search that string for "Brown" and Return that value into a new Column called [Color].

                    "Brown" can appear anywhere in that string.
                    ...
                    See more | Go to post
                    • ilikebirds
                      replied to Combo to Combo LookUp Default
                      in Access
                      Multiple Combos

                      The Cascading Combo technique worked perfectly.

                      I was wondering if it was possible to pull info from multiple combos as such:


                      Code:
                      Private Sub Combo154_AfterUpdate()
  With Me![Combo106]
    If IsNull(Me!Combo154) Then
      .RowSource = ""
    Else
      .RowSource = "SELECT DISTINCT[PID]" & _
                   "FROM
                      ...
                      See more | Go to post

                        Leave a comment:

                      • ilikebirds
                        replied to Updating a column with additional digit
                        in Access
                        Thank You.

                        Using:
                        iif(len([line_item])=7, "0" & [line_item]), [line_item])

                        I was able to find out that after my 7th digit, I had a Null Character.
                        Therefore the exact code didn't work.

                        Still trying to beat my head into getting this null character calculated.

                        ...=7 & " ", as well as =7 & NULL, are not working.
                        See more | Go to post

                          Leave a comment:

                        • ilikebirds
                          started a topic Updating a column with additional digit
                          in Access

                          Updating a column with additional digit

                          I've searched the forums with no success.

                          I have a column of data containing 7 digit and 8 digit numbers.

                          I would like to update all the 7 digit numbers and add a 0 in front of them so they become 8 digit numbers.

                          I have tried an update query and Find and Replace however I have had no success

                          iif(([line_item]) ="????????,"0?? ?????,)


                          Any Suggestions?
                          ...
                          See more | Go to post
                          • ilikebirds
                            replied to Update Null Fields in Table 1 from Table 2 & 3
                            in Access
                            Fortunately. [table1].[A] will never be null.

                            I will try the update query again. I've tried it before and it did not function correctly. I will post results here.

                            Thank You.
                            See more | Go to post

                              Leave a comment:

                            • ilikebirds
                              started a topic Update Null Fields in Table 1 from Table 2 & 3
                              in Access

                              Update Null Fields in Table 1 from Table 2 & 3

                              I am trying to update a table that is Inner Joined or related to 2 other tables with similiar data. For Instance:

                              Table 1
                              -----------
                              A - B
                              --------
                              y - x
                              z - null

                              Table 2
                              -----------
                              A - B
                              ----------
                              y - Null
                              z - x

                              AB are the Field Names
                              A from Table 1 is in a one-to-many relationship to A in table 2
                              Where...
                              See more | Go to post
                              • ilikebirds
                                started a topic Join Table by Date Match
                                in Access

                                Join Table by Date Match

                                I have 2 tables that are, for the sake of description, nearly Identical.

                                The only Difference is that 1 has [Test Date] and the other has [Work Date] which are always different.

                                Is there a way to combine the information where if [Work Date] < [Test Date]?

                                So that I can have both [Test Date] and [Work Date] in the same Row of Data.

                                For Instance:

                                Table 1:

                                [Fish][2:00PM][Bob]...
                                See more | Go to post
                                • ilikebirds
                                  started a topic Combo to Combo LookUp Default
                                  in Access

                                  Combo to Combo LookUp Default

                                  I am looking for a way to have one combo lookup drop down to autopopulate with multiple items based off another combo lookup. I've tried

                                  Me!rc1 = DLookup("[Root_Cause]", "[xRoot_Cause]", "Reject_Reason_ 1='" & Me!Reject_Reaso n_1 & "'")

                                  But it only gives me one of the possible items.

                                  For Instance:

                                  Table xRoot_cause:

                                  Root_Cause...
                                  See more | Go to post
                                  • ilikebirds
                                    replied to Querying 1 Day Old Data ( Date )
                                    in Access
                                    If I only had half the smarts you did!
                                    That seem to do the trick. Thanks.

                                    Now if I add:

                                    WHERE t1.[to_order_step_n um]="Step1";

                                    To the end, I will be able to search specific steps that are =>1, correct?
                                    See more | Go to post

                                      Leave a comment:

                                    • ilikebirds
                                      started a topic Querying 1 Day Old Data ( Date )
                                      in Access

                                      Querying 1 Day Old Data ( Date )

                                      My table looks like the following

                                      [PartNumber], [FromStep],[ToStep],[MovedDateValue]
                                      Ex.
                                      [Fish], [Step1], [Step2],[1/2/2007]
                                      [Fish[, [Step2], [Step3],[1/3/2007]

                                      It contains all the [FromStep] and [ToStep] that [PartNumber] goes through in the past 3 months.

                                      How would I go about querying for all [PartNumber]'s that took more than 1 day to move from Step 1 to Step 2?... so on and so...
                                      See more | Go to post
                                      • ilikebirds
                                        replied to Access 2003 - Could Not read Definitions ; No Read Definitions
                                        in Access
                                        I tried that as well.

                                        In the end, I had to re-name the Table.

                                        I still can't find the root cause for it's occurrence....
                                        See more | Go to post

                                          Leave a comment:

                                        • ilikebirds
                                          started a topic Access 2003 - Could Not read Definitions ; No Read Definitions
                                          in Access

                                          Access 2003 - Could Not read Definitions ; No Read Definitions

                                          So I've come across a complicated Paradox.
                                          I am the owner and admin of Database A.
                                          However, When I try to open this one certain table in Database A - I get the following :

                                          Could Not Read Definitions; No read permissions for table....

                                          So I checked the Tools - Security and that is the only Table where all Permissions were unchecked.

                                          How could that happen?

                                          The problem is , Now...
                                          See more | Go to post
                                          No activity results to display
                                          Show More
                                          Working...