Dear all This is a complicated issue for me so I will try and make sense! At work we have a 'helpdesk' ODBC server which records various information...

How do I lock an Access DB, so that it closes as soon as the user form closes?

1. I have a one-to-many relationship. But everytime i go back to the relationship window Access automatically creates another relationship using the same table...

I have a report created that i'm counting on a field a certian field. When i count on this field it gives me a total of 861. This field has 2 items that are...

I have a report created that i'm counting on a field a certian field. When i count on this field it gives me a total of 861. This field has 2 items that are...

In a query i'm tring to calculate days away example: - But I would like to calculate as Date() untill an accual date has been entered.

I have been trying to open an Access 95 database on a machine with Windows 2000. It gets to a certain point and then it comes up with a memory error, however...

Hi All, I have a macro which runs a query, which makes a table. I then want this table to be output to a 'Data' page on an Excel spreadsheet held on...

Hi All, Can anyone please give me instructions on how to remove the annoying macro and security prompts that occur when I open up Access 2003...

Hi All, I am creating the database using Access 97 and am experience difficulties with the lack of features etc. At home I have both Access XP and Access...

Hi All, I've trying to work on an Access 97 database using Access XP but not having much luck. Is it possible? If so how? I also have Access 2003 it that...

Dear All, I'm an Access newb using 97. I have an excel spreadsheet which staff members fill in daily to complete there statistics for there days work. It...

how can I keep the the formula bar from blocking the column headings (in Excel) when writing long formula's?

Afternoon All ! I'm an Excel person whose starting to look at expanding my knowledge into Access. I have a query and I want to add a new field into the query...

Hi All, In our office we are using Touchpaper Helpdesk (effectively its a database for Call logging in a Telephony centre). In the data tables it records...

Hi All, I'm a newbie at Access queries, especially Crosstab queries. I have a crosstab query that has the categories running down the left and dates running...

All, I have a module that converts the time which comes out of another ODBC database application. Please can you see the below code, is there something wrong...

Hi All, Mr Doug Steele answered a similar post to this previously, hopeing for another type of answer as his answer worked a charm , see previous...

Hi One of the columns in my table contains tick-boxes. Some tick-boxes are ticked and some are not. I'd like to run a query that only displays tick-boxes...

1. Adam - Regus Feb 2, 10:48 am show options Newsgroups: comp.databases.ms-access From: "Adam - Regus" - Find messages by...