Recent content by Jo8701

Please see attached I have created a calender function which i use in one of my databases. I am from the UK and it works fine on my access. I have users in Denmark who when i introduced the database recieved the attached errors. The users in Denmark use the same version of Access SP3 and...

Premium Amount: [Avg]=[Items Processed]![Premium] The transactions show up as Aviation Aviation Marine Cargo Cargo Marine I would like the query to show me just an average premium broken down into the main transaction groups so Avg Aviation 9500 Marine 1000 Cargo

Hi Guys, I have two fields in a table: Items Processed Transaction Type and Premium Paid Im having trouble building a query which gets me an average premium paid from the various transaction Types within a certain date range? Can some one please help? Thank you

Hi We all input data into one database used from a shared drive, one of the users works from home and finds it very slow because of the connection we have. If she works on a copied version of the database at her home, then puts it in a shared drive how can I link the two so that I can...

Thank you very much

Hi Guys This is prob a small thing but I have a Form and included are two fields IPT (Yes/No box) IPT Amount I want to have it so IPT Amount is shaded out but if the user clicks yes in the box the IPT Amount box becomes unshaded? Appricate any help on this thanks

Hi Guys, We currently have about 25 users who log in transactions on a form, some of those transactions need to be double checked by other users before it is complete. Each user has a cue of outstanding work (a table few when they log into their page). i have created a drop down list of...