Excel VBA Count # of Cells within Max and Min in a Table
How do you write a VBA macro that count the numbers cell within a selected table that falls between a maximum and minimum number?
Answer Question
| November 25, 2010 3:24 AM
COUNTIF statement, Excel VB code, Excel VBA, Visual Basic
How do you write a VBA macro that count the numbers cell within a selected table that falls between a maximum and minimum number?
Answer Question
| November 25, 2010 3:24 AM
COUNTIF statement, Excel VB code, Excel VBA, Visual Basic
Visual Basic code for txt file help
When using a text file for inputing information, how can you write code to read identifier and go back to a previous place in the text file?
Answer Question
| November 10, 2010 7:05 PM
VB Code, Visual Basic, Visual Basic developers
When using a text file for inputing information, how can you write code to read identifier and go back to a previous place in the text file?
Answer Question
| November 10, 2010 7:05 PM
VB Code, Visual Basic, Visual Basic developers
Visual studio 2010 problem
Visual Basic 2010 problem:- “http://picasaweb.google.com/lh/photo/-m76cANEU-vKRWNMKzjo_Q?feat=directlink” Why comes like this?
Answer Question
| November 4, 2010 12:25 PM
Visual Basic, Visual Basic Error Messages, Visual Studio, Visual Studio 2010
Visual Basic 2010 problem:- “http://picasaweb.google.com/lh/photo/-m76cANEU-vKRWNMKzjo_Q?feat=directlink” Why comes like this?
Answer Question
| November 4, 2010 12:25 PM
Visual Basic, Visual Basic Error Messages, Visual Studio, Visual Studio 2010
Application in Visual Basic 6.0 to create path to removable disks
I am building an application where I want to put my data in a removable drive and my exe somewhere in any of the fixed drives. I can’t be sure about the path to my removable drive because the letter assigned to it can change due to many reasons, like, another removable drive was inserted [...]
Answer Question
| October 25, 2010 10:42 AM
Removable data storage, Removable storage, VB6.0, Visual Basic, Visual Basic 6.0
I am building an application where I want to put my data in a removable drive and my exe somewhere in any of the fixed drives. I can’t be sure about the path to my removable drive because the letter assigned to it can change due to many reasons, like, another removable drive was inserted [...]
Answer Question
| October 25, 2010 10:42 AM
Removable data storage, Removable storage, VB6.0, Visual Basic, Visual Basic 6.0
Dir() Function doesn’t find .pdf files in Access 2003
I’ve used the Dir() function with VBA several times for different file formats, but for some reason it’s not working on .pdf files. Am I missing something?
Answer Question
| January 28, 2011 10:40 PM
Access 2003, Dir() function, PDF, VBA, VBA editor, Visual Basic
I’ve used the Dir() function with VBA several times for different file formats, but for some reason it’s not working on .pdf files. Am I missing something?
Answer Question
| January 28, 2011 10:40 PM
Access 2003, Dir() function, PDF, VBA, VBA editor, Visual Basic
Report field properties
I have a memo field that can have well beyond 255 characters. When I create the report and change the “cangrow” property to yes, it still seems to cut off the field at 255 characters. That didn’t happen in 2003 version. Has some changed with this property?
Answer Question
| October 21, 2010 12:22 PM
VB, Visual Basic
I have a memo field that can have well beyond 255 characters. When I create the report and change the “cangrow” property to yes, it still seems to cut off the field at 255 characters. That didn’t happen in 2003 version. Has some changed with this property?
Answer Question
| October 21, 2010 12:22 PM
VB, Visual Basic
VBA Access forms and 1 table
I have an application where a start form, launches a second one and then according to text input/selection more form open (as a 3rd level form). I want all the answers to be recorded in one table as a singe record, but instead I get 3 different records, with responses from each form. What do [...]
Answer Question
| October 18, 2010 5:44 PM
Access 2007, Microsoft Access subforms, VBA Access 2007, Visual Basic, Windows XP SP3
I have an application where a start form, launches a second one and then according to text input/selection more form open (as a 3rd level form). I want all the answers to be recorded in one table as a singe record, but instead I get 3 different records, with responses from each form. What do [...]
Answer Question
| October 18, 2010 5:44 PM
Access 2007, Microsoft Access subforms, VBA Access 2007, Visual Basic, Windows XP SP3
Printing File Dump Path in Visual basic
How do i write a macro for a PDF print file to be printed to a folder path?
Answer Question
| October 13, 2010 5:33 AM
FIle path, Print PDF, VBA, Visual Basic, Visual Basic printing
How do i write a macro for a PDF print file to be printed to a folder path?
Answer Question
| October 13, 2010 5:33 AM
FIle path, Print PDF, VBA, Visual Basic, Visual Basic printing
How to develop a VB application for any computer?
I am very new to this and want to know if I develop a database application using Visual Basic 2005, can my application be loaded onto any computer and used or will the user have to have VB 2005 or some particular database software installed on their computer to use it?
Answer Question
| June 3, 2011 7:12 PM
VB, VB 2005, Visual Basic, Visual Basic 2005, Visual Basic developers
I am very new to this and want to know if I develop a database application using Visual Basic 2005, can my application be loaded onto any computer and used or will the user have to have VB 2005 or some particular database software installed on their computer to use it?
Answer Question
| June 3, 2011 7:12 PM
VB, VB 2005, Visual Basic, Visual Basic 2005, Visual Basic developers
VBScript to file compare
Is there a way to make a VBScript that will get a word from FileA.txt and look for it in FileB.txt. If the word(not the whole line) is found in FileB.txt, then write it in FileC.txt. ?
Answer Question
| April 18, 2011 3:38 PM
VB, VBScript, Visual Basic, Visual Basic Script
Is there a way to make a VBScript that will get a word from FileA.txt and look for it in FileB.txt. If the word(not the whole line) is found in FileB.txt, then write it in FileC.txt. ?
Answer Question
| April 18, 2011 3:38 PM
VB, VBScript, Visual Basic, Visual Basic Script
Access 2003 – command button to show query in pivot format
I have a form with a comman button. I want the user to be brought to a query when they press the button. The query is built in a pivot table format, but when accessed by the command button, it appears as a datatable instead. What am I doing wrong?
Answer Question
| September 28, 2010 2:54 PM
Access 2003, Access query, Data Tables, Pivot tables, VB Code, Visual Basic
I have a form with a comman button. I want the user to be brought to a query when they press the button. The query is built in a pivot table format, but when accessed by the command button, it appears as a datatable instead. What am I doing wrong?
Answer Question
| September 28, 2010 2:54 PM
Access 2003, Access query, Data Tables, Pivot tables, VB Code, Visual Basic
VB with wamp server
Sir pls give the proceedure to connect visual basic basic 6.0 and wamp server and the source code related to this matter at this email-id= arifch2009@gmail.com your response will be great pleasure
Answer Question
| September 22, 2010 9:09 AM
VB, Visual Basic, Visual Basic 6, Visual Basic 6.0, WAMP Stack
Sir pls give the proceedure to connect visual basic basic 6.0 and wamp server and the source code related to this matter at this email-id= arifch2009@gmail.com your response will be great pleasure
Answer Question
| September 22, 2010 9:09 AM
VB, Visual Basic, Visual Basic 6, Visual Basic 6.0, WAMP Stack
DSO file wrong pagecount
Hi, (1st post so be gentle ) I am using dsofile.dll to get pagecount from word documents, all i need at this point is pagecount and only word documents at this time. for some documents the pagecount returns as 0 (or invalid in general maybe?) and therefore i’m in need of a solution or a [...]
Answer Question
| September 22, 2010 11:30 PM
ASP, dsofile, VB script, Visual Basic, Visual Basic Script
Hi, (1st post so be gentle ) I am using dsofile.dll to get pagecount from word documents, all i need at this point is pagecount and only word documents at this time. for some documents the pagecount returns as 0 (or invalid in general maybe?) and therefore i’m in need of a solution or a [...]
Answer Question
| September 22, 2010 11:30 PM
ASP, dsofile, VB script, Visual Basic, Visual Basic Script
Visual Basic Email Script
I have an Access Database with multiple groups. I would like to send emails containting reports to the individuals corresponding to particular groups. How can I do that?
Answer Question
| September 21, 2010 11:13 AM
Access 2007, Access 2007 functions, Access Database, Access database permissions, Visual Basic, Visual Basic Script
I have an Access Database with multiple groups. I would like to send emails containting reports to the individuals corresponding to particular groups. How can I do that?
Answer Question
| September 21, 2010 11:13 AM
Access 2007, Access 2007 functions, Access Database, Access database permissions, Visual Basic, Visual Basic Script
Avoid duplicate entry in database through Visual Basic 2005
I have made a program in VB 2005 with SQL2005 as back end. In the data base there are three fields which are unique id of a person. I want to display “Already Exist” message box when i enter an already existing id. matching all three fields and not allow duplicate entry.
Answer Question
| September 20, 2010 10:29 PM
Software Management, SQL 2005, SQL Server 2005, VB 2005, Visual Basic, Visual Basic 2005
I have made a program in VB 2005 with SQL2005 as back end. In the data base there are three fields which are unique id of a person. I want to display “Already Exist” message box when i enter an already existing id. matching all three fields and not allow duplicate entry.
Answer Question
| September 20, 2010 10:29 PM
Software Management, SQL 2005, SQL Server 2005, VB 2005, Visual Basic, Visual Basic 2005
Excel 2007 macros
In Excel 2007: How to make current time/date (static) populate active cell when command button is clicked?
Answer Question
| October 14, 2010 7:41 PM
Excel 2007, Excel 2007 macros, Excel macros, Office 2007, VBA, Visual Basic
In Excel 2007: How to make current time/date (static) populate active cell when command button is clicked?
Answer Question
| October 14, 2010 7:41 PM
Excel 2007, Excel 2007 macros, Excel macros, Office 2007, VBA, Visual Basic
Word document using VB.net
there is a property of word document Tools->Option->TrackChanges->Changed Line. is it possible to set the ChangedLine property of word document by Vb.net programming.
Answer Question
| August 1, 2011 9:37 AM
Office 2003, VB .NET, VB.NET 2005, Visual Basic, Visual Basic .NET
there is a property of word document Tools->Option->TrackChanges->Changed Line. is it possible to set the ChangedLine property of word document by Vb.net programming.
Answer Question
| August 1, 2011 9:37 AM
Office 2003, VB .NET, VB.NET 2005, Visual Basic, Visual Basic .NET
Building a VB application
I’m about to create a project using VB.net and Microsoft SQL Server. It’s not difficult when i’m running it on 1 single computer. The problem is, this application should be located in 1 server and accessible through the network. Is there something different i have to do, or i only need to add the connection [...]
Answer Question
| September 22, 2010 2:08 AM
Networking in 2010, SQL Server, VB .NET, VB.NET, Visual Basic, Visual Basic .NET
I’m about to create a project using VB.net and Microsoft SQL Server. It’s not difficult when i’m running it on 1 single computer. The problem is, this application should be located in 1 server and accessible through the network. Is there something different i have to do, or i only need to add the connection [...]
Answer Question
| September 22, 2010 2:08 AM
Networking in 2010, SQL Server, VB .NET, VB.NET, Visual Basic, Visual Basic .NET
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 [...]
Answer Question
| September 16, 2010 9:43 PM
VB Code, VBA, VBA macro, Visual Basic, Word 2003, Word document template
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 [...]
Answer Question
| September 30, 2010 3:04 PM
Access multi-table reports, DOS, DOS program, excel, Excel macros, Visual Basic
