Search results

  1. A

    DSum function results on Single data type

    Hello, I am using the DSum function on a field that is specified as having: Field size: Single Format: General Decimal Places: 2 I add 5 records to the new table. The contents of the records are: Record 1: 1 Record 2: 2 Record 3: 3 Record 4: 4 Record 5: 5 The results of the DSum function...
  2. A

    DLookup function - search criteria x 2

    Hey there, I would like to find a value from a record, and I am using the DLookup function. To find the right record I need to provide two references, the customer id and the booking id. I have tried to use 'And' such as: dateineed = DLookup("[Arrival date]", "detbooking", "[BookingID]= " &...
  3. A

    Parameters in a CrossTab Query

    Hey, I am trying to enter a user-defined parameter in a CrossTab query with little luck. It works fine if I enter the code already defined as in: >= #12/06/2006# but when I enter the code for a user-defined / input such as: >= [Enter date:], or if I try to redirect to a textbox on the active...
  4. A

    Error-You do not have the necessary permission..

    Hello, I get this error when opening my MS Access database - You do not have the necessary permissions to use the ...[flie name and path]... object. Have your system administrator or the person who created this object establish the necessary permissions for you. The database works fine on...
  5. A

    Moving the design master (replication)

    Hey, Happy New Year to all. I have a replicated access database, and I want to move the design master to another computer. I have tried using the Windows 'Copy and paste' command, and the 'Save as' command, both result in creating a replicated database. I have also tried chnging the design...
  6. A

    Encrypting data

    I want to enter in data so I get stars (*****) when I type, and encrypt the data when entering the data in a form. How do I do that? Cheers, Adam.
  7. A

    Error - User defined type not defined

    Hi, On Compiling my assecc database VB code I get the following error message "User defined type not defined". I understand it is beecause I have not declared the Variable Type, but have no idea to exactly which part of the code the error is referring to. How do I find out WHICH User defined...
Back
Top Bottom