Search results

  1. S

    Active X textbox borders

    Hi I wonder if anyone else has come across this. I have opted to use an active x textbox control to get around the limitation on text size in a normal text box, however I do not wish to have a visible border. Having tried all the options in the property sheet and also using VBA I am left with a...
  2. S

    Referring to arrays using variables

    Hi I wonder if anyone can tell me if it is possible to refer to arrays using variables. I have a number of arrays and rather than write out separate code for each I would like to refer to the array using a variable e.g "Array" & var. I have tried all the combinations I can think of but...
  3. S

    Combobox not working

    Hi I have a question regarding comboboxes, and also text boxes. I have a form where users can select the report they wish using option buttons, no problem there. The option buttons relating to individual students have code attached to the on focus and lost focus events to hide or show a...
  4. S

    Excluding values from a query

    Hi I am trying to create a query that will show only trainees who have not completed a test. The attached relationship produces a query that does the opposite, i.e. only trainees from a particular school who have completed a specified test. I cannot work out how to exclude trainees rather...
  5. S

    Counting non empty textboxes

    Hi I have a form with a large number of text boxes that must be completed. I would like to use a formula if possible to check if any are incomplete rather than loop through using VBA. I feel sure that it should be possible but cannot find any reference on the web. Any advice would be...
  6. S

    Disappearing textbox on subform

    Hi I have a problem with a textbox on a subform disappearing when it is empty. The form has a number of subforms all behaving correctly with empty textboxes. All are set to no for grow/shrink and all properties are set the same on each subform. The only thing that is different is that the...
  7. S

    Hiding report elements in report view

    Hi I have a report that is used for printing tests for trainees. One test involves the addition of between one and three variables. In the printed version the addition signs that are not required can be removed using Detail_Print or Detail_Format. However as I intend to also administer tests...
  8. S

    Referencing an embedded report

    Hi I have a report that in standalone form for a test that changes the heading dynamically according to the test being administered, when it is to be printed. However I have embedded the report in a form for administering a test using the computer. Unfortunately I am finding it difficult to...
  9. S

    Run time error 3061

    I have a query which returns a single record based upon using DMax on one field and a lookup value from a form on another. Run in isolation the query correctly returns a single record but when I try to use the query as a recordset it returns the above error. The cause of the error is the...
  10. S

    Table Structure and Linking

    I am writing a database for use in a casino and am looking for some advice regarding the linking of tables. Generally everything is fine apart from the creation of a query which returns duplicate values which I think is due to the way I have structured the data. There are three linked tables...
  11. S

    Removing formatting from sub-form

    Hi I have a form with embedded sub-form in datasheet view, and all data displays correctly, the problem I have is in formatting the sub-form to match the main form. I would like to remove all headings, background color etc. and leave only the data showing, however I am unable to achieve this...
  12. S

    Populating a field not shown on the form

    Hi I have a simple database recording payments made by customers, just two tables and a form, the tables are customers and payments and data is entered via the form. Initially the payment date was entered for each records from the form but I am trying to autofill the date in the payment table...
  13. S

    Report Conditional Sum

    Hi I am currently transferring a system used for discounts from Excel to Access and would like some advice. I believe that what I want to achieve will be possible in Access Reports but would appreciate any pointers. What is very easy in Excel is a little more complicated in Access, but overall...
Top Bottom