Search results

Wow, if I could combine this with the multiselect box, so that I could select one or more people/places and then be prompted for the dates... I think that this could do exactly what I am after!! I can see that I would alter [tbl1] to say [whatever my table/query is called] and [datecolumn]...

Can I add a picture as a background for a form, rather than just a colour? I can't see how, but I'm sure I've seen others do it. NB: I have developed my database in Access 2003, to ensure that it is usuable by all computers networked on my system. Also, would this dramatically alter the...

Thanks... OK - in as much as you were using English I understand the words you are using, it's just that the way they are combined makes no sense to me. I am not trying to be modest when I say that I don't know what I am doing with the coding! If I hit Alt+F11 it opens up a window that...

OK... If I want to be able to see all three fields when selecting, but display the third field once selected, then I have to switch round the order, so that that the third field is displayed first? Hmm... might be messy. If I reorder the column widths to 0cm, 0cm, 5cm then the selected third...

That explains why I haven't been able to manage it! I guess that this might be a project for another time and I'll have to make do with the drop down list. Thank you Andy

I have asked this question before, but failed in implementing the answers!! I have created a database to collect info via forms on (for example) errors/incidents that occur at a specified site and relate to other specified details (such as who is responsibile for the incident, who investigated...

Yes - used the wizard! Yes - the data type is text; the lookup table that I was accessing via the wizard did have 4 values: ethnicity_ID (autonumber/primary key); code; category; sub-category. However, using the wizard with this set-up made the data type = number... whether or not I added the...

Hi I have a risk matrix (Johari window) that I would like to make 'selectable' in a form, rather than having to select an item from a drop down box. Ie, I have a 5x5 grid (25 box grid) - A,B,C,D,E on one axis and 1,2,3,4,5 on the other: potential options to select are A1, A2, A3, A4, A5, B1...

Hi I have created a table (data entered/selected via a form) which includes a drop down box, for 'Ethnicity' to pick a value from another table (ie used Lookup wizard to for options from another table). The row source looks like this: SELECT [Lookup_Tbl_ethnicity].[Code]...

You'll note that it is a long time since I asked this question... but I have finally tried to follow your instructions again, thinking that I had a better understanding. I posted this: DoCmd.OpenReport "Rpt_interventions_all", , , "FieldName = '" & Me.Name & "'" Because the report name is...

I have just been kicked out twice, having written a huge reply!! I am struggling with this problem… My understanding of Access if very simplistic: you collect info in tables; forms are a user-friendly way of collecting the info that goes into tables; reports display the info from the tables...

My database currently contains roughly 70 forms... plus subforms, reports etc. One menu/switchboard often leads to another. I might try the technique for other small databases that I have built, but I guess that I have the answer for this one! Thanks

Ah! OK. I will attempt to build the form and come back to you!

Thank you, both. My database uses multiple forms. Does this mean that it is a no-go? Andy

Thank you... but I am fairly ignorant when it comes to the 'coding bit!' Where do I put this piece of code? If you can tell me, I'll go away and try to build the bits that need it and see how it works. Andy

I am convinced that I recall using a database (created by someone else that I don't have contact with) whereby, when you open it, the user-end form opens up on your Windows desktop, but the usual MS Access window is minised/hidden. Is this possible? (It would make the databse look much...

Hi I apologise if this is very simple task, but it is something that I have never had to do using Access before. I have created a database to collect info via forms on (for example) errors/incidents that occur at a specified site and relate to other specified details (such as who is...

It doesn't give me the option of a control source for the label. When I cahnge it to being a textbox I want it to read the same way as the label would, but if I try to type in the text (as though I were typping in a label) it uses this as the control source - if it matches an actual control...

Right then... I have attempted to attach a screenshot. I apologise for the quality - it is the best I could do with the facilities available to me on this (someone else's work) computer. The grey bits are the labels and the boxes directly below are the associated textboxes. I have opened up...

I will try, but I can't work out how. I think that this might be because I have less than 10 posts!