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!

  • Congratulations strongm 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: *

  1. Marty2of5

    Determine if a form is already open

    The users will not have access to design view. CajunCenturion's solution is working. It would be great to use Rohdem's function if this comes up multiple times. Thanks again! Marty
  2. 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...
  3. Marty2of5

    How do I connect to remote server?

    That's what I needed! Thanks, Marty
  4. 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
  5. Marty2of5

    How to use one field value to identify other field name

    Thanks Doug But it looks like your SQL criteria are still matching one field value to another field value. I'm trying to get a field value to match to field name. Also, the database I'm working on is in Access 97. I want to loop through the entire recordset, not just 'A'. rst1 contains the...
  6. 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 =...
  7. Marty2of5

    VBA code to kick off logged users before maintenance

    Francescina I'm trying this out and when I call MessageBeforeshutdown, I need to get an OK to continue. If the user is away from their desk and they don't OK out of the msgbox before the five minutes is up, nothing shuts down. Any suggestions? Marty
  8. Marty2of5

    Need Help please

    Hi tintinthio This makes more sense than your first question. What is the RecordSource of the subform? If it is a query based on name=Alex and period=March, then all the records referenced by the subform will be Alex's. Marty
  9. Marty2of5

    Compare and update entire recordset or reassign key field?

    I wish it were that simple raskew. OK, kathryn, thanks for hanging in there with me. Here's the whole gruesome tale. Table2 is a weekly data dump from an old Unix mainframe that was written 30 years ago. Each record represents a project. The project ID changes to reflect the progress of the...
  10. Marty2of5

    Compare and update entire recordset or reassign key field?

    Yes. Table1 needs to be repopulated each week from Table2. OR Table2 can replace Table1 if I can find a way to assign the key field from Table1 to the corresponding record in Table2. (Right now, I have Table2 as a linked table. When the table is updated each week, I need to run a series of...
  11. 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