Search results

I think you would want to join the two tables on the Date fields and then pull in your FiscalWeek. Galaxiom's suggestion is probably the preferred method here. If the fiscal year follows some sort of repeating logic you should be able to write a function.

Have you tried to join the two tables and run a Select query to make sure that your Date and Week fields are able to be joined? After that, once ProductionDate is populated on the form you can write a query to update ProductionWeek as FKWeekOfFiscalYear by using the ProductionDate displayed on...

See my edit. Undesirable means it doesn't work. My previous button is always disabled and my next button is not disabled when it should be. I tried Recordset with the same results. Edit: I'm sure it's clear by now that I don't understand the fundamentals of the problem, so I hope it doesn't...

Setting it to RecordsetClone produces undesirable results. I don't know what other options I have in that regard. Edit: From what I understand RecordsetClone is a copy of the underlying record source for the form? So, if the results in the record source somehow don't match the Form's...

I cannot get it to work when I declare the recordset variable. I am unable to add the DAO 3.6 library as a Reference due to a naming error, if that makes a difference. Code: Private Sub Form_Current() Dim rst As dao.Recordset 'On Error GoTo Err_Next_Record With rst If .AbsolutePosition =...

The code is "working", but I need to modify it so that when I'm on the last record I can't navigate forward, but I can add records and I can navigate backward. Edit: I just ended up using my own buttons. Problem solved. Thanks!

"You use Recordset objects to manipulate data in a database at the record level. When you use DAO objects, you manipulate data almost entirely using Recordset objects. All Recordset objects are constructed using records (rows) and fields (columns)." I would assume using Recordset allows the...

I'm sure that would be work just fine. What code can I use to determine if I am on the last record? I tired this yesterday, but could not get it to work: http://www.access-programmers.co.uk/forums/showthread.php?t=104478 My VBA is mediocre at best. Edit: This is the code I'm using...

I've spent far too long searching for the answer to this. On my form's onCurrent event I want to check if I am on the last record and if so, disallow navigating to the next "record" which is blank. I'm not sure why Access will let this happen to begin with when selecting Next Record. Isn't...

Yes, didn't make a difference. The white space issue is now the least of my worries. Now, I just need the form to requery the checkbox on record changes, so that it will hide the unneeded controls. Here is the code for the checkbox. It's working fine when selecting and deselecting. I just...

I tried the rectangle, but it didn't appear to "absorb" the controls. I put the controls within its boundaries and then hid the rectangle, but the controls remained.

I have a checkbox that determines whether or not to display certain form controls. How can I also hide the resulting white space that comes from hiding the form controls? Can I put all of the controls in some sort of container and hide the container? The form objects are all displayed in...

My edit from above: I've gotten it to work albeit in a silly way. The first query remains the same as my OP: SELECT DATE_ID FROM CALDATE WHERE (((DatePart("w",[DATE_ID]))=DatePart("w",Date()-1)) AND ((DatePart("ww",[DATE_ID]))=DatePart("ww",Date()-1)) AND ((Year([DATE_ID]))=Year(Date())-1))...

This will get the first day in the series, but I'm having trouble combining that with the last day in a between statement, so that I have a total of one week going back 7 days from the same weekday as yesterday, last year. My users apparently aren't worried about the query not working for the...

Will this run into the problem lagbolt described for the beginning of the year?

This would explain why I was having trouble grasping what they were asking for.. The date file is one our datawhse team has put in place. It stores Date, Week, Month, Quarter, Year, and Day of Week (e.g. Sunday). It's quite helpful in a lot of cases where writing Date functions causes time...

I'm not sure why I'm having such trouble here. Last 7 days this year is no problem, but now I need those same days for last year; the caveat being that they must be the same Days of the Week, so they are comparable. If Yesterday = Wednesday of Week 38, then for Last Year I will need...

Well I went through I changed it to .accda > went to VBA window > Tools > References. Then I had to browse to find it, however the only available "add-in" extension was .mda. Since it did offer the ability to add an actual .accdb file I chose one of my other databases and added it. Then I was...

I think there would be a different file extension. Unfortunately, google isn't helping me find it.

I just need to access my user-defined functions in all new or old .accdb databases. In Excel you can save them as an add-in or possibly to your personal workbook, but how can I do this in Access?