Search results

I have a client (Non-Profit Org) with an Access 2003 app as a front end to a SQL 2000 database using ODBC connectivity. Multiple users access the SQL db using the Access 2003 db front end app from XP workstations running Access 2007. My ultimate goal is to get the clients SQL database upgraded...

I am in a similar situation. Did you ever find a solution for this problem?

I am looking for a simple way to transfer values that have been calculated for the field values of a single record in a source table into individual records in a target table. The only thing I can figure is to run a macro that opens the first record in the target table and then use SetValue to...

I have tried using the the Sort/Group options in the Report, but to no avail. I have tried all of the options (Group Header, Group Footer, etc...) but nothing seems to work properly. I am using Access 2000 for this database, but I do have Access 2002 & 2003 installed on the machine that I am...

I have created a query that retrieves data from two tables (CustomerInfo & CustomerOrders) that are related to each other by a common field (CustNumber). It retrieves the data from the two tables and sorts it by the CustNumber and then by the OrderDate. I am trying to recreate a report that...

We have a database application that was created in MS Access. We are wanting to upgrade to using MS SQL Server. We have imported the data from the Access mdb file into a new SQL table, created the ODBC SQL objects to link to, Linked the Access Application to the SQL tables, and pointed the...

Thank you Thank you for your help.

I need to have a query select records that "IS NOT NULL" in either 1 of 2 fields, or "IS NOT NULL" in both fields. Any suggestions?

That did it! Thank you, thank you, thank you, and thank you!!!!! I appreciate your assitance very much. Thank you, again. Randy

I am using a Tab control in the Form header to select between showing either my active clients or my cancelled clients. Here is my VBA code: Private Sub tabActiveClients_Click() Me.RecordSource = ("ClientsQuery") End Sub Private Sub tabCancelledClients_Click() Me.RecordSource =...

Does any body know the DAO string, for VBA, to change the Record Source of an open form? The normal VB string that I have used before is giving me an error in VBA for Access. I can duplicate the form and manuallly set the Record Source to the other Query and then switch between the forms, but...