Search results

  1. C

    user access denied in Access 2000 Runtime

    We have two computers in a work group. On computer1 I have the back-end and front-end database files in the shared folder and 2 users out of 4 can access the database no problem. When the other users try to access the database they receive the error message "Microsoft Access can't Find The...
  2. C

    list box value not saved to underlying table

    :confused: I have a list box whose record source is a query based on a value selected in a combo box. when the value in the combo box changes the list box is requeried to show the updated value. this all works fine but when i come to save the record the table entry correcsponding to the list box...
  3. C

    Can't get rid of border around list box in report

    I have a report with a list box on it which is populated by data from a table. However I can't get rid of the list box border. On the design screen the border is not there, but when I print I get a black border around the data. I have set the list boxes border colour to white but to no avail...
  4. C

    YES/NO combo box

    I have a YES/NO combo box on a form for the user to select from. However I need the default value to be blank, it currently defaults to "No". Any suggestions? Thanks
  5. C

    nz function

    I am having trouble with a query which uses the results of sub queries for it's data. I have included an extract below: SELECT DISTINCT qryItemNumber.item, IIf(NZ([qryComposition2].[DESCRIPTOR_VALUE])<>"","FOUND","NOT FOUND") AS Expr1 FROM qryComposition2, qryItemNumber; What should...
  6. C

    Urgent report help required

    I have a report based on a cross tab query which lists profit made on sales orders by month from deposits and final balances. My detail section has two sets of data fields called dep_jan, dep_feb, etc, and bal_jan, bal_feb, etc. These are bound to the underlying query and include some 'iif'...
Top Bottom