Search results

sorry for not being clear. so, if Monday's a holiday, and I come in Monday then print-out is fri-sun (the query looks in the tbl_holiday if any holiday exists). tues printout would be is checking the tbl_Holiday and if exists, adds fri-mon I suppose another example would be is thanksgiving...

one more question, if Monday's a holiday how would the coding be to add that into Friday's totals? I currently have a table called tbl_Holidays where field one is called "Holiday" and the other field is called "Date". I was trying to see if the coding arnelgp first posted for excluding holidays...

thanks for the clarification arnelgp.

that is true, let me try that method.

^true but that requires a manual input which the idea was to automate as much as I can without interruption. im still a noob, but arnelgp, can you elaborate on some of your line coding please? what's going on here? is it just saying if it errors to not show a message? fncIsPrevious = False...

arnelgp, thanks! looks like it works. it's picking up yesterday's data. i'll follow up after this weekend when I run the query Monday, but this is greatly appreciated and thank you for your help!

I get a Run-time error 94: Invalid use of Null at line: fncIsPrevious = (d1 = DateAdd("d", -1, d2))

arnelgp, thanks, I did run across your posts and saw something like this but they were from what I thought, for excluding weekends. im fairly still new to coding please bare with me as I read and try and break down your code.

is it possible to be written as a query/sql or as a function?

yes, where if Monday then grab 'all' data (Friday-sunday) and if not Monday, but Tuesday-Friday to grab prior day.

I don't have the coding down currently, I apologize for that. so where I work, the business week is Monday through Friday but there is work that gets done on Saturdays and sundays but those numbers gets added into Friday's numbers. so come Monday when I run my database, I want to be able to run...

I searched around but did not find a solution or something similar to what i'm working with. what im trying to do is whether it would be doable in a query or better off in vba. the dataset i'm working with is a day old, meaning it'll always be yesterday's date and prior. and the work week is a...

hi everyone. fairly new to access and am in the process of capturing retail data where the work day is mon-fri but the weekend and holidays that fall on Mondays like labor day, the number o retails is totaled and considered to be Friday. I did a few searches and majority of the posts were...

hmm ok, thanks for the in depth reason why the original thought I had wouldn't had worked at all. yes, qry_ChkDate is the name of the query and it is pulling from a local table with just the date with no time included edit-how would the code look if add in a loop where after the else msgbox...

you the man :D Dim strSQL As Date strSQL = qry_ChkDate If DLookup("Date", "qry_ChkDate") = Date Then MsgBox "works" Else MsgBox "not today" End If curious on why DLookup would work but not the simpler idea?

I still get the msgbox "not today" the data type in the table for the date is Date/Time if that matters?

[SOLVED]Struggling with If then Else Date I can't believe i'm struggling over something that looks so simple but :banghead::banghead::banghead: Function Check_BA_Local() strSQL = qry_ChkDate If strSQL = Date Then MsgBox "works" Else MsgBox "not today" End...

Vlad, you're correct, sorry about that. I re-ran and the table still has the list box. I'm still wrapping my head around on how to design this. basically the premise is have a table that's uploaded to sharepoint for users to edit the "Plan/No Plan" field on various widgets each day. the...

I tried the delete * from my_table and it removed the field that I changed to a combo box?

Vlad, thanks for elaborating. my question is rather than manually open it in design view everyday, if it'd be possible to have it coded in vba so I can run it via macro via task scheduler to automatically run it? after figuring out how to change the column/field fo the Plan/No Plan, you're...