VBA Code for adding a day 14 days after a template is opened in Word 2003
Hi, I have been asked to create a Word template (2003)that is held ona network drive and will be accessed by numerous employees as a .DOC file. The template has three date fields in the text. The three fields need to have a date that is 14 days after the template is opened as a [...]
Answer Question
| September 16, 2010 9:43 PM
VB Code, VBA, VBA macro, Visual Basic, Word 2003, Word document template
Hi, I have been asked to create a Word template (2003)that is held ona network drive and will be accessed by numerous employees as a .DOC file. The template has three date fields in the text. The three fields need to have a date that is 14 days after the template is opened as a [...]
Operating DOS through excel(VB or macro).
Cheers. I m new to IT.I wish 2 operate DOS through excel. For example , in DOS we write some command and then press enter, then dos displays the information concerned with that command. Is this possible to do this, i.e writing command in DOS and pressing enter jst by writing a programme in excel.Plz [...]
Answer Question
| September 30, 2010 3:04 PM
Access multi-table reports, DOS, DOS program, excel, Excel macros, Visual Basic
Cheers. I m new to IT.I wish 2 operate DOS through excel. For example , in DOS we write some command and then press enter, then dos displays the information concerned with that command. Is this possible to do this, i.e writing command in DOS and pressing enter jst by writing a programme in excel.Plz [...]
Software application to build database
I’m Planning to build an application to store/update and retrieve data (say employee details) Could you please suggest me the best frontend and backend technologies to build this application?
Answer Question
| December 14, 2010 6:26 PM
.NET, Access, Database, Database frontend, Java, Visual Basic, Web development, Web development tools
I’m Planning to build an application to store/update and retrieve data (say employee details) Could you please suggest me the best frontend and backend technologies to build this application?
Media Player in Visual Basic 6.0
How to create a Media player in Visual Basic 6.0 ? using Windows Xp.
Answer Question
| September 3, 2010 11:35 AM
Development, VB 6.0, Visual Basic, Visual Basic 6.0, Visual Basic developers
How to create a Media player in Visual Basic 6.0 ? using Windows Xp.
Running a VBScript from a batch file
Hi, I have a VB script that I want ran from a batch file. How do I go about this? See the VBscript below: Dim oFS : Set oFS = CreateObject( "Scripting.FileSystemObject" ) Dim sSrcDir : sSrcDir = "//serverNameFBSurvey" ' Source directory (remote server) Dim sDstDir : sDstDir = "c:SampleDir" & "" ' Destination directory [...]
Answer Question
| April 18, 2013 10:05 AM
Batch files, VB script, Visual Basic, Visual Basic Script
Hi, I have a VB script that I want ran from a batch file. How do I go about this? See the VBscript below: Dim oFS : Set oFS = CreateObject( "Scripting.FileSystemObject" ) Dim sSrcDir : sSrcDir = "//serverNameFBSurvey" ' Source directory (remote server) Dim sDstDir : sDstDir = "c:SampleDir" & "" ' Destination directory [...]
Display Datagridview
Vb.Net code for display content in Datagridview? Eg: “select * from table where name=’sss’ ” Output for this Quary Display in gridview….
Answer Question
| September 1, 2010 2:33 PM
DataGridView, GridView, VB DataGrid, VB.NET, Visual Basic, Visual Basic .NET, Visual Basic .NET Web services
Vb.Net code for display content in Datagridview? Eg: “select * from table where name=’sss’ ” Output for this Quary Display in gridview….
Class call not recognized
I have created a class TMT2PropertiesCollection as a separate file. I have a second class (TMT2Layers) and from within Layers I can make a call to Properties (e.g. properties.xxx and back comes a value). But In In my main form I call TMT2properties.xxx and it comes back empty! I am new to class use — [...]
Answer Question
| August 24, 2010 5:50 PM
VB, Visual Basic, Windows Forms
I have created a class TMT2PropertiesCollection as a separate file. I have a second class (TMT2Layers) and from within Layers I can make a call to Properties (e.g. properties.xxx and back comes a value). But In In my main form I call TMT2properties.xxx and it comes back empty! I am new to class use — [...]
How to inherit parent site permissions when creating subSite using webservice
Using Sharepoint 2007 webservices from a .Net web application I create a subSite (CreateDWS method). I was originally hoping that the parent permissions would be inherited but no such luck. According to the http://msdn.microsoft.com/en-us/library/ms772546(office.12).aspx, I should be able to add a XML tag like: Dim strNewUser As String = “<UserInfo>” & _ “<item Email=’someone@somewhere.com’ [...]
Answer Question
| August 24, 2010 2:04 PM
Active Directory Permissions, SharePoint, Sharepoint Webservices, Visual Basic, Visual Basic .NET, Visual Basic .NET Web services
Using Sharepoint 2007 webservices from a .Net web application I create a subSite (CreateDWS method). I was originally hoping that the parent permissions would be inherited but no such luck. According to the http://msdn.microsoft.com/en-us/library/ms772546(office.12).aspx, I should be able to add a XML tag like: Dim strNewUser As String = “<UserInfo>” & _ “<item Email=’someone@somewhere.com’ [...]
Crystal Report Not Coming on Screen
I am calling one crystal report from VB, it is running well on server. but when I run the same at client side, report comes on a screen for a second and disappered. Output is splash for a sec and return it to calling form. Can you please suggest me the possible reason with solution.
Answer Question
| August 16, 2010 7:06 AM
Crystal Reports, SQL Server 2005, VB 6.0, Visual Basic, Visual Basic 6.0, Windows Server 2003
I am calling one crystal report from VB, it is running well on server. but when I run the same at client side, report comes on a screen for a second and disappered. Output is splash for a sec and return it to calling form. Can you please suggest me the possible reason with solution.
Active Directory reports
Does anyone know of any useful Active Directory reporting tools that could: pull a list of users and there password age, pull a list of users and the OU they are in, or any variation there of to view AD maintanence? This could be a simple batch file or VB script that might output to [...]
Answer Question
| August 31, 2010 3:47 PM
Active Directory, Active Directory Administration, Active Directory interoperability, Active Directory Reporting Tool, Batch file, VB script, Visual Basic
Does anyone know of any useful Active Directory reporting tools that could: pull a list of users and there password age, pull a list of users and the OU they are in, or any variation there of to view AD maintanence? This could be a simple batch file or VB script that might output to [...]
create a login screen in VB.net
I am wanting to create a login screen that will verfiy the login number to either a text file or an excel file. I have no idea what to do.
Answer Question
| August 16, 2010 11:12 AM
excel, VB.NET, VB.NET Express Edition, Visual Basic, Visual Basic developers
I am wanting to create a login screen that will verfiy the login number to either a text file or an excel file. I have no idea what to do.
Using a combobox to control textbox
how do I code this?
Answer Question
| August 20, 2010 7:50 PM
ComboBox, Excel 2003, Microsoft Excel ComboBox, TextBox, VB, Visual Basic
how do I code this?
updating, deleting in access with asp.net using Visual basic
hi, i m using asp.net 2005 usin vb. i m having gridcontrol with the back end of msaccess. i know to retrive the data from databse by using tis code, Dim msaccessconnect, query, databasecommunication, readdatabase msaccessconnect = New OleDbConnection(“Provider=Microsoft.Jet.OLEDB.4.0;data source=” & Server.MapPath(“db1.mdb”)) msaccessconnect.Open() query = “SELECT * FROM `advertiser`” databasecommunication = [...]
Answer Question
| December 15, 2010 5:52 PM
Access 2003, ASP.NET, Visual Basic, Visual Basic .NET
hi, i m using asp.net 2005 usin vb. i m having gridcontrol with the back end of msaccess. i know to retrive the data from databse by using tis code, Dim msaccessconnect, query, databasecommunication, readdatabase msaccessconnect = New OleDbConnection(“Provider=Microsoft.Jet.OLEDB.4.0;data source=” & Server.MapPath(“db1.mdb”)) msaccessconnect.Open() query = “SELECT * FROM `advertiser`” databasecommunication = [...]
What is the procedure for Deployment in VB6.0
Dear Friends, I have developed a small project using Visual Basic 6.0 as front End, MsAccess for database & VB reports for reports on OS Windows XP SP2. It was completed successfully and working on my system but how to transfer or make it work on other system where VB is not available. Please mention the steps [...]
Answer Question
| August 9, 2010 6:00 AM
Access, VB 6, Visual Basic, Visual Basic 6, Windows XP SP2
Dear Friends, I have developed a small project using Visual Basic 6.0 as front End, MsAccess for database & VB reports for reports on OS Windows XP SP2. It was completed successfully and working on my system but how to transfer or make it work on other system where VB is not available. Please mention the steps [...]
VB.NET How to create a picturebox in a container control that is sizeable and the user can drag
Hi, I am quite new to VB.NET and I was wondering if anyone could help me? I have a picturebox control that is within a container control. I have added a trackbar control which I have configured so that when the tracker is moved the picturebox control is shrunk or enlarged. What I would like [...]
Answer Question
| August 2, 2010 9:55 AM
PictureBox, VB.NET, Visual Basic, Visual Basic .NET
Hi, I am quite new to VB.NET and I was wondering if anyone could help me? I have a picturebox control that is within a container control. I have added a trackbar control which I have configured so that when the tracker is moved the picturebox control is shrunk or enlarged. What I would like [...]
Help with code in Visual Studio 2008
strComputer = "." Set objWMIServices = GetObject("winmgmts:root/default") Set wmiSink = WScript.CreateObject("WbemScripting.SWbemSink", "SINK_") Set ObjRegistry = GetObject("winmgmts:{impersonationLevel = impersonate}!\" _ & strComputer & "rootdefault:StdRegProv") objWMIServices.ExecNotificationQueryAsync wmiSink, _ "SELECT * FROM RegistryKeyChangeEvent " _ & "WHERE Hive='HKEY_LOCAL_MACHINE' AND " _ & "KeyPath='Software\Microsoft\Windows\CurrentVersion\Uninstall'" WScript.Echo "Listening for Registry Change Events..." While(True) WScript.Sleep 1000 [...]
Answer Question
| July 28, 2010 2:22 AM
Visual Basic, Visual Studio, Visual Studio 2008, Windows Management Instrumentation, Windows Service Pack Blocker
strComputer = "." Set objWMIServices = GetObject("winmgmts:root/default") Set wmiSink = WScript.CreateObject("WbemScripting.SWbemSink", "SINK_") Set ObjRegistry = GetObject("winmgmts:{impersonationLevel = impersonate}!\" _ & strComputer & "rootdefault:StdRegProv") objWMIServices.ExecNotificationQueryAsync wmiSink, _ "SELECT * FROM RegistryKeyChangeEvent " _ & "WHERE Hive='HKEY_LOCAL_MACHINE' AND " _ & "KeyPath='Software\Microsoft\Windows\CurrentVersion\Uninstall'" WScript.Echo "Listening for Registry Change Events..." While(True) WScript.Sleep 1000 [...]
How do I create a trigger in VB 6?
HOW TO CREATE A TRIGGER IN VB6
Answer Question
| October 1, 2010 3:57 AM
Triggers, VB, VB 6, Visual Basic, Visual Basic 6
HOW TO CREATE A TRIGGER IN VB6
cannot connect vb program with sql server 2005 in local machine
the simple program of fetching the data of table through vb.net program. i am retriving the data into DatagridView . i am writing following String str for connection : Dim str As String = ” Data Source=COMP1SQLEXPRESS ; Initial Catalog=Atuldb; User Id=COMP1comp11;Password= ” my database name is “Atuldb”, I am using SQL SERVER MGT STDIO. [...]
Answer Question
| January 21, 2012 2:34 PM
SQL Server, SQL Server 2005, SQL Server Management Studio 2005, VB.NET 2008, Visual Basic, Visual Basic .NET, Visual Basic 2008
the simple program of fetching the data of table through vb.net program. i am retriving the data into DatagridView . i am writing following String str for connection : Dim str As String = ” Data Source=COMP1SQLEXPRESS ; Initial Catalog=Atuldb; User Id=COMP1comp11;Password= ” my database name is “Atuldb”, I am using SQL SERVER MGT STDIO. [...]
INSERT INTO TABLE1 (SELECT * FROM OTHER DB.TABLE1)
INSERT INTO TABLE1 (SELECT * FROM OTHER DB.TABEL1)
Answer Question
| July 18, 2010 6:23 AM
Data Tables, Visual Basic
INSERT INTO TABLE1 (SELECT * FROM OTHER DB.TABEL1)
I need vba code to update item cost from a word document w/o changing the previous wks item cost in Excel 2004
I have a work book with week 1 – 5 ending inventory worksheets. I need vba code to update item cost from a word document w/o changing the previous wks item cost.
Answer Question
| July 15, 2010 1:52 AM
Excel 2004 Workbooks, Excel VBA, Excel worksheets, Visual Basic
I have a work book with week 1 – 5 ending inventory worksheets. I need vba code to update item cost from a word document w/o changing the previous wks item cost.





