User Profile

Collapse

Profile Sidebar

Collapse
rehanemis
rehanemis
Last Activity: Oct 27 '15, 06:20 AM
Joined: Jul 18 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rehanemis
    started a topic Getting Error while using it on MAC
    in Desktop Software

    Getting Error while using it on MAC

    hi,

    The below code is working fine in Excel 2013 version to save a sheet as PDF but it giving error while running on MAC,

    The Error Code is: "Run Time Error 438
    Object Doesn't support this property of method.

    Can anyone solve the issue.

    Code:
    Dim str As String, myfolder As String, myfile As String

str = "Do you want to save the sheet to a single pdf file?"
    ...
    See more | Go to post
    • rehanemis
      replied to Require Results in Cross tab query
      in Access
      I have attached the db

      I have attached the db and sample report what i want.

      thanks for your kind help.

      [IMGnothumb]http://bytes.com/attachment.php? attachmentid=85 11[/IMGnothumb]...
      See more | Go to post
      Last edited by zmbd; Oct 24 '15, 08:50 AM. Reason: [z{inserted image}]

        Leave a comment:

      • rehanemis
        started a topic Require Results in Cross tab query
        in Access

        Require Results in Cross tab query

        Hi,

        I would like to generate report of volunteers.

        my Tables are as:

        DepDetail: Contains all information of Departments and activities.

        ActivitiesDetai l: Activities assigned to different volunteers and activity time also.

        I would like to get the report as:

        Code:
        Activities         Roll down    updo    checking   so on...
6:00 Am             Mr.A        Mr.B
        ...
        See more | Go to post
        Last edited by zmbd; Oct 24 '15, 07:50 AM. Reason: [z{placed Code/ format on table}{inserted img inline}]
        • rehanemis
          replied to how to add data into ms access table from various excel sheets
          in Access
          If there is browse button for locating file that would be great and then i have to choose what columns i would like to add.
          See more | Go to post

            Leave a comment:

          • rehanemis
            replied to How to combine two ms access reports
            in Access
            Thanks for you reply.


            But it does not resolve my problem because i always would like to view the 2nd report on separate page like on page 2nd without disturbing the 1st page.
            See more | Go to post

              Leave a comment:

            • rehanemis
              started a topic Unable to add more fields in table(created in sqlServer)
              in SQL Server

              Unable to add more fields in table(created in sqlServer)

              Hi,

              I have created small database in SqlServer. The problem i am facing is that after completion of database if i need to enter more fields in table, SqlServer didn't allow me to do.

              I got information that we can also insert field using query, is it true? if Yes please can you help?

              Secondly is there other way to add field without query and solution to that error mentioned above.

              Thanks...
              See more | Go to post
              • rehanemis
                started a topic How to combine two ms access reports
                in Access

                How to combine two ms access reports

                HI,

                I have an ms access database(2013 version) which i am using for quotation creation, i have implemented code that generate quotation in PDF and save it to my desktop.

                I have need to append 2nd report(which is terms and condition of company) at the end of PDF quotation. For example my quotation is ready for PDF of 1 page and when i click on Got PDF button then i like to got 2 page PDF 1st page quotation and 2nd page...
                See more | Go to post
                • rehanemis
                  started a topic how to add data into ms access table from various excel sheets
                  in Access

                  how to add data into ms access table from various excel sheets

                  HI,

                  I am new the ms access programming(VBA ). During my work there is need to import 3 columns data into ms access table from various excel sheet and excel sheets format is not always same For example. we have 3 columns in ms access item code, item description, item price. So in excel these columns not always on standard.

                  Can anyone help how can i import the data and can only import the columns with heading Item code,...
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...