Search results

hi, I am trying to select a value from one combo box and on the basis of this selection the other combo box show only those values which have link to the value I have selected. I tried to search few links but couldn't get a proper answer, could anyone please help me >> :confused::confused...

hi Paul, at last i have managed to print invidual customer report, i have ctreated an extra text box by referencing the combo box and then create a macro which pulls the control: e.g. [Nameofnewtextbox]=[forms]![frmname]![Comboboxname] sorted. :)

the below appears in the imm.windows when i press Ctrl+G The value that is obtained from the User is : qry_test_customer_Search

here is the code for the "Print Report" button: Private Sub Command4_Click() MsgBox "The button to open the report is Clicked !" & _ vbCrLf & vbCrLf & "Please check your immediate window !", vbInformation Debug.Print "The value that is obtained from the User is : " &...

thanks for that, I have added this code in the click event of the button : firstly if i don't select any customer name and click on report button it pulls the complete report for all the customers and even i select any customer from the list it still brings up the whole customer report which are...

hi Paul, a bit silly question but where should i put this code below the original code or above the original code ???? :confused: thanks

hi, after clicking on button another window appears asking for customer name which is not looking good and also it prints the blank report ??? >>> ???

hi Paul, thanks for the code, do i need to put this code into on click event of a button ???

hi, i am struggling to pull out a report based on the combo box selection. I have NOI database and want to pull out a report for a specific customer that how many NOIs are generated by this customer.. I have a sepatare table of customer and another table of NCRs and the customer information...

also the data in both combo boxes coming from the table where i created two different fields for checker and approver and user can select from dropdown combox which is added via lookup wizard. there is no query for these >> :confused:

hi how can i requery the Approver Combox, after adding the above query ???

hi how can i requery the Approver Combox, after adding the above query ???

hi, thanks for the code but which form should i refer to in <YourForm> ???

hi, i am totally stuck, actually i have two fields in a table one for created by and other one is approved by. the creater and approver list is same. I have created 2 combo boxes and what i need to do is that i don't want same person's name on both combo boxes. If creater is Mr X but he can't...

you can send e-mail with out coding by using macro sendOject.

Thanks but I also want to hide tool bars and manu bar when the user is logged in and all these should be visible to developer and also I don't know what's BTN stands for. If anyone can help ?? Thanks

Hi Thanks for the post as I said in earlier post that I have created the user login and responsibility table but I am not sure the coding to secure the database from different level of users. e.g. some users use just for view some use for data entering and obviously developer has the...

Hi, during research i have found that in Access 2007 you can't create user level security, so keeping in mind i have created couple tables for users and security permissions but not sure how can i apply these permissions on whole database.... ??? thanks:confused:

hi, how to clear the combo box after selection ???

Excellent ! thanks