Search results

Got it. It worked. I forgot to set the argument to Add in DataMode action argument. All works well.

Hello, I would like to know how to add new records into a table from another table. I have 2 tables A & B. A is the main file and if customers wanted to add new data into table A and if he clicks on add records in table A then table B needs to open. So that they want to add records in Table...

Am doing changes to this now. Thanks for your support

Hello Roku, Thanks for your reply. Am figuring it out now :)

Yes, The Author should be related to Unique Authór ID. It is the only criteria for me. Publication is nothing but the year in which the book is published. If I search for "A" in author column then it should return all the authors whose name contains "A" at the bottom of the form. It means...

Hello Roku, Kindly have a look into your messages. I have sent you a message regarding this.

Intial Phase : MForm : Main form There should be some search boxes at the top of the form. And the main table should be displayed at the bottom of my form. If I search for any of the fields and click on search then then the main table should display the searched results at the bottom of my...

Hello Roku, Thanks for replying for my posts. My Requirement When I DBLclick on any one the searched results at the bottom of my page then it should display in the new page. I had tried by keeping the squery as the subform. The my colleague said that we can't open the result in the new...

Thanks for your valuable reply. Am Novice to MS Access. Could you kindly let me know where to use that code in the main form MForm

Hello, I have created a form and a subform from a table. Initially I created a table with 11 rows. After completion of my project I added an extra of 480 rows to the main table. But the newly added rows are not coming in my subform. Attached is my project. Could you kindly have a look into...

I have a field named Location of type Hyperlink. I have copied the respective filepaths in those location column. The location filed looks like M:\New\1234.pdf M:\New\1111.pdf M:\New\2222pdf M:\New\4444pdf If the user clicks on this link then the respective file should be open I don't want...

Can anyone help me out please

Thanks for your reply. Am Novice to MS Access. Could you kindly elaborate your above post please

Hello, I have created a from which consists of search boxes in the above and the table in the below. If we search for any in those search boxes then the results will be displayed at the bottom (The results will be displayed in the table which is located at the bottom of the page) I had...

I had further 2 more queries which I will be posting it today/tomorrow based on my work. Please don't hesitate for posting queries as am new to MS Access and I have no !dea on this before. Hoping you to reply in those threads too :) Have a Great Day!!

Learned new things from your end today. It worked well and this is what I needed in my output. Thanks a ton. You helped me in many situations :)

I added 2 text boxes Start date and End date in the design view and I am unable to link up those two boxes to the Published column. The main table doesn't contains start date and end date then how can we write a query for those? Could you kindly help me out on this please. I had attchached...

Hello, I have created a 6 search boxes with names Author, Published, Language, Title, Keywords and University. If I enter "A" in Author search field then it should return all the 6 fields which contains "A" in Author field. It worked well. Am happy with it. My Requirement : The column...

You are right!! Worked for me :) Thanks..

Thanks for writing a query for me.... Sorry for checking it once again. I haven't seen anything regarding access in your query. I tried your query by replacing my SQuery but still am able to delete the data from the search results Is your above query will set only Read Only Permissions?