Search results

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

Hi. I have a code which someone helped me with a while ago to put meetings into Outlook from information put into an Access database. I now want to do the same with contact details, so that when a new client is added to the database, their forename, surname, email address, telephone numbers...

Thanks. God I bet that seemed really obvious to you! Thanks a lot Just1

After entering a forename in one field on a form and then entering a surname in the next field, can anyone help me with some code so that I get a message up to tell me if I have someone in the database already who has that exact surname and forename? Thanks Justine

Hi. I have a client record form which links to a client background form. A button on the client record form opens the background form and links the client id to display the relevant record on the background form. This works if I go into an existing client and open the background form, but on...

I know you can find and replace within a datasheet or field, etc, but are you able to search the whole database, ie. all the different tables to find a particular word? Or would I need to set up a query to include all the fields from all the tables and then search that in the usual way? Thanks...