Search results

hMmmm.. it's not going to be THAT easy. I have a problem with how i have linked my tables/queries together. Unfortunately I don't understand it enough to explain it.

usedate: Nz(DMin("[Filter_qFiscal]![tbl_stop]","[Filter_qFiscal]","[Filter_qFiscal]![tbl_stop] > = " & [Audit_Date]),0)

Hello. Did you ever make any progress on the bizarre fiscal month function?

I'm in a similar hell at the moment, but I found this link which should help: http://www.databasejournal.com/features/msaccess/article.php/3764206/Creating-Charts-in-an-Access-2007-Database.htm

Good morning raskew and gemma-the-husky. I was thinking the following sort of pseudo-code. Given “testdate”, determine year(testdate), and lookup the start of that fiscal year in a tbl_lookup. The one constant we do have is 7 days to a week. Determine how many “weeks” have elapsed from...

Wow.. it's working.. THANK YOU.

Man I wish I was that smart.. and rattle off the code like you do.. I need to change the code slightly to preview the report first. DoCmd.OpenReport "rpt_DataRpt", acViewPreview, , "[qry_DataRpt]![FiscalMonth]= '" & Me.qFiscalMonth & "' And [qry_DataRpt]![tbl_type] = '" & Me.qProduct & "'" ?

no both are strings. Dec-08 (qFiscalmonth), and Fabrication (qProduct)

Good so far, but if I have two fields? DoCmd.OpenReport "rpt_DataRpt", , , "[qry_DataRpt]![FiscalMonth]= " & Me.qFiscalMonth And [qry_DataRpt]![tbl_type] = " & Me.qProduct" So looking at this example.. What's the correct syntax? Dim strWhere As String Dim ctl As Control Dim...

I do not need anything fancy, but I'm at my wit's end. Given a report, and a form to enter my criteria, what is the simplest way to pass that filter to the report? I've read, I'd tried this and that.. and nothing has worked completely to the point I've erased the form and started over. The...

Thank you !!

I've having trouble doing something, and I've lost it somehow in Access 2007. How do I make the "main menu" (a form that I create with command boxes) load automatically when the user first starts my access application?

raskew -- "The START DATE for each fiscal month is the the first.." -- the words were mine. I have no idea how the months were created. When I first started, I was using Excel for the project, and my original plan was using a VLOOKUP function. I'm still using that table, that has every START...

It's definitely not too late. I'm really struggling with every aspect of Access 2007. Back in the day, I used to be halfway good at it, but I sure can't say that now. Preyzar, if you'd upload an example or better explanation, be glad to study it. Raskew, I totally understand your frustration...

I totally agree. I posted up a fiscal calendar for your review. (and I don't ~know~ that's it's actually the first whatever after or before the whatever -- I just know that I need to tweak the code a little to calculate it correctly.) FYI -- I originally started this project in Excel, because...

Greetings. I have attached a pdf of our fiscal months. For example, Jan-09 started on 12/22/08. I love all the VBA/formula work contributed, and have incorporated all of it into my current project -- unfortunately I do not understand all of it well enough to modify it for our fiscal calendar...

page break?.. maybe set up a special "last page" ?

OK, I'm really close. Just a little tweaking. bimmer5 originally stated "The START DATE for each fiscal month is the the first Saturday after the last Friday in the previous calendar month and the END DATE is the last Friday in the current calendar month." I'm at home, and not at work, but I'm...

Sorry, finally got it all figured out I think.

Ok, I've got the user-defined function working now. One question, since different companies have different fiscal calendars (I'm assuming), where do I tell my function where the start date of OUR fiscal date is.. ?.. Dim dteDate As Date Dim newDate As Date dteDate = DateValue(pdate)...