Recent content by David8

Hello could anyone help me with my understanding here? I have what I think is a normalised database that uses foreign keys quite a bit, as I believe (correct me if I'm wrong) is regarded as good practice. For example if I had a 'contracts' table which refers to 'clients', then there would be...

Right, this works really well. Much easier than I thought. There are no errors for multiple users making separate selections, and thus different filterings (as there would be if for example they were changing values in tables then getting errors to tell each other that someone had since changed...

OK, basic progress! I did not understand that the way the filter is applied is the same way you would apply any other filter. You enter the full name of the combobox in the criteria row underneath the field you want to filter by, within the query on which your subform is based. Afterupdate...

I've just been looking at this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=190314 I don't understand. Obviously this person is asking about unfiltering, whereas I'm a step earlier asking about filtering. I don't really understand the code. Is this code from the...

Dear all, Hopefully this won't be too difficult to sort out. I think it is probably a common scenario. I have already searched the web, but each answer I've found doesn't quite tell me enough to fully 'get it'. Regarding my 'level', although I don't write my own SQL if I can avoid it, I do...

It seems that the pop-up form is in large part a code creation, rather than a 'feature of Access'. That's OK, but it means I now need to go and learn a lot more (code). I wish the concept of a pop-up form was more 'built-in' to Access.

...and another question (I am busy looking at your example). FRM_ClientAddSubform does not have the usual datasheet ability to add new records at the bottom. It seems to be locked at the original number of address records. Would it be possible to design without this restriction? Ideally if you...

Correction, command 14 corresponds to the "cancel" button, obviously the other buttons are linked to other commands.

John, I also note that FRM_AddAdd contains no bound fields. Instead of being bound they rely on the buttons and the code behind them. The button is linked to a click, and that to an event procedure - which is command 14. Clicking on the 3 small dots leads me through to the VB editor and a...

So basically, did you write this yourself, or did you get the program to write it for you? Option Compare Database Private Sub Form_DblClick(Cancel As Integer) Dim stDocName As String stDocName = "FRM_AddAdd" DoCmd.OpenForm stDocName, , , , , , "Edit" & Me.Address1 & "*" &...

Well I have now! So this is based on the "On Dbl Click" event. Is it possible to describe the event procedure with the help of a wizard or UI, or do you have to go to the VB editor?

Thanks John Your first posted example did say something about double clicking the record-selector, but it wasn't in datasheet view and I wasn't sure what the record-selector was. But (thanks for your patience) I have just seen what you mean. Suddenly I am optimistic again - this does look...

Multiple records (or field values for multiple records) can be pasted into datasheet view. Is that possible with continuous view? Coming to the latest example you posted (thank you) it shows a datasheet view form embedded within a more ordinary looking form. That doesn't tie in with my...

I'm just checking we haven't misunderstood each other. Now I've done a bit of research into pop-up forms I am still a bit hazy about them (I think they need a deal of code to set up well - not ideal for me but I'll go there if I have to), but I think they generally require a button to pop them...

I'm really sorry, but I'm struggling with your example. As I think we established, I want to see my data in datasheet view by default. I thought you had suggested to me that I should be using pop-up forms? I had thought you were saying that although cascade combos would not work in datasheet...