User Profile

Collapse

Profile Sidebar

Collapse
wishwish20
wishwish20
Last Activity: Feb 12 '07, 01:56 AM
Joined: Feb 7 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • wishwish20
    replied to Error 3027 Help using DAO
    in Access
    is there any other way?
    See more | Go to post

      Leave a comment:

    • wishwish20
      replied to Error 3027 Help using DAO
      in Access
      Oops Field1 in the SQL string is CustNum now, forgot to change in post. Still doesn't work though
      See more | Go to post

        Leave a comment:

      • wishwish20
        started a topic Error 3027 Help using DAO
        in Access

        Error 3027 Help using DAO

        I am having a problem with my Database. I am having an issue with being able to update a set of records. What I need is a way to uncheck a checkbox in the underlying table in this query. The # of checkboxes to be unchecked will be different for each customer, so I've been told an SQL query won't work. When I run the following code I get "error 3027 Cannot update. Database or object is read only" It stops at rs.edit

        Code:
        testString
        ...
        See more | Go to post
        Last edited by NeoPa; Feb 10 '07, 07:10 PM. Reason: Tags for Layout
        • wishwish20
          replied to Selecting only X number of records in query
          in Access
          I thought that that might be the best approach, but the code is already in place for what it is now. I might end up doing it that way, but are there any other ideas?
          See more | Go to post

            Leave a comment:

          • wishwish20
            started a topic Selecting only X number of records in query
            in Access

            Selecting only X number of records in query

            Hello, I am having trouble with an SQL query which is used as a source on a report. The database is being used to keep track of billing information. I have made an sql query, which has 2 tables. table A contains customer information. table B contains all the bills for each customer. Table B has fields: customerID, Rate, and the Date. I have a field in the customer table (table A) which contains how many months that they still owe for. I need a way...
            See more | Go to post
            No activity results to display
            Show More
            Working...