Recent content by Dogberry

Hi On my form I have tab control for 9 different things. My problem is each tab seems to be limited to 255 characters is their a way round this that will allow me to enter more information into each tab. Many thanks in advance Dogberry

Hi Ridders you have been an absolute diamond with this. I thought it might be a code job. I found some vba that works perfectly when you click a search button, but when I use it as an afterupdate i get "no Match" a match is present? so I have put it in the vba section in the hopes someone might...

Hi I have very limited VBA knowledge. With the following code it works perfectly when clicking a search button but comes up as "No Match" when I run it as a combobox value change. Any ideas please Search Private Sub cmdSearch_Click() Dim bkmk As Variant Dim strField As String...

Thank you for the help. As you can see from the attached picture its working now in the form header but not showing the correct plant on the form. Variety is unique within the database, how do I link it so that the form updates to what has been selected. Dogberry

Thanks for the pointer to combo boxes. The examples I have looked at appear to be select from a list. Is it possible to set up the first box for typing in the plant name myself as the Mrs has over 300 plants/varieties. So I would type in Strawberry to the first box and the second box would...

Hi Folks I hope the screenshot has uploaded for you. I have no knowledge of vba. What I am looking for is a simple way to search on two fields from the header so that i can search for ie strawberry then refine it to a specific variety ie cambridge, flamenco or marshmallow. The record...

Hi if you are talking about right click change to label, list and combo are the only choices I have the rest are greyed out:mad:. Unfortunately my database is over the limit or I would upload it Thanks Dogberry

I have uploaded a pic of the properties page for the table the lookup is checkbox, what else am I missing. Thanks Dogberry

Hi Doc They are tick boxes in the table I have made the boxes bigger because when they were the proper size all I had was a hash. From the picture I put up is what I am trying to achieve possible and if so am I using a nuke to crack a peanut or is their a simpler way and yes I am a novice...

Hi Doc I am very new to access so I have uploaded a pic of my situation. I am going into the Tbl to enter the correct ticks in the box. The Mrs goes into this form so she can view the information without altering it. All the tick boxes from the forms have been added using add "existing...

Hi Ridders Checked the Display Control for all four and they all show checkbox? on the table side its only when it comes to the form that one table shows No the other three tables added to the form all have the expected check box. Thanks Dogberry

Hi I have four columns on a form that are designated Yes/No. Three of the columns have displayed the expected tick box. One however shows the word No. Properties for all four appear the same. Has anyone any clues as to where I should be looking to change it to a tick box. Many thanks...

Thanks for giving your time Minty I have a correct direction to go in now and your post will resolve a lot of my problems. Dogberry

Hi Minty Everything is on paper at the moment as it is very much in the planning mode and hence the question. Can you expand on what you mean by identifier. I have a copy of Access Bible 2016 to help me but I cannot see anything referring to this. Thanks Dogberry

As I said I am new do not really know what information you require but her indoors wants a database for her plants. The idea is the plant is called up and then in the multi use text area she can see such things as time to plant, benefits, soil conditions, ailments, etc. The categories would...