14,025 Topics
 | |
| | Hello VB Masters, Firstly, apologize if my question is in the wrong place :) I would like to create a loop that will copy a data from rows in the first sheet to the columns in the second sheet. The data in the Sheet1 looks as follows: A B C …  |
| | Hello. I want to make a simple login page using MVC4, where both users and admins can log in. The users should be allowed to see their own details, edit their details. The administrators should be able to list all the users, show a specific users details, edit those details … |
 | Hi group, I'm attempting to create and write to an Excel spreadsheet with data from a text file. The code is meant to parse each line of the text and place the data into individual variables. I then need to place these variables into the appropriate cells on this newly … |
| | Hi I have data set where I find it easy to sort data by using pivot tables. BUT one essential cell is not a part of each sample ID. I have tried to make a macro to insert this data without luck. So in b column every time an empty … |
| | Am having a little problem with importing data from MS SQL to and Excel sheet. I followed previous answers on daniweb, but they couldn't help me out. Here my code. Private Sub btnExcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExcel.Click Dim appXL As New Microsoft.Office.Interop.Excel.Application Dim shXL As …  |
| | Hello Group, I'm attempting to create and write to an Excel file. I'm sure I've hit the first of many snags. Hopefully you can point me in the right direction. In this first attempt, I'm getting an error code: "Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))". The error is attached … |
| | Dear forum members, i a m trying to export the contents of datagrid to excel but i am facing errors.After searching i have seen that the problems occurs because one of my columns is of type TIME and taht is why i am getting the error : Object reference not … |
| | I'm trying to give access to client computer from my server and also tryin to revoke the granted access... the grant is successful but the revoking is not working please help. hms is the satabase that i want to give access to my clients.. my code try { Connection con …  |
| | Good day! I just want a little help on how to loop from one cell to the end and set a sum Formula. I have Columns From **F to O **and created a Sum formula for column F. Is there a way to make it in a loop and pass …  |
| | Good day! I have the following sub-query that generates payroll report by a given date with format **(dd/MM/yyyy)** but I do not know why MSAccess **automatically changed it to (MM/dd/yyyy)** thus I am getting incorrect data. My regional date settings in **control panel is set to (dd/MM/yyyy)** format as well … |
| | I have high hopes for the Swift programming language, the presentation showed a lot of potentials for this language in apple keynote, just a question do you guys think swift will come to windows in an IDK soon?  |
 | what are the codes to use to filter out my listbox as the user is typing in the textbox? the data in my listbox is from database. I have used a relay command to get all the details of an Event then place the details in an observable collection. Then … |
| | We had a need to factory restore our PC. It is Windows 7 Home Preimum with SP1. We copied all data off ran the factory restore drive, reinstalled Office 2007, restored all data files and now when we open Excel files we cannot format them proerly. The page breaks will … |
| | The idea of this thread is to help the beginning Python programmer with hints and helpful code. Please feel free to contribute! If you have any questions start your own thread! The creators of Python are very active, improving the language all the time. Here is a little of the … |
| | Hi I am currently using pyinstaller 2.1 with python 2.7. I am making modifications to "TI's MSP430 Tools (Python scripts and library)" which allows the update of the MSP430 firmware over USB. Specifically, I have made some modifications to the top-level script and when I run the script it works … |
| | Hello all, I am using Office.Interop.Excel.Application in which i have to save a file using saveas() but before saving it i have to disable the Excel's OverWrite prompt . I did tries Application.DisplayAlerts = false; But it's not working , How to do this??? Pl Help ? |
| | I have an Access 2007 file that I was working on at my office. I left for the day and the database was still open. When I came back the next day the system had shut off so I rebooted (no issues). I tried to open the database and am … |
| | I went to a customers site and copied a MDB file and a MDW file to my stick and brought them here. When I attempt to open the MDB in Access 2007, I receive You do not have the necessary permissions to use the 'c:\desktop\file.mdb' object. Have your system administrator … |
| | I am having an issue with a formula in excel and am not understanding what it is doing =COUNTIF(J28:L31,"w")+COUNTIF(J28:L31,"l") is supposed to give me a result of the number of cells with the value of either w or l in that range But instead of displaying a number, it is … |
| | Good day to all. I have a database in MS access and i need to access it using HTML. Can anyone help me to do this. Thanks.  |
| | hello guys. Just want a little guide here.. because there's no error in program but the data is not inserting to database. Thank you and god speed!. <?php $conn=odbc_connect ('visitor_list','','') or die ("Error cant connect to database"); $sql = "select * from TEMP_LIST"; $rs = odbc_exec($conn,$sql); if (!$rs) { exit("Error … |
| | We have a Windows NT 4.0 Workstation which we forgott the admin password. The admin is the only user assigned to the machine. I want to know, is there any free software out there that will let me reset or change the password of the administrator? or how can I … |
| | Hi, Installed login script. Now get...Access denied for user 'root'@'10.24.3.4' (using password: NO) Can/should I delete the script/reinstall or try another script? Thanks!  |
 | In MS Access I am trying to append data from one table to another table that is identical. However, once I run the append query, I get a message telling me that "..it didn't add 2253 rows due to key violations". How can I identify the 2253 records that are …  |
