3,842 Topics

Member Avatar for
Member Avatar for Romil797

I have a website for a painter where the painter uploads a picture. The picture name is added to a mdb (access) database table, the picture is added to the end of a table called galleries, and the file is uploaded. It is also then resized to a small image. …

Member Avatar for Romil797
0
221
Member Avatar for happygeek

It's not often that Microsoft recommends that Windows users should disable a much hyped part of the OS, but that's exactly what has happened regarding the Windows Sidebar and Windows Gadgets found in Windows Vista and Windows 7. [Microsoft Security Advisory 2719662](http://technet.microsoft.com/en-us/security/advisory/2719662) clearly states "Disabling the Windows Sidebar and Gadgets …

Member Avatar for chiccosilva
1
613
Member Avatar for AnkitGuru

Hi Guys!! I am creating an addin in Excel using VB.Net. I want to access the current worksheet using a ribbon designer. I have tried all sorts but to no avail. Also all the resources that I have checked are providing solutions by adding or opening new workbook. What I …

Member Avatar for G_Waddell
0
1K
Member Avatar for jackparsana

Hello, I m new in asp. I need to run asp website with access database. Pls help me to do this.. i got problm with connection string i think. Broswer reply : ------------------------------------ Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a …

Member Avatar for jhai_salvador
0
164
Member Avatar for mrabrar09

Hi to everyone. I have created jsp report in that date column is there where am showing the date format like this (02-01-2012) <% String Rcheckdate=""; SimpleDateFormat df = new SimpleDateFormat("dd-MM-yyyy"); Rcheckdate=df.format(rs.getDate("tr_dt")); %> <td align='center'><%=Rcheckdate%></td> In report i have given the excel button from there am exporting the data to …

Member Avatar for mrabrar09
0
311
Member Avatar for Trebron

Hi I hope someone can shed some light on the problem I am having at the momment with an Excel 2010 Sheet, the workbook has 13 sheets with formulas and I rotate the 2 values using vba there are other things going on like a link to SQL server that …

Member Avatar for AndreRet
0
265
Member Avatar for ashvyas

Am having this piece of COde, but whenever am trying to execute this , Dim tsf As TestSetFactory - > error user not defined appears. pls help Dim tdc As TDConnection Sub UpdateStats() 'create QC connection QCconnect_silent "URL", "DOMAIN", "PROJECT", "USERNAME", "PASSWORD" 'process tests getMetrics 'disconnect QCdisconnect End Sub Private …

0
195
Member Avatar for judithSampathwa

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, …

Member Avatar for Cameronsmith63
0
379
Member Avatar for amitash

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

Member Avatar for QVeen72
0
423
Member Avatar for gkendall

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 …

0
155
Member Avatar for ecinevenice

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"); ?>

Member Avatar for blocblue
0
178
Member Avatar for katie1988

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() …

Member Avatar for Bile
0
1K
Member Avatar for sujitpatil444

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...

-1
215
Member Avatar for heels

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 …

Member Avatar for AndreRet
0
89
Member Avatar for Top_Hat

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 …

Member Avatar for Philomena
0
332
Member Avatar for xzajox

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 …

Member Avatar for kemaltaskin
0
2K
Member Avatar for crazyvonzipper

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 …

0
187
Member Avatar for iwanttolearnc

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 …

Member Avatar for jasonsarino
0
356
Member Avatar for bikashjit

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 ?

Member Avatar for tigerbright
0
535
Member Avatar for Eruditio

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 …

0
189
Member Avatar for Eruditio

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 …

Member Avatar for Eruditio
0
1K
Member Avatar for aekaette

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 …

Member Avatar for belenos46
0
702
Member Avatar for GregDen

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 …

Member Avatar for TnTinMN
0
327
Member Avatar for nice_candy

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 …

Member Avatar for pritaeas
0
175
Member Avatar for JerrodYoung

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, …

Member Avatar for hericles
0
315
Member Avatar for jescapism

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 …

Member Avatar for JorgeM
0
616
Member Avatar for poojavb

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 …

Member Avatar for TnTinMN
0
2K
Member Avatar for sam.tubb.10

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 …

Member Avatar for TrustyTony
0
225
Member Avatar for Eruditio

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 …

Member Avatar for Reverend Jim
0
1K
Member Avatar for HTMLperson5

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 + …

Member Avatar for khansen46
0
4K

The End.