Search results

I'm actually in the other hemisphere I think, and need some sleep. So I can't examine the example too closely. But I did notice that I seem to be able to select the Aberfoyle Park locality whichever state I choose in the first column, so either it isn't working correctly, or more likely I...

What I need (I think) is a form that carefully distinguishes between the entry of new data and the display of existing data.

I've realised, what I've got here is a problem of circular logic. For any given field I want a choice in the Buildings form field to narrow down the choice in the Room form field. So the Room entry depends on the Building entry. But thereafter, once entered, I want the building field to show...

No, it won't work properly in datasheet view. If I change the value for the first (unbound column) then all the records in that column change to match. Does data sheet view not work with unbound columns? I could make it bound (sort of). It does have a relationship with the column next to it. Its...

As soon as I changed the name of the second combo box (the one I was binding) to match the name of the field in the table it was supposed to be bound to it started working. I cannot view my form in Datasheet view (it will not show any data if I do). I really would like to. EDIT: And just...

Now I'm having problems binding the second form field. It keeps making a ding noise, and at the bottom of the screen along the grey bar it says: Control can't be edited, its bound to unknown field ... name of field I gave it. What might I have done wrong now?

Thank you very much for your help. Actually when I click on the three dots I have to choose one of three options. I chose the Code Builder, because it became clear to me that JANR had probably used the Visual Basic editor with the first combo box. I simply copied and edited the code in JANR's...

OK, new problem. My database is not happy with the term Me. It says it cannot find the object Me. Is Me some kind of generalising jargon?

Thanks for your help, but as I said in the first post, I'm a beginner. So, where is the After Update event please? EDIT: OK, worked that out, that was easy. I realise now why I spent so long on this. In JANR's example I was focussing on the second combo box. It didn't occur to me that it might...

I'm a beginner. I am up against the problem where the second box will not refresh if the first box changes. I do not know how to deal with it. http://www.access-programmers.co.uk/forums/showthread.php?t=199762 Here someone posted me an example. Please look at it, especially frmSearch, which...

I urgently need help with this, please. I thought I'd understood what you did with frmSearch. How did you get the Items list to pop open, once a Manufacturer had been chosen? How did you get the Items list to refresh if the Manufacturer choice was changed?

I am an Access beginner, particular with forms. Ideally, I would like to create a split view form. The lower section datasheet view will get used for editing existing records, and... key point: data entered in the upper form section would not accidentally ammend any existing record, but...

I know how to do this with Forms. I'm also aware that it is bad practice to use lookup fields in Tables. But I like to learn by exploring, and by experimenting to find out how stuff works. Don't jump to the conclusion I am trying to use this technique for a finished job, I'm not. I'm trying to...

Before it gets too long I wanted to say thanks for your response, which was brilliant, since your example was about as bang-on-the-nose an answer as could have hoped for. I recreated the tables and relationships from a blank database start to make sure I could do it myself. In the past I've...

A form that looks like a query? That sounds very interesting, and as a beginner not something I've seen yet. I shall have to set one of those up and have a play with it.

Thank you for your help. IMHO I am NOT worrying about formatting in the wrong place or level. You can create a manual check box (directly in a table), enter data into it, and it stays showing as a check box. There you do have control over it, so why not for a calculated field? Pointless. For...

As per title. This does not seem to be possible, unless Display Control can be called in SQL code? I doubt it, but maybe. This really annoys me. I want a check box to come up for my CALCULATED FIELD in my Table, and especially in my Query. Yes my caculated field will deliver True or False...

Oh, and just tried something really simple. Created a new calculated yes/no box field. Set the expression simply to: True Nice column of ticked checkboxes. Now I change the Result Type in design view to Text. Nice column of "-1 " as expected. Now I change the Result Type in design view...

Thank you for your help. IIf([field1] Like "James",True,False) ....will deliver True/False, as I want, or Yes/No, depending on my format choice in design view. I have put LIKE in there because it is more flexible than =. It has the potential for me to add wildcards even if I'm not using them...

I've read up a bit on SQL, but basically I am a total coding and SQL beginner. I understand how to write some complicated Excel formulae, and that's about as close as I get (not very close). To practice I thought I'd try what I thought would be a simple easy step. To create a calculated yes/no...