Search results

Many Thanks Geoff, your first method works perfectly. Regards Scott

I have a check box on a form that asks the user if a test has been done. Tick for yes don't for no. Easy. Next to this I have a combo where the user selects what the result of the test was (Pass, Fail, Waiting for Results). I would like to make it so that if the user selects a value from the...

When in the form design view go to Format > Conditional Formatting ... It is all pretty self explanatory from there.

Sorry to trouble, I have got it sorted now. I made some changes in the coding on another part of the form, and it mucked up the coding of the subform. Thanks for your interest anyway. Scott.

No, both the main form and the sub form are based on tables. It is the simplest form-subform setup you could imagine. Typical!

I'm back... I have created a simple form with sub-form. nothing special. It is identical to a similar one I have in the DB, but this one seems to be generating an error message when I go to open the main form. It looks like this: "This expression is typed incorrectly, or it is too complex to...

I am having a go at what you said Hayley and it is nearly working. The relevant subform is showing for the correct employee and the correct course details. However, when I try and add a record to the subform a pop up message says 'File Cannot be updated'. Why is it doing this? I am thinking of...

That'd be great. margaretkombakono@hdvfoundation.org.uk address would be best. Will get back to you how I get on

The main form only has 2 fields from my employees table: employee id and employee name. Do I just stick another field in the training table that looks up say employee id and then make the relationship that way? also are the master/child links correct?

OK, I have setup the form with subform. A couple of questions ... 1) The tables employees and training are not related (they don't have a relationship becuase there is no common field). Do I need a link table to link them together? 2) I will be setting up another combo at the top of the form...

I have a big problem with part of my staff DB. Basically, I need to have a form where you can select an employees name from a combo and details of all training courses that they have completed is displayed below and you can also select another training course to add to their reputoire (sp?)...

I knew it was simple. I had the row source as: ztblReports when it should have been: SELECT [ztblReports].[ReportName], [ztblReports].[ReportTitle], [ztblReports].[DocPath], [ztblReports].[Menu] FROM ztblReports WHERE ((([ztblReports].[Menu])="Merge")) ORDER BY [ztblReports].[ReportTitle]...

I chickened out in the end and created another form with the fields and the combo ob and then linked to this form from the main menu using a command button. I have still emailed you from my works address, Graham, as I am still interested in seeing how it works. Cheers Scott.

Right. I have setup a sucessful mail merge based in data in a table. It works great. Now, I want to adapt this so that the mail merge only takes data for specific people. i ahve created a query that picks the specific people out. I have adapted the code of the mail merge to be based on the...

Apologies go to Happy YN, you way did work. Thanks all. Scott.

Currently my SQL looks like this: DELETE [Employees Archive].*, [Employees Archive].[Employee ID], [Employees Archive].[Employee Name], [Employees Archive].[Address 1], [Employees Archive].[Address 2], [Employees Archive].[Address 3], [Employees Archive].[Post Code], [Employees...

Happy YN, I don't think this will work because it is saying to just add 180, not 180 days. The format of the field is dd/mm/yy, so I don't think you can just put 180. I tried it and it said is was invalid syntax. RV, Your way looks a little more workable. Now, do I copy and paste the code you...

I have a table that contains records of employees that have left our company. One of the fields is called End Date and this has a date in the format dd/mm/yy that states what date the employee left. It is all based on a table called employees. The form is called Emp Left. I want to create a...

As previously posted by capri: yes it is, I found a file http://www.candace-tripp.com/_pages/HTML/default_HTML.asp here is the text but you will need the dll Animated GIF's in Access Follow the instructions below to place Animated GIF files into your Access application...

Your are almost right. I do want to select a record from the combo, but there is no command button. The results are displayed on another form. Well, that is the theory anyway. I have started a new thread clearly explaining what the problem is. It can be found at...