My corporate environment is Access 2000. I have established ODBC links to SQL Server 2000 views in Access. Occasionally my users are having issues with...

I have a table that I want to delete specific records from based on data in other tables. I'm more familiar with Access '97, but am now using 2003, but the...

Hi all! I am running a query in a subform where I sum a * . Units are imported from a csv file with 3 decimals and operation sign is either -1 or +1: For...

I have two Tables in a database & I have made a Join between the Reference fields.However, the data in the two Reference fields that I wish to find duplicates...

I am using Access 97. I have a table called maindata with a field called Turnover, the field contains numbers which need to be shown as thousands of £.That is...

I have an access 97 database. When I run a query to return a text field I get the following error. The width of a Unicode text column must be an even...

Hi guys, Urgent problems that I need to sort before Monday, I will be so grateful for ANY help received! I am not familiar with Microsoft Access with Visual...

Hello all, I have a problem with a query in Access 97, and I'll try to give you all of the details to see if you have any idea if it's even possible: I have...

I know I have to use code or sql for this as there are approx 30 combo boxes. I have been looking for similar examples...with no luck...The user will select...

I apologize for rehashing the Access/SQL Server question, but I haven't been able to find a post that addresses it quite the way I need. We have an Access...

Hi I have two cases: 1) Access97 DB - FrontEnd VB6 application. (Live) - table structure is almost same 2) SQL*Server DB - VB.NET application (Not Live) -...

I'm working with Access 97. In a form, I have a listbox based on a query which calls a function I have created. This function calls VBA functions like "Mid",...

Does anyone know how to do something like this in Access 97? UPDATE tableB SET date_ferment_completed = EXISTS ( ...

I have an Access 97 program that for many years linked to tables in another database through drive letter access. Recently, because of speed, we converted the...

I'm having a few issues working with MS Access queries, becuase if I want to search for a dated range information, the data included within the last query day,...

Hi I have 2 tables one is imported every week with up to date data from a different system, and the second holds most of our data. Because some of the records...

I have a query that works just fine on my computer where I have A97 installed along with A2007. They don't like each other, and they don't play well, but my...

Once upon a time I used to know what I was doing in Access but time has taken its toll and Im struggling. I am thinking of setting up a database for helping...

What am trying to do it get my form to Pass parameters to report... when i click on the report my form opens up and allows me to enter in start adn end date....

I currently have a working Access 97 database, which uses 1 table and 6 queries. The first 2 queries are crosstabs, pulling relevant data out of the table in...