Recent content by Nick-in-Paris

Thanks rural guy, I am trying to learn. It's just taking me a while

Here is the code The problem is that I am not a programmer and I have just cobbled this together from other stuff I found on the site, so that's probably why it doesn't work - oh and the fact that I don't know what I am doing. ----------------- Private Sub Organisation_NotInList(NewData As...

I think the title sort of spells it out, but here is the whole question. Simple contacts dbase I have contacts that belong to organisations (usually companies). In my contacts form, the organisation that the contact belongs to comes from the organisation table (drop down). When I have an...

Hi, does anybody know where I can have a look to get the fundamentals of vba programming. I'm titting around with stuff I've found on the forum here (all very good by the way), but I don't know, or moreso can't work out, exactly what the language is telling the magic box of tricks to do. Thanks...

Thanks guys, both Both very helpful.

Hello, Is there a simple way to update a lookup list. I want to be able to generally select towns from a list, but should I need to add a new town, I can do it directly into the form and the lookup list will be updated aswell. I am struggling with Not In List function. Is tehre some secret that...

Did that help you Simon, did you get around the problem?

This works for me Have a look at the very simplistic followig immages

Link Table I think I know what you need: Each application can have many tests associated with it: correct? and Each test can relate to many applications: correct? You need to form a table called a many to many relationship (and keep it in a table. I would suggest create a tale that looks up...

I may have the solution But it involves creating queries that go back to tables. I'm at work at the moment, but I'll have a look at it tonight - if you haven't already found the answer by then! Speak to you soon

Personnel form What this does is you select a persons record (naviagation with form buttons), The subform shows timesheets for that person only and the data sheet in the subform shows their details on the project. You can modify personnel, timesheets and timesheet details - and all this backs...

I don't know how to create the snapshot in the first Dave, Sorry to be an pain, but I don't know how to create the snapshot in the first place

Solution I think I can help you if you can tell me how to create snapshots of my dbase to post, I think I have one that does a similar thing. I will also need to know how to snapshot in design mode.

Thanks Dave, I might have seen it if I had opened my eyes. You haven't got any answers for my question about filtering lookup information in a query (funnily enough in the quries section) have you. Cheers

I would like to take snapshots of my tables, queries etc to show them in this forum in order to better explain how things work. Duhh, anybody know how to do it. For example I wanted tio show someone how a query is set up in design mode, using visual aids. Thanks