| | I'm currently have and excel speadsheet that has 3 rows. What I would like to do is create a macro that reads the last populated row, usually will be column A1, and then created a new column listing the current date and time. So for example, I have ColA ColB … |
| | How to export the column data from excel to listbox without using database. plz help  |
 | This is my code <?php session_start(); require_once("facebook-sdk/autoload.php"); require_once("facebook-sdk/src/Facebook/FacebookSession.php"); require_once("facebook-sdk/src/Facebook/FacebookRequest.php"); require_once("facebook-sdk/src/Facebook/FacebookResponse.php"); require_once("facebook-sdk/src/Facebook/FacebookSDKException.php"); require_once("facebook-sdk/src/Facebook/FacebookRequestException.php"); require_once("facebook-sdk/src/Facebook/FacebookRedirectLoginHelper.php"); require_once("facebook-sdk/src/Facebook/FacebookAuthorizationException.php"); require_once("facebook-sdk/src/Facebook/GraphObject.php"); require_once("facebook-sdk/src/Facebook/GraphSessionInfo.php"); require_once("facebook-sdk/src/Facebook/GraphUser.php"); require_once("facebook-sdk/src/Facebook/Entities/AccessToken.php"); require_once("facebook-sdk/src/Facebook/HttpClients/FacebookCurl.php"); require_once("facebook-sdk/src/Facebook/HttpClients/FacebookHttpable.php"); require_once("facebook-sdk/src/Facebook/HttpClients/FacebookCurlHttpClient.php"); use Facebook\FacebookSession; use Facebook\FacebookRequest; use Facebook\FacebookResponse; use Facebook\FacebookSDKException; use Facebook\FacebookRequestException; use Facebook\FacebookRedirectLoginHelper; use Facebook\FacebookAuthorizationException; use Facebook\GraphObject; use Facebook\GraphSessionInfo; use Facebook\GraphUser; use Facebook\HttpClients\FacebookCurl; use Facebook\Entities\AccessToken; use Facebook\HttpClients\FacebookHttpable; use Facebook\HttpClients\FacebookCurlHttpClient; $api_id="452545828240757"; … |
 | My Mac address book syncs itself with my iPhone. Somehow (I think through Microsoft Entourage??) it silently added contacts to the address book for everyone I sent/received an email to/from. I now have thousands of contacts that have an email address only with no phone number, and I don't want … |
| | Hi All, I have created Add-In for Outlook 2007, 2010 and 2013 with VS 2010 (VSTO 4) The requirment is to store the Email addresses (FROM and TO addresses) to one table. I can able to get the TO email addresses in Outlook version 2010 and 2013, but unable to … |
 | The disk C was formatted. By means of R-Studio pulled out from it the ntuser.dat and Outlook.pst files. Through regedit I exported from ntuser.dat all branch [HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows Messaging Subsystem] to the .reg the file. I placed in the virtual disk the received file of the register and base with … |
 | MS Outlook 2007. The user account domain was accidentally deleted, then created again. I received new SID. on a local computer the new local profile was created. on exchange the new box with the same name (to it access is) was created. in exchange there are 2 boxes now. How … |
