14,025 Topics
 | |
| | hi there, i have an application that opens an excel file and get the values to the mdf file in visual studio database file. the code for opening the file is below [CODE] Microsoft.Office.Interop.Excel.ApplicationClass tt = new Microsoft.Office.Interop.Excel.ApplicationClass(); String path = a; tt.Workbooks.Open(path, 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, … |
| | Hi, I want to change the numeric value in a cell to a string with 1000 Separator(,), e.g. numeric 1000 will to string "1,000" and 123456789 will change to string "123,456,789". How to do that in VBA? Thanks  |
| | Access 2010 Compact & Repair drops indexes in descending order. The database is ~700MB and the table affected has 190 columns, 228,000 records and 13 indexes and runs on Windows 7 with 4GB of memory. The same file compacts without incident using Office 2007 on a Window XP machine with … |
| | I want to automatically increase 15 minute interval to the cells once I enter in one cell in the Microsoft Excel (.xls)file. For Example: In cell D11 I enter manually 3:00(i.e format h:mm), then automatically data should come to other cells i.e(E11, F11, G11, H11, I11, J11, K11, L11, M11, … |
 | Hi all! I need to intercept GDI function to save painted screen to hard drive. I have tried Microsoft Detours. Everything is good, but I need 64-bit version (Detours Professional do support but it costs much). Is there any 64-bit alternatives to Detours Professional? |
| | hey does anyone here knows how to change excel page orientation to portrait? i get landscape as default <?php header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=transactions.xls"); header("Pragma: no-cache"); header("Expires: 0"); ?> |
| | I'm creating a program where the user can search items in an access database and results are displayed in a listview. When I click search all items are displayed but when I enter an item in the textbox then search nothing is displayed. This is my code Private Sub cmdProdSearch_Click() …  |
| | hi am getting the following error when I try open my application. everything was ok and nothing has been installed. it just stopped working one day. Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /ssi/login/profile.asp, line … |
| | hi, i want to disable menu bar button(left-top) in office 2007 word document opened in windows form. please provide sample code. ASAP Thanks in advace... |
| | I want to insert a "words file" into "ms access" which has a column with data type "attachement". Can anyone suggest me what the sql statement look like? |
| | Hi All, I am tasked to generate report templates in excel and I am new to excel, VBA and still learning. A little more information on my task, the information for the report will be extracted from different sheets in the workbook which contains a whole list of calculation and …  |
| | Hey there, I have invisible internet windows and audio ads going on in the background of my task manager in the processes tab, I did do some of my own virus scans and did remove some viruses by I still have it, can I get some help here please. Malwarebytes … |
| | I see this sort of thing regularly. In the forum page a topic will be bumped up by a poster [name appearing to right]... you go to the post or topic and the bumper's post is just not there. An example, same in FF n Opera: http://www.daniweb.com/hardware-and-software/microsoft-windows/windows-nt-2000-xp/threads/28182/password-recovery-on-windows-xp-home-sp2#post1835562  |
 | The latest from Microsoft research: a new language based on O'Calm, called F#. Read about it and download the compiler and documentation to try it for yourself. Make your colleagues scratch their heads wondering what the heck you're writing in :cheesy: [url]http://research.microsoft.com/projects/ilx/fsharp.aspx[/url] |
| | Hi, This is a problem googled easily, but no solution helped me. Locally I am trying to open a PowerPoint application to read and import a ppt (or pptx) file. this is the command where exception is thrown (ASP.NET VB): [CODE] objApplication = New Microsoft.Office.Interop.PowerPoint.Application [/CODE] the exception text is … |
 | Dear Daniweb members. I am having quite a troublesome time here with OleDb. What I am trying to achieve is to allow my users to connect to an uploaded Excel workbook, then to be able to select data from the sheets. I have a query designer in the front end … |
| | I am trying to create a "simple" c# windows application for adding data from textboxes to a MS Access database on the local machine. I am new to C# and have not found a good tutorial on how to do this. I have viewed multiple sites and this is my … |
 | Acronis responds to DaniWeb questions regarding a leak of customer data which, [as we exclusively reported over the weekend](http://www.daniweb.com/hardware-and-software/microsoft-windows/viruses-spyware-and-other-nasties/news/427455/breaking-acronis-blames-technical-issue-for-customer-data-leak), resulted in some information being indexed by search engines and accessible to anyone on the Internet.  Although the leak itself was identified by Acronis on Friday 29th June, the … |
| | From this [article](http://www.daniweb.com/web-development/asp/threads/42314/exporting-asp-pages-to-excel) i found this code snippet that imports html data to excel: <% Response.ContentType = "application/vnd.ms-excel" Response.AddHeader "Content-Disposition", "filename=excelfile.xls" %> <table> <tr> <td>Category Name</td> <td>Category Description</td> </tr> <tr> <td>Software</td> <td>Holds data for software</td> </tr> <tr> <td>Hardware</td> <td>Hardware related data</td> </tr> </table> However, what i want to do is …  |
 | Why virus only attacks to windows operating systems and not to Unix operating systems?  |
 | My laptop has only 257MB RAM, so it does works soo slowly, it always hangs, I heard that windows users can increase RAM space with pendrive... I know it works windows 7 but does it work in XP ?? and Does hardrive memory also slow down your computer ?  |
| | **I am facing some problem in updating ms access with parameters. I succeeded to insert the data in access with parameters. My code for inserting the data is:** Dim dbPath As String = "C:\Users\Abhishek\Documents\ToolDatabase.mdb" Dim connStr As String ="Provider=Microsoft.Jet.OLEDB.4.0;" _ & "Data Source=" & dbPath & ";Jet OLEDB:Database Password=agupt80;" Using …  |
| | HI. I have a situation where we need to pull data from multiple data sources into one dataset. Once we have the data in one dataset we would like to somehow manage to execute some sort of [complex] select query on the data in order to generate a new DataTable … |
| | First of all, I realise there are a fair few related questions on many other sites, in addition to Microsoft Support pages. I have spent many hours on this issue, and this is where I stand and what I know/have been able to achieve: * I have an application written … |
| | First I am new to C#. I attempting to build a simple windows form where you can send textbox info to an access database on the machine. When viewing online tutorials and book, I notice their is a step, form missing from my Visual Studio 2010 program when I try … |
| | I am doing a project in Visual C# and trying to insert data into MS Access database but whenever I press the insert button in the C# Windows From a message box appears and its written "Microsoft Access Database Engine". I have installed Microsoft Access Database engine but still the … |
| | Is it possible to alter Excel Viewer print settings via VB.NET and, if so, what is the syntax I need to do this? I would like my application to be able to change the printing preferences of an Excel spreadsheet opened in Excel Viewer (through the application via `Process.Start()`). This … |
| | I've been having this problem for a while now. Basically what happens is at random times my computer will lock up for about 2 seconds and then just turn itself off. If I try to turn it back on it will start up for about 3 seconds and then just … |
| | Hello, I am trying to read values from an excel spreadsheet but just for specific cells at a time; say Cell A1 and B1. Then I want to save the respective values into a variable and use the variable through out the rest of the code. Then loop at the … |
| | Hi all, Can someone please help me. I'm writing a VB5 app that connects to an Access 97 database using a data access control with the following parameters: Connect = "Access" DefaultType = 2 'UseODBC Exclusive = 0 'False Options = 0 ReadOnly = 0 'False RecordsetType = 1 'Dynaset …  |
| | Following on from the news earlier this month that [LinkedIn had suffered a major security breach](http://www.daniweb.com/internet-marketing/social-media-and-web-communities/news/425019/linkedin-confirms-six-million-password-hack-check-if-yours-is-one-of-them) involving the compromise of at least six million user passwords, and then dating site [eHarmony apparently falling victim to the same password hacking compromise](http://www.daniweb.com/hardware-and-software/microsoft-windows/viruses-spyware-and-other-nasties/news/425118/dating-disaster-eharmony-confirms-passwords-exposed-by-linkedin-hacker), the latest to be hit would appear to be the …  |
| | hi, i have created a solution project in Visual Studio. The solution project contains an ASP.net application project and several class library projects. now one of my class library is accessible by other projects by adding class library dll in it. now i want to hide my one of class …  |
| | Hello people, First of all, i'm not an experienced ASP coder at all, i usually do php/java so i'm still kinda puzzled by this language. For my current project, i need to update a piece of an intranet, written completely in ASP. since it can't be reached from my position, … |
| | ok, I have what I hope is an easy problem to fix. i'm try to query a db, store to a temp table, and then query the same db, inner joined with first query. please help. I'm currently getting "access cant find table/query" error. I've tried putting quotes around tmp, …  |
| | Hi there, I'm another one of those people who's stuck with Access: Local Only on an HP notebook with Vista. I don't have access to an ethernet cable connection, so wireless is my only hope. My Macbook gets connection fine; that's what I'm using right now. I tried following the … |
 | Hello, Is it possible to disable the windows key when the application is running?? Suppose I am running a particular application....and if the user press the windows key or clicked on the windows key on the task bar it shud prompt a message box that user is not allowed to … |
| | Hello, I am newish to wxPython and I am attmpting to make a text editor Everytime it attempts the open file code it gets this error: IOError: [Errno 22] invalid mode ('r') or filename: u'' WHY!!! here is the code... import wx import os wildcard = "Text file (*.txt)|*.txt;|"\ "All …  |
| | Using Nero 8 Ultra Edition ... Everytime I DVD burn, with 5 seconds left during a dvd I get the below error message .... the program worked fine for about 6 burns ... I downloaded and installed "vcredist_x86 runtime" from ms ... also asked for / received / downloaded a …  |
| | I'm struggling to think of a reason why I should be getting an 'Access denied' error when trying to save an Excel document opened through a program written in VB 2010 Express. The program is essentially glorified Excel automation. It converts information from hundreds of Excel documents into a few …  |
| | Well, as you might know, when you are attempting to run a script from poweshell and have not used: Get-ExecutionPolicy You will get File C:\scripts\test.ps1 cannot be loaded because the execution of scripts is disabled on this system. Please see "get- help about_signing" for more details. At line:1 char:19 + … |
| | okay. Here's my problem. I have a form in which a Microsoft Hierarchical Flex Gid (fgdCompany) is used to display records taken from a database to relavent textboxes on the same form. When a record from fgdCompany is clicked, then the data in that record is shown on the textboxes. … |
| | Dear,programer I use VB2008 and database access and Crystal report. my problem : when ever I change location the database. I will always change location in my report from crystal report. It's very difficults and waste the time because I have many report. Please help me how to set up … |
 | Hi Guys.. I recently discovered that I am having issues with Windows Installer. I searched the web and tried a couple different things and finally found a thread on this site. I went through the steps and will post the results below. Also, when I open up Services, Windows Installer … |
| | I need Delphi 2011 XE code for editing an Excel file. If there is found a text in a row of column A of the Excel file, to change the number of the same row in column B. That's all I need. Thanks! |
| | Recently we have all become somewhat over-exposed to the leaking of customer data courtesy of inadequate security allowing hackers to gain access to databases. The [LinkedIn LeakedOut leak](http://www.daniweb.com/internet-marketing/social-media-and-communities/news/425019/linkedin-confirms-six-million-password-hack-check-if-yours-is-one-of-them) and [eHarmony dating data disaster](http://www.daniweb.com/hardware-and-software/microsoft-windows/viruses-spyware-and-other-nasties/news/425118/dating-disaster-eharmony-confirms-passwords-exposed-by-linkedin-hacker#post1817377) are good examples of the genre. However, let's not forget that sometimes no hackers are required to … |
| | hi every one, i have a problem. i have a belkin wireless modem. the wireless works but the local area connection (cable) connection is enabled but no internet. ive tryed nearly all trouble shooting but no good. i have had enternet connection through the cable twice. but it some how …  |
| | Howdy, I'm trying to write a program that will copy files from one destination to another. After some reasearch it was suggested that I use SHFileOperation, and SHFILEOPSTRUCT. I'm trying to set the struct members accordance with [MSDN](http://msdn.microsoft.com/en-us/library/bb759795%28v=vs.85%29.aspx), however, I run into a problem with pTo and pFrom. The error …  |
 | I currently have a client who came to me asking me how to build a system for him where he can give varying levels of discounts to events based on the number of people who get referred via a unique affiliate link/cookie. The key stumbling block for this project isn't … |
| | I'm trying to compile the following program (file named test.cpp): #include "stdafx.h" int main(int argc, char* argv[]){ INPUT *buffer = new INPUT[1]; //allocate a buffer buffer->type = INPUT_MOUSE; buffer->mi.dx = 100; buffer->mi.dy = 100; buffer->mi.mouseData = XBUTTON1; buffer->mi.dwFlags = MOUSEEVENTF_LEFTDOWN; buffer->mi.time = 0; buffer->mi.dwExtraInfo = 0; SendInput(1,buffer,sizeof(INPUT)); delete (buffer); //clean … |
| | General rules is that: 1) A private method cannot be overridden. 2) Subclass method should be a lower access modifier than a overridden superclass method. But the output of the program is "I am Son". Why? Is it because of the rule 2 the output comes? If that's the case …  |
The End.