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
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...
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
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...
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 =...
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
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
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...
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...
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...
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.