Recent content by Yoshi88

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"...

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...

The 10 tables give the possible choice for 10 combo box in my billing form. They are explanation or description of different information on the billing form, for example: Airplane: Departure from Montreal Arrival Orlando with Air Canada The user can add other data in the field link by the...

Its a DB for a travel agency. They neede it to be flexible to the change that can occur in the future. The main tables are agent and client with information like: name, phone numbers, credit card adress, birthday, Air Miles number, their actual agent, what they usually choose when they travel...

What do you mean by unformalize database? Its a client billing database, they have a lot of information on the bill and they have a lot of information on their clients. I forgot to mention that the form is link to 10 other tables for all the combo box needed in the form. Do you have a solution?

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

Your 2 proposition are great but i create my switchboard with the switchboard manager. If the first button is the administration choice will it affect the other menu on other function. ex 1 is administration invisible and enable 2 choice 2 3 choice 3 if the user isn't in the admin...

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.

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