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 besto1a

  1. besto1a

    Export to XL

    Is there a easy way in VS.2005 to export as dataset to MS Excel ?
  2. besto1a

    Copying Rows For New Order Entry Detail

    Auguy, I'm not quite sure what it is you are doing, but if you have orders in a datagrid that is bound to a datset, you can add as manys rows as you like. Once you have added your order you could you a SQLDataAdapter and create the Update and Inserts methodes> SqlDataAdapter1.Update(yourDS...
  3. besto1a

    Retrieve a single value

    Thank My example was a simple one just to illustrate my problem. I need to bring back a count of rows where the name is andrew and assign that value to a integer
  4. besto1a

    Retrieve a single value

    How do i retreive a signle value use a sql statement in VBA I gace tried the following but it dosent work. Dim myString as string myString = db.execute "Select Name from Tbl_Users Where UserID = andrew"
  5. besto1a

    Isolating cells with shading

    Evansey, I think you need to look a little closer to home for the answer to this one, you could be going round the houses when the answer may be on your doorstep. Why are the cells shaded, conditional formatting perhaps? If so, do a Simple if statement using you conditional formating criteria...
  6. besto1a

    Format A string

    I have a some strings some 9 charactors long and some 10 long. I need all my strings to be 12 didgets long, so I need to add "00" to the front of my 10 didget strings and "000" to my 9 didget string Is there any kind of format funtion to do this Thanks
  7. besto1a

    ReportDataSource

    All I have the following code to populate a reportviewer in Windows application, the reports (rdlc) are local to the application. I am unsure what needs to go where I have ?marks. My dataset is called OpsReportingDataSet.xsd and the table within it is called tbl_EWTCases. Dim varStart...
  8. besto1a

    Report Viewer Problem

    Thanks for the reply I forgot to add that the reports are not server based, they are held within the application.
  9. besto1a

    Report Viewer Problem

    I have a problem with the report viewer. I have a form showing a report viewer (RV), When the form loads it shows the report the report viewer is linked to with the data bindings. I want to be able to change the report (rdlc) the RV shows programaticaly but for some reason it does not work, can...
  10. besto1a

    Populate a List Box from recordset

    Does anyone know how to Populate a list box with the contents of a record set that has 5 columns Thanks
  11. besto1a

    How to handle DB Null

    I have this code that check is a value from a dataset is Null but it wont work, can any help If IsDBNull(Me.DsData.tbl_SocTar_ALL_SAP_AND_INFOPAC_COMBINED(count1).Canc_date) = True Then
  12. besto1a

    Error 3146 ODBC call failed

    All I have this code trying to execute a stored procedure on a sql server: myQD.Connect = "ODBC;Description=PLYSQL03;DRIVER=SQL Server;SERVER=PLYSQL09;UID=Blahblah;PWD=BlahBlah;" myQD.SQL = "EXECUTE addUserName '" & UID & "','" & Name & "'" myQD.Execute However when i run this I get error...
  13. besto1a

    IsDbNull?

    I have this code: If IsDBNull(Me.DsTables1.tbl_EWTCases.FindByEWReference(ewRef).AssignedTo) Then But receive a error message stating cannot convert Dbnull to string, how can i covercome this THanks
  14. besto1a

    Count Nulls ?

    I have a basic Query: SELECT CurrentStatus, COUNT(CurrentStatus) AS [Count of Status] FROM dbo.tbl_EWTCases GROUP BY CurrentStatus THis works fine but will not produce a total for anything that is showing as Status null, how do i get this to count nulls ? THanks
  15. besto1a

    Crystall Reports

    I have done this, but no data is populatingf me report?
See more

Part and Inventory Search

Back
Top