Visual Basic question
I made a database and to get around security issues. I made forms that will open when someone opens the database. I want to build a visual basic code to look for the computer name and based off the computer name a form will open. I have the forms made and the table to put [...]
Answer Question
| May 20, 2010 6:45 PM
Access 2007, Visual Basic, Visual Basic developers
I made a database and to get around security issues. I made forms that will open when someone opens the database. I want to build a visual basic code to look for the computer name and based off the computer name a form will open. I have the forms made and the table to put [...]
Answer Question
| May 20, 2010 6:45 PM
Access 2007, Visual Basic, Visual Basic developers
Script to add a Period after a Middle Inital- Then query AD for User ID
I would like to create a script that parses an excel spreadsheet column with user’s full names (I.E. ‘John A Smith’) and inserts a period (.) after the middle inital character. (I.E. ‘John A. Smith’) Once the middle inital period has been inserted, I would like the script to query Active Directory using the User’s full [...]
Answer Question
| May 20, 2010 6:38 PM
Active Directory, Excel 2003, SQL, User account management, VBScript
I would like to create a script that parses an excel spreadsheet column with user’s full names (I.E. ‘John A Smith’) and inserts a period (.) after the middle inital character. (I.E. ‘John A. Smith’) Once the middle inital period has been inserted, I would like the script to query Active Directory using the User’s full [...]
Answer Question
| May 20, 2010 6:38 PM
Active Directory, Excel 2003, SQL, User account management, VBScript
error solving
“Provider=Microsoft.Jet.Oledb.4.0;Data Source=”+path+”;Extended Properties=”Excel 8.0″ “ i write this ^ in source of click event of button i want to convert the data in gridview that were in excel file but i got some error so please help me and take me out of this problem
Answer Question
| May 20, 2010 11:01 AM
Microsoft Excel, Microsoft Excel error messages, Visual Studio 2008
“Provider=Microsoft.Jet.Oledb.4.0;Data Source=”+path+”;Extended Properties=”Excel 8.0″ “ i write this ^ in source of click event of button i want to convert the data in gridview that were in excel file but i got some error so please help me and take me out of this problem
Answer Question
| May 20, 2010 11:01 AM
Microsoft Excel, Microsoft Excel error messages, Visual Studio 2008
Which tool is best in all aspects?
Which tool is best in all aspects – speed, performance, user friendly, to do all activities etc - PL/SQL Developer or SQL Developer or TOAD
Answer Question
| May 20, 2010 6:38 AM
Oracle, PL/SQL Developer, SQL Developer, TOAD
Which tool is best in all aspects – speed, performance, user friendly, to do all activities etc - PL/SQL Developer or SQL Developer or TOAD
Answer Question
| May 20, 2010 6:38 AM
Oracle, PL/SQL Developer, SQL Developer, TOAD
Crystal Enterprise 10 javascript error when trying to export.
When I select the export utton I receive the following error. “doExport is not defined javascrpt:doExport(“exportdlg”) Line 1″ All of our workstations started receiving this error. I suspect it’s a javascript update problem but how do I get around it?
Answer Question
| May 19, 2010 3:34 PM
Crystal Enterprise Server, JavaScript, Javascript error
When I select the export utton I receive the following error. “doExport is not defined javascrpt:doExport(“exportdlg”) Line 1″ All of our workstations started receiving this error. I suspect it’s a javascript update problem but how do I get around it?
Answer Question
| May 19, 2010 3:34 PM
Crystal Enterprise Server, JavaScript, Javascript error
JQuery Function Not Defined?
Hi there, I’m trying to set a php session variable from a radio button. The idea is that a jquery function is called which in turns calls a seperate php file using AJAX which does the work but it just keeps telling me the function is not defined. The function is in the head tags: [...]
Answer Question
| May 27, 2011 3:19 PM
Ajax, JavaScript, jquery, PHP
Hi there, I’m trying to set a php session variable from a radio button. The idea is that a jquery function is called which in turns calls a seperate php file using AJAX which does the work but it just keeps telling me the function is not defined. The function is in the head tags: [...]
Answer Question
| May 27, 2011 3:19 PM
Ajax, JavaScript, jquery, PHP
sql query
I have stored A value in a string , when I try to use the STRING VARIABLE IN SQL QUERY DOESN’T NOT RESPOND??
Answer Question
| September 2, 2011 9:33 AM
SQL queries, SQL Query
I have stored A value in a string , when I try to use the STRING VARIABLE IN SQL QUERY DOESN’T NOT RESPOND??
Answer Question
| September 2, 2011 9:33 AM
SQL queries, SQL Query
Active subsystems
Hi, anyone pls let me know how to find the active subsystem. I found the API QWCLASBS. When I am trying to execute the api, I am getting the error.If you have any sample code to execute ths API, let us know. Pls advice on this.
Answer Question
| May 20, 2010 7:29 AM
API, AS/400, AS/400 API, AS/400 subsystems
Hi, anyone pls let me know how to find the active subsystem. I found the API QWCLASBS. When I am trying to execute the api, I am getting the error.If you have any sample code to execute ths API, let us know. Pls advice on this.
Answer Question
| May 20, 2010 7:29 AM
API, AS/400, AS/400 API, AS/400 subsystems
Would using a table variable from a function be efficient?
We divided our tables from table zone_a, …_b, …_c to zone_z, these tables have the same attributes. We have divided this tables in this way so that any data that is under zone_a would only be on it’s specific table, and the same with the other remaining table. Since per table holds thousands of data [...]
Answer Question
| May 19, 2010 7:16 AM
MSSQL, SQL tables, SQL variables
We divided our tables from table zone_a, …_b, …_c to zone_z, these tables have the same attributes. We have divided this tables in this way so that any data that is under zone_a would only be on it’s specific table, and the same with the other remaining table. Since per table holds thousands of data [...]
Answer Question
| May 19, 2010 7:16 AM
MSSQL, SQL tables, SQL variables
Calculate Business Hours
I found a VBA code that fits the program I’m trying to create but I’m having a difficult time locating the 12-1 lunch break so I can make it straight time. Listed below is the code. Function CalculateDownTime(StartTime As Date, EndTime As Date) As Double Dim Result As Double, EndDay As Date Result = 0 [...]
Answer Question
| May 21, 2010 6:48 AM
Access 2007, Access 2007 alerts, Microsoft Access, VBA
I found a VBA code that fits the program I’m trying to create but I’m having a difficult time locating the 12-1 lunch break so I can make it straight time. Listed below is the code. Function CalculateDownTime(StartTime As Date, EndTime As Date) As Double Dim Result As Double, EndDay As Date Result = 0 [...]
Answer Question
| May 21, 2010 6:48 AM
Access 2007, Access 2007 alerts, Microsoft Access, VBA
xml report
i am having two queries in my report these 2 queries are linked by data link when i am generating xml output 2nd query feils are not coming kindly help me
Answer Question
| May 19, 2010 6:07 AM
XML, XML development, XML Publisher
i am having two queries in my report these 2 queries are linked by data link when i am generating xml output 2nd query feils are not coming kindly help me
Answer Question
| May 19, 2010 6:07 AM
XML, XML development, XML Publisher
xml handling on AS400
I’m trying this for the first time. 1. BizTalk server will send an XML to AS400 2. On AS400 I have to write something which will read this xml and extract the necessary fields passed in it. I’m not sure what is the fastest, easiest way to do this. First of all how xml is [...]
Answer Question
| May 21, 2010 4:57 AM
AS/400, BizTalk, XML
I’m trying this for the first time. 1. BizTalk server will send an XML to AS400 2. On AS400 I have to write something which will read this xml and extract the necessary fields passed in it. I’m not sure what is the fastest, easiest way to do this. First of all how xml is [...]
Answer Question
| May 21, 2010 4:57 AM
AS/400, BizTalk, XML
Dreamweaver Cs4 FTP Question
[em][strong]Hi there. This is pretty strange and I cant figure it out.I was FTP about 10 html documents to my server from my Dreamweaver Cs4. About 8 html documents successfully uploaded to my server but the weird thing is 2 of the html documents will not FTP to my server, and no matter how many [...]
Answer Question
| July 6, 2010 3:35 AM
Dreamweaver, Dreamweaver CS4, FTP, FTP Error Codes, HTML
[em][strong]Hi there. This is pretty strange and I cant figure it out.I was FTP about 10 html documents to my server from my Dreamweaver Cs4. About 8 html documents successfully uploaded to my server but the weird thing is 2 of the html documents will not FTP to my server, and no matter how many [...]
Answer Question
| July 6, 2010 3:35 AM
Dreamweaver, Dreamweaver CS4, FTP, FTP Error Codes, HTML
what is base 2 to base 10?
what is base 2 to base 10?
Answer Question
| May 19, 2010 2:09 AM
Base 10, Base 2, Binary, Binary data, Hard drive space
what is base 2 to base 10?
Answer Question
| May 19, 2010 2:09 AM
Base 10, Base 2, Binary, Binary data, Hard drive space
Website capture and comparison
We have an interesting project in that we would like to be able to capture a web site for off line viewing (I realise there are many apps that can do this) but then we would also like to be able to re-capture the content at a later date and have an automatic process compare [...]
Answer Question
| June 7, 2010 1:44 AM
Content management applications, Offline Backup, Website Testing
We have an interesting project in that we would like to be able to capture a web site for off line viewing (I realise there are many apps that can do this) but then we would also like to be able to re-capture the content at a later date and have an automatic process compare [...]
Answer Question
| June 7, 2010 1:44 AM
Content management applications, Offline Backup, Website Testing
Tfield.DisplayText
How do I show alternate data in DBGrid cewll
Answer Question
| May 19, 2010 11:43 PM
DBGrid, Text field
How do I show alternate data in DBGrid cewll
Answer Question
| May 19, 2010 11:43 PM
DBGrid, Text field
Adding Leading Zeros to a string
I have a field with a mixture of 9 and 8 character strings… I need to make them all 9 characters in length..so how do I add a leading zero to those records with only 8 characters while leaving those records with 9 characters alone?
Answer Question
| May 18, 2010 6:45 PM
Access, String manipulation
I have a field with a mixture of 9 and 8 character strings… I need to make them all 9 characters in length..so how do I add a leading zero to those records with only 8 characters while leaving those records with 9 characters alone?
Answer Question
| May 18, 2010 6:45 PM
Access, String manipulation
MySQL brain teaser
This has been driving me crazy. I’m trying to come up with an UPDATE query in MySQL that will remove the second blank space in a name and close the gap. Example: O Brien, John E should become OBrien, John E A simple REPLACE (name, ‘ ‘,’’) where SUBSTRING (name,2,1) like “ “ [...]
Answer Question
| May 19, 2010 3:00 PM
MySQL, MySQL query, SQL
This has been driving me crazy. I’m trying to come up with an UPDATE query in MySQL that will remove the second blank space in a name and close the gap. Example: O Brien, John E should become OBrien, John E A simple REPLACE (name, ‘ ‘,’’) where SUBSTRING (name,2,1) like “ “ [...]
Answer Question
| May 19, 2010 3:00 PM
MySQL, MySQL query, SQL
what is the difference in Java and J2EE
what is Java, and What is J2EE, and What is the difference
Answer Question
| May 18, 2010 1:17 PM
J2EE, Java
what is Java, and What is J2EE, and What is the difference
Answer Question
| May 18, 2010 1:17 PM
J2EE, Java
retrive data from 3 tables
HI i need to retrieve data of 3 tables using one more master table wat are the possible options Union,Joins anything else? with good performance please guide for considering the performance as the retrival count is huge in my case
Answer Question
| May 21, 2010 8:31 AM
Oracle, SQL, TOAD
HI i need to retrieve data of 3 tables using one more master table wat are the possible options Union,Joins anything else? with good performance please guide for considering the performance as the retrival count is huge in my case
Answer Question
| May 21, 2010 8:31 AM
Oracle, SQL, TOAD
