User Profile

Collapse

Profile Sidebar

Collapse
SriKumar
SriKumar
Last Activity: Jan 20 '13, 10:37 AM
Joined: Jun 12 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • SriKumar
    replied to Rowset does not support scrolling backward
    in Access
    Hi TheSmileyCoder,

    I have checked all the points with the user.
    1. Do each user have their own frontend on their own PC or do they share a frontend file on a network share?

      - Yes, user has his own file on this desktop.
    2. If they have their own frontend file, try giving user a new frontend file (You probably allready have, but if haven't try it)

      - tried this one too.
    3. Other then that I
    ...
    See more | Go to post
    Last edited by SriKumar; Oct 15 '12, 10:08 AM. Reason: Incomplete sentence...

      Leave a comment:

    • SriKumar
      replied to Rowset does not support scrolling backward
      in Access
      Hi TheSmileyCoder,

      Thanks much for quick response...
      I will check all the points with that user and let you know on the outcome.
      See more | Go to post

        Leave a comment:

      • SriKumar
        replied to Rowset does not support scrolling backward
        in Access
        Hey TheSmileyCoder,

        As you mentioned, error occurs on line 17. I tried changing to FindFirst but it says: Compile Error: Method or data member not found.

        Also, I have one question... This code works on many other systems but not on one system with whom we are facing this issue. Is there any solution you can recommend there?
        See more | Go to post

          Leave a comment:

        • SriKumar
          replied to Rowset does not support scrolling backward
          in Access
          Sorry zmbd & TheSmileyCoder about half information on my problem.
          Database: Access Database with tables - DB is in one of the shared folders.
          Frontend UI: Access file with forms and VBA codes.
          Both FE & BE are in Access 2010 version.

          Code used is:
          Code:
          Private Sub Check_Click()
   Dim Conn As ADODB.Connection
   Dim myRecordset As ADODB.Recordset
   Dim strConn, str As String
          ...
          See more | Go to post

            Leave a comment:

          • SriKumar
            started a topic Rowset does not support scrolling backward
            in Access

            Rowset does not support scrolling backward

            Hello,

            I have created a split database. The frontend interface is working fine on some systems. But on one system it shows this error: "rowset does not support scrolling backward". I am not sure why it is creating problem on only one system at this time.

            I tested it on my system and on others too. Never showed any error while submitting or retrieving a record.

            Please help!!!
            See more | Go to post
            • SriKumar
              replied to Email with Hyperlink - Click to open specific record
              in Access
              Thanks Z ...

              I tried this option yesterday... it is good to use ... but is there a way to do this in VBA?

              Because, the users are not well aware of access and they may mess-up...
              See more | Go to post

                Leave a comment:

              • SriKumar
                replied to Email with Hyperlink - Click to open specific record
                in Access
                Okay Rabbit ... Do you suggest any better way to get my requirement done?
                See more | Go to post

                  Leave a comment:

                • SriKumar
                  replied to Email with Hyperlink - Click to open specific record
                  in Access
                  Oh!!! I have come across a link which I believe is some solution for the same. But I could not understand the concept.

                  http://msgroups.net/microsoft.public...om-email/62542

                  May be if you check the link, you can help me with the issue......
                  See more | Go to post

                    Leave a comment:

                  • SriKumar
                    started a topic Email with Hyperlink - Click to open specific record
                    in Access

                    Email with Hyperlink - Click to open specific record

                    Hello,

                    I am in a tough situation... I am working on a database and now I have a hard hurdle to finish my database.

                    I have a form from which I am able to send a record for approval. Where approval will be through email reply. Now I want to change it to electronic way:

                    - First send an email to user with a link
                    - either link should pass the Approved / Rejected word to access table in the server or...
                    See more | Go to post
                    • SriKumar
                      replied to Sum of values in multiple columns - Column names keep changing every week
                      in Access
                      Hello Rabbit,

                      Thanks much for the reply.
                      I accept that the data structure is not normalized and there is no way for me to change it now.

                      Please let me know if there is any way to make it possible with the present data structure.
                      See more | Go to post

                        Leave a comment:

                      • SriKumar
                        started a topic Sum of values in multiple columns - Column names keep changing every week
                        in Access

                        Sum of values in multiple columns - Column names keep changing every week

                        Hello,

                        I have a problem with adding values...
                        If the table headers are unchanged then adding values from different columns is not a problem. But in my table, the headers keep changing every week.

                        Could someone please help me with the VBA code to add columns irrespective to the column names? One option I have is the header names start with OH 2300, OH 2301 ...

                        Is there anything like: DSum anything starts...
                        See more | Go to post
                        No activity results to display
                        Show More
                        Working...