Search results

Cool I from reading alot of these forums I thought you had to make a query instead of build one. That's a funny joke. I appreciate all your help....

Question You said you got rid of the queries. But I was using PartsQuery as a recordsource for Parts_subform to sort the partnumber column in ascending order then the Description column in ascending order. Is there another way to sort these fields everytime? the searchquery I know isn't...

Thats perfect I had the visible property to false I corrected this and everything works perfect I really appreciate all your help this will make my job at work a lot easier. Happy Access World Surfer, Chad:D

I noticed you set the focus of the subform to part number I tried to set the focus to PartID then I changed the column to (1) instead of (2) but now I get an error stating that It cannot setfocus to PartID why would this be this is only a situation because I am working with data that can have...

I am forever grateful I have been working on this all night and was able to come up with something similar to this but I LOVE the updating list box as you type it sure beats typing in something then having to research because that item wasn't spelled the same. Thank you so much and I hope I...

update I am going to paste the code I am currently using if this will help anyone, help me solve this problem to elaborate on the problem I need to modify this code to not only go to the record that matches the VendorID but then also goto or highlight the respective record in the Parts_subform...

problem for an expert I found some code on this forum that works beautiful but I would like to increase it's functionality. What I have is a Vendor form with a Parts datasheet subform within it. I have a search command button that opens a search box and then allows the user to do a full...

Thank you shay. That worked beautifully. I am trying to make a inventory program to make my job easier at work and I appreciate your help tremendously. Thanks again Chad

I am getting all the bugs out of my program thanks to everyone here. Need some more help. I have a form based on table1. when the form opens it automatically goes the the first record ever entered in the form. is there a way to make it go to the first alphabetical record? :) Thank you in...

Can any give me some ideas? I have two forms 'Vendors' and 'Vendor Info' I have a combobox on the Vendors form that when doubleclicked opens the Vendor Info form and finds the vendor information based on the combobox selection. In the Vendor Info form you can add a new vendor. Two...

don't think thats feasible Further Detail: I have a list of 2799 Parts the list contains part numbers, descriptions, vendor part numbers. What I am trying to do is search all three columns at once based on a user entered string of text or numbers. Also this must be a wildcard search "*"...

works great Thank you that works great. I tried putting it under the on click event of my exit button on the form instead of on the form close where it works beautifully. Now I have a problem opening the form alone. I know I can use a statement like If isopen but I am not sure how to...

I want to be able to click a command button on a form and have it display a question box "What item are you looking for?" then when the user enters a string I want it to search every field of the subform that string. Is this possible. The subform is based on a query. Thanks Chad

I have a combobox based on a query placed on a form. I made the doubleclick open a form to add an item to the list. But when the new item is added it doesn't show up in the list until I close the form and reopen it. Any Ideas. I know I have done this before but am having a brain block...

Thank You I figured it out now. It sorts in a first come first serve basis so I had to swap the two fields in the query to produce the correct results. Thank you very much for your time and help.

how in a query when I try to sort two fields it sorts one then sorts the other but when it sorts the second field the first one is no longer sorted.

Please help, I have a subform that displays data from a table that I need to sort in two fields. First I want to sort the data to be displayed by the "current" field then sort by the "name" field next. How would I accomplish this. Is there some vba that I need to write and if so please be as...