Search results

Hello Thank you for your comments and advice, I will certainly be reading more into it. The current database works perfectly. All links and relationships are working well. My issue is that I would like a field to display the information from the field where the mouse cursor is. So whether you...

Thank you for your kind words, please see attached a copy of the relationship. Going from left to right they are one to many relationships. Yours Iain

Re: Display contents of active field Hello Thank you so much for you work with this, I can't really attached the database as it is very large and also you would need the back end data to open the front end db. I have attached 2 screen shots, the first shows Looking at screen1.jpg you can see...

Hello Thank you for that, I am not sure if I am missing something within that text but breaking down the table isn't really the problem I have. I have the relationship already set and worked out. Thanks Iain

Hello Sorry for that, Fields rather than cells. What I am trying to do is the follows. I have a master form which has a list of part numbers in several fields. When a user clicks on Field1 they are able to click on a subform and get information about the part number in Field1. This is using...

Hello I'm trying to have a cell display the information from which ever cell the cursors is on. I am trying to use (Master Info / Child info) for a subform but would like the Master cell link to where ever the cursor is. Is this even possible? Thanks Iain

Hello I have found this thread very useful, thank you very much. Would you know what I would need to do so that rather than just opening the PDF insted it just printed it? Thanks Iain

Thanks for that, it stops the error saying I can't insert that char but all it does it highlight the field. If I do it in a text box it works fine but just not in a number one. Thanks

Hello, I have made an OSK and am using the code TypeAlphaNum "6". This works fine until (the cell is set to number) I want to enter a decimal point. It treats this as AlphaNumeric (there's a surprise!) but I don't know what the code would be to enter a "." into a number field. Many Thanks Iain

Hello, I suspect I am being silly in missing the special button but... I have a tab control form and when you select the next tab the screen scrolls down so that the first cell selected is at the top. But then I loose the tabs. How can I stop it doing this. :banghead: Thanks Iain

Paul Thank you, I thought that would be the case. I totally agree with your "knowledge about access until you came here" I feel the very same. Iain

Hello. I have a form which shows costings of parts. When we get a new cost for a part we update the cost but then adjust either the retail or markup. At present I have loads of cells which calc the price difference based on Current markup giving calculated new retail user defined new markup...

Actually what you said of Me.YourComboBox.Dropdown worked perfectly. When someone starts to type it auto drops down. Many Thanks Iain Also the website you recommended is really good.

Is there any way in which I can get a drop down menu to automatically drop down as the user starts type? Thanks Iain

The main problem with the datasheet is that you loose a great deal of the styling when it comes to field positioning and buttons. Thanks Iain

So in the main record it would show, Your current item to pick is SSD x 1 128GB @ £100. The last item you picked was 21" TFT Screen (just so the user can see what they just picked) Cheers. Iain

Thank you for that, What I am really trying to do is to have the main form only show one record. On the same screen it would show the record before it as well. A bit like in datasheet mode but rather than a complete list of all records it will only show two records. Iain

I have a mainform which shows a single record, I would like to have it also show the previous record. The user is picking parts, the main area is to show them what to pick next and I want it to show what they just have picked. I thought about having a subform which would contain the identical...

Hello all, I have a query which doesn't run properly unless the user has put the cursor in a cell which contains data. The data is in a subform. If they leave it in the bottom (make new) cell then it fails. Please can someone help with regards to either making the cursor go to, say the first...

You are correct, it is a bit of a bodge. I have now changed the way I do it. (fix my code) Thanks