Search results

I created some forms in datasheet view. Now I want to change the datasheet properties (background color, text color...): the problem is that the forms I create with the new properties are displayed as I want, but the old forms are displayed with the old properties. Does it exist a command to...

Hi! I created two applications, one connected to the server and the other working in local. When a user is in his office, he uses the first application connecting to the company's database, and when he's out he can launch the other application to insert data which will be syncronized the first...

The problem is that the form below has the Popup property set to yes and I can't change it :(

I've an insert query used to copy some articles chosen by the user from the articles-table in an user-order table, and it works perfectly in all the computers using access 2002. It works in the pc with access2000 too, but there are a few articles (about 7-8 of 1000) having a description too...

I need to change the reference "Microsoft Access 9.0 Object Library" in Access 2000 with the "Microsoft Access 11.0 Object Library" but I can't de-select it 'cause it's used by the program. Another problem is that I tried to import the 11.0 copying the file and when I select it from the panel...

I thought the same thing, but they "need to see it" and don't want a command button...

I created a little form containing informations the users need to see to insert the right values in other forms. I need to have this little form always visible even if the users are working with another form maximized. Does it exist a code to do it?

Solved: the code to use was simply Application.CommandBars("ToolbarName").Enabled = True Thanks!

I created the shortcut menu bar as you said and selected it in the forms properties: the problem is that I disabled all the menu and toolbars using the code Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next i DoCmd.SelectObject acTable, ...

I created a locked database, I've hidden the menu bar and disallowed the right-click for all the users. The problem is that some users need to use the right-click to filter the data they can see (i.e. the results of a query): is it possible to give 'em the possibility to filter all they want...

Ok, solved changing the position of me.form.requery

I've a formA with a field "total" and a formB based on the results of a query where the users can insert N parameters (for each of them the fields are ParameterName; Quantity; Price; TotalPrice(=Quantity*Price) ) and there's a field TotalB =sum of TotalPrice of the parameters. Each time a user...

Hi! I've a dialog box used to display the results of a query and to select one of them. Is it possible to enable "filter" and "order" with the right click as if it was like a table-data form or I just have to use a subform? I thought to use comboboxes to specify the criterias of a dynamic query...

Thanks! :)

I've a combobox "Client" used to choose a client from the table of clients to filter other informations. I'd like to display a default value "ALL CLIENTS" to display all the infos related to all the clients without filters, but I don't know how to do it. I thought to use a checkbox to...

I created different dynamic queries (QD1, QD2...) to give to the users the opportunity to choose how to filter the results. The problem is that I need to show the results in a dialog box in the form, not using the command DoCmd.OpenQuery "Dynamic_Query" I don't know how to set the properties of...

The DB is normalized: I just tried to explain the problem using a simple example. the Total which is a sum of prices is not stored, but the users need to see it to "control" the order (I don't know why, but they told me so). They just insert some parameters and the total is calculated...

Hi! I've a form with the fields PriceA, priceB, priceC and a field Total. I set the source control of Total =priceA+B+C 'cause it's always the same operation and in this way I didn't need to write the same code in priceA_afterUpdate, priceB_afterupdate etc. and when I change a value of a price...

I set the properties manually, without the wizard. Thanks for your help ;)

The problem is that when I try to select the fields of the query in the combo-box I can't choose the memo field "description" (the only field of the query that appears and can be selected for the combo-box is the OrderNumber, but if I run the query in the query-window I can see both the...