Search results

  1. H

    Updating/importing? Question

    Hello all, I have a question; I have 2 databases with 4 tables in it following the same structure. Table 1: tblPersons consisting employeenumber as pk Table 2: tblLocation consisting the location as pk Table 3: tblCompanyvehicle consisting the licenseplate as pk Table 4: tblAssets consisting...
  2. H

    'Dynamic' selection

    Now, I don't know if this topic should be in forms, queries or reports, so I decided to post it here in general until someone gives me a big bollocking and send this topic elswhere :D I have a table with loads (50+) of columns which hold information about people in our company. What I want is...
  3. H

    High/Mid/Low Query

    It must be me but: I have a table with the column Grade and a column Grade_Group In the column Grade I can give a value from 0 - 10 (pull-down). When I grade between 0 and 3 I want the column Grade_Group to be updated to Low (easy, even I can do that with an update query). But if the grading...
  4. H

    Derive birthday from field and pop-up.

    Our company has a employee numbering system like 65.01.20.HAR this is also the primary key that I use in the table. The employee number is build up like this:65=year 01=jan 20=day HAR=first three letters of last name, so 65.01.20.HAR is me Hartkoorn born on 20-01-1969. Furthermore I have...
  5. H

    Updating fields in report?

    K, Going great now, mainly due to the information found on this forum. Breaking my head again on a thing here: I have a tabbed form, one of these tabs is called reports, the others used to enter information. Now if I change some data in the form and switch to the reports tab and hit the view...
  6. H

    Data from multiple tables without relationships

    K, Maybe a noob question, but I'm still learning access (I know a little late at the age of 37, but better late then never). I have a form with several tabs, linked to a table with employee information, works like a charm. Now, my last tab is called settings, maybe no need to say that the...
  7. H

    Manipulating printer settings

    K, I've got a printer which can print both sided. Now, this is what I want: Certain reports I want to print single-sided and other I want to print both-sided, so the ideal situation would be access to set the printer settings (HP laser) and print directly, instead of going manually through the...
  8. H

    Clear data in a complete yes/no column

    K, I'm new here and I have a question: In my db I have a yes/no tick, now I want to create a button that clears out all the ticks in that specific column, possible? To clarify: I have an address db with an gift table (tbl_gift) and a yes/no parameter for, lets say, 'did they gave me a present...
Back
Top Bottom