Search results

Thanks. Played around with it and finally got it to work! You really know your stuff! :)

Thanks! Knew it was simple. Just didn't know exactly what to type in :)

I was just wondering if there is any way that I can create a query to find all of the records which have a tick box checked. There is a tick box on each form and I want to know what I type in the 'Criteria' box is Query Design so that I can quickly and easily search for all those which are...

Ok... I've included a screenshot of what I think you mean... but an error has appeared too..

Could you just confirm to me what controlName would be? Is it like 'Combo 26'? I have tried this, and it does appear to work, but it still doesn't update both parts of my form (the listbox and the related fields below)

I have been developing my database further and was wondering whether there is any way that the whole form can be refreshed so that another search can be done, without closing the form and re-opening it. Tim very kindly and helpfully told me how to update a forms fields by using a combo box...

Another easy way is to go to the properties table for your form and under the heading Format, there is a part that says 'Picture'. Click on the text box next to this and then click on the little button with '...' on it. This will allow you to insert a picture from a file stored on your computer...

I have just returned to look at this query, and it seems that it will only work when the letter 'd' is typed in. What i mean, is that it only finds results that begin with 'd' and no others. This seems very strange. This is what is in the 'Criteria' box in my query under Bodyshop Name: Like...

Thanks! That worked perfectly!

I have set up a query to search for Customer Name by its first letter (thanks to Bob for that). I have created a form with a List Box which shows the results of this query. What I want the form to do is change according to which result is clicked on from the list box. My question is, how can...

i've done both and it's still 2,570kb when compressed..

I would send it as an attachment, but its too big, and i can't send just one form?

wait a minute... i've just managed to change that back. i'm gonna try and see if its something to do with the query

ok.... i have found something else that might help you to help me.... when i move the cursor over the first data entry field in my form, it turns sideways!

its a form to add information, but it might be possible i have changed it somehow without realising... how would i have turned it into a 'non-updatable' query and can i change it back?

ok, i've found it, but they seem to be set right. 'enabled' is set to YES and 'locked' is set to no.....

Where is the 'enable' property? I can't seem to find it...

but thats the thing... i can't enter anything. not even new records. I've tried making a new form, but it does exactly the same thing. i have other forms that are fine, and i can add a new record whilst i'm in the table's datasheet view format, but not when they're put into a form. Its really...

Um.... something has happend and i dont know how it did! On one of my forms, which i haven't done anything to in a while, wont let me enter any new information. The computer just makes a noise when i try to type in a text box. I don't know whether i have changed something accidentally, but i...

I've checked all of these and its none of them