Search results

Hi, I have a question regarding tabs in a form: I'm creating a competence matrix for the engineers in my team and under each engineer I would like to have the equipment they can work on and then their scores under that. I would like to have a tab for each equipment with the option to add...

Hello, I've recently been told how to enable/disable fields in a form by ticking/unticking a box. Is there a way that, on a tabulated form, i can only disable/enable the field for the same record as the one the check box is in rather than for every record? Any help will be greatly appreciated...

In a tabulated form that i have created, i'd like to only add another record only when a yes/no field in the last record is set to true Is there anyway of doing this? Any help is apreciated Cheers, Phil

Hi, Is it possible to enable and disable fields on a form with another field that is a check box? i.e. a text box is greyed out until a check box is ticked. Any help is appreciated, Cheers, Phil

is there a way to join 2 fields? for example Field 1 a b c Field 2 d e f Joined field a b c d e f cheers Phil

Is there a way of creating a combo box so you can select items from different fields with out using 2 tables? For example, the fields in the table are customer, vehicle 1, vehicle 2 and vehicle 3 on the when the customer is selected from a combo box, the vehicle combo box contains the 3...

When i select data for one field from a combo box on a form, how can i make data from from a different field in the same record appear on the same form? For example, if a customer name is selected, the correct address appears in the address box. Cheers Phil

Hello, How do I join several fields in one table to be looked up by one fields in another? For example, there are 2 fields, 'First Name' and 'Surname', in one table and they are to be looked up by one field called 'Name' in another table. Cheers, Phil_L

How do i put a wildcard in the following SQL statement? I want the returned data to include every entry that includes what i type in the query, whether before it or after it. I would imagine this uses "*" [Type]=Forms![Advanced Search Form]!Type Cheers, Phil_L

i have created a form with several combo boxes which are references for a query. its a sort of 'advanced search', if you like. however if one of the combo boxes is left blank then no search results are found as its looking for a field with no entries. is there a way that a blank combo box can be...