3,842 Topics

Member Avatar for
Member Avatar for minuteman263

I have an Excel spreadsheet that contains names. addresses and various other information. I have word wrap set for all cells in case some new data gets entered that's long. If I sort the data, the data that was in the cells that were word wrapped will end up in …

0
200
Member Avatar for jkvt

Hi, I have a VBA script that places WinForm dropdown boxes (xlDropDown) into an excel workbook dynamically. For some reason, on the 17th box (called "INCL" & i + 1 in the code below), the data type of the placed shape becomes msoAutoShape instead of msoFormControl. All of the following …

Member Avatar for Stuugie
0
490
Member Avatar for vishal anand.s

Hi my name is vishal. For the past 1 week i been in the process of creating a dashboard using listview in c# windows forms with sql server 2008. I created listview named lstDashItems and populate it from a table named USERACTIVITIES in sql server 2008. The design of USERACTIVITIES …

Member Avatar for vishal anand.s
0
387
Member Avatar for kannan mangalar

# i get the excel values, but i dont separate the column value, how to i get the columns value. # include 'simplexlsx.class.php'; $xlsx = new SimpleXLSX('bb.xlsx'); list($num_cols, $num_rows) = $xlsx->dimension(2); foreach ($xlsx->rows(2) as $key => $r) { echo $key . "<br>" . $r; }

Member Avatar for kannan mangalar
0
621
Member Avatar for fourty

How can i copy data from a named range in a different worksheet and paste it to another worksheet all done without activating both sheet. With all code just behind a form button If i try to use the statement **application.goto reference:="x"** where x is the named range but this …

Member Avatar for Stuugie
0
6K
Member Avatar for rb1234567

Hi, I need to create a page where an admin can upload an excel worksheet in the .xlsx file format, this is then read and writen onto another php page. I'm new to PHP so I am confused by the code, I can find help on .xls but not accepting …

Member Avatar for patk570
0
298
Member Avatar for mavtcr

Hello friends..please help me I have two identical Tables in my Database (Access) Table 1.Salup , Table 2.Salup1 . All the fields are identical My problem is:- I want to copy/append 1. All the records 2. selected Records agreeing certain criteria(eg."Sex=Male") From Table 1 to Table 2. through VB6 code.I …

Member Avatar for mavtcr
0
206
Member Avatar for neha05
Member Avatar for guyinpv

This may require an expert in MS Excel, I happen to have version 2007. The issue involves how Excel is distorting images when placed in a sheet. Imagine this scenario, and maybe duplicate it on your end: 1) I use the graphic borders feature of MS Word to create a …

Member Avatar for Stuugie
0
1K
Member Avatar for BenWard

I had to map a network drive with specific credentials in my PHP script and it kept falling over because I'd already navigated to the drive in windows explorer. This snippet will unmap a network drive using COM regardless of whether or not there is a drive letter associated with …

0
617
Member Avatar for viian04

Hi. So I have an assignment wherein I have to calculate the highest, lowest and average of the bowling scores that is entered. How do I do it? I am so confused!

Member Avatar for ddanbe
0
129
Member Avatar for YumnaZia

