Search results

thanks for the prompt reply bob. if i wanted to have a query search form, then display the results in a datasheet subform.. how would i make the query updatable?

Hi, I'm using a query that won't let me update data when viewed either in query mode, or through a subform. All other queries in my database are updatable, however, this query i have now contains several sections like this [SUBURB] Like "*" & [Forms]![FormFINDER]![SUBURB] & "*" Or...

Subform doesn't allow modification or additions of records in datasheet view. I don't know what indexes or links are. I've just discovered that the query itself does not allow modification or additions of records. Interesting. I'll look into that further and update as required.

i've got a form with a subform based on query setup it doesn't let me modify query data or add new records via the form. i can only assume there's somewhere i need to set permissions, but i cannot find where =/

thankyou very much! - i did say it was a simple one! :)

this might be a crude roundabout way of doing things but it works as is, and i'm trying to streamline a little. i have a database that contains all of my customer's details. once a month remove those whom no longer want my mailout, and export the remainder into excel so that my printer can...

this is my query in design view i use this query when entering data i want to know how i can set it up it display all or any one/two/none of the criteria i put into the question text boxes, number surname and state, or even just number, or just state. anyone?

in that case, how do you align customer table record #1, to sales table record #1 ?

Hello there, first post here. :) Recently I inherited our mailout database at work. Not knowing anything about access, and none of my colleagues knowing anything about it, has caused me no end of headaches. But I've figured a fair bit out for myself, and am now trying to streamline my...