User Profile

Collapse

Profile Sidebar

Collapse
natyboi
natyboi
Last Activity: Dec 8 '14, 09:14 AM
Joined: Nov 30 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • natyboi
    started a topic Count in ms access record...
    in Access

    Count in ms access record...

    Hi i have a table named Employee having IDNo and a combobox named department with this row source
    INST'L SERVICES DEPT.
    FINANCE SERVICES DEPT.
    TECHNICAL SERVICES DEPT.
    OFFICE OF THE GM

    the question is how can i create a count in each row source?

    i already tried this code but it only shows #Error

    here's the code ive tried:

    =DCount("[IDNo]","Employee ","[department]='INST'L...
    See more | Go to post
    • natyboi
      started a topic How to create a count expression?
      in MySQL

      How to create a count expression?

      Hi i have a table named Employee having IDNo and a combobox named department with this row source
      INST'L SERVICES DEPT.
      FINANCE SERVICES DEPT.
      TECHNICAL SERVICES DEPT.
      OFFICE OF THE GM

      the question is how can i create a count in each row source?

      i already tried this code but it only shows #Error

      here's the code ive tried:

      =DCount("[IDNo]","Employee ","[department]='INST'L...
      See more | Go to post
      • natyboi
        started a topic Replace data in mysql with the same primary key
        in MySQL

        Replace data in mysql with the same primary key

        Good day, I dont know how to start asking even my title in this question is a kind of confusing. Lets start with this

        I have a table called member and reso with the same column called ID and resuNo

        all i want is to replace all resuNo in table member using the resuNo in table reso without affecting other datas.

        Example:

        member ---------------- reso
        ID = 1 ---------------- ID=1...
        See more | Go to post
        • natyboi
          replied to How to Justify this one?
          in Access
          what if i want the text to be justified? how will i do that?
          See more | Go to post

            Leave a comment:

          • natyboi
            started a topic How to Justify this one?
            in Access

            How to Justify this one?

            = "<p align="right">" &[txt1] & "" & [txt2] & "" & [txt3] & "" & [txt4] & "" & [txt5]&</p>"


            im having an error i dont know whye need help. This thing is for my ms access report inside a textbox.
            See more | Go to post
            • natyboi
              replied to Adding new record clearing the fields
              in Access
              ok. to simplify . i would like to clear specific field after i add data
              See more | Go to post

                Leave a comment:

              • natyboi
                started a topic Adding new record clearing the fields
                in Access

                Adding new record clearing the fields

                Good day,

                I want to save record then clear the field for my next entry except for one unbound field not to be clear.?

                i tried the DoCmd.GoToRecor d , , acNewRec but it clears all data in my field together with my one unbound filed.

                Need some help?.
                See more | Go to post
                • natyboi
                  started a topic MS Access copy value from form1 to from2
                  in Access

                  MS Access copy value from form1 to from2

                  Good day,

                  I have ms access having 2 forms.,,, form1 and form2

                  form1 has textbox named txt1
                  form2 has textbox named txt2

                  Now i want to create a button which opens form2 and copies the value of txt1 of form1 to txt2 of form2.

                  need help please...
                  See more | Go to post
                  • natyboi
                    started a topic Delete record permanently
                    in Access

                    Delete record permanently

                    i have ms access table using a query to get data from a table, in this time i have to delete a specific data but it only delete the data from the query but not in the table
                    See more | Go to post
                    • natyboi
                      started a topic Auto Assign number from values selected from a combo box
                      in Access

                      Auto Assign number from values selected from a combo box

                      Hi guys. i have a little problem here.
                      I have a combo box with values like Japan, China, Philippines and i want ms access to assign auto number in every values that i choose. Any help out there?

                      for example :

                      i choose Japan from the combo box then the text box will give an auto number.

                      help please!
                      See more | Go to post
                      Last edited by natyboi; Dec 3 '13, 02:10 PM. Reason: Additional, for clarification.
                      • natyboi
                        replied to Ms access to exe
                        in Access
                        ty very much.. so i have to start again from a scratch using vb6.0 as front end.. :D ..much appriated your help
                        See more | Go to post

                          Leave a comment:

                        • natyboi
                          started a topic Ms access to exe
                          in Access

                          Ms access to exe

                          Is there any way to make my ms access an exe file?

                          or convert my ms access projects to vb?
                          See more | Go to post
                          • natyboi
                            replied to Auto assign number with in every place that i choose from combox
                            in Access
                            Ok sir..lets make it a simple one.
                            like this.
                            example i have a combobox with a values like Japan, Philippines, China and i also have a textbox named txtautonumber

                            if i choose japan, txtautonumber will give a sequential number.same as i choose philippines or china

                            ty sir
                            See more | Go to post

                              Leave a comment:

                            • natyboi
                              replied to Auto assign number with in every place that i choose from combox
                              in Access
                              much appreciated sir..thank you very much. i will construct a much understandable explanation .
                              See more | Go to post

                                Leave a comment:

                              • natyboi
                                started a topic Auto assign number with in every place that i choose from combox
                                in Access

                                Auto assign number with in every place that i choose from combox

                                Can anyone help me/..i have a problem in auto numbering. this is the case
                                i have a combo box named municipality then with values like
                                Dapa, Gen. Luna and Pilar.
                                with another combo box named barangay with values
                                if i choose Dapa the Values in combo box barangay will be Brgy. 1, Brgy. 2 and Brgy. 3.
                                and if i choose Gen. Luna the Values in combo box barangay will be Consuelo, Cloud9 and Tawin2x
                                so on and so...
                                See more | Go to post
                                No activity results to display
                                Show More
                                Working...