Search results

I have a database that has the basic tables of products, accounts and orders. I need to figure out how to deal with returns. Do I create a separate table and link that to the orders table for returns? I haven't made such a large database file so I was curious if anyone had any information...

I'm sure making a mess of things today.... I deleted my message but the attachment is still in one of your replies to me. How do I get rid of it? Thanks.

Bless you and thank you for sticking with me and helping me figure this out.

well dang..... sorry about that I did run in the immediate window: ? Plusworkdays(#12/24/2007#,2) it correctly gives me 12/27/07. But when I open my form: and type in 12/24/07 on the orderdate, when I tab to invoicedate it goes to the vba code and highlights those 3 lines again. I'll go...

I had changed the table name before having these things happen so it's still not picking things up. It seems to go over that last line. is dd supposed to have the / \ surrounding it? (I know little about this so just curious.) Thanks!

Breakpoint is still on there. I typed in the immediate window: ? Plusworkdays(#12/24/2007#,2) And it highlights the same lines again where it has the breakpoint. If Weekday(PlusWorkdays, vbMonday) <= 5 And _ IsNull(DLookup("[HoliDate]", "tblHolidays", _ "[HoliDate] = " & Format(PlusWorkdays...

My table was named Holidays but I just made a quick copy of it after reading your code and name it tblHolidays to match it. My other fields on the tblHolidays are HoliDate and HolidayName. HoliDate is a date/time field but I don't have any formatting set on it. Didn't know if that could be it.

I tried the form again and when it goes to the code for the error it points to: "[HoliDate] = " & Format(PlusWorkdays, "\#mm\/dd\/yyyy\#;;;\N\u\l\l"))) Then

I clicked and added a breakpoint..... It selected all of this (is that correct?) If Weekday(PlusWorkdays, vbMonday) <= 5 And _ IsNull(DLookup("[HoliDate]", "tblHolidays", _ "[HoliDate] = " & Format(PlusWorkdays, "\#mm\/dd\/yyyy\#;;;\N\u\l\l"))) Then

That helped! I have holidays listed in my holiday table.... tblHolidays 12/25/2007 (is in the table) It works stupendously adding the additional days for the Saturday or Sunday date! woo-hoo!!! but it's not picking up the info. in the holiday table. Any suggestions? Thanks! (I did paste...

Yes, I did copy/paste it. (I checked it again to make sure no space too.) The name of the module I have saved is PlusWorkdays. I copied and pasted the code into that. (didn't change anything.)

same error Compile error: expected variable or procedure, not module.

(Thanks. I won't be offended at all as this is all completely new to me with the modules and all.) I typed in the immediate window for the PlusWorkdays module: (hopefully this is correct.) ? PlusWorkdays (12/11/2007) and it gives me: Compile error: expected variable or procedure, not module.

Thanks a bunch. I appreciate the help. Can you tell me what I'm going incorrectly? I put the code above into a module and named it PlusWorkdays. Then I put the AfterUpdate event on the OrderDate control. Nothing happens....... do I need to put the code somewhere else? Thanks.

I have created the tables and module following the instructions on microsoft's page. http://support.microsoft.com/kb/210064/en-us The Module is: Function OfficeClosed(TheDate) As Integer OfficeClosed = False TheDate = Format(TheDate, "dd/mm/yyyy") ' Test for Saturday or Sunday...

worked perfectly! Thanks a bunch!

Just need some quick help in clearing up something.... I have a form with the follwing....... OrderDate default value =Date() InvoiceDate control source =[OrderDate]+2 DayoftheWeek control source =Weekday([InvoiceDate]) ActualDateofInvoice control source...

I think I figured it out for now. Moving on to figuring out how to avoid the holidays!

or another option.... What about something like... If InvoiceDate = 7 or InvoiceDate = 1 Then (What do I do with the then part of it.....I'm stuck on that also.?) Thanks!

I have a question regarding something similar. I have an OrderDate field that automatically puts in today's date. I have an InvoiceDate field that has an expression for it's default value =[OrderDate]+2 I need to make sure the InvoiceDate does not fall on Saturday or Sunday. Being new at...