Search results

How can i add a user password to a user account? I have tried to change Log on Password in the user Group and Accounts menu but the only user that appears is admin. Can you add accounts to let only added users access the database by adding a password.

Do you have the data refering to the different beverages in tables or do you need to add them by hand using VBA code?

Im not sure about XP but in 2000 you can covert databses to current and prior versions in the Tool>databseUtilities>ConvertDatabse menu

Thanks for the replies. I knew you could call different queries from VBA i was just wondering if i could have the query change onstead. Thanks for clearing that up. Chris

Ive never come accross this statement untill recently so im not at all sure how to use it but is it possible to change the field a query searches using the Iif statement that references the results of an OptionValue Frame. If not not does anyone know of a way to change the filed a query...

Thaks once again for the reply. Thats a lot clearer now and im beginning to get somewhere. I guess its the same as any other IT development. It just takes a bit of practice. Hopefully in a couple of weeks i will look back and laugh at how a got stuck on such a simple task - Hopefully. Thank...

Thanks for the reply rob. Its basically what i thought. SO thanks for clearing that up. To set up relationships with referential integrity do the record therefore have to be unique? I have been trying to set up these kind of relationships however i have been having trouble with an error...

Counld somebody please explain to me referntial integrity and how it works in access or a least point me in the direction of somewhere that explains it better than Access Help. Im pretty sure i need this to keep my records in my tables up to date however when i to turn it on in the...

Thanks to colin and Bobby that has done the trick thanks. Also i have just been looking at the properties for the query and there is an option to slelect unique record. If this is set to YES then the DistinctRow SQL statement appear in the SQL. Does this do the same job as what colin has...

Thanks for the reply colin. I get what you mean by append. However i have two quetions. 1. Where exactly do i put GroupBy in the query? In the criteria collum? Or do i need to put it in to the SQL? 2. What exactly is the count field? Do i add this as a field in to my table? If so exaclty whatt...

I have inhertited a database that has been poorly designed. It contains a table thant has many duplicate rows (too many to delete by hand) IS there an easier way to delete duplicate values other than to scroll through thousand of entries and delete them by hand?

thanks for the reply. Could you explain a little more about declaring the forms as public declarations. Wher and how exactly would i go about doing this?

thanks for the reply neileg. Im already using the full names in if statments that are referencing the results of an optionValue frame. Im not using the ME.reference anywhere in the project at present. Thanks again for the advice PS aint it grim up north today??!!

I have a form that contains two check boxes that are held within an optionvalue frame. There is also a textbox whioch allows a variable search. The text box currently only searchs one field in a table. Is it possible to have the text box search different fields depending upon the result of the...

Thanks for the reply. All of the spellings are correct as the forms open perfectly under different conditions. Even if i open the Forms from a switchboard everything works fine. The only time i have a problem is when i have to open up a search variable form from another form. I cant undersand...

I have a strange problem and was hoping that someone out there had come accross something similar. Im sorry that this is long winded but im trying to give all the info i can as the problem seems strange to me. Ok i have many forms. for the sake of this example i have one form that has a text...

Thnaks for that both posts were very useful Cheers Chris

I have an option value frame and two checkboxes in the frame. I need the result of the selection to be referenced in a query. Eg if option 1 is selected then i need the query to search one field if option 2 is selected then i need another field to be searched. The problem i have is referncing...

Id like some advice of others with a little more experience with me with databases than me. Id like to know opinions on what you people see as good design methods. I think this question may come down to opinion but im sure both methods have their pros and cons. When designing a database I have...

I think that this is what you need. Somebody please correct me if im wrong In the form properties find the auto resize selection box and select yes.