Data Entry in Microsoft Access using ASP
Data from the form not able to add into the database although using Internet sample source code.
Data from the form not able to add into the database although using Internet sample source code.
10 pts.
How to connect my application using Visual Studio 2005 to a SQL Server database?
how to connect my application using visual studio 2005 to a database using sql server?
View Answer
| Mar 24 2009 0:27 AM GMT
Visual Studio 2005, SQL Server database, SQL Server connectivity
how to connect my application using visual studio 2005 to a database using sql server?
View Answer
| Mar 24 2009 0:27 AM GMTVisual Studio 2005, SQL Server database, SQL Server connectivity
SQL query to list databases that have a given table
Hi all I need your help for creating some SQL query that returns the names of all databases that have a given table name. Ex. I'd like to run this query against the master database and search for all databases that have a table called "customers". Is it possible to do this, if yes how? Thanks in...
Hi all I need your help for creating some SQL query that returns the names of all databases that have a given table name. Ex. I'd like to run this query against the master database and search for all databases that have a table called "customers". Is it possible to do this, if yes how? Thanks in...
Delete duplicate values in Microsoft Access
there was a ms access database in which there 3 to 4 values same so i want to delete the values keeping only one value. so i need a query.
there was a ms access database in which there 3 to 4 values same so i want to delete the values keeping only one value. so i need a query.
How to save ListBox values to the database with Visual Basic 2008
i m doing a pharmacy system by using visual basic 2008. but i hv a problem when storing a data in table i nid to save a medical list that contain of medical name and medical quantity but how i save it into the table because 1 patient can hv many of the medical. should i use array? or how? i ady...
i m doing a pharmacy system by using visual basic 2008. but i hv a problem when storing a data in table i nid to save a medical list that contain of medical name and medical quantity but how i save it into the table because 1 patient can hv many of the medical. should i use array? or how? i ady...
Error while referencing external assembly in SQL Server 2005.
Sir, I created a dll (SqlWcfServiceLibrary1.dll) using .net frammework 2008. My code has a reference of another assemble (WcfServiceLibrary1.dll) also. I want to create assemble in sql and use that assemble in a procedure. I am getting error that "Error while referencing external assembly". I...
Sir, I created a dll (SqlWcfServiceLibrary1.dll) using .net frammework 2008. My code has a reference of another assemble (WcfServiceLibrary1.dll) also. I want to create assemble in sql and use that assemble in a procedure. I am getting error that "Error while referencing external assembly". I...
ActiveX control for Webcam
I'm creating an application with a webcam to get a snapshot data image, i want to use MS Access for database and use Crystal Report 10 for the print out. My friend told me if i want to use the cam then i hav to use the activeX control, can u help me, please..
I'm creating an application with a webcam to get a snapshot data image, i want to use MS Access for database and use Crystal Report 10 for the print out. My friend told me if i want to use the cam then i hav to use the activeX control, can u help me, please..
Database connectivity between Microsoft Access and C++
how can i give database connectivity in code of c++, and my database is stored in ms-access?
how can i give database connectivity in code of c++, and my database is stored in ms-access?
DataGrid in Visual Basic 6
I am developing an application in VB6 using a bound data grid with a data control, and am struggling with the following: 1. How do I force an update of the data grid to the data control by pressing the Enter Key, regardless of which cell of the data grid is current. 2. When updating the data grid,...
I am developing an application in VB6 using a bound data grid with a data control, and am struggling with the following: 1. How do I force an update of the data grid to the data control by pressing the Enter Key, regardless of which cell of the data grid is current. 2. When updating the data grid,...
Microsoft Access linking
Hi, I have a database in access which has a main table and a products table. They are linked by a customer I.D. field (Primary Key). I have 2 forms one is the customer form and one a products form there is a button to open the products form from the customer form. I would like to be able to open...
Answer Question
| Feb 25 2009 10:40 PM GMT
Microsoft Access forms, Microsoft Access, Database programming
Hi, I have a database in access which has a main table and a products table. They are linked by a customer I.D. field (Primary Key). I have 2 forms one is the customer form and one a products form there is a button to open the products form from the customer form. I would like to be able to open...
Answer Question
| Feb 25 2009 10:40 PM GMTMicrosoft Access forms, Microsoft Access, Database programming
Microsoft Access AutoNumber
Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as "Auto Number" and save the same it automatically gets changed to Text type.Please suggest.Also, the requirement is modified and now the serial number has to be of...
View Answer
| Feb 25 2009 12:01 AM GMT
Microsoft Access, AutoNumber, Microsoft Access auto increment
Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as "Auto Number" and save the same it automatically gets changed to Text type.Please suggest.Also, the requirement is modified and now the serial number has to be of...
View Answer
| Feb 25 2009 12:01 AM GMTMicrosoft Access, AutoNumber, Microsoft Access auto increment
Switch between two options in Microsoft Access 2000 text field
I am an access programmer, not much used to with the VB codes. I am using the wizards instead. I have a new project where in I want the secondary level users to check the data fed by the primary users. The findings of the primary user will be available in the new screen for the secondary level user...
I am an access programmer, not much used to with the VB codes. I am using the wizards instead. I have a new project where in I want the secondary level users to check the data fed by the primary users. The findings of the primary user will be available in the new screen for the secondary level user...
How can I compare fields on two databases
I want to list all fields on a database and use a forall loop to check list of fields on two forms in two seperate databases...can this be done
I want to list all fields on a database and use a forall loop to check list of fields on two forms in two seperate databases...can this be done
Update one database from another database with ASP.NET
I want to update my database from another database when it change.Thank for your answers
I want to update my database from another database when it change.Thank for your answers
Microsoft Access 2007 - Code for connecting two related forms, bringing up same record?
:sigh: My database suddenly requires me to have my forms appear as read-only's (since my employees are too stupid to NOT going flailing around, typing madly for no reason). However, we still need to be able to edit the information. I've created a second form, mirroring the original, to be my...
Answer Question
| Feb 17 2009 3:44 AM GMT
Access 2007, Microsoft Access 2007, Microsoft Access 2007 permissions
:sigh: My database suddenly requires me to have my forms appear as read-only's (since my employees are too stupid to NOT going flailing around, typing madly for no reason). However, we still need to be able to edit the information. I've created a second form, mirroring the original, to be my...
Answer Question
| Feb 17 2009 3:44 AM GMTAccess 2007, Microsoft Access 2007, Microsoft Access 2007 permissions
How can I pass tablename as a parameter in MySQL stored procedure?
my SQL stored procedure is like this.... ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = 'Insert into ' + @_tablename + '(ImageID,Status) values ('+ convert(nvarchar(5),@_ImageID) +','+...
my SQL stored procedure is like this.... ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = 'Insert into ' + @_tablename + '(ImageID,Status) values ('+ convert(nvarchar(5),@_ImageID) +','+...
VB.NET code to search if a record already exists or not
hi! i m fresher i want a vb.net code to serch record from sql database table by using 2 fields of table as a condition i.e client name and client code before saving any new record and if record already exist in table it give me message for that i m sending u code plz rectify it and reply Imports...
hi! i m fresher i want a vb.net code to serch record from sql database table by using 2 fields of table as a condition i.e client name and client code before saving any new record and if record already exist in table it give me message for that i m sending u code plz rectify it and reply Imports...
Limit number of rows in a table
Dear all, I'd just like to ask if anyone can help me find a solution to the following problem: I want to limit the number of records in a table. So when all the available rows are used, the customer can purchase additional ones. Say for example that the customer is allowed to enter 100 sites. When...
Dear all, I'd just like to ask if anyone can help me find a solution to the following problem: I want to limit the number of records in a table. So when all the available rows are used, the customer can purchase additional ones. Say for example that the customer is allowed to enter 100 sites. When...
