Search results

Can anyone help me in the right direction. I have created 2 filter forms but i am required to build a more complex filter form for the entire database. I have created a form with Field,operator,value, logic I am trying to create a 3 level filter option. Narrowing down the search to the...

Dynamically search multiple fields I have got this code and used it to create a search filter. It works but for the first item. How can i create a loop to work for all the items on the list box. 'Create a string (text) variable Dim vSearchString As String'Populate the string variable...

Thanks to this forum i have been able to create 3 combo boxes that work to filter some values in my form. I have 3 -4 combo boxes like cboname,cbostate,cbocompany etc. My next attempt is to have a list box which has row source bound to a query. I have some variables Firstname State...

:(I have 3 combo controls on my form. Each combo box row source has a select query eg. cbocompany rowsource = SELECT tblcompany.CompanyID, tblcompany.CompanyName FROM tblcompany; I have a form which has the values based on a query Recordsource is bound to a query When i click on company...

I need to create a one resuable code to be used filter various forms in my database. I had selected all the searchable fields put it in a table and then search the forms using a query. Could anyone help me with the direction of how to go about doing it. My idea is to be able to populate the...

I have finally figured out my visio data org. charts and the output is saved as tabs. Basically they are company organization charts with each tab representing a company. I have created a combo box based on a query which shows all the companies. I want to be able to do the following. 1) when...

I have a table Org data attached as pdf. in visio when i run the wizard i get what i am looking for and based on the report to id i get my organizational chart. Can i automate this process in access. we run the access run time version for users and no one has visio software to work with. So...

i have a form has a text feild control which records all changes made to the form values. The form gets values based on the employee table. so if anyone changes the records it creates an audit trail of values. A code i got from this forum. I want to be able to copy these values into an audit...

I have 3 tables tblprojects projectid projectname tenderid value tbltender tenderid value tblleads leadid leadcategory value tblprojects and tbltender are linked with tenderid and i can create a query to extract the data tblleads is stand alone and not all leads convert into a...