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

Thanks for your response. Could you elaborate? I'm pretty inexperienced with Access and especially events. Thanks again, Phil

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

If I initially set allowadditions to false then there is no initial record on the form, therefore no tick box to tick. If I initially set allowadditions to true then as soon as i enter information in the record a new record appears. I dont want this to appear until i tick the box at the end.

which event should i put this code under?

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

Does this mean instead of selecting the customers name, I'll have to select their PersonID?

What im trying to achieve is a program which has a database of customers names and an invoice creating sytem which looks up these names to put on the invoice for when they're used again. Any ideas?

Does this select both names? I need the full name to be shown on the second table.

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

Sorry, working now! Cheers Phil

This comes up with a dialog box saying 'syntax error (missing operator) in query expression

Sorry for not getting back but i was put on another project for a bit. The search now works using the SQL statement. Thanks for you help. Phil

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

still not playing ??

done this and it doesnt seem to be working. any ideas?