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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Sw0rdfish149

  1. Sw0rdfish149

    Setting captions for labels on data report...

    Hi guys Im kinda doing the same thing adding text into a label in the report header. I've tried the code Jerrycurl put but I keep getting a subscript out of range error. I know the code works as it works in the page header section but not in the report header section? Im stumped. any ideas...
  2. Sw0rdfish149

    SQL problem

    Hey everyone Thanx for help. I now know what I've been doing wrong, I don't have a field in the database for Manuid Duh! Anyhow after doing some major changes I've decided to set up from scratch something else between two tables: Items table which has Item ID Stockists ID Item Name etc...
  3. Sw0rdfish149

    SQL problem

    Okay... after changing my code to sqlselect = "SELECT 'Stock Invoice Items'.*,'Stock Invoice'.* From 'Stock Invoice Items' Left Join 'Stock Invoice' on 'Stock Invoice'.'Stock Invoice ID' = 'Stock Invoice Items'.'Stock Invoice ID' WHERE 'Stock Invoice Items'.'Stock Invoice ID' = 'Stock...
  4. Sw0rdfish149

    SQL problem

    Hey Mike, Urs is the only one that worked after I tampered around with it. I kept getting syntax errors so had to amalgamate everything into one line. This is what I ended up with: sqlselect = "SELECT 'Stock Invoice Items'.*,'Stock Invoice'.*From 'Stock Invoice Items' Left Join 'Stock...
  5. Sw0rdfish149

    SQL problem

    Hi there, I've inserted an SQL statement that will enable me to pull off data out of two seperate tables and show them on a datareport. The tables are: Stock Invoice Stock Invoice Items This is my statement: manuid = dbcCompanyID.Text sqlselect = "SELECT 'Stock Invoice Items'.*, 'Stock...
  6. Sw0rdfish149

    random questions & problems

    I can't find anything on the validation or the sstab events! Any other pointers? (yeah ive read item 15)
  7. Sw0rdfish149

    random questions & problems

    I've been using VB6 for a while now and I've got some questions to ask: Where does an OLE word document get saved to? cos it ain't in the same folder as the Project, unless its stored in the Visual Basic Form Binary File. On an SSTab, is there any events for clicking on each tab? Is there a...
  8. Sw0rdfish149

    basic printing

    Hi there eveyone, What sort of methods are there apart from Me.PrintForm that I can use to print out a bunch of textboxes and labels and not others? Thanx Sw0rdfish149
  9. Sw0rdfish149

    Exporting data to Word via OLE

    Hi everyone, I've just started to learn about the OLE control and I want to export several bits of data to a Word Document.Anyone know how I would do this? Thanx Sw0rdfish149
  10. Sw0rdfish149

    Linking VB with Word

    Hi there, I'm trying to do the same thing as huBBLe;exporting data to specific fields in a word document. I want to ask, would you still use the OLE with the code that Hackster supplied or would you use the code in something else? ie. a command button Thanx Sw0rdfish149
  11. Sw0rdfish149

    textbox format

    Hi everyone, This may sound stupid but how would I format 2 textboxes in an array of several textboxes to only accept numbers? I want to do this through code as well, in this kind of way: If txtQuantityRemaining(X).Text = "" Then MsgBox "Please Fill in the Quantity...
  12. Sw0rdfish149

    Saving Listbox entries to database

    Hi there everyone, I've got a listbox that has several entries, each with several items in seperated by & vbtab & and I've been trying to figure out to save each listbox entry as a new record in an Access db, with each item in a different field. any answers? Sw0rdfish149
  13. Sw0rdfish149

    ListBox Style Checkbox

    To extend this question a more how would you then remove selected items in a listbox that has the checkbox style? Sw0rdfish149
  14. Sw0rdfish149

    MSFlexGrid problems

    Cheers Zor that helped with most of the problems. But I can't find anything on saving a column of data to an Access Database with each cell in the column in a new field. Any help on this one would be much appreciated. Sw0rdfish149
  15. Sw0rdfish149

    MSFlexGrid problems

    Hi there everyone, I just began playing around with MSFlexGrids and I was wondering how I would add the contents of two cells and show the result in a third cell? Also how would I then save the contents of a MSFlexgrid through a dataenvironment to an Access database? with each column as a...
See more

Part and Inventory Search

Back
Top