Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
MS access search tool, help!
Name: wheelspinner99 Date: March 22, 2004 at 22:27:01 Pacific OS: xp home CPU/Ram: enough
Comment:
I have a client has a large ms access db file. They want to be able to search through it and return a listing of results that begin with a certain letter. This needs to be automated as the people that use this software don't understand SQL or how to use it. Let me know something!
Name: a_kelly Date: March 23, 2004 at 02:51:15 Pacific
Reply:
Hi nick nice to meet you ! Most easy way is to create new form and place subreport linked to required table on this form. Also add text field. Add to text_field.onchange event code that will change subform record source to filter from
text field, for example SELECT * FROM table_name where record_name like '%text_field%'
------------------ http://www.keyglobe.com - Ready sale trade board
0
Response Number 2
Name: wheelspinner99 Date: March 23, 2004 at 10:13:17 Pacific
Reply:
Hey, thanks for the info. I know how to make a form but i don't know how to add a text field or add the SQL statement. Where are these options set at? thanks again.
0
Response Number 3
Name: Wolfeymole Date: March 24, 2004 at 02:59:56 Pacific
Reply:
Try this site Nick http://www.w3schools.com/sql/default.asp
On a hot summers night would you offer your throat to the Wolf with the Red Roses?
0
Response Number 4
Name: wheelspinner99 Date: March 24, 2004 at 23:00:37 Pacific
Reply:
I know how to use SQL, very well in fact. I don't know how or where to insert it on a form.
Summary: Steve, I am not aware that you need to convert ACCess to asp. compatible. First, I believe you can complete develop your site in asp (vb, c#, or whatever) and then simply use the connectors and setup...
Summary: I have seen this when using MS ACCESS that is located on a server. I can't help much, but have seen this so here are some possibilities: if the database is on a server their permission to use it may...
Summary: I have an Excel S/sht which is linked in MS Access. The fields can be either text, numeric or both. I get #Num! errors in the Access version of the Excel S/sht, the data type is wrong but I can't fix ...
0 
