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 bkrike 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: Marty2of5
  • Content: Threads
  • Order by date
  1. Marty2of5

    Determine if a form is already open

    Hi, I'm not too familiar with ADO and I keep getting error messages trying to do this how I think it will work. I have a control on a form (frmMain) that runs some automation before opening another form (frmAssign). However, if the frmAssign is already open, I don't want to run the automation...
  2. Marty2of5

    How do I connect to remote server?

    This may be basic, but a vendor who holds some of our data on a dedicated server at their location just gave me update access to a SQL Server table. From my Access 2000 environment, how do I access the data? ADODB.Connection? What is the syntax to include the user name and password? Thanks, Marty
  3. Marty2of5

    How to use one field value to identify other field name

    Hey there I'm trying to compare data between recordsets. What I want is take the value of one field in rst1 (rst1!flag = A) and look up the value in rst2 in the field of that name (rst2!A = ?). What is the syntax for doing that? Dim fldname Set fldname = rst1!flag If rst1!subflag =...
  4. Marty2of5

    Compare and update entire recordset or reassign key field?

    I'm not sure where to begin. I need to synchronize two data tables. Table1 is the one I work with for queries, reports, automation. Table2 is the official data source which is updated weekly. The two are nearly identical except I added a primary key to Table1. I can't modify Table2 and it...

Part and Inventory Search

Back
Top