Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Import Date Problem
Hello! My table gets it's records from a text transfer. One of the fields is a date that comes into the table in YYMMDD format. The data type of the field is text. The date/time type screws up the date and causes import errors. My question is how can I format the date once it's in the table? Or...- daver676
- Thread
- Replies: 0
- Forum: Microsoft: Access Forms
-
Advanced Filters
Hello, When trying to use an advanced filter, the filter does not display all the records that match the criteria, it only displays the first one it finds. What could the problem be? Any advice would be helpful.... Thanks Dave- daver676
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
search db using textbox input
Hey Guys, Thanks for the great advice. In the end, I just used an advanced filter. I couldn't use an auto filter because this process needs to run in a macro. All the user has to do is type in a part # in an input box, then the program returns all information about that part from a huge list in...- daver676
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
search db using textbox input
I want to create a Userform in VBA to take in a value though user input, into a text box, then when the user clicks a CMd button on the form, it needs to be able to search a column on a worksheet, then return any matching value to a separate worksheet in the same workbook. I know how to create...- daver676
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
