search button

[red]

i have a form that i use to enter data in and i would like to put a search button on that form. that is the easy part, now, there are a lot of check boxes, text boxes, a few drop downs. i would like to be able to enter something in that form and hit the search button and for that to find all the results and put it into a report. what kind of sql statement would i use?

 

[spacepro]

Sounds like you need to create a query and not a search function.
You can then base the query on the report.

Try breaking down your questions and solve the first part and the others will follow.

Post an example if you can. I would create a query based on the fields and if necessary reference the fields in your form to display the records in the query.

Hope this helps

Andy

 

[red]

Sounds like you need to create a query and not a search function.
You can then base the query on the report.

Try breaking down your questions and solve the first part and the others will follow.

Post an example if you can. I would create a query based on the fields and if necessary reference the fields in your form to display the records in the query.

Hope this helps

Andy

the form is a customer form, name, address, phone number and what the customer is looking for or purchased (basic info, much more is on the form but not needed for my problem at this time). what i would like is to use to same form that is used to enter in this information to search the info already entered. so if i start as a blank form and enter something in the looking for textbox and hit search i would like a report of the results of customers that match that search. i could do a regular sql statement but the search button could be used for other purposes like if i am looking for a customer in a certain town or customers looking for a certain length of something. do you see my problem? there is only one table for this whole database and i think that going into the queries section of access will be to time consuming for the people i am making this for. i hope this helps you help me.

 

[spacepro]

Firstly please take my comments in a constructive way, as they are not intended to offend.

One table is bad practice and design. Do a search on normalisation and db design.

Secondly Queries are not time consuming or difficult.You should be using queries in some shape or form in the db.

If you use one form what happens when you enter some of the information, it will automatically add this data to the underlying table, if the form is bound.

You could post the db without any data in it and I will take a look at it for you if you like.

Hope this helps

Andy

 

[jfgambit]

Have a look at this thread and example...

http://www.access-programmers.co.uk/forums/showthread.php?t=62853

 

[red]

Firstly please take my comments in a constructive way, as they are not intended to offend.

One table is bad practice and design. Do a search on normalisation and db design.

Secondly Queries are not time consuming or difficult.You should be using queries in some shape or form in the db.

If you use one form what happens when you enter some of the information, it will automatically add this data to the underlying table, if the form is bound.

You could post the db without any data in it and I will take a look at it for you if you like.

Hope this helps

Andy

i thank you very much for taking the time to help me and any comments that anybody has are taken constructively. you didn't offend me in any way. i understand that having one table with lots of data is not the best way to go about doing things but i wasn't sure how to make more than one table because the data that is entered doesn't have any relationship to anything else so i can make more than one table and create one to manys or whatever. i am not sure on how to post the db and i will be away from my computer until thursday so i can get back to you then. thank you for your help and your time. if you could tell me how to post the db i can do that when i get back thursday. talk to you in a few days.

 

[spacepro]

Hi Red,

To post a db, zip up the db and when you post a new thread, scroll down the page and there is a button 'Manage Attachments'.

Click on the browse button, and select the zip file , then click upload.

The attachment if below 100k will display in the attachment section of the post, then just click on the post thread button when you are done.

Let me know if the db is over 100k and I will send you my email address if needs be.

Andy

 

[beef]

Search Button

Hi Red!!!!!!

Have a look at the attached sample it has a number of routines that you may want to use.

Two features are:

1 - A calendar routine (found this on the web some time ago, do not know who originally designed it. Who ever it was it is very good as it does not require third party produces)

2 - A access to excel routine (found this on the web some time ago, do not know who originally designed it. Who ever it was it is very good as it does not require third party produces)

I then put the lot together

Any way have fun.


Cheers!!!!!!


Lou

 

[beef]

Search Button

Hi Red!!!

For some reason I cannot attach the sample db. I must be doing something wrong.

Just e-mail me at support@nlsa.org and I will send it to you.


Cheers!!!!!

Lou

 

[red]

ok, first jfgambit, your link didn't work. Second, Andy i zipped my db and it is about 150 or 160 kb, so could i get your email so i can send you the db? thanks for your help.

 

[Mile-O]

ok, first jfgambit, your link didn't work.

The link works for me. Do you mean the database on the other end, once downloaded, didn't work? If so, it can be converted to Access 97.

Second, Andy i zipped my db and it is about 150 or 160 kb, so could i get your email so i can send you the db? thanks for your help.

Have you compacted the database before zipping?

Also, just make a blank database, import the table in and empty any confidential records. Put a few dummy records in. Post that. Everything other than the table is irrelevant at the moment.

 

[jfgambit]

Actually...the link does work.

And, I posted a 97 version if you need it.

HTH

 

[red]

i tried to open your db file again and i got the same error as last time: The Compressed (zipped) Folder is invalid or corrupted. it sounds like the example i need to see becuase of the search.

 

[jfgambit]

Hmmmm...I just opened both of them without a problem.
Do you want me to send you a copy directly. If so, send me a PM with your e-mail address and I will send it to you.