Search results

can you correct the formula accordin to the image. i am not getting it :banghead: please:D

here is the detail of the items on my form... 1: There is no Subform on the form 2: Form is based on MainTable 3: filteragent is textbox bounded to MainTable 4: cbo1 is a comboBox peresent on that form taking values from Agent_Name field on MainTable 5: Filter agent is Unbounded textbox on the...

I am trying to calculate sales of agents seperately in the database. For total sales the DSUM is working fine. But if i try to bound it to some criteria (specific aget name) it gives ?NAME? error. Here is my code i applied for value selected from combobox...

I have managed to do it. I just simply put the textbox in the header of the report and rest of the required in detail section and it worked like a charm. thanks for the comment but it was not what i was looking for.:)

I have created an access form and have different fields on it. I want the report to print values according to a specific fields (i.e NBC & PPT#) and data related to these field. For example i have a textbox named NBC and other textbox are related to that field. If i gerented report based on...

I have attached the database on which the code is not working. it on the form named Client Details

but how come it runs on one db but not other ?:confused::banghead:

but this same code is running on my second database without any errors... you can check the attached db file

i have an access code which is working fine on one database but when i apply that code on other database it gives an error Here is the code i applied on click to a button On Error GoTo Err_Handler Dim strPath As String ' open 'file open' dialogue and get path to selected...

how dumb i am. the trust center was turned off and activex was disabled thus no code was running :D thanks for the help

is there something wrong with my access settings? i have also dowloaded a search form https://access-programmers.co.uk/forums/showthread.php?t=99353 but none of its search controlls are working too. :banghead::banghead:

list is populated but results are not filterig. no matter which value i select from combobox the datasheet remains the same.

can you update the db file with the suggestions you are providing so that it would be easy for me to look where i have done the mistake.:confused: it will be so nice of you. thanks in advance:)

you can clearly see in the picture attached with this reply

i did but its still showing blanck :(

it didnt work on both textbox or the combobox. the values are now showing. can you change it on the db and upload >

now the list is showing nothing :(

sorry for late reply. i am attaching the database and there i have created two form and applied vba code on both of them to find a record with a combo box. but both of them are not filtering any data. kindly check them and let me know where i am missing something. thanks. main form with combo...

tried your code and its not working. after updating the button with the vba code now even the data is not filtering when i click on search.:confused:

i have created a split form and added a textbox to search for a particular data on the datasheet. The button on which i have applied a macro to search for particular data is working fine but it generates a problem. When i search for a text it displays the data in datasheet view but after...