Search results

It is to check every 5th of the month data that will be expiring in 3 months, that's the query I need, but I think I cam work with TheDBGuy criteria: Thank you everyone! [EndDate] Between Date() And DateAdd("m",3,Date())

@Gasman return the last 3 months no data expiring in 3 months from today's Between DateAdd("m",-3,DateSerial(Year(Date),Month(Date),5)) AND DateSerial(Year(date),Month(date),5) @ theDBguy Return an empty table [EndDate] = DateAdd("m",3,Date())

Thank you so much! That's closer...It returns from May 31st 2019 through July 31, 2019, which is correct on that query, but to return the data expiring in 3 months would be data for July 31 st showing only, how can I do that to view only that data?

Hello, Looking for a criteria to pull data that will be expiring in 3 months from every 5th of the month. All that I find is to pull past data: Between DateAdd("m",-3,Date()) And Date() If I do: Between DateAdd("m",-3,[EndDate]) And Date() Will pull data from the end of may 2019...

Hello Everyone! Just to keep you post. What I needed to do was to build a Form and not use the subform, I create a form where I add the New data, in the other hand I build a continuos form which I added into the Main Subform, so I can edit the new data from there instead going back and for to...

MajP After searching more info realize why was giving all null, What I am trying to do is to pass some values from a Subform to another SubForm, but in secod Subform it need to pass on a new record with a click from Subform A. I am still searching for more info about it, also I was wondering...

Hello, Hope you can give some ideas, because I have tried to find one and no success. I have to Subforms (A, B): I have data on SubForm A I want to pass to Subform B but this is how: 1) SubForm A I have a combo box which filter the data I wan to pass to SubForm B 2) after filter data in...

MajP sorry the private Sub in form A is below.."frm_B"... not "frm_A"

@theDBguy I did this way: Debug.Print Nz(Me.OpenArgs,"Null") printed: Null with the same error pop up.

MajP, I did declare the array, both ways as variant and as String: Dim varSplitString() as Variant Dim sSplitString() as String same error

The line Which gets the error is: varSplitString = Split (Me.OpenArgs, "|") I switch for a String as per MajP, but gave me same error message: Run time error 94 Invalid use of Null Also changed for : Dim varSplitString() as Variant But, same error.

@theDBguy This was my open args: Form A: Form B: Error Message: Run time error 94 Invalid use of Null

Thank you all, I will recreate the open args I did, and follow the rest of your advises, keep you post soon.

Hello, Hope you can give some ideas, because I have tried to find one and no success. I have to forms (A, B): I have data on Form A I want to pass to form B but this is how: 1) Form A I have a combo box which filter the data I wan to pass to Form B 2) after filter data in Form A, It has a...

Yes, that's exactly what I did but still not working....I'll do some more tests, I'll let you know.

No, did not work same error, I'll keep trying. Thanks.

Within the forms, you find two subforms when open frm_PartnerNetwork_AgencyMasterlist, then if you stay on tab "Agency Masterlist" start passing records, will recreate the error, see before when I was able to add data for ID 3 and ID 4 on Customer Specific, now I can even pass the records on...

Sure, I can.

Hello Paul, What is the data type of "Field"? = String What values are in the Tag property of the two controls? = String Me.ID= Numeric Edit: and what line throws the error? This line for both Width and Format, it throws Null on Me.ID and "" Me.CD1_Width Private Sub Form_Current()...

Hello, Hope you can help me to figure this out, had tried everything I know and nothing works, keep giving Nulls, It was working before, but then start giving nulls. Private Sub Form_Current() If Me.NewRecord Then Me.lblRecordCounter.Caption = _ "Record " &...