Search results

i have managed to get a set of text boxes to show the results of the query but it only shows the data on the record that is chosen in the little record box at the bottom of the form :( . is there a way to syncronize the number in the record box of my subform displaying my table and the number...

I am making a from that has a set of combo boxes that allow the user to search through a table. the results are displayed in a subform / subreport window that is set to a query. the search works by changing the SQL of the query. I have spent weeks on getting this far and i have decided to just...

no i didn't read that thread. my searches of the site didn't throw it up. Thanks for the pointer though :) it seems to be spot on and should solve all my problems. CHEERS mate

Am i using this the right way ? i have tried to use the Nz statement but it seems to do the same thing with the combo boxes. this is the SQL view of the query SELECT enquiry.[Taken By], enquiry.Client, enquiry.Status, enquiry.[Enquiry Ref] FROM enquiry WHERE (((enquiry.[Taken...

sorry for the repeating of a previous thread but i have looked at all of the replys on the first combo box controlled query and have followed what was reccomended but i still have some problems. :( i have three combo boxes and i want to query a single table with the selected combo options...

what does the path you have look like i have an idea as to how you could get the file name

i Am new at VBA and i have a basic understanding. I am trying to find out if it is possible to write code that would reffer to a given lcoation and store the file names in that location into an array. i am planning on using the names in the array to populate a combo box. and then use the...

I have realised that the way i am directly putting in a query to the subfom is not the best way to do it and that i would gain more controll by putting in a subform that contains the query instead. i was just setting the sub forms control to a query. that is why i didn't have the subform...

i have just found that if i don't enable the subform the user cannot select anything on it (obviously)which is undesireable. but on the upside is that if the user scrolls the mouse wheel the text boxes data cahnges to diffrent rows in the query?? :confused: perhaps i could use this because...

I am using VBA and can't find the current event for the sub form . Is this just a VB event? i can only see the on enter and on exit events. :( here is the code for my combobox selection and update of the subform and text boxes. Private Sub cmboStaff_Change() Sm = cmboStaff.Text...

I am new to this and i may be going about this the wrong way but what i am doing seems to do the job until now. I am making a form that has a combo box, a few text boxes and a subform\ subreport on it. The idea is that the first thing a user does is to select a name form the combo box. this...

thanks guys ill try that out

Hi all im new to this and im trying to make a from that will display a sub from containg infomation that can be changed by altering a combo box. im not sure if its possible but i want to have the combo box containing names of people and then the sub form to display records that relate just to...