Search results for query: *

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

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

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

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

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

A97 Unbound texbox control I'm trying to get the count of records that meet this expression =DCount("corpBranch","tblBranch"," [LastReview] = Month(Now) & "/" & Day("*") And [Sales ID] = [txtSales ID]") I'm trying to count the records with a...

Easy one What criteria expression would return the top 50 records. Example A field has [lastMonthRev] which is the amount the client billed last month. I need to build a query for a report that will return the top clients based on [lastMonthRev]. Many thanks! Dave To learn fron those who...

Help! Access 97.... 120 users, 2 seperate call centers. One has NT 4.0 with Novel and the other Win 98. Currently when I have updates, I send out a new version(email) with the same file name(linked to the DB) to my end users and (in the perfect world) all they have to do is click on the...