Search results

Hey I have a form which allows data to be added to a table, but i also want a command button which will shut the form but not add the data put into the form, onto the table that it is related to. at the moment i have a command button with a macro that shuts the form down but still adds any...

I cant get the first part to work, it keeps saying that there is an "invalid .(dot) or! operator or invalid parentheses." thanks for your help, yeah i am very new to this.

Hey I have created a way of seraching for table fields in one of my forms, the query results from the serach show up on a new screen. idealy i would like these to appear on a sub form, how do i do this Sam

One other question. At the moment this requires the user to serach via both fields, how can i make so if the user only knows one of either the first name or second name it will show a list of results... for example if the user serachs john he will get many results but if he serachs John...

Mate... Thanks alot worked a treat cheers. :D

In my database I want a form which allows me to serach for a feild in a table. The table i want to serach in is titled Trader Details and the field that i want the user to type in to search is First Name and Second name. I want the user to type either the first name or last name in and click...

Hey, I have a form which is binded with a table and when i type information into the fields and then press enter the field is added to the table... however i want a button to do this and not just press enter and i cant seem to work out the macro for this... Also if possible I would like a...