Recent content by Sarah

Hi All having trawled through many, many threads on here to find what I am looking for and not finding it, I am looking for help again. I have four fields on my form that are supposed to show up as a % however when entering a number i.e. 23 the box is formatted as 2300.00% I cannot see a...

The Combo is already in place can it be amended, changed or updated without having to start again? This field is linked in so many ways if I create a new combo box nothing works. If I was creating this from scratch I don't think there would be a problem

Hi I have a number of tables that are sorted in ascending order but when using the form the data is not in the same ascending order. e.g. 1-Girls 2-Boys 3-Infant & Preschool 4-All business Units The drop down menu shows as (this is just an example the order is not necessarily as it would...

Thanks - All fixed now, using the Link manager. Sarah

Both the FE & the BE are on my drive at the moment but it seems impossible to move them both without everything ceasing to work. Fortunately I saved the DB on a memory stick and was able to re import it so everything worked again. Should I make a copy of the FE & BE save it to the new...

Hi I've created a database in my personal drive which is stored in a directory only accessable by my immediate colleagues. Problem is I am about to roll this out to a sales team that do not have access to my drive (and will not be permitted access) so I need to move the database to a shared...

Hi Guys just to say this works like a dream. Thanks for all your help and support. Sarah

Ok - this is starting to make sense - I'm attaching a screen shot of the form and it's showing all the boxes you mention currently set as 'Yes' there is already a box, which is currently visable but which I can hide, on the form, labeled 'check if current budget is committed' in the table it's a...

Hi I suppose the one at work is access 2000 but my home computer has access 2007 - we should base it on the one at work as its the sales force that are going to have to use it. thanks

Hi RG I think I better quit while I'm ahead - I wouldn't know how to find whether this was a single record dispay or a continuous form - I'm way out of my depth on this. Maybe I didn't ask the question in the right way. I only want the data (for each record) to become read only, when I...

Hi your information is gratefully received but I am so new to this you wouldn't believe it. The database is inherited from our US subsiduary and believe it or not this system is not supported by the company - so I'm very much on my own. The form is built around a table, not a query. It will...

Hi I have created a form that our sales team can use to enter sales/customer information. untill the work is fully approved the user is able to go in and amend any of the fields. once approved backup documentation has been received by me I want to be able to make the record read only so the...