Recordset not Updated as per query and not giving any error
Dear Sir, thanks for your reply for my earlier query, What I am trying to do is i am editing RM item rate in RM master file.. my code doing it correctly, secondly i am updating bill_detail file for rate where that RM code is used in bill this also my code doing correctly, but [...]
Answer Question
| May 28, 2009 10:11 AM
Database programming, Debugging, VB 6, Visual Basic 6, Visual Basic debugging
Dear Sir, thanks for your reply for my earlier query, What I am trying to do is i am editing RM item rate in RM master file.. my code doing it correctly, secondly i am updating bill_detail file for rate where that RM code is used in bill this also my code doing correctly, but [...]
Answer Question
| May 28, 2009 10:11 AM
Database programming, Debugging, VB 6, Visual Basic 6, Visual Basic debugging
How to make VB6 and SQL Server 2000 multiuser and client-server?
how to make vb6 and sql server 2000 multiuser and client server??i use adodc for connection please tell me the source code. thx
Answer Question
| May 28, 2009 7:49 AM
ADODC, Client/Server, Multiuser, SQL Server 2000, VB 6, Visual Basic 6
how to make vb6 and sql server 2000 multiuser and client server??i use adodc for connection please tell me the source code. thx
Answer Question
| May 28, 2009 7:49 AM
ADODC, Client/Server, Multiuser, SQL Server 2000, VB 6, Visual Basic 6
VBA copying a range from Excel and pasting to a text file
Do you know how to copy from excel and paste to a text file using VBA?
Answer Question
| February 2, 2012 9:38 PM
Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications
Do you know how to copy from excel and paste to a text file using VBA?
Answer Question
| February 2, 2012 9:38 PM
Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications
Populate Access 2007 object in form
I am trying to populate a form object based on the value from a combo box. I have tried FindRecord and SetValue and so far nothing is working. Please help.
Answer Question
| June 1, 2009 6:56 PM
Access 2007, ComboBox, Microsoft Access
I am trying to populate a form object based on the value from a combo box. I have tried FindRecord and SetValue and so far nothing is working. Please help.
Answer Question
| June 1, 2009 6:56 PM
Access 2007, ComboBox, Microsoft Access
How do I use SDA without having too much knowledge using DDS?
I wrote a menu a while ago after going to a class and getting a cheat sheet for SDA. I have very little DDS experience but was able successfully write the menu. Is there any helpful information on SDA that helps design screens without knowing DDS?
Answer Question
| May 30, 2009 3:43 PM
DDS, QuickRef, SDA
I wrote a menu a while ago after going to a class and getting a cheat sheet for SDA. I have very little DDS experience but was able successfully write the menu. Is there any helpful information on SDA that helps design screens without knowing DDS?
Answer Question
| May 30, 2009 3:43 PM
DDS, QuickRef, SDA
Runtime Error 3001 – Arguments are of the wrong type or out of acceptable range or are in conflict with one another
Dear Sir, Thanks for your answer for my earlier questing. It solved my problem I am using VB6 as front end and Access as back end. I’m editing my table for particular field. I am editing rate of one item in RMmaster file. It’s doing it, but I want to edit rate of same field [...]
Answer Question
| April 19, 2013 11:42 AM
Error 3001, Runtime Error 3001 - Arguments are of the Wrong Type or out of acceptable range or are in conflict with one another, Runtime Errors, VB 6, Visual Basic 6
Dear Sir, Thanks for your answer for my earlier questing. It solved my problem I am using VB6 as front end and Access as back end. I’m editing my table for particular field. I am editing rate of one item in RMmaster file. It’s doing it, but I want to edit rate of same field [...]
Answer Question
| April 19, 2013 11:42 AM
Error 3001, Runtime Error 3001 - Arguments are of the Wrong Type or out of acceptable range or are in conflict with one another, Runtime Errors, VB 6, Visual Basic 6
How can I send VB.NET output to the DYMO labels
For one project i need to integrate the application output of my project with the labels of the dymo printer. Actually we have to send some data(text,numeric,mix) to the labels of the DYMO LABELWRITER DUO Label printer. The labels we need to send data is 1. Shipping(99014) 2. Tape Label with 12 mm width. I [...]
Answer Question
| May 27, 2009 10:08 AM
DYMO Labels, DYMO LabelWriter Duo, VB.NET, Visual Basic .NET, Visual Basic printing
For one project i need to integrate the application output of my project with the labels of the dymo printer. Actually we have to send some data(text,numeric,mix) to the labels of the DYMO LABELWRITER DUO Label printer. The labels we need to send data is 1. Shipping(99014) 2. Tape Label with 12 mm width. I [...]
Answer Question
| May 27, 2009 10:08 AM
DYMO Labels, DYMO LabelWriter Duo, VB.NET, Visual Basic .NET, Visual Basic printing
How can I build cacading Dropdown Lists with Parent-Child Relationship in SharePoint
Hi, We run 2007 Server, and we have several lists, and there is a parent child relationship. When user selects first column (parent) second column (child) values should be filtered based on parent column selection (basically getting Country and state functionality; when user selects country in first drop down list all the states of that [...]
Answer Question
| May 27, 2009 9:20 AM
DropDownList, SharePoint, SharePoint 2007, SharePoint 2007 Parent Child relationship
Hi, We run 2007 Server, and we have several lists, and there is a parent child relationship. When user selects first column (parent) second column (child) values should be filtered based on parent column selection (basically getting Country and state functionality; when user selects country in first drop down list all the states of that [...]
Answer Question
| May 27, 2009 9:20 AM
DropDownList, SharePoint, SharePoint 2007, SharePoint 2007 Parent Child relationship
Oracle RR Date Format
TELL ME ABOUT RR DATE FORMAT IN ORACLE9I(SQL)
Answer Question
| August 9, 2011 8:43 AM
Oracle 9i, Oracle RR date format, SQL
TELL ME ABOUT RR DATE FORMAT IN ORACLE9I(SQL)
Answer Question
| August 9, 2011 8:43 AM
Oracle 9i, Oracle RR date format, SQL
Application with VSFlexGrid1 in VB6
Dear Sir, Sorry for again with same question, before I say anything I will submitt to you my Command what I use I think its a better way to solve my problem. MySql = “select * from _ Location where ItemNo” If MyItem.state = 1 Then _ MyItem.Close MyiTem.Open MySql, Data, asOpenKeyset, adLockOptimistic if MyItem.Recordcount [...]
Answer Question
| May 27, 2009 8:35 AM
VB6, Visual Basic 6, VSFlexGrid
Dear Sir, Sorry for again with same question, before I say anything I will submitt to you my Command what I use I think its a better way to solve my problem. MySql = “select * from _ Location where ItemNo” If MyItem.state = 1 Then _ MyItem.Close MyiTem.Open MySql, Data, asOpenKeyset, adLockOptimistic if MyItem.Recordcount [...]
Answer Question
| May 27, 2009 8:35 AM
VB6, Visual Basic 6, VSFlexGrid
Purpose of creating SQL Server stored procedures at run time
Hi Experts, I am a programmer in SQL. Please explain me the purpose of creating stored procedures during run time and it’s effects on performance and memory. Please provide me if there is any best alternative for this. Thanks in advance
Answer Question
| June 3, 2009 7:33 AM
RunTime, SQL Server 2000, SQL Server development, SQL Server stored procedures
Hi Experts, I am a programmer in SQL. Please explain me the purpose of creating stored procedures during run time and it’s effects on performance and memory. Please provide me if there is any best alternative for this. Thanks in advance
Answer Question
| June 3, 2009 7:33 AM
RunTime, SQL Server 2000, SQL Server development, SQL Server stored procedures
Thread culture
Hi there I am new in programming, I was wondering if you kindly help me please what is Thread culture in the software? and what is doing?, picture shows Thread culture in the software more appreciated Thank you in advance
Answer Question
| May 27, 2009 7:10 AM
Localization, Software development, Thread culture
Hi there I am new in programming, I was wondering if you kindly help me please what is Thread culture in the software? and what is doing?, picture shows Thread culture in the software more appreciated Thank you in advance
Answer Question
| May 27, 2009 7:10 AM
Localization, Software development, Thread culture
adding url’s to the links toolbar in IE via script
daily I have to add a couple of url’s to the links toolbar for every new computer that comes into our office. it’s simple to drag and drop manually but time consuming and tedious. does anyone know how I can have this done automatically with a simple batch file or vbs script?
Answer Question
| May 29, 2009 6:55 PM
Batch files, Internet Explorer, VBScript
daily I have to add a couple of url’s to the links toolbar for every new computer that comes into our office. it’s simple to drag and drop manually but time consuming and tedious. does anyone know how I can have this done automatically with a simple batch file or vbs script?
Answer Question
| May 29, 2009 6:55 PM
Batch files, Internet Explorer, VBScript
Workflows and Properties
We would like to use SharePoint workflow for reviewing and approving our invoices. However, we would like to add a budget field in this process so that the approver can add the budget at the workflow level and then approve as opposed to going into the Edit Properties screen. But we’d also like this data [...]
Answer Question
| March 26, 2013 5:36 PM
SharePoint, SharePoint Workflow, Workflow
We would like to use SharePoint workflow for reviewing and approving our invoices. However, we would like to add a budget field in this process so that the approver can add the budget at the workflow level and then approve as opposed to going into the Edit Properties screen. But we’d also like this data [...]
Answer Question
| March 26, 2013 5:36 PM
SharePoint, SharePoint Workflow, Workflow
Database Issues – Trying to prove that something has to be done
Hello Everyone, I’m currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some major changes happen, we won’t see [...]
Answer Question
| September 20, 2010 2:16 PM
AS/400, Database, Database issues, Indexes, iSeries, iSeries Navigator, Logical File, PF, SQL, SQL tables
Hello Everyone, I’m currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some major changes happen, we won’t see [...]
Answer Question
| September 20, 2010 2:16 PM
AS/400, Database, Database issues, Indexes, iSeries, iSeries Navigator, Logical File, PF, SQL, SQL tables
SQL update a column to remove a certain character
I have a table (book) where there is a column that contains number in some rows and numbers with an addition *infront. I want to be able to perform some calculation with the table but the ‘*’ is preventing me from doing this. So how do I update or alter the table so that I [...]
Answer Question
| April 19, 2013 1:41 PM
SQL, SQL tables
I have a table (book) where there is a column that contains number in some rows and numbers with an addition *infront. I want to be able to perform some calculation with the table but the ‘*’ is preventing me from doing this. So how do I update or alter the table so that I [...]
Answer Question
| April 19, 2013 1:41 PM
SQL, SQL tables
test director 8.0 installation error
Iam new to software field just finished st course I try to install test director 8.0 on windows server 2003 enterprise edition set goes up to login details page when i select next it displays unknown user name or bad pass word can any body help me get out of this problem thanks in advance [...]
Answer Question
| May 26, 2009 1:38 PM
Test Director, Test Director 8.0, Test Director Installation, Testing software, Windows Server 2003, Windows Server 2003 Enterprise Edition
Iam new to software field just finished st course I try to install test director 8.0 on windows server 2003 enterprise edition set goes up to login details page when i select next it displays unknown user name or bad pass word can any body help me get out of this problem thanks in advance [...]
Answer Question
| May 26, 2009 1:38 PM
Test Director, Test Director 8.0, Test Director Installation, Testing software, Windows Server 2003, Windows Server 2003 Enterprise Edition
Netgear DG834 fails to block sites using HTTPS
Using a netgear dg834 we have set a block for www.facebook.com this works fine if the users attempts to contact through HTTP but if they do an HTTPS access then this bypass’s the filter and allows them access. Any help would be greatly appreciated.
Answer Question
| May 26, 2009 11:31 AM
HTTPS, NetGear blocking, Netgear DG834, Network security, Router configuration, User restrictions
Using a netgear dg834 we have set a block for www.facebook.com this works fine if the users attempts to contact through HTTP but if they do an HTTPS access then this bypass’s the filter and allows them access. Any help would be greatly appreciated.
Answer Question
| May 26, 2009 11:31 AM
HTTPS, NetGear blocking, Netgear DG834, Network security, Router configuration, User restrictions
Runtime Error 2147217900 (80040e14) – Syntex Error (Missing Operator) in query expression
Sir, I am using VB6 as fronthand and Access database as backend. Now in my project i want to display only those records which match selected value through combobox. but when executing system giving error as “Runtime Error 2147217900 (80040e14) – Syntex Error (missing Operator)in query expression ” My code is as under Private Sub [...]
Answer Question
| May 26, 2009 10:09 AM
Error 80040e14, Microsoft Access, Syntax errors, VB 6, Visual Basic 6, Visual Basic runtime errors
Sir, I am using VB6 as fronthand and Access database as backend. Now in my project i want to display only those records which match selected value through combobox. but when executing system giving error as “Runtime Error 2147217900 (80040e14) – Syntex Error (missing Operator)in query expression ” My code is as under Private Sub [...]
Answer Question
| May 26, 2009 10:09 AM
Error 80040e14, Microsoft Access, Syntax errors, VB 6, Visual Basic 6, Visual Basic runtime errors
Crystal Reports database
I am storing my database in the APP_DATA Folder of my application. I added crystal report to my application. I mentioned .SQLEXPRESS as my server. In database drop down i see only these databases -Master, Model, msdb, tempdb My dabase’s name is “Database.mdf” . Why i am not able to see it ? My connection [...]
Answer Question
| October 28, 2011 8:48 AM
Crystal Reports, Crystal Reports Database, Database applications, Database connectivity, Database programming
I am storing my database in the APP_DATA Folder of my application. I added crystal report to my application. I mentioned .SQLEXPRESS as my server. In database drop down i see only these databases -Master, Model, msdb, tempdb My dabase’s name is “Database.mdf” . Why i am not able to see it ? My connection [...]
Answer Question
| October 28, 2011 8:48 AM
Crystal Reports, Crystal Reports Database, Database applications, Database connectivity, Database programming
