Recent content by redalert

This should do the trick. Forms!frmGenerateChecklist!frmSubform.Form.Filter = "" Forms!frmGenerateChecklist!frmSubform.Form.FilterOn = False

Does anybody know why the following code: MsgBox Me.Top returns an error: Method or data member not found (Error 461) I want to ascertain the position of the current form so that I can position it where I want to on the screen. Thanks

I can surely be forgiven for thinking that I have joined the wrong forum with the abuse by flying pigs and lashes with a limp noodles being suggested!! I support the need to avoid using spaces in Access object names, field names, control names etc. If the name of the filename to produce is...

Try the attached database for an idea. Using this technique I am sure that you can build what you want.

A good principle is to build in scalability from the start, it is often easier and certainly saves time later. You may not be around when the system needs changing in the future and others may not even be aware that changes are / were needed. This may result in incorrect decisions being made...

I am still unclear as to what you want to be able to do. The scrollable box can have records from another table in it. Various fields can be displayed in columns in this scrollable box. Do you want to be able to display a different set of records when you click on a button on the main form...

It depends on what you mean by 'control'. Can you be please be more specific.

See attached jpeg image. As suspected, you have records for the same valve with different manufacturer and model data. This is the reason for the difference in record counts. Your data is not normalised which causes problems. Maybe this is an issue to address in the future. Can you describe...

There needs to be a field in the tbl_options table that represents the identifier in the table that you are wanting to query. Link the table that you want to query with the tbl_Options table using this field and only return options where the YesNo field is true. If you want to use the Listbox...

Another way and one that involves little coding although it does depend on what sort of recordset you want to create and where your options come from. Create a small sub form based upon a table, (e.g. tbl_Options), with the options in it and a Yes/No field named 'ThisRecord' for example...

What I often do is to have a set up routine that creates some of the tables that are needed in an application. This especially useful if the tables are only required whilst the application is open. In your routine you could rename the existing table, create a new table using the CREATE TABLE...

You have discoveder that for a combination of description and connection values you records that have different combinations of manufacturer and model values. You need to decide if thes scenarios are valid and if they are then you need to ascertain why. It maybe that two different valves have...

Are the questions in a table or could they be? If so then a listbox or a subform is maybe what you need. Without knowing what you want to display and or enter / update I cannot suggest much more.

Just another technique to add to you library of knowledge.

If the Manufacturer and Model fields have the same values for all of the records representing a single product then you can group on them. If there are different values then you will get extra records in the result, one record for each combination of description, connection, manufacturer and...