Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jagilman
  • Content: Threads
  • Order by date
  1. jagilman

    How to make the page refresh?

    After the user logs into my site I would like the code to perform the same step as if the user clicked the refresh button. This is being used to make additional menu choices available for different users. I have not found any VBScript code to cause this to happen. Thanks John A. Gilman...
  2. jagilman

    Field missing in query results??

    I am using Access as the front end for SQL Server 7. I use a stored procedure to return a recordset. However, one field is missing from the results. It is a varchar field. About 1 month ago this same field was a text field and just started to remove itself from the results. The only way to get...
  3. jagilman

    problem after switching to Access 2000

    One of my customers just put Access 2000 on a laptop. Now when he tries to run my application he gets an error message when he clicks the drop arrow on a combo box that uses the Trim(lname) function in the underlying query. I tried to reproduce this problem on my laptop and it works great for...
  4. jagilman

    Select will not return a value

    I have this stored procedure. CREATE PROCEDURE [sp_SWGetOnHandQuantity] @ProdID varchar AS SELECT OnHand FROM tblInventory WHERE ProdID = @ProdID However it will not return the matching record. My table has the field type varchar, and a unique index. If I search on the identity field with...
  5. jagilman

    How to create an Updateable recordset in ODBC workspace.

    I need to open a recordset of selected records in an ODBC workspace, loop thru the records one at a time, and set one of the field values to a new value before going on to the next record. The problem I am having is an error message stating "the recordset is not updateable." Any ideas...
  6. jagilman

    Workspace and Transaction question!

    My application uses Access as the front end to SQL7. I open a form and start a new workspace. Then I start a new Transaction. One of the first things to take place is for the user to select a bunch of records and my code sets a lock on each record. Then the user starts another process and I...
  7. jagilman

    New Workspace and New Transaction question

    My application uses Access as the front end to SQL7. I open a form and start a new workspace. Then I start a new Transaction. One of the first things to take place is for the user to select a bunch of records and my code sets a lock on each record. Then the user starts another process and I...
  8. jagilman

    How To High Light The Current Row In Continuous Forms!

    PLEASE DO NOT POST IN THIS THREAD I have put togeather a sample database to show an easy way to have the current record highlighted with a different back color. This works on Continuous Form view. Request a copy by sending an emai to gms@uslink.net There are several other neat ideas in the...
  9. jagilman

    How To High Light the Current Row in Continuous Forms!

    PLEASE DO NOT POST IN THIS THREAD I have put togeather a sample database to show an easy way to have the current record highlighted with a different back color. This works on Continuous Form view. Request a copy by sending an emai to gms@uslink.net There are several other neat ideas in the...
  10. jagilman

    Someone has talked about this, but I can't find it.

    When you use the scroll bar to view records in a datasheet, continuous form or query, Access has a popup showing the record # for the record in the top "Visible" position on the form. Have we been given any access to this capability? This is not the me.SelTop property because you need...
  11. jagilman

    Need help with concept!

    I have been working on a re-write of a customers order entry and shipping program in Access 97. The old programmer had designed the order table to include the products.(the company only had 2 items to sell) Now they have many items to sell and needed the addition of an order details table. So...
  12. jagilman

    Help with concept needed!

    I have been working on a re-write of a customers order entry and shipping program in Access 97. The old programmer had designed the order table to include the products.(the company only had 2 items to sell) Now they have many items to sell and needed the addition of an order details table. So...

Part and Inventory Search

Back
Top