I have a Main Form called frmPurchaseRequest that has a tab control (TabCtl0) on it with three tabs. Each tab uses the same sub form to capture data entry (context oriented each tab represents a different way of acquiring goods and services). the intention is to have a client click on a tab...
I want to populate a combo box with the results of a selection from a preceeding combo box. My front end is in Visual Studio 2005 and my database is SqlServer 2005. To use an example from the 'pubs' database I would like to slelect An "Author Name" from one list, and then in the next combo box...
I am using the following code to establish a relationship between tblCompany and MainTable. tblCompany is on the "One" side with a primary key called Comp_Id and MainTable is on the "many" side and has fk_Comp_Id as its linking field. When I run this code I get the error message "User defined...
I am trying to get a query working that has two parameters. I can find a record in a table by using the ado recordset object with one parameter but I am unable to get it to work with two. I have a bridge table that I need to use two parameters to locate a unique row. The statement is as...
I have a save button on my form which opens a recordset and saves the data to the table. If the user clicks on the button twice by mistake it will save the data twice in two separate records. I will actually get two rows in the table with identical information (with different primary key...
I have a table with a primary index that is an Autonumber field and I need this number to insert into another table as a foreign key. Since the first table does not have the value actually "physically" in its dataset (even though there has been a number generated by the autonumber field) I keep...
I have an application that has a datasheet presentation style for the data entry form (client insisted on this) and I have a need for a field that can handle two events. I need it to do one thing on double click and a different thing on key down all within the same field. I have tried to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.