Software 💾 Microsoft Access question

[michaelskis]

Ok here is one for all the computer people in here.

I am creating a few databases in Microsoft Access.

I want to create a search form (such as key word or applicant name) that will bring up information. I am not sure as to how to create this. The help files so far have been no help, and it would save allot of time for our Zoning / Codes research and our Attorney Opinions Files.

Any information would be of great help.

 

[jmf]

Sorry, I can't help but if you get an answer please share! You can PM me.

 

[jordanb]

Re: Computer Program Question, PLEASE HELP

Ok here is one for all the computer people in here.

I am creating a few databases in Microsoft Access.

I want to create a search form (such as key word or applicant name) that will bring up information. I am not sure as to how to create this. The help files so far have been no help, and it would save allot of time for our Zoning / Codes research and our Attorney Opinions Files.

Any information would be of great help.

You want it to open a table window showing the data or what?

 

[michaelskis]

I was going to create a form that will pop up (basically a switchboard) and from that one of the choices will be to search for key word. In the tables that I will have, one field will be “key words” that will relate to that record. I think that I have figured out how to search for a range based on date, but nothing that will let me call up a specific text, that will allow for me to call up specific records.

 

[jordanb]

If you have a form object, like a text box, and you want to get the text in it, you can access it from vba like this (assuming the form is named "this" and the text box is named "that").

dim keyword as string
keyword = Forms!this!that.text

Then you can use that to make an sql query. So to open a query showing all of the records with that keyword, you could do this:

docmd.openquery( "SELECT * INTO oldtable FROM newtable WHERE keyword = '" & keyword & "';")

Hope that helps.

 

[michaelskis]

Thank you for the info, I will try it when I get back from lunch.

 

[michaelskis]

Something is still not working right. I keep getting an error. Maybe I will see if I can get a book on this topic.

Unless you know any other ways.