Search results

Thanks for all your help, Im able to hide all tools that can change the form so that users dont have that option. I just showed the complete form to my boss and now he owes me lunch. :)

Thanks a lot Bob, Appreciate it!

Hello, I was wondering if anyone knows how to make the front end of a split database secure so that when opened, the user cannot have access to changing the design or code. I pretty much need it to follow the same format as the file attached below. Does anyone know how to do this. Thanks for...

Hey bob, I tried to split the databases but for some reason when i did they dont seem to actually work. I used the method within this link for Access 2007 http://support.microsoft.com/kb/304932 when trying to complete searches within the forms on the front end or back end they dont work. is...

Great info thanks! So what steps would have to be taken? Create a frontend for users Email it to them or store it on a shared network?

Im sorry because Im fairly new im not sure how to deploy a MDE or ACCDE file to the end user. Will it be accessible through an icon without showing Access 2007 running?

The user would have access installed.

Oh ok I understand. So what I really am trying to accomplish is creating a "frontend" for users to have access to. If i did create a front end, would user still have to open access than the file or can it be opened through an icon on the desktop

Thanks Bob, Im a lot less confused about the different formats and which would be acceptable for a executable file. The thing is im still stuck on making it into an executable file. Is it possible I can get a step by step list of how to go about this? I would be very grateful. thanks,

Hey guys, Before anything, Im fairly new to access so I apologize in advance if I dont understand something but,I tried doing some research on google and on this forum to make an access file executable. there are a couple things Im confused about As of now, I have a file that has a form and...

thank you sir

Hey guys, Does anyone know how to make a file executable without opening access so that it would just be an icon that sits on the desktop? Thanks!

Sorry I wasnt aware!

I actually Dont need to do that last part but I really do appreciate your help! by any chance do you know how to make the file executable without opening access? I will post another forum for that But you seem like you have extensive knowledge with Access.

I just saw the re attachment and it looks great! Is there any way so that the subform doesnt display all the items unless it has been searched?

Because this is my first project using access im still new to some of the terms and tools. So let me get this right. 1. Remove the Link Master Fields and Link Child Fields properties from the subform 2. Remove the "On Click" event for the search button & replace with: Me.Query1_subform.Requery...

Hey James, So I tried the * way and it didnt seem to work. I guess it would be easier if you saw exactly what im trying to do which is why I attached the file below. My main goal is: If there are two categories in a query, "people search capabilities" & "technical People" and the user...

I tried it and It didnt work. I think its because now the subform isnt linked to anything in particular so it just shows everything. Its as good as looking at the table. Attached is the Form im trying to build.Maybe it might be easier to figure out exactly what Im trying to accomplish if you...

I understand but is there any way for it to show all the relative fields that pertain the word "people" in it? Almost like a keyword search that shows all the relative items.

As of now, Whatever I type into the MAIN FORM text box in the SQL is the primary search. I would like all the results to appear in the subform. So for example, If i type in "PEOPLE" into the main form text box, I would like all possible hits, "PEOPLE search" & "technical PEOPLE" to show up in...