I have two forms. One form is where user enters the search criteria and then on the second form he sees the search results where he has the ability to update, delete the records.
My question the table has 18 columns and it is not possible to fit all those columns on the report. I am looking for a solution where after the results of the query has been viewed in the bottom of the form the user could select the columns on the results...
microsoftsucks
Last Activity: Jan 20 '12, 04:49 PM
Joined: Jan 13 '12
Location:
-
Thanks guys for your help.Last edited by NeoPa; Jan 13 '12, 05:27 AM. Reason: Removed follow-on question - Ask in separate thread if you need an answer. -
GOt it. I used the Docmd.openform code and then specify the conditions thanks.Leave a comment:
-
Thank you for your reply. I am able to get it work but there is another problem. I am doing something wrong for sure.
I have 2 forms. Form 1 and Form 2. Form 1 takes all the parameters from the user and when user click on the search button it goes to vb code where it does all the data work. The query runs fine.
On Form 2 i changed the property to continous form and placed two textboxes to show first two columns. I created...Leave a comment:
-
How do I Filter in a Form Rather than Search for One Record
I have a table with 18 columns. The client wants to search on all the 18 columns with any sort of combination ranging from 1 col search to all 18 columns. I have written a query using the OR condition that would search all the 18 columns and its working fine. The coding is done using recordset and the values are returned back to the form.
The problem is when I have more than 2 records satisfying the same condition when I want to return...
No activity results to display
Leave a comment: