Search results for query: *

Hello- I have a situation that really has me stumped. I have a form used to display contacts, and to view the calls made to this contact, a command button is clicked that loads a new modal form for viewing and inputting call information. This form includes a subform that lists the calls in...

I want to create a stored procedure that will select all columns from one row of table 1 and insert them as a new record into table 2 of a different database that is located on the same SQL server. I'm sure I could use the Query designer in my Access ADP to accomplish my goal, however I cannot...

Hello- I'm trying to write a view whose recordset will be the RowSource for a big combo box that essentially displays a user's search results. I've done this before, but am now having trouble. Ideally, the combobox will display an account name, ID number, client name, reference number, last...

Hi All- Let me first start by saying that this is my first foray into the world of VB.NET application programming, though I have over 10 years experience with VBScript/ASP/SQL Server programming. I've read what seems like a million posts on how to use a combobox's selected value as a parameter...

Hello all- I have a form with several subforms in it. One of them has a combo box which a doctor uses to select a medical diagnosis code. There is another combo box which is sometimes used to select a relevant diagnosis modifier. I have it coded so that when the AfterUpdate event occurs on the...

I have a simple stored procedure that executes successfully, but always says no records returned...this is BS! I can run the proc in Query analyzer and it also says executed successfully...but returns no resultset.. There's just one parameter being passed to the SP, whose value would be...

I have a command button on a form with an event procedure that fires off a stored proc that updates any records whose value is "Promised" to "Broken Promise" if they do not pay by the PromiseDate value.. it then opens a form which allows them to buiild the criteria for reports. The problem is...

I have a command button on a form with an event procedure that fires off a stored proc that updates any records whose value is "Promised" to "Broken Promise" if they do not pay by the PromiseDate value.. it then opens a form which allows them to buiild the criteria for reports. The problem is...

This event procedure worked fine in Access 2000, but now that it's in an ADP, not. It is deleting the first record in the recordset when I click the DeleteButton rather than the selected value in the Combo0 combo control. How do I get it to delete the selected value from the combo box...

The following search code works great in an Access 2000 database, but now that I've convered to an Access 2003 ADP, it doesn't return any results: ----------------------------------------------------- Private Sub btn_OK_Click() On Error GoTo btn_OK_Err Dim strWhere As String Dim strAnd As...

I've got a data access page that I'm posting a form field named ClientID to in hopes of avoiding the prompt that the stored procedure forces. This site is still very much in development and using some staticly defined values to retrieve the first bit of data you see and the CleintID that the...

Hi all- I recently upsized to SQL Server 2000 and created an Access 2003 ADP using an Access 2003 MDB that worked perfectly. I've got a subform on a form and have it set to be in datasheet view. Previously, there was a "new record asterisk thingy" located in the very last row of the datasheet...

I've just upsized an MDB to SQL Server 2k and have created an ADP to use as the front end. Evidentally, since I had Access 2000, only the tables were upsized. I'm now trying to convert all my queries into either Views or Sproc's and having many difficulties, but the main problem is that I have...