burrina's Profile User Rating: -----

Reputation: 1 Apprentice
New Members
Active Posts:
9 (0.02 per day)
09-November 12
Profile Views:
Last Active:
User is offline Dec 14 2012 11:47 AM

Previous Fields

Dream Kudos:
Icon   burrina has not set their status

Posts I've Made

  1. In Topic: Use Up Down Arrow Keys To Advance Date Plus or Minus 1

    Posted 17 Nov 2012

    I found the answer and here is the code; This is on the Key Press Event.
    Select Case KeyAscii
    Case 43 ' Plus key
    KeyAscii = 0
    Screen.ActiveControl = Screen.ActiveControl + 1
    Case 45 ' Minus key
    KeyAscii = 0
    Screen.ActiveControl = Screen.ActiveControl - 1
    End Select
  2. In Topic: Error: operation must use an updateable query (MSAccess + IIS 6)

    Posted 16 Nov 2012

    Not familiar with IIS 6, but consider this and see if it helps.
    When Recordsets Are Never Updateable

    A recordset is never updateable when:

    It is based on a Crosstab query.
    It is based on a Union Query.
    It is an Aggregate Query that calculates a sum, average, count or other type of total on the values in a field.
    It is an Update Query that references a field in the Update To row from either a crosstab query, select query, or subquery that contains totals or aggregate functions
    Note: By using a domain aggregate function in the Update To row of an update query, you can reference fields from either a crosstab query, select query, or subquery that contains totals or aggregate functions.
    It is based on a Query that includes a linked ODBC table with no unique index.
    The database was opened as read-only or is located on a read-only drive.
    It is a SQL pass-through query.
    It is a query whose UniqueValues property is set to Yes. (That is, it is a query with a DISTINCT predicate.)
    Cartesian Joins (that is, a query that includes more than one table or query, and the tables or queries aren't joined by a join line in Design view.)
    Query based on three or more tables in which there is a many-to-one-to-many relationship.
    Note: Though you can't update the data in the query directly, you can update the data in a form or data access page based on the query if the form's RecordsetType property is set to Dynaset (Inconsistent Updates).
    Calculated fields. Even if the query itself is updateable, if a column in a query is based on a formula, the field cannot be updated. However, if the other fields in the formula are updated, the calculated field will automatically update.

    Recordsets Are Updateable Under Certain Conditions

    Some queries, especially those involved in a Join, will not be updateable under some conditions, but will be under others. In other queries, even if the query itself is updateable, some of the fields will not be. The following are cases of query problems and their corresponding solutions.

    1. Query based on a Join of tables with no Relationship.

    Problem: If a query is based on two or more tables that DO NOT have a relationship established (with Referential Integrity enabled), the query will be non-updateable.
    Solution: Create a Primary Key or Unique Index on ALL of the fields used in the Join on the "one-side" table. To be clear, this means ONE primary key or unique index based on all of the fields, not separate indexes on each field.

    In a query based on a Join of tables with a one-to-many relationship (1:M), you might not be able to edit the data in one or more fields. As the following examples show :

    2. Join field from the "one" side

    Problem: If you have a 1:M relationship created between two tables, you cannot change the primary key field (used in the Join) of the table on the "one" side of the relationship.
    Solution: Enable cascading updates between the two tables.

    3. New records, if the "many" side join field doesn't appear in the datasheet

    Problem: In a query based on a 1:M relationship, you can create a new record and fill in the fields that come from the "one" side table, but if the join field from the "many" side table is not visible in the query (that is, the foreign key), you cannot add data to the "many" side fields.
    Solution: Add the join field from the "many" side table (ie, foreign key) to your query to allow adding new records.

    4. New records on the "one" side that are duplicates of other "one" side records.

    Problem: When adding a new record, if you try to type into the "one" side fields, you will be attempting to create a new record. Even if you use the same primary key values, it will give you an error.
    Solution: Add a value to the "many" side join field (foreign key) that matches the "one" side join field (primary key) of an already existing record. The "one" side values will simply appear.

    5. Join field from the "many" side, after you've updated data on the "one" side

    Problem: If you are currently editing fields from the "one" side of the relationship, you cannot change the "many" side join field (foreign key).
    Solution: Save the record; then you'll be able to make changes to the "many" side join field.

    6. New records, if entire unique key of ODBC table isn't output

    Problem: This is different than #5 under Never Updateable. In this case, the primary key of the linked ODBC table exists, but is not added to the query.
    Solution: Select all primary key fields of ODBC tables to allow inserts into them.

    7. Query does not have Update Data permissions

    Problem: Query (or underlying table) for which Update Data permission isn't granted.
    Solution: To modify data, permissions must be assigned.

    8. Query does not have Delete Data Permissions

    Problem: Query (or underlying table) for which Delete Data permission isn't granted
    Solution: To delete data, permissions must be assigned.


    The causes of non-updateable recordsets are many and varied. Some have solutions and others don't. Hopefully, this list will help you know the difference.
  3. In Topic: Ensuring a Parent Record exists before creating Child Records

    Posted 16 Nov 2012

    You could try something like this;Substituting you table and field names;

    If DCount("*","yourtablehere","[fieldnamehere] = #" & Me.[fieldnamehere] & "#
    and [fieldname] = """ & Me.[fieldname] & """ and [fieldname] = """ &
    Me.[fieldname] & """") > 0 Then
    MsgBox "This record already exists"
    Cancel = true
    End If
  4. In Topic: ListBox Need to add quantity for each item selected

    Posted 11 Nov 2012

    View PostJune7, on 11 November 2012 - 12:33 AM, said:

    Is this the same topic as http://www.accessfor...item-29827.html

    YES it is and it has been marked as solved.


My Information

Member Title:
New D.I.C Head
Age Unknown
Birthday Unknown

Contact Information

Click here to e-mail me


burrina hasn't added any friends yet.


burrina has no profile comments yet. Why not say hello?