Search results

Gina, Thank you, this is working perfectly :) ........ In that case last question, If I have a combo with a value list of 2 or 3 or 4 option to choose from, can I use the select case option or how would I have to do it?

Yes it does. But if I want to see only records with date field empty, it doesn't work.

Yes that's right. Or something like: 1: date 2: no date If left blank nothing selected, assume not to filter and show both. Thank you

Thank you, it works, filters all records where value is not null, Any chance you could modify the code so it filter all Is Not Null records and Is Null, depending on selection in the cboIsClosed? Thank you

thank you. Im sorry but I am unable to follow your directions. Can you please give more advice. My current code is: in the RowSource: *;"Closed";IsNull;"Open" in the code: If IsNull(Me.cboIsClosed) Then strWhere = strWhere & "([qaCloseDate] = True) AND " ElseIf Me.cboIsClosed = "" Then...

Thank you. I can't use actual values as this field is a date field. I just need to filter records where value=true or false.. Is that possible?

@llkhoutx I am lost, can you please advice what exactly is "YourColumnName" ??

What do you mean by "columnname" If my values were entered into row source of that cbo, there is only one column. I didn't know those can have a name, and here to look for it?

Hello Again, I am using this code: http://allenbrowne.com/ser-62.html works excellent for me, but I need to add a combo with value list (only 2 items) and will be singular selection. I have type in those 2 values in the cboTaskType row source, and then tried to use this: If Not...

Thanks for that. I am a bit lost, so 1. do I leave my current relationship between table user and department as it is? 2. do I make any changes to my current table fields structure?

Try in form properties, data sheet, allow addition = no Or Private Sub form_beforeinsert(cancel as intiger) Cancel = True MsgBox "You cannot add new data to the form.", vbInformation, "Permission denied." 'You can also add here select focus back to this field. End Sub It's from top of...

I would create a form based on table mother and add a subform with this single field from table children. Then when you save, all records should update.

Right, How would relationship change after this? I have table t_user and t_department. They have a one-many relationship. In my understanding, you suggest to create another table that will hold FK for userID and departmentID. Will my current table t_user store any value in deptFK field after...

Hello, I am trying to resolve a problem with selecting multiple records. I have a table called T_user and bound form called F_user. This form displays all 3 fields from that table. When I want to add a new user, I enter a name and select a department. Some of the users work for few...

Hi Gina, Any chance you had a little bit of time to look into this? Thanks

it works!!!! It's alive, it filters everything!!! I am soooo happy, Thank you Gina :) I re-applied the code from Allen Browne website, you've posted on the first page. I just don't understand why it didn't work in first place. I can think of 2 possibilities, 1. I have commented too much of...

I have done this so far... (see attached) and got stuck at cboSeverity (and other yes/no fields) I am not sure how to define rowsource, it needs to be something like -1:YES;0:NO at this stage (I hope) we can slowly come back to the topic of this post :)

@RainLover. ???

I left the file at work, I'm guessing I will attach it tomorrow. In the mean time, you have mention a while ago, that I don't have any modules. When is it good to have separate modules and when is it ok to just leave the code in the builder?

Ok, in that case, I will try to put it all together and post a sample tomorrow for you to review. Thank you for continuous support and advice.