how to make search data that also can be edited? (1 Viewer)

[nhk]

hye,

i'm new in access..i have a problem regarding how to search data using query that can also be edited by user..
right now, i've already make query to search the data and it will came out as a report. so, i want add one new button to make data be edited once user search the data..

how i'm gonna do this??
can somebody help me to give any idea or solution to my problem..??

your help is much appreciate..
tq..

 

[John Big Booty]

Welcome to the forum.

Perhaps the sample posted here will give you some pointers. Check out the Double Click event of the List box. As presented it opens the record in a non-editable form, but that can easily be changed.

 

[nhk]

hye John Big Booty,

thankz for reply..
could you help me by explain this..

"Save and close your query and go back to our form FRM_SearchMulti, now put a list box on the form use your Query QRY_SearchAll as the source for the List box when promoted by the wizard, and follow the bouncing ball from there, call this List Box SearchResults."

i do not understand about put a list box and use the query part..
i'll appreciate if you could help..

thankz,
nhk

 

[nhk]

and 1 more thing, if i put the code in criteria of query, some of my data is missing..
my data in query is not same in as data in my table..

why this happen huh..??
can you help me to solve this problem..

thankz in advance

 

[John Big Booty]

hye John Big Booty,

thankz for reply..
could you help me by explain this..

"Save and close your query and go back to our form FRM_SearchMulti, now put a list box on the form use your Query QRY_SearchAll as the source for the List box when promoted by the wizard, and follow the bouncing ball from there, call this List Box SearchResults."

i do not understand about put a list box and use the query part..
i'll appreciate if you could help..

thankz,
nhk

Create your form, then use the Tools Menu to create a List Box;

Now ensure that the Radio Button next to "I want the list box to look up the values in a table or query" is selected;

Then select the Queries Radio Button and select your query. And follow the bouncing ball from there.

 

[John Big Booty]

and 1 more thing, if i put the code in criteria of query, some of my data is missing..
my data in query is not same in as data in my table..

why this happen huh..??
can you help me to solve this problem..

thankz in advance

Sorry I'm not sure I follow

 

[nhk]

i want to ask again..

why when i insert list box and select the query, it said data cannot be retrieved from the source you have been select. you must select a different table or query to cont in wizard.

huhu..i cannot proceed to the other step because of this..
do you know how to solve it..??

thankz in advanced,
nhk

 

[John Big Booty]

Can you post a copy of your DB? '03 version for preference and certainly no newer than '07

 

[nhk]

hye John,

here is sample of my db..
can you take a look at searchForm. i have problem regarding textbox which description.
when i enter keyword it does'nt work..
but for combo box it's working..

i dunno how to solve that..
the coding for description in query seem right to me..

dunno why it cannot work..??
huhu..

thankz in advance

 

[John Big Booty]

I've move the criteria for the text box to it's own Or row criteria, I think it should work now.

I'm not sure if I already mentioned it but I would seriously consider reading up on Data Normalisation and perhaps even doing a tutorial or two on the subject.

 

[nhk]

hye John,

thankz, it work but it work for text box only..
if i select from the combo box, it will come out with all data..
it's not search the want that i selected..

 

[John Big Booty]

Dude before you start investing time and effort in a search function, you really need to invest some serious time on normalising your table structure. Once you've got a good table structure then you can look at search functionality.

 

[mahenkj2]

At least, you should review the table relationship in database tools, you can understand what result could be attained by taking advantage of relationships established.