Search results

Hello, I don't have a listbox. Only a text box in which people can write anything and based on that the subform(which shows all the records initially from a table) is filtered. One option group which has 3 options (opt number 3 being show all). What I want is to filter the subform using this...

Hello guys, Once again I hope you will help me as usually happen. I have the following situation : - one form and subform ( set to start and show all records - datasheet style) - a textbox that filters the subform based on what is written in it ( more exactly matches what is written...

How to do that since in the after event of the entire option group i have it set to True and to filter based on the selection. And since my no 3 selection(the one that should show all) - must have an option value ( default to 3) and the script only works one way by filtering based on the...

Hello, Thank you guys,especially John Big Booty. Worked beautifully. But: How to do if i want in the option group to have the option to see all again ? Meaning when i press third option - "shows all" - the filter to be set to False and show me again all the records? Regards, ===...

Hi, Do you mean the click event of the frame or the click event of each option from the option group (I have to ask just to be sure). Regarding the value, honestly is not important since that column will not be visible in the subform. Regards,

Hi, Thank you for your fast reply. But since I'm far from having a real grasp on vba and access - I'll repeat to see if I understood well. So I need to insert your code into the option group frame after update event? (the option group is found in the main for as is seen in the dba attached...

Hello, Any solution how I could insert everything in the option group frame event? Thank you.

Hello, Please find attached the database i'm working. It's not the complete db,i removed what is not connected to the situation presented. Thank you very much for the help.

Hello, On the frame events i've used the code :( and wasnt able to make it work. It's like nothing happens. regards,

Hello everyone, I'm trying to use an option group to filter a subform from my main form. I did try some scrips behind the option group Afterupdate event but i'm not able to make it work and actually filter the information shown in the subform. I managed in the end to kind obtain what i...

Hello all, Meanwhile i managed to find a solution to obtain exact what i was looking for ( using recordset and ActiveInspector ). Please find below the code for anyone that will find it usefull: Private Sub Command93_Click() On Error GoTo Err_Command93_Click Dim Email As String Dim...

Hello rdub, Worked great. Thank you very much for the help - maybe soon i"ll have a better grasp on late binding and be able to figure out alone this types os simple questions. Here is the code for anyone interested: Dim myEmail As Object Dim objOutlook As Object Dim SaveEmail As...

Hello all, I really need your help to convert this script that i put together and tested (works ok),but in late binding since the users have different versions of Outlook and right now it works only with outlook reference activated. The code does a simple thing - takes the current opened...

No ideas how i could make my from thru VBA to past my recordset to the To or CC of an e-mail already opened in taskbar ? Right now i'm able to copy my recordset only to a new e-mail that i create thru VBA ( Set objOutlook = CreateObject("Outlook.Application")). Hope someone will know how to...

Hello, The above code is working fine - the problem is that it creates a new e-mail in outlook where it paste the recordset. I want the recordset to be pasted in an e-mail that i have open in the taskbar. For example: i recive an e-mail ,i hit reply and after if i hit the form button -...

Hello all, I need your help in accomplishing the following thing: - i want to be able to paste a recordset in an existing(opened e-mail) Right now i have some code that accplishes a part of this - i paste the recordset to the "To:" of an e-mail that is created. I want to open...

Hello, Worked like a charm - thank you a lot for all the help :). I will post my code for people that look simmilar things - all of it is tested and works (at least in 2000-2003 ) Private Sub Email_Click() On Error GoTo myError Dim varWhereClause As String Dim sql As String...

I'm Asghaar. I've been working for about 1 year with access and now i had to step to the next level and do my first "application" ( don't tell the people at my work that those are just some forms:) ). In my searching to improve and find solutions for different problems i stumbled across this...

welcome to the forum m8:)

Hello and welcome, I think most of us found this site searching for ways to improve our code/forms etc:)