I have an application installed onto 50 machines (all supposedly same build). On one of the machines I get the following error Category Remote OLE...

Hello -- I'm using Access 2003 and Office 2003, Windows XP. I'm unable to output to Excel. I don't know why, it just doesn't do it. There's no error...it just...

quite simply, I added a new record to the source table and it hasn't appeared in the form which is based on that table. (which is in single form view) I'm at a...

You could just put Is Null in the criteria row of the grid, lot less complicated I would have thought. SHeila "Souris" wrote: I would like to update my...

I would like to update my record with current date time, if the value is null. May I add 'IF(NULL, FieldValue, Date())' in my query? If not, are there any...

where can i find this? it;s a windows 2000 OS machine tanks

I am wondering if there is a way to create a calendar from an excel document that has multiple dates in it. Thank you.

Hello all, I have been working strictly in Access to create a kind of front-end for users to retrieve invoice information from a database. It is very simple...

In a multi-user enviroment, where my database resides on a netweork file server, certain individuals cannot run ANY of the reports that have been created. The...

Is it possible to change the order or a field, i want the letters to come before the numbers so it would start a to Z and then the numbers 0-9. On my report,...

Hey, I have just started using Access for the first time in about 3 years and I am a bit stuck. I have a table set up that has all of the data that I require....

Hi, I recently installed Office XP (2002) on a new Dell machine. Everything worked fine. Then I installed Office 95 (Everything worked fine) Then I installed...

I am trying to find the distance between two zip codes and i found this equation on line: select acos( ( sin(z1.latitude * 0.017453293)*sin(z2.latitude *...

I have a client that is getting an error when executing a query that says ODBC--connection to 'DSNP' failed. I'm not real Access saavy. Any ideas on where to...

What is the format for identifying the code to use in a Run Code Switchboard Command? I have several procedures that I can only get the switchboard to call by...

whatever it is, it is chewing the newsgroups up at the moment... -- Regards Alex White MCDBA MCSE http://www.intralan.co.uk

How many records can Access 97 hold and still be stable?

I have a form (net) with a subform(foto) with the field fotolocatie The data in this field contains the directory and name of a photograph, linked to the...

Hello, I have a user who has 134 customers. He regularly uses two reports--one identifying sales invoiced and one identifying orders (sales not yet invoiced)....