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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: ThatNeverWorks
- Order by date
-
Simple String..not simple?
Got it crackt now... You where 100% right.. I changed the "Flag" to "Y" and "N" and it flys. Now I know the why I got all the "Data Mismatch" errors. THX for all your great help.. best regards- ThatNeverWorks
- Post #7
- Forum: Visual Basic (Classic)
-
Simple String..not simple?
THX Mark... The code runs, but will not come up with the Goods. It stops with the first Record of the Table that matches the Part No, ignoring the second criteria of the query. It shows the right Par, but this entry is long booked in to stock and not Outstaending no more. I use the...- ThatNeverWorks
- Post #5
- Forum: Visual Basic (Classic)
-
Simple String..not simple?
I have an Order Table where the "In" field is ether 1= Outstanding or 0=Arrived I like to run a Query on Part Numbers of Parts on order, witch are still outstanding. But all mutations on the SQL syntax give me grief. Any pointers? Regards My String is like this:(not a jocke, lol)...- ThatNeverWorks
- Thread
- Replies: 6
- Forum: Visual Basic (Classic)
-
help to export query results into excel
Hi.. Yes you can do this in VB. All you need is a existing Querie, and the code to export the results to Exel. code is like this: Private Sub Command_Click() Dim strExcelFile As String Dim strWorksheet As String Dim strTable As String Dim objDB As Database 'Change Based on your needs, or...- ThatNeverWorks
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