I have tried every possible way of connecting the database to the program, but its just not happening! Help me please :( final static String fileName ="Netlync.mdb"; static{ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="+fileName; con = DriverManager.getConnection(url,"",""); }catch(Exception exx){ exx.printStackTrace(); }} private static Connection con;

Member Avatar for JamesCherrill
0
328
Member Avatar for pathum_1

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace WindowsFormsApplication1 { public partial class Form2 : Form { OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='login.accdb'"); public Form2() { InitializeComponent(); } private void label3_Click(object sender, EventArgs e) { } private void button2_Click(object …

Member Avatar for Ketsuekiame
0
185
Member Avatar for vodkasoda

I'm right at the start of designing a small E:Mail control program for a friend, but would just like to ask some advice on best practice before I dive in at the deep end. I have a Form with 2 ComboBoxes and the data selected decides what to send, what …

Member Avatar for G_Waddell
0
345
Member Avatar for azapovjednik

hello all, I want to make some simple database in access that would track student information, semesters etc... I have created basic tables like: students, professors, subjects.. now I am stuck with the most important part: semesters and subjects... here is the link [Click Here](http://prntscr.com/2jafl6)where you can see database relationship …

Member Avatar for Shahbaz_2
0
350
Member Avatar for happygeek

When it comes to web browsers, my general rule of thumb is that the latest version is usually the most secure and this is certainly the case with Internet Explorer. However, when I started using Internet Explorer 11 on my new Windows 8.1 Pro laptop I soon discovered that latest …

Member Avatar for happygeek
1
712
Member Avatar for kristen72888

I start up my mother in laws computer and she has not start menu no icons nothing. I can acess task manager and commpand prompt. She thinks she has gotten a virus where it has hidden everything as when you click create a new task under file you can see …

Member Avatar for gerbil
0
282
Member Avatar for MARKAND911

Is it possible to implement theme of Microsoft Office in my windows application. I mean when anyone changes theme of Microsoft Office it should also make change the theme of my windows application. If its possible, let me know how to do that?

Member Avatar for Fenrir()
0
284
Member Avatar for subbudaita

I do not see the Application.Resource in app.xaml file in a windows store app.What could be the reason please?

0
177
Member Avatar for 2lethal

Good day, I must be blind .. I am developing my first "Visual Studio" desktop application. My apps are normally always Internet Apps. I have about 20 text boxes, but I want to give the user the ability of pressing Enter, and "defaulting" to the Enter button on the screen. …

Member Avatar for 2lethal
0
207
Member Avatar for micca.jhai

greetings everyone!. I'm making Clinic system for my project. I just want to ask how to get the total quantity of the medicine and display it on textbox. I'm using using vb6 and adodc. Any help will be greatly appreciated.Thank you... Table name inventory fields: Medicinename StockQuantity

Member Avatar for Ferdielux
0
199
Member Avatar for thannu07

hy i m trying to do a smal vb.net project using sql server 2008 in vs2012,and i dont know how to use those database in my project for eg : using select/insert/update/delete queriesfor my controls(textbox,combobox datagrids etc..) please help me with detail how to connect database and use it in …

Member Avatar for Reverend Jim
0
182
Member Avatar for IsaacMessi10

Sheet1 A1: Football A2: Rugby A3: Basketball Sheet2: A1: A2 A2: B4 How can I get a location of a field from String? Is it even possible? *eg. I want to tell the contents of cell A2 in Sheet1 by getting the string value "A2" from cell ''Sheet2'!A1'*

0
141
Member Avatar for WILLIAM_5

Hi everyone, I recently installed Python on Windows. I wanted to develop a gui program using Tkinter. The problem is that when I try to import Tkinter module. It gives me a 'module not found' error. But I thought Tkinter was preintalled within Python's installation. It is even more confusing …

Member Avatar for nichom
1
628
Member Avatar for gbhs

Hi Experts my excel data is copied successfully to the listview. But on importing to database, I get this error. InvalidArgument=Value of '5' is not valid for 'index' ParameterName:Index ================= I have 2 problems ================= Problem 1: What should be the problem when I importing from listview(I think it is …

Member Avatar for ling_tj
0
1K
Member Avatar for deceptikon

In my job I tend to write a lot of Windows services. Due to this I've pared it down to bare essentials so that the code is as simple as possible, but still fully functional for the needs of each service. What this generally means is I *don't* use the …

Member Avatar for deceptikon
4
413
Member Avatar for jeniffer09

Live2Support is pleased to announce its integration with Microsoft Dynamics CRM providing customer service and business a multi channel platform to engage the website visitor proactively. **Features:** * Ability to store chat transcript * Callback requests can be sent to the Microsoft Dynamics CRM * Drive online sales * Enhances …

0
171
Member Avatar for Erika_2

PLEASE HELP - I have forgotten my Windows 8 Password for my new HP Laptop. I can not find a way to bypass. I changed my Microsoft Account password and tried using a new one, yet I continue to receive an error indicating - I do not have access,try again …

Member Avatar for Deep Modi
2
428
Member Avatar for M.Waqas Aslam

Dear All ! I am starting R&D for Microsoft CRM and HRM. I have some basic knowledge about CRM and HRM but I want to know is there any offline version of both ? or we can only use it online. If you have some important links having some information …

Member Avatar for M.Waqas Aslam
0
197
Member Avatar for babbu

I have created an application in c#. Following are my concerns. 1) create setup file which includes the ms access db 2) identify the location where this db will be stored 3) use this location as the data source for the application

Member Avatar for Ketsuekiame
0
225

The End.