629 Topics
 | |
| | good day.. i have a slight problem in my enrolment sytem. im new in vb programming, and this problem perfectly work in stressing out and pressuring me as begginer. i have a listbox that contains all filtered data from my database. and i want it (all entry in the filtered … |
| | i have an office with 6 computer & laptops fully wi fi connected but i always face trouble of either connection cut or mainly slow network pl .help  |
| | I am trying to apply conditiona formating to shade every other row with a different colour. I am applying the following formula =MOD(ROW();2)=1 and nothing happens, if I use a coma instead of a semi colon I get an error. Can somebody help me. Thank you.  |
 | Hie everyone I have the below code on my console to import data from an excel sheet to a mySql database but unfortunately I am having an error which reads: NO CONNECTION TRYING TO RECONNECT.... ERROR 2005 (HY000): UNKNOWN MYSQL SERVER HOST '(ID,NAME):' (11001) ERROR: Can't connect to the server … |
| | Dear All, I'm working on application in C# which needs to filter "blanks" in one column and copy some value from other column instead. Filtering works perfectly, but copying is not so cool.. It copies some lines, but rest left blank. I cant find out where is problem. If possible … |
 | Hello, I am trying to write a macro for Excel 2003 that will allow me to search for two words in Sheet1, copy all the data below those words, and then paste that data in Sheet2. That part I can get to work. My problem is that I have multiple … |
 | I already have a php file that catches data from an uploaded CSV file to MySQL but the problem is, every time I upload the csv file, it duplicates the data into the MySQL What i really want is, if I uploaded the first csv file, and edit some data …  |
 | Hi, I was wondering how I might get data from a personal application form (name, address, phone, etc..) sent to me in an email into excel without having to retype or cut and paste. I am open to any idea, I have upcoming membership drive/update and would love to automate … |
| | I receive an error message when i install an Office Software or open an Office program or document. |
 | Good Day all, My question is When I get the schema of an EXCEL worksheet with Column headers I get what's expected the names of the columns but when I get the schema of a worksheet without headers I get the first row of data as the Column Names. The … |
| | dear friends, icreated small project to open excel using vb. everything works fine with one exception. i used VB express 2010 in xp OS when developing the project. when it runs on the windows 7 platform the opening excel file goes behind the my application. the VB form topmost function … |
 | when i click my any microsoft office's product then it start geetting installing. it is installed from 4-5 years and was wroking fine. it happened 10 days before. now i cant open my word, excel or any other file. when i try to unsitall it , it says "this product …  |
 | I've got these two tables on two different worksheets. A1: ID B1: Name C1: Locality D1: ID_2 E1: Status A1: ID B1: Name C1: Locality D1: Status Basically I need to match the two tables via "Name". If the names are similar I want to fill in "ID_2" with "ID" … |
| | Hi, Some one pls help me to read datas from mysql table and update only single field in my table. I have mysql table and already inserted datas. But now i want to update only date field , since i need to place the all other data as it is. … |
| | Hi, Can someone help me. I need to create a VBA project in excel using combo box. For example, I have in column A, combo box of ITEMSA and in column B, combo box of ITEMSB. If I choose items from ITEMSA, just the corresponding items that will match will … |
| | Hey everyone, I am trying to create an excel spreadsheet that is populated with data from a table in sql server. I would like to make it so it will update several times a day with out the user having to do so. I have no clue how to go …  |
| | A simple timer for Excel VBA Excel VBA does not have a timer control. The alternative is to use the Timer() Function, and that leaves much to be desired. This code should be placed in a code module. My need was to tend to an abandoned program that was waiting …  |
| | I've written a script to alter images in a number of Excel workbooks. In order to properly access the image information, I need to iterate through all Sheet.Shapes on a particular worksheet. I'm having trouble with grouped worksheets. **How do I ungroup worksheets from VB.NET?** I've tried both activating and … |
| | So I must build an app that has to do with mail address management and more. Let's say the user has an excel file with 2 millions of rows (email addresses). I made it the oledb way and the first mistake I made was putting ~500k rows in a datagridview, … |
 | Hello, I am using VBA userform in MS Excel to insert data for database purpose. When I tested it for the first time, it was running okay. But after I saved it and used it again to insert the real data, it happens to repeat/duplicate the data to multiple times …  |
| | Hi, This is going to be the least important post you will read, but if anyone can help me, I will still appreciate it. Every fall I have a small weekly football contest with my friends for fun. I have an html file with 20 games on it, players choose … |
 | Good day folks, I've been wondering how can I open an excel file in vb.net. Can somebody help me? I always get this error below: > The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) Thanks in advance |
| | Hello, I am working on a web form project in Visual Studio 2012 and MS SQL Server 2008 R2 using Visual Basic. I would like to place an Excel file template in my project folder which would then be modified using the ASP.NET controls on the page and prompt the … |
 | My company is using a simple spreadsheet to write down things from control surveys. Then the data is beeing saved in a big and useless program. Since the data is beeing saved to a database, I want to view this same spreadsheet in a ASP.NET page, with the textboxes filled … |
| | Is it possible to create a delimited file and structure the delimited file in some way so that opening that file in Excel creates an Excel file with multiple worksheets with data on each worksheet?  |
 | hi, I am working on an asp application using c# and i can import excel file to sql table i have two columns in excel and as well as in sql of same name "id" and "status" when i import data both columns are imported to sql table in the … |
 | Situation: My VBA program compiles, but fails at runtime when I try to access a specific method. It doesn't seem to matter whether I set the method up as a function or a property get. Here is the code fragment which calls the method: ****** Function roots() As Variant ' …  |
| | Good day pals. please i need a VBA code that could make ms excel automaticly tell the maximum point of a curve in a chart. Secondly, another code that would make it automaticly tell the Y-value of the point of interception i.e when two series or range of values are … |
 | I'm trying to generate a random number for each field in column "A" of my spreadsheet, and I have been trying to experiment with the following formula: =LARGE(ROW($1:$1000)*NOT(COUNTIF($A$1:A4, ROW($1:$1000))), RANDBETWEEN(1,1000-ROW(A4))) This is giving me the numerical values that I want, but is affecting both Columns "B" and "C" as well. … |
| | Hi Guys... looking for a quick answer on excel Formula.. Anyone know why my text "Please Chase" is not showing up? =IF(ISNUMBER(F2),$F2>TODAY(),"Please Chase") |
The End.