User Profile

Collapse

Profile Sidebar

Collapse
Anjani
Anjani
Last Activity: Jan 18 '13, 10:45 PM
Joined: Dec 21 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Anjani
    replied to ON CLICK event working on DOUBLE CLICK
    in Access
    other two values are always produced before clicking on Specimen ID.
    I want the format to generate on click and hence the code has been written on the CLICK event.
    Please help.
    See more | Go to post

      Leave a comment:

    • Anjani
      replied to Query column names as LIST BOX content
      in Access
      Oops!!! I made a boo boo... Column Count was set to 15 and hence i was facing this problem.. thank you TheSmileyCoder, as your confidence made me dig harder into its properties.

      But the problem is that all Column names are transferring from List1 (List Box 1) to List2 (List Box 2) other than the first column name i.e. Project Number. Please help
      See more | Go to post

        Leave a comment:

      • Anjani
        replied to Hyperlink not opening when character count is around 100+
        in Access
        Happy New Year to u and your family NeoPa...
        See more | Go to post

          Leave a comment:

        • Anjani
          started a topic ON CLICK event working on DOUBLE CLICK
          in Access

          ON CLICK event working on DOUBLE CLICK

          Hello,

          My FORM has 3 main components along with other components in it.

          1. Project Number (Text Box)
          2. Created Date (Text Box)
          3. Specimen ID (Text Box)

          Specimen ID has prespecified format to follow i.e. "YY-Project Number-001" where "YY" is last two digits of the Year pulled from CREATED DATE. "001" is the increamental number which should be populated ON CLICK...
          See more | Go to post
          • Anjani
            replied to Query column names as LIST BOX content
            in Access
            Thanks for your swift reply.

            Same query for Main and Sub Forms is the demand of my project.

            My Query has 15 Columns in total. When i set the Row Source Type property to FIELD LIST (Shown in Untitled1.jpg), it still shows 15 columns and value of each column is converted into Column Names (Shown in Untitled2.jpg).

            [imgnothumb]http://bytes.com/attachments/attachment/6849d1358538856/untitled1.jpg[/imgnothumb]...
            See more | Go to post
            Last edited by TheSmileyCoder; Jan 18 '13, 10:21 PM.

              Leave a comment:

            • Anjani
              started a topic Query column names as LIST BOX content
              in Access

              Query column names as LIST BOX content

              Hello,
              I have a Main Form named DATA and a Subform named SPEC. A query named DATA QUERY saves all the data from both the forms.

              I am making a new form named FORM1 which has a LIST BOX named LIST1. I use LIST BOX WIZARD to create the same. I use QUERY to populate this list box.

              The problem is that LIST1 is populated with the data of the QUERY and not the COLUMN NAMES of the DATA QUERY.
              Kindly help....
              See more | Go to post
              • Anjani
                replied to How Do I Cancel Changes on Both Main and Sub Forms Using a Single Button on Main
                in Access
                Thank u sir for ur reply. When i made changes as per your code, following things happened: -

                1.Changes made on MAIN FORM only and CANCEL button pressed, then changes are undone. (As per requirement)
                2.Changes made on MAIN FORM and then changes made on SUB FORM. After pressing CANCEL button, none of the changes are undone. (Both the changes should be undone)
                3.Changes made on SUB FORM only and pressed CANCEL, then the changes...
                See more | Go to post

                  Leave a comment:

                • Anjani
                  started a topic How Do I Cancel Changes on Both Main and Sub Forms Using a Single Button on Main
                  in Access

                  How Do I Cancel Changes on Both Main and Sub Forms Using a Single Button on Main

                  Hello,

                  I have a Main Form, which also contains a SUB FORM. My SUB FORM contains Text Boxes and Check Boxes. CANCEL button on the MAIN FORM only undo's the data on the MAIN FORM. Kindly tell me a way to UNDO the changes in SUB FORM as well using the same CANCLE button on the MAIN FORM.

                  I tried to find an answer in the questions asked in the past, but i found it difficult to understand, as i am a rookie. Please help.
                  ...
                  See more | Go to post
                  Last edited by NeoPa; Jan 17 '13, 09:40 PM. Reason: Merged both halves of the single question into a single sensible post.
                  • Anjani
                    replied to Auto generation from main form to sub form
                    in Access
                    I hope its clear now...
                    See more | Go to post

                      Leave a comment:

                    • Anjani
                      started a topic Auto generation from main form to sub form
                      in Access

                      Auto generation from main form to sub form

                      Code:
                      Private Sub Specimen_ID_GotFocus()
'Get the next Spec ID
Dim NextSpecID As String
Dim CurrSpecID As String

'Get the last 3 characters from the last specimen ID belonging to this project number
CurrSpecID = Nz(Right(DMax("[Specimen ID]", "Spec", "[Project Number] = '" & Me.Project_Number & "'"), 3), 0)

'Increment the ID by 1
NextSpecID =
                      ...
                      See more | Go to post
                      • Anjani
                        replied to Hyperlink not opening when character count is around 100+
                        in Access
                        Hey NeoPa.. Thanks for the reply and concern.. the problem was that there were special characters used in the path i.e. File name.. and hence it would direct me to My Documents.. I figured it out.. Thanks anyways :D
                        See more | Go to post

                          Leave a comment:

                        • Anjani
                          started a topic Hyperlink not opening when character count is around 100+
                          in Access

                          Hyperlink not opening when character count is around 100+

                          Hello.. I have a form in MS access 2003 which has a browse button and a hyperlink box next to it. The path gets saved in the hyperlink box which is selected using the browse button. When i click on the hyperlink, it should open the path of that file. It works absolutely fine for less than 100 characters (approx number), but blows up when 100+ characters are saved. Then, instead of opening the exact file path, it opens "MY DOCUMENTS". Please...
                          See more | Go to post
                          No activity results to display
                          Show More
                          Working...