Recent content by burton

Query that searchs multiple tables Hi i siiting at my computer rakeing my brain trying to think of a way to make a query that will search 4 different tables for a certain name, , can anyone help or is this a hopeless quest, i welcome any feed back. Cheers Paul

how do i insert clock on my switchboard. (preferable an anologe clock)

i need help to do a password comfimation screen. Where they enter a password they click on a button this then takes them to another screen. this is supposed to confirm their password. but it actually changes the password. could somebody help me with this.

hi all. i have a database that someone loans out garden tools from. i need to search for a part of a field. because when i search for something at the moment you have to enter the full path. could someone please tell me how to set up a wild card search. what i can gather this is a search that...

hi my friend has this database which is designed for a theme park. this database is going to be used by employees of that theme park. so he has made a swithcboard called Managers and Supervisors. this is displayed when you go through some links. but he wants that to be protected by a password. i...

i haven't changed the table. it requires to much to do. im going to have to send the file to you by email sorry.

i have now created a new query called qry current unavailable items. this uses criteria "yes" on booked and "no" on returned. this shows all the items that have been booked out that haven't been returned. would this be of any help for the quest of getting a message box to work?

you would think that i have been taught how to do this but i haven't. the thing is i have attempted to change this but the files said it isn't a unique code or something. ii know that i have o change the file around. indexed stuff like that. but i can't do it because i think that it will wreck...

thanks for the reply. i have tried this out but it seems to have too many negative effects. i think that if i was to change from 2 tables to 1 would be a major change. i can't quite seem to get it to work.

thanks for taking a look at my database. i think i know what im supposed to do. but if i was to change the tblBorroweditems wouldn't change my project completly. what fields would you put in the new table? thanks for looking i thank you once again

to the previous post. i do not use anything like available and unavailable. i use returned. this indicates if an item has been returned

i have tried to cut the database down. but it is still too big. if someone wants to send me a pm with their email in then i could send them the file as an attachment in an email.

the file is too big even when i zip it. it is 1.24mb when zipped. that is too big to add to an attachment

if you want i could send you the file. because that way you would know how to update my database. i need to know your email address though. i can't use outlook because it doesn't work so if you send me a pm then i could send the file to you.

at the moment i use a combo box to select the item. if you want i could send you the file. and then you could tell me how to do it or send me the new file back. thanks for the reply.