Search results

  1. K

    Comparing values in a query

    Hi... I will try to keep this succinct. I have a query that totals a column in a sub-form. The query also gets a sum from the main form for the same record. Is it possible to have a message/colour change/warning if the total of the column in the sub-form exceeds the other number in the query...
  2. K

    Opinions on security

    I have very painstakingly worked out a new database and I'm about to present it to the departments who will be using it. At various times words like 'password' and 'locked' have been thrown out but as of now I have not implemented any security measures. I started reading up on the topic this...
  3. K

    Do I need a query or not?

    I don't know anything about databases, but I'm learning quickly...in short, this is what I have. A situation where a county council has many jobs that it contracts out, so there are lots of contracts which constitute individual records on a table. I have a form that is used to enter new...
  4. K

    auto populate issues and unlimited fields, newer than newbie.

    I have (sort of) built a database and I think worked out the normalization issues. Its for a county council and is designed to keep track of the contracts they have going for projects. Two departments work on the database, the department that keeps up with the contractor (who they are, what...
  5. K

    Normalization/table set up

    I'm not a programmer and know very little about setting up access databases other than the very basics...however...due to my politics background, I'm setting them up for the local government....just my little disclaimer about why I'm asking stupid questions. I am creating a database for...
  6. K

    Merging two data bases

    I have two seperate files with the same type of data. Each file is sorted into multiple batches. The first file is a current data base still being used that was created in an older version of access. The new database has some records, but is in a newer version of access. I need to know how to...
Back
Top Bottom