Search results

For anyone who is curious, I did a bunch of 'testing' and any time a date variable or function was used anywhere in the code for the particular form it would throw the type mismatch error. This made me a bit batty - because it *should* work. I got around this by duplicating the underlying...

Going to give this a try - I'll report back ETA - Red text & syntax error. There seemed to be a couple ending paranthisis missing, so I tried adding those. That changed the text to black while editing, but back to red with syntax error at runtime. I so appreciate all of your help! -- I am...

Sorry - data type is Date/Time

I did - when it runs in the monthly report sub I still get 'type mismatch'

Thanks for trying to help - still throws type mismatch :(

I'm beginning to think this database is just cursed lol. I have tried many variations - using variables or dateserial directly in the OpenReport command. Every time it pitches type mismatch, yet it takes hard coded dates fine. Doesn't look like it. Should it be, if so where do I place it...

It breaks before then - on this line: defDate1 = DateSerial(Year(DateAdd("m", -1, Date)), Month(DateAdd("m", -1, Date)), 1) I have also tried using DateSerial within the Where section on the OpenReport function - same error "type mismatch"

FYI - hard coding a specific date within Where section of OpenReport function works correctly

Short Date

Output is as expected - LastDay 2/29/2020, FirstDay 2/1/2020

I'm trying to make a button that will open a report filtered for last month. I have been all over the internet and tried several different methods, everytime I end up with a type mismatch error. Here's the lastest attempt: Private Sub cmdMonthlyReports_Click() Dim defDate1 As Date, defDate2...

Hi, I'm sure there is a more efficient/eloquent way of dealing with my current issue. It's a small database and will work as is, but if there's a better way I'd like to learn it. I have tried to search, but nothing I'm finding matches my situation. I have three nearly identical 2-step...

I was given a huge mess of Excel files for what should be a simple ledger - so I'm trying to build an Access db for it, even though it's been over 15 years since I've worked with Access. General work flow: Once a month a check comes in that is for the previous month and distributed to the...