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 strongm 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: *

  1. bartdedecker

    File not downloading

    I have uploaded a sta file in de www folder at our Windows 2003 Server, but nobody can download this file. The message "The page cannot be found" appears. I'm sure the path is correct. I replace the sta file by a txt file, and that works. So, it seems to be a security issue... Does somebody has...
  2. bartdedecker

    Pivot charts and Access Runtime

    Hi, I made an Access-application (Access 2003) that uses pivotcharts. Because not everybody has Access, I made a runtime version of my project. But I see that the list view (the list with the fields from the table/query on witch the pivot chart is based) is not available in an Access runtime...
  3. bartdedecker

    Access Runtime

    We can't install Office 2003 because we don't have enough licences for each user. :-)
  4. bartdedecker

    Access Runtime

    Hi, I made an access project in access 2003. Some people in our company works with Office 2000. In my project, there are some important Pivot charts. I see, Pivot features are not available in Office 2000 and we can't install Office 2003 on their computer. May be their exists some thing like an...
  5. bartdedecker

    Modeless Forms

    because I wanna see directly the new added article in the overview list
  6. bartdedecker

    Modeless Forms

    Hi, I made a program "Article administration". In the main window I show a list of my articles. When I double click on an article, you can edit them. It is also possible to add new articles. When you edit or add an article, the list in the main window has to be refreshed after closing the...
  7. bartdedecker

    Importing from Excel file

    There is only one sheet. I renamed the sheet in "test", but it don't work yet.
  8. bartdedecker

    Importing from Excel file

    Hi, I have a strange problem. I wrote an import procedure to import data from an Excel file. It worked already without any problem. Today, I want to do the same import and it doesn't work anymore... :-s this is my code: Dim myDT As New DataTable("Artikels") Dim excelConnection As New...
  9. bartdedecker

    How to use an IFF in the SELECT clause

    Hi, How can I use an IFF in my select clause. I have a column VAT_NUMBER (nvarchar(50)) in my Table. I want an extra column in the result of my query. If the VAT_NUMBER is not null then return 1 otherwise return a 0. (I use SQL Server 2000) SELECT NAME,VAT_NUMBER, ???VAT_NUMBER_YN??? FROM...
  10. bartdedecker

    Fetch data from OleDbDataReader

    Problem solved. I used this code: While myReader.Read value = (myReader("LastId")) End While
  11. bartdedecker

    Fetch data from OleDbDataReader

    I want to receive the last Unique Identifier from a table. I have already this code: Dim myCommand As New OleDbCommand("Select max(Id) as LastId from Translation", OleDbConnection2) OleDbConnection2.Open() Dim myReader As OleDbDataReader =...
  12. bartdedecker

    How to load a form into a panel

    Of course you are! Je bent een Belg ;-)
  13. bartdedecker

    How to load a form into a panel

    Does a User Control has the same possibilities like a form?
  14. bartdedecker

    How to load a form into a panel

    Korach, What do you exactly mean with "Make a user control" Bart
  15. bartdedecker

    How to load a form into a panel

    Hi, How can I load a form into a panel? Bart
  16. bartdedecker

    Import data from Excel and write into SQL Server

    To get te records from the Excel file, you have to use "Select * from [sheet1$]". Thx for your useful tip. But once I have my data in the DataAdapter... Is it possible to write the DataAdapter at once to the SQL server? I have already tried it, but it doesn't work. I use the Update() method. ->...
  17. bartdedecker

    Import data from Excel and write into SQL Server

    Hi, I want to write a tool in VB.NET to import data from an Excel file and write it to a SQL-Server. Does somebody has any experience with this topic? What is the best way to do this? Thx, Bart

Part and Inventory Search

Back
Top