Search results

The solution can be seen in the attachment however the structure of a database is not built like you did.

Maybe if you attach an example file, saying what the offending mask is, you do it first.

After "StrataPlan_T" there is an extra point the correct code is the following Me.Filter = "[StrataPlan_T].[StrataPlanNr] like '*" & SearchText & "*'" Me.FilterOn = True

Attach an example file, indicating which form is not opening, so you can check what happens.

You have to explain step by step in detail how the activity you would like to register in the database takes place. Also you should say for each column: - what kind of data it should contain - if the entry is mandatory - if the data must be unique

You attach a sample file so we can see what's going on and make it easier for us to help you. Furthermore, it seems, from what can be seen from the structure of the two tables T_Contract and T_ContractInfo, that there are problems in their structuring.

Attach a sample file so you can see what's going on and make it easier for you to help.

Surely first of all you have to review the database structure as it is not correct either from the point of view of Field Properties or from that of Normalization.

In the attached file you will find an example of how it could be done. However, the first thing to do is learn how to manage the properties of the various fields of the tables and in particular: - Size (if the type is text, don't always leave 255 set as you almost always won't need all those...

Attach a sample file and maybe it's easier to help you.

Attach a sample file and maybe it's easier to help you.

The search through Ctrl + F is already provided on HTML pages just press Ctrl and F at the same time which opens, usually in the lower left of the page, a text control that allows you to enter the text to be searched.

Meanwhile in the attached file there is no query or control named txtTotalQuantityinStock, you should say where you entered the IIf (...) control statement they suggested. Also remember that it is very important to correctly set the various Properties of the fields of the tables such as...

You should attach a copy of the DBF file with a minimum of data, replacing the sensitive ones, in order to test and verify what happens.

If you do not attach a file with a minimum of data, replacing the sensitive ones, it will be difficult to understand what happens and consequently help you.

The problem comes from the Cycle Property in the Other tab, you have to set it to Current Record. The filters would be better to make them in a data summary mask and then eventually print the result.

The unique index "yr" of the "Dues" table is wrong as it is set only on "Year" while it must include "Year" and "MemberID".

Again I repeat that it can be done but it is necessary to have the Excel file available, with a minimum of data and replacing any sensitive ones, to get an idea of how to carry out the project.

Of course it can be done but you need to have the Excel file available to get an idea of how to carry out the project.

Yes, but the attachment satisfied your request.