Range of one cell backcolor in excell 2003
Dear Sir Madame I am doing a function in Excel 2003 that takes three cells as range data-type. the function all it does is to see if two of the cells equal to the third one. if yes I want to color the background as green Can anyone reply to my request? Thanks in advance [...]
Answer Question
| February 19, 2008 5:02 PM
Microsoft Excel, VBA
Dear Sir Madame I am doing a function in Excel 2003 that takes three cells as range data-type. the function all it does is to see if two of the cells equal to the third one. if yes I want to color the background as green Can anyone reply to my request? Thanks in advance [...]
Answer Question
| February 19, 2008 5:02 PM
Microsoft Excel, VBA
Visual Basic IF statement…
I am trying to write an IF statement that will show a message box if the postcode of the customer begins with one of about 20 area codes. I can get it working for one code, but as soon as I add ‘ Or “HS*” ‘ (minus the apostrophes) it comes up with Type Mismatch. [...]
Answer Question
| February 5, 2008 9:20 AM
Database, VBA
I am trying to write an IF statement that will show a message box if the postcode of the customer begins with one of about 20 area codes. I can get it working for one code, but as soon as I add ‘ Or “HS*” ‘ (minus the apostrophes) it comes up with Type Mismatch. [...]
Answer Question
| February 5, 2008 9:20 AM
Database, VBA
Automate download from ALV grid to excel using VBA
I have recently started extracting data into Access using RFC_READ_TABLE. I now need to know how to get results from a standard report via an ALV grid into excel / access. I am using VBA. Thanks
Answer Question
| January 22, 2008 8:22 AM
ALV, Excel 2007, VBA
I have recently started extracting data into Access using RFC_READ_TABLE. I now need to know how to get results from a standard report via an ALV grid into excel / access. I am using VBA. Thanks
Answer Question
| January 22, 2008 8:22 AM
ALV, Excel 2007, VBA
Header in Word Document using VBA
How to have different stlye within the same header,i.e. if a header consists of 3 rows the 1st header is bold and the second 2 are not. This way a single page should have a header consisting of 3 lines and each line has different format
Answer Question
| December 31, 2007 5:31 AM
Microsoft Word, VBA, Visual Basic
How to have different stlye within the same header,i.e. if a header consists of 3 rows the 1st header is bold and the second 2 are not. This way a single page should have a header consisting of 3 lines and each line has different format
Answer Question
| December 31, 2007 5:31 AM
Microsoft Word, VBA, Visual Basic
Accountant
What software proficiency, would enhance my career. There are so many MS Certificates.
Answer Question
| October 26, 2007 3:00 PM
Application development, SQL, VBA
What software proficiency, would enhance my career. There are so many MS Certificates.
Answer Question
| October 26, 2007 3:00 PM
Application development, SQL, VBA
dynamic visual basic form based on access database table
I am useing an access database table to populate some lists. I want to dynamicly add picture boxes that I use to seperate the list box as if lined based on how many records I have in the database. Basicly, I just need to know how to add a control by code. I don’t want [...]
Answer Question
| October 19, 2006 12:39 PM
Access, Database, DB2, Development, Oracle, VBA, Visual Basic
I am useing an access database table to populate some lists. I want to dynamicly add picture boxes that I use to seperate the list box as if lined based on how many records I have in the database. Basicly, I just need to know how to add a control by code. I don’t want [...]
Answer Question
| October 19, 2006 12:39 PM
Access, Database, DB2, Development, Oracle, VBA, Visual Basic
how to send sms through GSM modem in VB 6?
hello alll, I am working on a school management s/w. Plz if anybody knows anything about sending sms through GSM modem in vb 6, then reply me. thank you all.
Answer Question
| December 12, 2005 7:58 AM
Development, VBA
hello alll, I am working on a school management s/w. Plz if anybody knows anything about sending sms through GSM modem in vb 6, then reply me. thank you all.
Answer Question
| December 12, 2005 7:58 AM
Development, VBA
Memory (helpfield) usage in Microsoft Access with VBA
Microsoft Access software is running on the desktop of every user, but the database is installed centrally on a server. More users can start and run on the same database simultaneously. In VBA I have various helpfields defined. What I want to know is: if more users are in the same part of the VBA [...]
Answer Question
| November 17, 2005 7:59 AM
Access, Database, DB2, Oracle, VBA
Microsoft Access software is running on the desktop of every user, but the database is installed centrally on a server. More users can start and run on the same database simultaneously. In VBA I have various helpfields defined. What I want to know is: if more users are in the same part of the VBA [...]
Answer Question
| November 17, 2005 7:59 AM
Access, Database, DB2, Oracle, VBA
Coping and Renaming multiple files using VB6 Code
Hi Everyone I would like to know how can we copy multiple files from one location to another location, and having the files automatically renamed. I want to copy Images from C:Original to C:Main but i would like VB to automatically rename the files. Naming must start from 000001 to the last image for example [...]
Answer Question
| November 18, 2005 8:08 AM
VB.NET, VBA, VBScript, Visual Basic
Hi Everyone I would like to know how can we copy multiple files from one location to another location, and having the files automatically renamed. I want to copy Images from C:Original to C:Main but i would like VB to automatically rename the files. Naming must start from 000001 to the last image for example [...]
Answer Question
| November 18, 2005 8:08 AM
VB.NET, VBA, VBScript, Visual Basic
MS Access to SQL Server Image
I have a Sql Server 2000 database. We don’t have Web resources available, so I must write a User Interface in MS Access 2003. What I want to do is have the user supply a path and name for a document. Then I want to load the document into the Image field of the SQL [...]
Answer Question
| November 14, 2005 10:45 AM
T-SQL, VBA
I have a Sql Server 2000 database. We don’t have Web resources available, so I must write a User Interface in MS Access 2003. What I want to do is have the user supply a path and name for a document. Then I want to load the document into the Image field of the SQL [...]
Answer Question
| November 14, 2005 10:45 AM
T-SQL, VBA
Cannot get the current year using vbDate or vbLongDate
I have tried to get the current year (2005), with the following statements: helpfield = DatePart(“yyyy”, vbLongDate) helpfield = DatePart(“yyyy”, vbDate) The first statement gives me the year 1899; in debugging I can see that vbLongDate = 1. The second statement gives me the year 1900; in debugging I can see that vbDate = 7. [...]
Answer Question
| November 10, 2005 3:30 AM
VBA
I have tried to get the current year (2005), with the following statements: helpfield = DatePart(“yyyy”, vbLongDate) helpfield = DatePart(“yyyy”, vbDate) The first statement gives me the year 1899; in debugging I can see that vbLongDate = 1. The second statement gives me the year 1900; in debugging I can see that vbDate = 7. [...]
Answer Question
| November 10, 2005 3:30 AM
VBA
VB Error
when i try to make my project as .exe format, i get a message that says there is no BINARY COMPATIBILITY FILE SET. i tried to enable that option from the project properties but it was disabled for the users to change it. thanks for your time…
Answer Question
| October 25, 2005 9:20 PM
Development, VB.NET, VBA, Visual Basic
when i try to make my project as .exe format, i get a message that says there is no BINARY COMPATIBILITY FILE SET. i tried to enable that option from the project properties but it was disabled for the users to change it. thanks for your time…
Answer Question
| October 25, 2005 9:20 PM
Development, VB.NET, VBA, Visual Basic
Visual Studio.Net 2003
I have a user who when she tries to run a project, recieves the following: “Error while trying to run project:Unable to start debugging. No such interface supported” Similar message appears when selcting Tools, Debug Processes. Software has been reinstalled, as well .Net Framework 1.1. Any advice is greatly appreciated.
Answer Question
| March 19, 2006 10:06 AM
ASP, ASP.NET, VB.NET, VBA, VBScript, Visual Basic
I have a user who when she tries to run a project, recieves the following: “Error while trying to run project:Unable to start debugging. No such interface supported” Similar message appears when selcting Tools, Debug Processes. Software has been reinstalled, as well .Net Framework 1.1. Any advice is greatly appreciated.
Answer Question
| March 19, 2006 10:06 AM
ASP, ASP.NET, VB.NET, VBA, VBScript, Visual Basic
Windows or Web App for Data Update?
I need to create an app that will give the user a list of items that they can then check off to denote that they are copleted. I would prefer a scrollable grid where they can make multiple selections. I would prefer to create a Windows app, but don’t know which control to use. Can [...]
Answer Question
| September 23, 2005 4:36 PM
ASP, ASP.NET, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, OS, Programming Languages, Security, Servers, SQL, SQL Server, VB.NET, VBA, VBScript, Visual Basic, Web development tools, Web site design & management
I need to create an app that will give the user a list of items that they can then check off to denote that they are copleted. I would prefer a scrollable grid where they can make multiple selections. I would prefer to create a Windows app, but don’t know which control to use. Can [...]
Answer Question
| September 23, 2005 4:36 PM
ASP, ASP.NET, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, OS, Programming Languages, Security, Servers, SQL, SQL Server, VB.NET, VBA, VBScript, Visual Basic, Web development tools, Web site design & management
tutorials
hi all. i wanted to ask if anyone knows any sites where i can download free ebooks or free tutorials. thx.
Answer Question
| September 10, 2010 3:39 PM
ABAP, ActiveX, ADA, AppleScript, ASP, ASP.NET, BASIC, Billing and customer care, Billing Support Systems, C, CGI, COBOL, ColdFusion, Computer Associates, Delphi, Development, Distribution/logistics applications, Enterprise Desktop, Forth, Fortran, HTML, J#, J2EE, Java, JavaScript, JSP, Linux, Lotus Domino, LotusScript, Microsoft Windows, MySQL, Networking, Oracle, Pascal, Perl, PHP, Platform Issues, PowerBuilder, Programming Languages, Python, REXX, RPG, Ruby, Smalltalk, Software Quality Assurance, Software testing, SQL, T-SQL, Tcl-Tkl, VB.NET, VBA, VBScript, Visual Basic, XML
hi all. i wanted to ask if anyone knows any sites where i can download free ebooks or free tutorials. thx.
Answer Question
| September 10, 2010 3:39 PM
ABAP, ActiveX, ADA, AppleScript, ASP, ASP.NET, BASIC, Billing and customer care, Billing Support Systems, C, CGI, COBOL, ColdFusion, Computer Associates, Delphi, Development, Distribution/logistics applications, Enterprise Desktop, Forth, Fortran, HTML, J#, J2EE, Java, JavaScript, JSP, Linux, Lotus Domino, LotusScript, Microsoft Windows, MySQL, Networking, Oracle, Pascal, Perl, PHP, Platform Issues, PowerBuilder, Programming Languages, Python, REXX, RPG, Ruby, Smalltalk, Software Quality Assurance, Software testing, SQL, T-SQL, Tcl-Tkl, VB.NET, VBA, VBScript, Visual Basic, XML
Library management system
i need a free library management system running on window or linux that can keep track of who has what cd/books any one help plse
Answer Question
| August 20, 2005 5:39 AM
3Com, ABAP, Access, Active Directory, ActiveX, ADA, ASP, ASP.NET, Availability, Avaya, Bandwidth, BASIC, Benchmarking, Bind, C, Cabling, CGI, Cisco, COBOL, ColdFusion, Computer Associates, DataCenter, Dell, Desktops, Development, DHCP, Distribution/logistics applications, DNS, Enterasys, Enterprise Desktop, Ethernet, Fault isolation, FDDI, Foundry, Frame Relay, General Directories, H.323, Hardware, HEAT, Help Desk, Hewlett-Packard, Hubs, IPv4, IPv6, Juniper Networks, LDAP, Lifecycle development, Lotus Domino, Lucent, Management, Microsoft Office, Microsoft Operations Manager, Microsoft Windows, MPLS, NetBIOS, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NFS, Nortel, Novell IPX/SPX, Novell NDS, Oracle, OS, Patch management, Performance management, PHP, Ping, Programming Languages, Protocol analysis, Remote management, Routers, SAP, Security, Servers, SIP, Software Quality Assurance, SQL Server, Switches, Systems management software, T-SQL, TCP, Tech support, Updates from SearchSQLServer.com staff, Updates from SearchWindowsSecurity.com staff, VB.NET, VBA, VBScript, Visual Basic, Windows, WINS, XML
i need a free library management system running on window or linux that can keep track of who has what cd/books any one help plse
Answer Question
| August 20, 2005 5:39 AM
3Com, ABAP, Access, Active Directory, ActiveX, ADA, ASP, ASP.NET, Availability, Avaya, Bandwidth, BASIC, Benchmarking, Bind, C, Cabling, CGI, Cisco, COBOL, ColdFusion, Computer Associates, DataCenter, Dell, Desktops, Development, DHCP, Distribution/logistics applications, DNS, Enterasys, Enterprise Desktop, Ethernet, Fault isolation, FDDI, Foundry, Frame Relay, General Directories, H.323, Hardware, HEAT, Help Desk, Hewlett-Packard, Hubs, IPv4, IPv6, Juniper Networks, LDAP, Lifecycle development, Lotus Domino, Lucent, Management, Microsoft Office, Microsoft Operations Manager, Microsoft Windows, MPLS, NetBIOS, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NFS, Nortel, Novell IPX/SPX, Novell NDS, Oracle, OS, Patch management, Performance management, PHP, Ping, Programming Languages, Protocol analysis, Remote management, Routers, SAP, Security, Servers, SIP, Software Quality Assurance, SQL Server, Switches, Systems management software, T-SQL, TCP, Tech support, Updates from SearchSQLServer.com staff, Updates from SearchWindowsSecurity.com staff, VB.NET, VBA, VBScript, Visual Basic, Windows, WINS, XML
Convert Excel file to AS400
I have ‘n’ number of excel files . i need to convert them into AS400 and validate data . My problem is that all these files are in different formats (e.g. Excel 1 has Age, Name ,Salary fields; excel 2 has name , salary , company fields) to validate data I need these excel files [...]
Answer Question
| July 1, 2005 4:38 AM
RPG, Tech support, VBA
I have ‘n’ number of excel files . i need to convert them into AS400 and validate data . My problem is that all these files are in different formats (e.g. Excel 1 has Age, Name ,Salary fields; excel 2 has name , salary , company fields) to validate data I need these excel files [...]
Answer Question
| July 1, 2005 4:38 AM
RPG, Tech support, VBA
MS Access payment book
Hello, This is my first time using this board, so bear with me if I am not using it correctly. I am trying to create a report that will print out 3 payment coupons per page. I have created a basic query that gives me the borrowers payment info (The amount owed) The problem that [...]
Answer Question
| May 27, 2005 11:29 PM
Development, VBA
Hello, This is my first time using this board, so bear with me if I am not using it correctly. I am trying to create a report that will print out 3 payment coupons per page. I have created a basic query that gives me the borrowers payment info (The amount owed) The problem that [...]
Answer Question
| May 27, 2005 11:29 PM
Development, VBA
Help with VBA Code for retrieving data from a table in an MS Access Database
Hi, I’m new around here. I’m a student in the programming field. I have a question for those of you with experience with VBA, VB, or SQL coding languages. Basicly what I’m looking to do with my database is have it fill in the remaining related fields in a form when the Primary key field [...]
Answer Question
| March 30, 2005 12:59 AM
Database, DB2, Oracle, SQL, VBA, Visual Basic
Hi, I’m new around here. I’m a student in the programming field. I have a question for those of you with experience with VBA, VB, or SQL coding languages. Basicly what I’m looking to do with my database is have it fill in the remaining related fields in a form when the Primary key field [...]
Answer Question
| March 30, 2005 12:59 AM
Database, DB2, Oracle, SQL, VBA, Visual Basic
SQL generated by 4GLs vs. Oracle stored procedures
We are attempting to adopt programming standards which would mandate the use of stored procedures in our Oracle 8i and 9i databases for data access. Application developers prefer to take advantage of the SQL generation capabilities of IBM’s WenSphere and Compuware’s Uniface. DBAs feel the security, performance, maintainability, visibility and sharability of procedures stored in [...]
Answer Question
| January 30, 2005 10:24 AM
COBOL, Information risk management, Oracle, SQL, VBA
We are attempting to adopt programming standards which would mandate the use of stored procedures in our Oracle 8i and 9i databases for data access. Application developers prefer to take advantage of the SQL generation capabilities of IBM’s WenSphere and Compuware’s Uniface. DBAs feel the security, performance, maintainability, visibility and sharability of procedures stored in [...]
Answer Question
| January 30, 2005 10:24 AM
COBOL, Information risk management, Oracle, SQL, VBA
