Search results

have you locked data entry for the entire form? you can go on to the properties of each individual text box and change the locked option to yes where necessary and leave it as no where data should be allowed to be changed

Cheers The Me.Refresh on After Update event worked, however it did not work when i put Me.Requery The problem is solved however. Many Thanks

The problem that i am currently encountering is that i have a combo box based on a query (the possible values that can be selected are the results from the query), but however the results of the query may change when a different date is selected from the same form. I have a booking system. When...

Wrong format First, like 'lagbolt' said it is not IF that is used, like on Excel, it is IIF that is used. In addition, i believe that the format of the if statement that you are using is incorrect. it should follow such rules... IIF([Calculation/Expression], Result if True, Result if False) I...

Have you made sure that the 'visible' settings for the check boxes, in the report design view, within the properties for the check boxes are set to visible or not?

In addition to creating the multiple selection query....I expect that when the combo boxes are left blank all records are returned, and when more and more 'filter selections' are chosen, the results returned decreases. However, if i do a search where part of the criteria is correct, but another...

Thanks....one last thing though Many thanks in helping me with the IIf in the query, it works fine. However, I wish to incorporate this into another query. I wish to be able to make multiple selections from combo boxes on a form, and then when a button is pushed for the form to display the...

IIF maybe??? Having thought about it slightly, am i correct in believing that I need to set the criteria for the 'actual completion date' to be along the lines of... If the combo box equals open, then display Is Null as the criteria, and if not then (i am unsure). and for the overdue...

I have set up a database that stores actions (i.e jobs). In the table; two of the fields are...'required completion date' and 'actual completion date'. I wish to lookup, by using a query, all of the open actions (those which havent yet been complete (i.e the 'actual completion date' is null))...

how do i go about posting part of my database up?

So far I have changed the people table so that it has a unique number (primary key) for each person, as you recommended. However, when going to set up the relationship for the actions table and people table i cannot enforce referential integrity and cascade update related fields when the primary...

i agree that two or more people could have the same name, but for this case they will not. so surely it should still work?

It appears that what you are suggesting for me to do is to use a link a primary key within the names table to the actions table? i currently have the persons name as the primary key...but as mentioned previously this field cannot be linked to the actions table to two fields with the...

Hi there people...i'm doing a databae project for A2 level coursework and have encountered a problem..please help me if you can. I have a table of names. Also another table (actions) which contains several fields, but 2 of them are names, (1 being Proposer, and other being Actionee), are...