Search results

Cheers this seems to have helped managed to transfer all but two forms across to a new database. I have a feeling that these forms are the problem if so it is probably a problem i inadvertantly created myself. I have 3 forms which are identical in every detail but used by different people...

:( Nope affraid I still have the same problem after using the Jet Compactor. Any further suggestions please BTW I know about not being able to change while people are using the Db, this is why i work on the copy and then transfer it accross, have also set it up so we can kick everyone out when...

Help I have a database on a main frame system and a copy which I work on also on the mainframe system running windows NT. I usually make changes to database then import forms etc into the live database when completed. Problem I am currently having is that the copy database has gone belly up...

:confused: Thanks however that flew straight over my head. I obviously need to start at square one on this one, can you point me in the direction of square one for this workaround Many thanks

I am using Access 2K. Is it possible to have more than the 3 options in the conditional formatting as under the formatting menu. If not any advise as to how best to go about my delima I have I field which is changed by different users throughout the database, which in turn changes the colour...

OK had a cup of coffee and a think, what i was trying to do would not have worked anyway. as i am changing the feild in several places so the likely hood was it would keep being changed. Have now opted for a simpler option with a second visual colour feild just showing whether credit is...

I dont think so I have had a look around. it seems you are limited to 3 options 4 if you count the no conditions met. You also seem only to be able to set conditions on info in the feild in question, and you can not seem to make reference to another feild as i need to.:confused: it seems to me...

Ok that works fine but I now lose my conditional formation options At various other points of the data base ie on other forms this field is changed to show progress So it goes from Red back ground with nothing in the field to Orange when the credit has been authorised by the manager with the...

Hi Probably a simple solution to this however it is doing my head in at the moment. I have a field ( Approv) which is currently set using the unconditional formatting. However I notice that you can only have 3 conditions set. I needed to add another condition which you could not do anyway...

Many thanks I have disabled most options like menue bars however still have the Shift key enabled, as will this not stop me also getting into the database? I would dearly love to use group security settings, this would indeed make my life so much easier. However I am using the database on a...

Hi Just a quicky how do you disable the properties so that unauthorised people can not tamper with the database. reason being i have set up button which opens up a form but requires a password to do so. however this is a bit pointless if all a knowledgeble user needs to do is right click and...

Many thanks. As i thought, i was going off in the wrong direction, this clarifies quite a bit, and a lot more simple than i thought. Cheers

Hi quite a simple one here i think, but thought i would seek advice before i cocked anything up. I have a database with a feild which carries a specific No to donate which location a site ie 37b could mean that the location is London. Like all Good organisations, just as you sort something...

Oops i posted the wrong ZIP Sorry. yes I am a bit in the dark about coding etc and have stumbled along to date, with quite a lot of help from people in here. what i am not to sure about is when i unzip the ( correct) Zip it contains two databases, which do not appear to be linked, what do i...

Many Thanks for the advise I think I need to go down the road of Sams and Autongs suggestions, as different sites are working different hours etc. I Downloaded from the link in Auotongs message, however can not seem to quite get my head round what to do with the files. Have also come across a...

I have been developing a database with the help of many from these forums, this is now operational and data inputted from 9 locations. My nightmare now is caused by not being able to get exclusive access to modify the database which is still developing. This is caused by people not logging...

Cheers Where do i find these controls, i have looked in both the form and query, I know i am missing something obvious here. And if i find them haow do I insert them into the report Cheers Paul

Are you saying that they would need to enter the date again once the form is open. they enter the date as part of the queery which forces a message box for the data, they can not get the form open without this data. am i misunderstanding you Paul

Long shot here but thought I would ask anyway I have a report which on opening the user enters into message boxes the beginning date, and end date of records they wish to include in the report. Is there any way to include these dates selected into the report i.e. in the header or footer, or...

Bingo!!!! As always it is obvious I must learn to read excatly what i see in answers to questions Many thanks again