Search results

Thank you. This was my original request for help: "Could you help me to figure out how can I filter by month not only for the current year but for past years as well? I have tried but without a solution." the original post carried a code which only filter the current year (2018) month by month...

Thank you, but how would you that code to filter by month but with year as well, per example if you have Nov, 2017 records and Nov, 2018 records how can you filter them? Me.subfrm_Invoice_Tracking.Form.Filter = "Month(InvoiceDate)=" & Me.cboMonth

I have use this ones, but they did not filter: Private Sub Form_Load() Dim strItems As String Dim intI As Integer For intI = 0 To 150 strItems = strItems & Format(DateAdd("m", intI, #1/2/2016#), "mmm-yyyy") & ";" Next intI '/ Remove end bits strItems = Left(strItems...

This is how is set: Private Sub SetUpMonthFilterCombo() Dim tmp As String Dim i As Integer With Me.cboMonth tmp = "0; < Clear >" For i = 1 To 12 tmp = tmp & ";" & i & ";" & MonthName(i) Next .ColumnCount = 2 .BoundColumn = 1...

It's a number.

Thank you plog, but I have done it with Month([InvoiceDate])=Me.cboMonth, it did not work not even filtering the month nor the years when click in months.

Hello, Could you help me to figure out how can I filter by month not only for the current year but for past years as well? I have tried but without a solution. Thank you. Private Sub cboMonth_AfterUpdate() Dim dates(1) As Date If Me.cboMonth = 0 Then...

OMG! Thank you so much missinglinq! finally worked.

No I am not receiving an error message, I am using it in the current event. but is not behaving well, It is a continuous form. Thank you for helping.

Thank you Ridders, but did not work...The one I submitted does it, but it does not stay gray out, it just flash it and go back to showing the field with value enable again when I change to another record If Me.[Position_Status].Column(1) = "Closed" Then Me.[Position_Status].Enabled =...

Hello, I just can't figure out how to grey out the combobox when value chosen is "closed". combobox is set to have a value list in the resource type and the resource is "Open", "Closed" If Me.[Position_Status] = "Closed" Then Me.[Position_Status].Enabled = False Else...

Yes , indeed, I did.

Thank you for the tip.

Hello, Could you help me please? I have a problem with a if sentence and a query: I need to pass the POSITION.OldValue to another table but it is getting the new value instead. Private Sub Position_BeforeUpdate(Cancel As Integer) Dim str As String If Me.POSITION.OldValue <>...

I have a question on how can I filter fields from Subform to a form in a query, also does anybody know the format to use as numeric field in a query, like # for Date? Please help. Thank you. ID is a numeric field that is in a Subform called subfrm_GCDS_Operations_Positions_Fills_Log_New1, The...

Right! Forgot, here it is: If Me.LeavingGroupProfile.value = 3 Then Me.Reason_for_Leaving.Enabled = False Else Me.Reason_for_Leaving.Enabled = True Me.Reason_for_Leaving.Requery End If need to add the ID instead of the name of the item.

Thank you Frothingslosh, I was able to figure out what I was doing wrong, fix it.

Access 2010, I am trying to disable "Give back" if I select it from the combobox, but is not working now, before it was because I was using a List, but I am using a query now, any help will be appreciate it. If Me.LeavingGroupProfile.RowSource = "SELECT tbl_LeavingGroupProfile.LeavingGroupID...

Thank you, Field Type = Numeric Long Integer I did not think about it 60 minutes = 1 hour I was thinking more to enter as decimal 1 hour means = 1.0 or 30 minutes = .30 I will try what you have suggested. Cheers!

Thank you for your reply, the data collect it from that textfield is bound to a table, I should use before or after update instead of click, my bad, by hour or by minutes if I enter 1, good questions, do not have the answer to that, maybe just enter decimals values like 1 hour would be...