Search results

oh ok thanks been staring at this until i was cross-eyed helps to have another set to look thanks. I was also able to get that working as well.

One more problem maybe you can help me on Bob on the same DB if you pull up the qryEmployAtt and try to add more than 1 field i get an error message i am not sure what i did wrong there either. Thanks again for your help from before.

Thanks Bob works great.

I can and here it is but it is in 2007 since I am using the attachments feature I can't downgrade Don't worry about the data as it is all dummy info.

I am still not having any luck with this code I have changed it a little as i changed the FName to txtFName and changed it to a combo box I also got rid of the LName control and as such adjusted the code to reflect this. The problem I am coming across is nothing happens when I press the Search...

Currently I have a search form that has 2 fields First Name & Last Name both in a combo box. First would it be easier to just have the one Box and title it name? Since you can see multiple columns or leave it as is. The other problem is that when i add the code below to the Click event...

Ok I added the follow code to the on_Click and it doesn't do anything I tried usiing the dummy names i set up and just leaving it blank but nothing is happening am i missing something? I have the FName and LName bound to a query but even making them unbound it still not searching. Please help...

I would have named it that but already had one named frmEmployData. I was also looking at doing a seperate search form as i wanted the search to put the info on 2 forms both frmEmployData & frmEmployAtt. Unfortuantely I dont know much about coding and I am thinking that is what i will...

Sorry I attached the first version you had done and saved the other in another area this one should have the fields

@vapid I have been looking at the DB you had setup and made a few changes before I start one, but i cant seem to get them to work would you mind taking a look at it and letting me know what I am doing wrong? For the search form I am trying to get it to search for FName & LName but then to...

Being a newbie at all this i guess i am just getting a little confused with it all. I probably know how to do this but drawing a blank. How do i bind the form that is already made to a query? Also if I bind the form will it still allow me to add new information? I already have the search...

ok but what about the other part? getting the query tied to the form

the data mode is not set on the search form but on my switchboard that has a button to add a student and that macro has the mode set. Would that still cause a problem?

Ok I am using Access 2007 I have 2 forms that I use to add employees and also display all their info. I have also made a search form and a query to pull the results. What i am trying to do is to attach the query to the forms as well so that I can still enter the data but if i need to search it...

ok another question for the sample you put together I want to be able to setup a search for the frmEmployData. I made the query but how would I attach it to that form and to another i had made that is pretty much a duplicate of the original but with another table called tblAttendance. I want...

i do as were mine

yeah i have been there done that. Like queries are uneditable if you use them :) I was also trying to look at the subform you created in the DB but it only lists it in a box that says Table.tblNotes any way to view the details and properties of that?

well whats the point of using the newer versions if you dont take advantage of the upgrades

i no 2003 is preferred but was unable to do it

I have a form that I am trying to have a combobox that once an item is selected from it. It will only show items associated with it. I setup the second query but cant seem to get it pull the rest of the info or even get the combobox item to stick please help. It is attached please help