Recent content by Just1

Thanks. BUT...when I go to open up the form, the message box now flashes up before I actually get into the form. This happens if my first record shows a "No".... ? Thanks Just1

I have a form where it is important for the user to know whether or not to contact an employer. If the data entered in the "Contact Employer" field states "No", I would like the next person to go into this screen to be fully alerted to this, ie. say, change the background colour of the whole...

In short - have these tables in a database, with junction tables to link where necessary as some are many to many relationships Current Event Table School Table School Contacts Table Employers Table Employers Contacts Table If I want to create a form to enter in an event and then select who...

Hi - don't worry, I've managed to sort it. Hoorah! Thanks for advice. I'm sure I'll be posting for other help! Just1

Sorry, that last paragraph I meant EventIDNo appears twice, not EmployerIDNo

Hi. Well I've given that a go and I'm getting somewhere - thanks. Just got a couple of problems. Difficult to explain, but here goes. Junction Table contains EventIDNo and EmployerIDNo Main form shows Employer Details - key field EmployerIDNo Sub form needs to show Events linked to that...

Fabulous! Thanks, I'll give that a try. Just1

Thanks. Don't think I'll create any more for now then!!! Just1

What if I've already done all the forms in one of the standard formats and then decide to pretty them up? Not possible? Thanks Just1

I know it is possible to copy formatting from one control to another within a form, but is it possible to copy the whole formatting of one form to another form? Thanks Just1

Thanks, used the Junction Table and it's working. Not sure how to get the translated values as I just have ID numbers from the two tables in the junction table, so I may need to come back to you if I can't figure that out!! (I'm a relative beginner) Thanks again Just1

Hi. Have a many to many relationship with a junction table to join. Events - of which there can be many, Employers - of which there can be many. I want a form to display an event and the employers involved in that event. And another to display an employer and the events they took part in...

Hi, a simple question I'm sure for all you experts... I have used drop down tables to pick one value from a list before. What if I want to select several? I have a list of employers who can offer training in up to 10 areas and would like to record which areas they can train in. How would I...

Thanks, that worked! Just1

I have a client database and whenever a new client is entered, I want this to export to Outlook as a Contact at the click of a button. This command button has the code shown below. When all the fields are complete, the code runs no problem. However, should a field be missing, eg. the person...