| | Hello, My computer has been slow and having problems for the last week or so. A message popped up the other day that my son said something about my internet provider found a threat or something weird. He closed out of the internet quickly, so I never saw it, but … Information Security amazon-web-services api apple apple-hardware audio data-protection file-stream google-api microsoft-office microsoft-windows office-suite pdf printer user-interface vbscript video-card virus-malware visual-basic visual-studio web-browser webcam windows-api windows-virus windows-vista wireless-networking  |
| | Group, In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It would solve some problems for me. foldernameGD = CStr(getFolderNameGD("O:\Revenue Management\Centralized Revenue Management Service\CRMS Hotels", propertyNo2 & "*")) In advance, thanks … |
 | Quite a while ago, I made [URL="http://www.daniweb.com/code/snippet217147.html"][B]this[/B][/URL] snippet. This code is basically the same, except that it adds animation. This method of blitting is very fast assuming you don't use a surface that's too large. On a 500 x 500 surface, I managed 350fps using only 0-1% of the cpu. … |
| | Good day! I have a running code but I found it not very fast in terms of saving data. Is there a way to make it more faster? I am using msaccess as databse. Set RsTrandet = New ADODB.Recordset Sql = "SELECT TranDetail.AccountNo,cashflowcode, TranDetail.Narration, TranDetail.TranNature, " & _ "TranDetail.TranAmount, Acctmaster.Accountname … |
| | I am using following C++ code to enter a value of X which is used to print out variable CDF. This C++ code is expected to give very similar value we get from NORMDIST function in excel. However I get following error in debugger with out getting any output in … |
| | I know to save records from database into listview, but how to save listview to database instead.. this is the code for showing record into list view..but can any help me how to change the code to save listview into database? Imports System.Data.OleDb Public Class Form1 Dim con As New … |
| | Hello everyone, I need to pass some parameters from my servlet to my JSP. I am able to access 2 of my parameters from the request object, but one of them is returning null value. Here's my servlet snipet: request.setAttribute("selectedA", aBook); request.setAttribute("selectedB", bBook); request.setAttribute("book_ref", book_ref); logger.info("book_ref = " + book_ref); … |
| | How to view corrupted mpp file of microsoft project ?exported a large (4,000 tasks) mpp to xml and when I attempt to open it with Project I get the error “An unexpected error occurred… The file may be damaged.” I tried exporting it several times but get the same error … |
| | my pc cant open windows 8 after i format my pc and again restore it so wat do u suggest to me |
 | The Electronic Frontier Foundation (EFF) has released the latest version of its 'Who Has Your Back?' [report](https://www.eff.org/who-has-your-back-government-data-requests-2015) and accompanying infographic, and it makes for interesting reading. Once you appreciate that what the EFF is talking about here is how good, measured as a response to a handful of yes or … |
| | Since upgrading to Microsoft Office 2007 I now have trouble reading PowerPoint documents from a particular client. Before I upgraded, I had no troubles reading their PowerPoint. Now, I have missing fonts and graphics - so much so that many pages are blank, or filled only with a few dots … |
| | Why am I asked for user name and password when I try to access an article? |
| | [URL="http://www.pcadvisor.co.uk/poll/index.cfm?action=showresults&pid=3228421"]A new poll into Operating System popularity by a British computer magazine[/URL] has revealed that an incredible 37 percent of respondents are still using Windows XP. That's more than Windows 7 which managed to woo 30 percent of the folk taking part, and Vista could only garner a pretty poor … |
| | Good Afternoon: I would like to have this JSON object written out to a CSV file so that the keys are header fields (for each of the columns) and the values are values that are associated with each header field. Is there a best practice for working with this? Ideally … |
| | hi, I was trying to download whatsapp for my pc and lots of rubbish came down instead. I have got rid of most of it but now every time I start IE searching.com comes up. Click on mu home page icon and ok. Also I've tried to uninstall all that … |
| | I'm not sure if I am on the right forum, but I can't access my web browser, it says I'm on the Internet and strength good, with a message no internet access, I have tried resetting the router but no good . |
| | I want to hide the button in my AppBar from the HubSections i have been using the following codes but it does not work please help i have just started with c# im new to it. Thanks HubPage.xaml <Page.BottomAppBar> <CommandBar x:Name="mybar" ClosedDisplayMode="Minimal" > <CommandBar.SecondaryCommands> <AppBarButton Label="setting" Click="AppBarButton_Click"/> </CommandBar.SecondaryCommands> <AppBarButton x:Uid="CALENDAR" …  |
 | im looking for way to make my game allow players to play with each others via internet i can use some kind of rooms i need help to know what is the recommended engines that can i use for real time multiplayer apps |
| | My problem is this: I am trying to automate the download, parsing, and insertion of an excel file into a database. I have the parser and inserter done, but I can't seem to find a way to download the files automatically. The core of the issue is that the website … |
The End.