Search results

Dear All, A data model is suggested for a library and book application (attached file). I got this from the site introduced here in this forum (Industry Data Model). My question is about the tables named : Books_by_Author and Books_by_Category. Books_by_Author is connected to tables Books...

Thanks. I still don't get it !!! but I will try to see what happens!? Cheers

Sorry , but are Orig Stocktake , orig Status , orig Location fields?

Thanks Simon, May be this a simple question but can you tell me where this code is used? Cheers LANA

Thanks a lot.

Thanks very much. Is there a way to use variable for the controls too? like this : Forma(fff).Textbox1.setfocus Instead of Textbox1 we use a variable ?? Cheers

Dear All, Is there a way to use a variable instead of a form name? e.g. FRM1 is a form Forms![FRM1]!textbox1.SetFocus Instead of FRM1 , a variable is used which can be any other form name.?????? Cheers

Thanks a lot. I will try.

Thanks again. I did what you said. It works in one form when I know the form name and the control name, but my problem is something else. I have 12 forms and in each form I have at least one sub-form which shows the data. The search form can be opened from each of 12 forms. NOW in the search...

Nobody really know how to do this? Help please. Really appreciate your time . LANA

Dear Gemma, I tried docmd.findrecord on the form and it's fine BUT I need to do this : When a from is opened and the user goes to specific field (on a sub-form Datasheet) then cliks a "Search" button. A search form opens and asks for a search string. When Search string in entered then it...

Many thanks for the reply. May be this is very simple for you but is it possible to show me how to do it? Docmd.findrecord .... is Ok but how do I define the search field? I have a sub-form which shows the data and I need to search in any field that I set the cursor in. Really appreciate...

ANY Ideas???????????????

Thanks for the reply. Actually no, this is not what I am looking for. I give an example : Lets say we have a form with two sub-forms which show two different data sets. If I go in any one of the fields on the sub-forms then I want to search for one specific data. It should find the data and...

Dear All, In access 2003 if we make .MDE file, when it is run we see only our project window with its menu tab or tools bar. I need to do this in 2007 and above. I tried but with no success. Maybe this is very simple but I need your help. Thanks. LANA

Dear All, As you definitely know and use Access "Find" window, which finds any data you need in any field the focus is.... Did anybody write a code to do the same thing?? I really appreciate any help in this. Cheers, LANA

Thanks a lot. Cheers

Thanks . I wrote [A] in the Default Value property. Are you saying that, this does not work in 2010 and must be written as """" & [A] & """" ??

What do you mean by this? This does not work on the default value. It returns #ERROR. If the variable name is A then how this must be written?

Thanks , I do exactly as you did in your example. It works perfectly on my system. On other systems, variable becomes null and in the text box I get #Name? Cheers LANA