Recent content by Utracman

Ok... we build a sql2000 db to replace the many Access 97 dbs. In the past I used a frontend/backend set up simply linking the client to the master db. I rewote the client (Access97) to work with the new Sql db and linked the tables using an ODBC with a File data source of a dsn in a shared...

Ok... we build a sql2000 db to replace the many Access 97 dbs. In the past I used a frontend/backend set up simply linking the client to the master db. I rewote the client (Access97) to work with the new Sql db and linked the tables using an ODBC with a File data source of a dsn in a shared...

Thanks Dan. That is one way to handle it, but I dealing with 80+ users and severals mdbs so I wanted to find a code solution that I can add to each app. Not sure if there is another solution. To learn fron those who have mastered the art..... Saves many headaches!

We have Access 97 and 2000 databases on a PC. Is there a way to programically identify which mode the machine is currently in and switch to mode of mdb being opened? Example - If I first use A2000 and then open an A97 .mdb I get an "unreconized format error" I then have to open...

I have completed writing from Access to Outlook.. Contacts, tasks, appts blah blah....How can I get from outlook into Access. I know I can add/change the Outlook forms so I would add my Contacts Business's primary key [AccountID] but I have never wrote in vbe before so I'm rusty on the recordset...

Perfect! Many thanks for the lesson Dave To learn fron those who have mastered the art..... Saves many headaches!

Ok.... searched several sites and can not find an example. I know its the after update event and probally a datePart function but there may be a better way. A97 Bound text box where a date is entered. I need to only allow Monday, Tues, Wed or Thurs as acceptable dates. No Friday Sat or Sunday...

Perfect! Thanks for the help Dave To learn fron those who have mastered the art..... Saves many headaches!

Joe I'm close but it always sets focus to the tab even if there are no records. Code If DCount([IssueID], "qryCriticalSub", [Sales ID] = Forms!frmBranchMain![txtSales ID]) > 1 Then Forms!frmBranchMain!tabCritIssues.SetFocus What am I missing? Thanks Dave To learn fron those who...

A97 How would I do this? One of my tab controls [Critical Issues] has a subform that displays Issues that need to be resolved and when they get resolved they will not show up in the subform. What I want to do is if there are records present in the subform I want to set focus to the Tab control...

A97 I use the following to build a history of reviews on each account, but now would like to make one master RevNotes (memo type) and append each review records RevNotes which already have the date and username built in. This way when you view the mastRevNotes you will see for one record with...

THanks, but I only want the date part to be a different color, So in the memo field Dates stand out more. Anys work arounds out there? Dave To learn fron those who have mastered the art..... Saves many headaches!

A97 I want to change the forecolor on part of my after update event value. Code for the afterUpdate event on a memo field Me!txtRtsNotes = Me!txtRtsNotes & " " & Month(Now) & "/" & Day(Now) I want the date stuff to be blue like 16711680 Thanks for the help Dave To learn...

Thanks Again THis is what I did. Copied the code into Sub MyCriteria() Dim lngCount As Long Dim MyCriteria As String MyCriteria = " Month([LastReview])=" & Month(Now()) & " And [Sales ID] = '" & Me![txtSales ID] & "'" lngCount = DCount("LastReview&quot...

Thanks for the help! [Sales ID] is a text field. I tried both options and in the first I get an #error and the second gives me a value of 0. What is missing? The [LastReview] field has a value like "05/09/2001 9:45:48 AM" I'm trying to show all records that match [Sales ID] and...