Search results

  1. A

    Totalling a section in a report

    i have a report with 'AdvSectionID' header and 'AdvSectionID' footer. in the detail section there's a field called 'NetDays' (the amount of days it takes a Section to do something). in the report footer i have 4 fields: Total cases cleared in 10 days...
  2. A

    Expression problem

    this is my problem... i havea form, with 4 fields (there are more than 4 but that's beside the point). [Guide Type ID], [GuidDateReceived], [txtRetdBySol] and [TargetDate] I am trying to populate [TargetDate] and have created the following expression, which doesn't work: =IIf([txtRetdBySol] Is...
  3. A

    total with and without date parameter

    My problem is that i have a query which displays a series of totals for a nominated period of time, based on date parameters entered by the user. This works fine. I also have a query that does exactly the same thing, returns a series of totals, but without the date parameters. What i am trying...
  4. A

    crosstab problem

    I'm sure this seems very simple to some, however i am finding it difficult to obtain the results that i want. I am trying to create a crosstab query to display the following... 2 columns, C1 and C2. 4 rows, R1, R2, R3, and R4. Values displayed in these fields are derived from 2 queries...
  5. A

    Input mask

    I have created form on which users enter payment details, and i want to put some kind of input mask on the form to prevent the following... for instance: i would like the user not to be able to change the value of the field 'status' to PC (Project complete) whilst the 'balance' field on an...
  6. A

    Form / Subform Problem

    I have created a tabbed form, based on a multi-table query, with 4 subforms in it. Application is the main table in the db, with the primary key,id, being an autonumber and all other tables are related to this table via the id field, which is a number field. For each new record i create, there...
  7. A

    Table Update Problem

    Can someone help, I have a main table in my db called Application, which has a primary key 'Application ID', which is an auto number. 19 other tables are connected to this main table by and ID field (primary key in the one-one tables) which is a number field. These tables either have one-many...
  8. A

    Combo box size restrictions

    When inputting text in to a combo box, is there any way of increasing the number of characters allowed on one line. I have tried the usual... pulling the line out to the right, but it still only allows me to enter a limited number of characters. thanks.
  9. A

    incomplete report

    I have a problem, i have a report that details payments made on certain dates. when i run the report, i should get the company name, payments made, and the date the payments were made. If there is more than one payment made, these extra dates and payments should be listed below the company name...
  10. A

    error message

    I'm building what i thought wasa straightforward query, though i keep getting the following message when i try to run it: "you tried to execute a query that does not include the specified expression 'PREFIX' as part of an aggregate function." 'PREFIX' is a field, the following is the expression...
  11. A

    append query/archive data

    I have a small database, and I want to archive data held in one of my tables. I intended doing this using the append query. I created another database, called 'Archive.mdb' which I want to append the data to. This worked successfully on my hard drive, and the data was appended accordingly...
  12. A

    opening a form on different levels

    I have a database which, when opened, the user is promted to enter a username and password. depending on these details, forms are made available to a user on different levels, ie. manager enters u/name and p/w and gains access to the whole db, but user enters u/name and p/word and is only...
  13. A

    what's wrong with this code??

    this is a form, with 3 command buttons on it. this is the code behind the command buttons. the first opens the form "Part 3 financial details main form", the second opens "Payments & Receipts Main Form" as input only, and the third opens the form "Assessment Navigation Form" as read only. ...
  14. A

    Opening form as 'read only'

    Based on the username and password entered, i want the Payments & Receipts form to open as a read only form. this is what i have so far. If Me.txtUserName = "Username" And Me.txtPassword = "Password" Then DoCmd.OpenForm "Payments & Receipts Main Form"
  15. A

    Switchboards

    I have created a switchboard, however i do not want every user to view each of the forms/reports on it, so what i want is something, that when i select a particular form from the switchboard, the user is asked to enter a password, and if they don't know that password, they can't view the form. i...
  16. A

    converting lotus approach query to access

    Trying to return a 'year' in a query. I am converting a db from Lotus Approach to Access, but i can't work out how to convert this query. i know Access doesn't use 'Combine', so would anyone know how to convert this. please. The expression should return the 'Financial year' each time...
  17. A

    averages

    my problem is that i want to find the average productivity, based on members of staff. however the number of staff is likely to change from month to month. i have a table 'staff', and 'productivity' is a calculated field in a query. at the moment the chart that produces the figures that i...
  18. A

    Charts

    I am trying to put a charts on reports. the charts will display various things, representing 6 members of staff, the number of days they work in a year, the different types of days they work etc. ideally what i would like to do it type in a staff member's name, then up should pop a chart with...
Back
Top Bottom