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!

Recent content by bbrendan

  1. bbrendan

    Create multiple Export Files from dataset

    Hi all, Just in need of some help in creating a variable number of export files from a database. The reason is i have a limit of the number of rows that each file can contain. in this case 3000 rows per file. I can create the file ok, but im having trouble dropping 3000 records into each...
  2. bbrendan

    access denied

    that would rely on you having outlook running all the time. since outlook is only a "mail client" if for example you were on holidays, the mail sent from SAP would sit in your mail server until you returned and opened outlook. Which would then action your code.. if you canb code in VB, i would...
  3. bbrendan

    access denied

    Its not very straightforward!. I have been down this road before. Wanting to build a qry and have it run as a background job overnight to extract a report and dump it somewhere. if you look on sdn.sap.com/forums you will see a number of posts in regards to how to set this up. From what i recall...
  4. bbrendan

    SAP SD - transaction MCSI

    Ah..., i see your issue. This type of report to the best of my knowledge cannot have a layout variant saved. One alternative approach is to write an infoset Qry/ SAP Query using this same table Use a ALV grid as the output this will allow you to save a layout variant. We have done this for...
  5. bbrendan

    Sample Code To Read SAP Table From VB

    ok, if you dont have an SAP OSS signon, you cannot get to the SAP connector. there are alternative products on the market. ive used on from these guys. http://rfcconnector.com/ its costs a little but its pretty good and does work with vb2005. It also has some neat tools for creating idocs...
  6. bbrendan

    access denied

    also, what about using SAP Query or Quick Query (SQ01) you could write custom reports (info sets) save them and run as a batch job via SM36 other ideas! cheers
  7. bbrendan

    access denied

    you cannot access SAP tables via odbc. use the SAP .net connector look on SAP for this. Its an addin that allows you to make BAPI calls, ie: query some of the tables like customer master and material master. if you look in SAP run TCode BAPI and you will see all the BAPI's you can run...
  8. bbrendan

    SAP SD - transaction MCSI

    yes there is. Variants by default cannot be saved unless you have the correct settings on your user profile transaction code SU01 enter your user name Goto the parameters tab add the paramter ID SD_VARIANT_MAINTAIN and values : XXXX XXX XX cheers
  9. bbrendan

    Sample Code To Read SAP Table From VB

    ive done vb.net app's that make BAPI calls to SAP. There are some standard BAPI's in SAP to read tables like customer master, material master and sales orders. If you do a search on SAP for .net connector you will find there is a SAP.net connector for VB2003. Note: this is version 2.0 this...
  10. bbrendan

    Microsoft's Retail Management System?

    Hiya, With regards to the crystal reports, you could publish these reports via crystal enterprise web application. Or am i not understanding your problem cheers
  11. bbrendan

    Split File Help

    Hi gmmastros, Ive tried your change to the code but im still only getting the first row of data. Man this is thrustrating me :)
  12. bbrendan

    Split File Help

    Hi All, thanks for you help on this really!. I will try your suggestions out. Regarding the text odbc driver, yes went down that path, but unless your using a common delimter like "," you hit some brick walls thanks again
  13. bbrendan

    Split File Help

    Hiya Thanks for your help, still trying to get my head round this OK, so I have the following code that splits each line the splits inside that that as shown below. But it doesnt loop through each line only the first line. any help would be great Dim strTemp() As String Dim intLine As...
  14. bbrendan

    Split File Help

    Hi all, im just i need of help with splitting a file The file looks like this ------------------------------------------------------------------------------- OrderID|BillFirstname|BillLastname|BillCompany|BillAddress 1143658|Chris|Bell|Strutt & Parker|13 Hill St 1143659|Chris|Bell|Strutt &...
  15. bbrendan

    Bookmark Synch Problem

    hi AMACycle Thanks for your reply but this doesnt help. the property you have stated doiesnt exist!

Part and Inventory Search

Back
Top