Recent content by saff_cossie

Thanks for that, I will give it a try

Hi Having had a quick look at your database and your number 1 point. If a report was created based on a query with a search prompt box like you have for another field, that could work. E.g you have a query with a prompt box for record ID. You type in your record ID and a report is published...

Hi all Could someone tell me if there is a way I can have an Access form on my client machine updating a table on a server please? I have looked at the help section in Access 2000 and found something called ActiveX but can only find its functionality not a definition. I want to do this in XP...

Thanks for that Wayne, I have done it and it is more or less what I am after.

Hi all I would like to compile a form so that the user only sees the form but cannot see if this can be done. Ideally it would be a shortcut on the desktop that when clicked on, only shows the form. I dont want to give them access to the rest of the database incase they play with things...

I have found how to do it as I wasnt clicking below the footer. I was clicking the footer thinking it was in that so if anyone else needs to know, it is the darker grey area below the footer line. Thanks for the help anyway

I don't see that option in the properties window. Could you tell me the tab it is under and its actual name please. Many thanks

Hi all I am trying to do a query where I pull data from 4 tables. The 4 tables are Quarter1, Quarter2, Quarter3 and Quarter4. From each table I want to pull PayDate and Done. Each PayDate and Done is prefixed by the appropriate Quarter e.g. QTR1PayDate, QTR1Done. PayDate is a date/time field...

I have redesigned the tables and seem to have it working for the moment. If I run into further problems I will post again. thanks for all your help, it is appreciated.

Daft question I know! I have seen it as well in the past few days when searching through access. I do not need it in one of my windows so how do I turn it off please? Thanks in advance

I am looking at redesigning the table structures as the data I am dealing with is a bit tricky. Here is the basic columns I need and have. FleetNo RegNo RWC Comments DueDate (x4) PayDate (x4) PaidDate (x4) Paid (Checkbox x4) Amount (x4) The problem I have is the 5 fields above that have "x4"...

Good Morning I didnt think I had based the form on a query so checked and have not done so. I did the second part of trying to update the query which it would not allow me to do. A bit more information that could be of use: To create some of the tables I have done union queries. I am not sure...

Sorry I meant all the allow fields in the properties of the form such as AllowDeletions, AllowAdditions etc were set to True. When I put the form in Form View the New Record and Delete Record on the tool bar are disabled. The New Record button is also disabled on my record scroll bar. I can...

Hi all I am new to this forum but have spent a while looking around it before joining. I have a question regarding updating the database from a form. I am using multiple tables in the same database linked via foreign keys (well one primary with about 6 foreign). My records have loaded fine...