Search results

Thank you so much once again!

Thank you; that's great! But from the query, how do I call the function?

The query is intended to return backorder information for the previous 10 business days. The function is intended to determine what the first business day in the previous 10 is (there are no backorders on non-business days). The function uses two counters, one (datecounter) is by date, and...

I have a user-definied function in a module that contains a Do Until Loop that works backward to determine the start date. I also have a query that uses Between [StartDate] and Date(). Specifically this queries back 10 business days, and the function looks backward to eliminate company...

Will absolutely do. Thank you again.

Hooray! I found it... In the code: Case Is < 10 strMyDefaultValue = strMyDefaultValue = "000" & CStr(intPeriodMaxValue) The second = should be &. Just a mistype. Thanks again so much for your help!

P.S. I inserted a MsgBox after that section that tells me the value of intPeriodMaxValue, which in this case is 1. Perhaps this provides a clue.

Ken, I can't tell you how much I appreciate this. Obviously I am in over my head. I replaced the section from Set rs = ... to rs.close with the new code: Set rs = db.OpenRecordset(strSQL) If IsNull(rs!lastnumber) Then intPeriodMaxValue = 1 Else...

Hmmm, now I get "Invalid use of Null" at this line: intPeriodMaxValue = rs!LastNumber + 1 Should LastNumber be substituted? Thanks again (sorry to be a pain).

Thank you again. Unfortunately at the line Set rs = db.OpenRecordset(strSQL) I get the error: Run-time error '3061': Too few parameters. Expected 1. The "change these" variables are now: strMyFieldName = "RefNumber" strMyTableName = "SPRRTable" The SQL is now...

I do appreciate it!

It should definitely not exceed 100 in a month. Realistic max is probably 30 (and that would be rare).

Yes, it will be fine. Thanks!

The final result field (really the only one that matters :)) is called RefNumber. That is the one with the format 20080701, 20080702, 20080801, etc. Thanks!

Hmmm... maybe there's a much simpler way. The ultimate goal is to provide a RefNumber field that is the year, month, and then counts from one up. 20080701, 20080702, 20080703, ..., 20080801, 20080802, 20080803,...,20080901, etc. I actually got this code from my brother. I expected the SQL...

Please help me debug the following. The problem appears to be with my SQL statement, as I get the error: "Run-time error '2342': A RunSQL action requires an argument consisting of an SQL statement." Here is the code (with MsgBox added to help me keep track; both come out correct)...

Thank you both very much. It works beautifully.

i have 2 command buttons. Once one is pressed, an invisible flag is selected, the first button is made invisible, and the second button becomes visible and enabled. What method do i use when a record is loaded so that the flag is checked to determine which button should be visible upon later...

Thank you. Unfortunately the link was not particularly helpful to me. i am indeed trying to display subform records based on combo boxes in the main form. From there, i would like the user to be able to select the specific record and have it open yet a different form (which happens to be...

Hi, guys, i have a little problem. i have a form (called RDR Search) which is used to search for a specific record in a table by one of three fields: SupplierCode, PLNumber, or Date. There is also a subform listing these three fields below, filtered from a main table. The field opens to these...