Search results

  1. Y

    Record number x of y

    I dont want to use the navigation bar in a form, but I want the user to know how many record there is and on wich he is working on. I create an unbound text box with this code in the control source. =[CurrentRecord] & " of " & Count(*) Its working well, but if I add a new record the "of y"...
  2. Y

    Form and combo box

    Someone gave this code to speed up my form. It is suppose to load the list of the combo box only when required Dim strSQL as String strSQL = "SELECT DISTINCT [TableName].[FieldName] FROM [TableName] ORDER BY [TableName].[FieldName];" Me.cboComboBoxName.RowSource = strSQL It doesn't work and...
  3. Y

    Slow form need help

    I have a form (billing) that is use often. The form is base on a query of 3 tables and contains about 85 fields. The querry load smoothly but the form can take up to 30 sec to load. What should i do to reduce this. Thanks
  4. Y

    Switchboard and user security

    I created a switchboard with Access 2000, it has 3 choices a the begening. One of them is the admin utilities, but I don't want other user to see or use this item of the switchboard. Is there a way to make it invisible or disable if the user isn't the administrator of the database.
  5. Y

    Switchboard that change during the day

    I want to create a switchboard that change at 6:00PM. I want to change a picture and the background color. How do I make this work and do I need 2 forms (one hidden and one that open at startup). Thanks
Top Bottom