3,842 Topics
 | |
| | How do I add a Macro to an Excel Sheet using Late Binding? I had the code working using Excel(2010) PIA: [CODE] //create a new VBA control module oModule = oWorkbook.VBProject.VBComponents.Add(VBIDE.vbext_ComponentType.vbext_ct_StdModule); //Add the VBA macro to the new code module oModule.CodeModule.AddFromString(sCode) //sCode is the VBA macro I created;[/CODE] I now … |
| | Hi there, In a form i have a datagrid with two columns. The columns are about 40 pixels wide and i can't find a way to have them larger when the program loads. Does anyone know a way to do this? Greets, K |
| | I'm using VBA to query and modify an Excel database. The database contains information about servers and their locations. Most of the rack mount servers have the location column as something like "G-05". Those are easy. When it comes to the blade servers, the locations are listed as "G-05E2S09" or …  |
 | Microsoft [URL="http://www.zdnet.co.uk/blogs/davey-winder-10015443/microsoft-staying-silent-over-security-patching-10015776/"]recently admitted[/URL], via the Director of it's Security Response Centre, that it doesn't report every Windows security vulnerability discovered and subsequently fixed via patches and updates. No big deal you might think, as long as the holes get fixed that's all that matter. I happen to agree, however that …  |
| | hello goodday. my name is babafemi ibitolu fro nnigeria. i am a desktop/web programmer and i have been programming for up to a year now and i have found the industry to be challenging and in return rewarding. something has been bothering me for like 2 months. i and a …  |
| | Hello, everyone, My question deals with Excel, and not Access, but I understand they should be roughly the same. I have an Excel worksheet which contains several tables. The tables are actually named ranges; basically, I grabbed an area, gave it a name, and -voila!- it is a table. Until … |
| | Okay, so I've been searching the internet for hours trying to find the solution to my problem. Many came close, but didn't describe exactly what I want to do. I have an excel file that displays the names, locations and other information about certain servers for work. I want to … |
| | Hi Experts, I have a windows service running every minute and has many database operations to perform. It runs perfectly for many days, sometimes it suddenly stops and throws this exception. Later when we start to debug it, the exceptions goes off, but if we don't debug, the exception continues … |
| | Ive been given a friends laptop to look at and suspect it has a virus on it as it is incredibly slow and some applications dont load, google chrome wont launch, windows live mail launches but when you try to send an email the program crashes.. and the laptop itself …  |
| | I have a spreadsheet for each month of 2010 (Jan-Dec) that is used to track church members donations by month. Under each month I have the last name, first name and weekly donation with the monthly donation total at the end of the row. I would like to output on …  |
| | Hey daniweb forums, Okay so my question is, what is the difference between VC++ (visual C++) and C++ with any other IDE (or none at all). I know for a fact that VC++ is an IDE but according to some people that I have met. They say, stay away from … |
| | good evening everyone.. im a student and currently taking my thesis...im having a problem with creating a excel file with vb... the thing is I need to open the excel file inside the form in vb.net... Anyone please need help... |
 | I just read an article called: [URL="http://www.infoworld.com/d/windows/life-after-windows-what-happens-tech-if-microsoft-dies-551?source=footer"]Life after Windows: What happens to tech if Microsoft dies?[/URL]" The article made me think of what it really would be like without Microsoft. I didn't like it. We need Microsoft over there competing with us. No matter what happens to the economy, to … |
| | HI guys, I have finish my project in vb.net and publish it without errors. The problem is this: As my project finished installing in the pc, an error occurred saying that the path where should be my DB Access is not there. Although I manage this problem by manually copy … |
| | Hey Windows fans, would you like to take Linux for a spin to see what everyone's buzzing about? It's easy to do in just five easy steps. You can test Linux for yourself without having to setup multibooting, worry about partitioning or installing over your current Windows system. That's right, … |
| | I have a small company Database that tracks our repair orders. I have a query that I would like to execute based on criteria that the user inputs. I am new to VBA so most of my code is based on google research. I took a technique of wrapping my … |
 | I am quite stumped on something in C. I found this code on the Internet, and it only gives me one error; however, I cannot seem to fix it. The variable in the function the compiler's complaining about is: [CODE]char ConvertTime[8][/CODE] and the function itself is a windows one: [CODE]GetWindowTextW(GETITEM(IDC_CONVERT_TIME), … |
| | [B]SELECT staff.StaffNo, semester.SemesterID, teach.SubjectID, teach.Sub2, teach.Sub3, teach.Sub4, teach.Sub5, teach.Sub6, teach.TeachLoad, (IIf(IsNull( teach.SubjectID),0,1) + IIf(IsNull(teach.Sub2),0,1) + IIf(IsNull(teach.Sub3),0,1) + IIf(IsNull(teach.Sub4),0,1) + IIf(IsNull(teach.Sub5),0,1) + IIf(IsNull(teach.Sub6),0,1)) * 3 As teach.TeachLoad, FROM (subject INNER JOIN (staff INNER JOIN teach ON staff.StaffNo = teach.StaffNo) ON subject.SubjectID = teach.SubjectID) INNER JOIN semester ON staff.StaffNo = semester.Staff[/B] i …  |
| | How to make or set this as autonumber in msaccess-vb database? from 00-00-00 up to 9999-9999-9999 how to make that code to become autonumber? and what code can i use in my database when the new entry is equal to existing ?(The same primary key) |
| | I am writing a video program, everything works fine except I am often (ie most times, but not [I]every [/I]time) getting the following error: Unhandled exception at 0x6076fde0 (msvcr90d.dll) in javaw.exe: 0xC0000005: Access violation reading location 0x0a450020. I have tracked it down to this function: [CODE]//fill the buffer from data … |
| | Hi folks, First time user of the forum, desparately needing help with an infection/virus/malware on my PC running XP. My antivirus has started going bonkers popping up with messages similar to "A threat has been detected and has now been fixed. Click here for further details". My AV software is … |
| | Why my code in my VB-access database is not working. my add code is not displaying the inputted data it only displays the gridline in datagridview. I already connect the database access file. What's wrong? Can anybody help me? thankz. |
 | Hi. so i'm using ms access 2007 as a database, i have here a table of TRANSACT IP which has the following columns of Transact_ID, IP_ID, Date, Time, Average, Min, Max. i have to produce a report in which i have to query from this table with the follwing format: … |
| | Hi, I have a question in MS SQ L enter prise edition. I have writtend an application in Visual studio 2008 standard edition and I am connecting to ms sql sever enterprise edition 2008 r2. When I depoy the application I created and install inanother computer some components relating to …  |
| | guys How do you Create Database in MS Access Using Oledb in vb.net? |
| | I'm using ASP to dynamically generate an XML file (for an RSS feed) that pulls information from a SQL DB. Users input the data into the DB using a UI that is a straightforward html form. However, there is a textarea field in that form in which most users seem … |
| | how can I select one or more columns from a table by column-index and NOT by columnname? I got the columnIndices of table by using this query SELECT name, colid FROM sys.syscolumns WHERE (id = (SELECT id FROM sys.sysobjects WHERE (name = 'table_name'))) |
| | Hi there, I am creating reports in SQL server business intelligent studio and when I deploy it to the report server the report is shown in only on a half a page. How can I make the report height and the width for the report thanksssss |
| | Hi, There is something wrong with my code. I can't seem to access the database anymore not can I add new data information. I am suppose to create a registration form with username and password. Then save it to a database on MS Access. Then login using the login form. … |
| | How to make the form size automatic setting the size equals to the screen. or Maximize the whole form including the form components. |
The End.