Search results

Hi Does anyone know how to do a keyword search in MS access so in a knowledge tree with 100 of records with a few keywords in one of the main fields i.e. symptoms i can reduce the amount of records to go throught Many thanks in advance

Just like to say like the previous post, i have been doing a year long work placement on creating a database for my employees and i would of not of completed my placement had it not been for everyone here. Dont like to be cheesy but this forum is brilliant and i will try my best to keep all...

Hi i just wanted to say i have finally solved the problem, All this time i never thought of creating another shortcut and then editting the target. Just wanted to say thanks to everyone who helped i really preciate all the help thank you

hi i have been posting a problem i have been having with trying to open my database on the network once i used the security wizard. however i think i may used the wizard wrong and hence i am having problems tryng to open my database on the network. Could someone please if they dont mind in...

hi i have tried the mapping before and it still didnt work, I can not change the target on the mapping either. Do you think it is cause where i work we dont have a dedicatd server i am getting this problem. All the pc's here are all linked via a hub

any idea what i can do to change this then

hi many thanks for the reply, this is the problem i have noticed but cant do anything about. i have attached a screen shot of the three files that must all be linked togeather inorder for the database to work. The file in the middle(highlighted) i can edit the the target. but how it works for...

Hi just wanted to ask if anyone has any ideas why i have problem opening my database from another computer. we do not have a main server all the computers are all connected via a network hub somewhere. many thanks in advance for all help i have used the security wizard and set to open a...

hi what i have done is put the mdw file on the shared documents so anyone on the network can see it. I have added a screen shot of the error message i am getting when trying to open the secure database from another computer. I also just tried to map the folder containing the database which is...

thanks alot for the help really apprectiate it, worked a treat

Hi i have recently created a user group for my database using the security wizard. However once you create a user group the security wizard makes a shortcut to the main database. You have to use the shortcut to get into the main database. This is fine however i tried to use the shortcut from...

Hi i have recently set a security wizard where users have to type in their name and a password in order to get access to the database. Does anyone know of any code where you can show the name of the user on the main form. At present i have a username on the form but that is linked to the...

hi thanks for the reply do you know if it quite easy to do a password form so user have to type a password to get access to a form thank you

hi many thanks for the reply i am not really sure on how to do this but is there a way where users who can add new projects but can not add new parts. And vice versa thank you

Hi many thanks everyone for the help, i have a problem whihc i am not sure how to do. My database is a project management databae. to start a project you have to add the ptoject title, date, client etc. My manager wants to limit users from using the add part form so they can not add parts to...

Hi i am hoping to make my database secure so users can not edit the designs of forms or even tought tables. queriies etc I have had a look at the tools menu and tried using the security wizard but it is a bit confusing can anyone give me some tips many thanks

is there any any i can print on A3 as well as spreading the fields out to fit the page

Hi I have an order report form which due to all the headers needed for certain reasons i have been asked if i can do a report on A3 paper. Is there anyway i can do a report on A3 and change the setting so i can even out all the fields to fit on a A3 paper size many thanks kabir

hi thanks for replying, i have tried the compact and repair, and that worked fine what is a compile error. thank you kabir

Hi many thanks for the reply i tried to change it the way you said and all i get is a dialog box saying MS access can not create mde any idea what could be doing wrong kabir