Search results

Well you can count the number of working days and subtract the holidays from it? Have a table that defines the holiday dates like the below: HolidayID - HolidayDate 1 - 12/25/2012 2 - 1/1/2013 Then do Dim DaysToSubtract as integer DaysToSubtract = DLookup("count(*)", "holidays", "holidayDate...

Why do you need a dlookup in a control source of a text box? Either run dlookup in VBA on open or on current OR change the textbox to a combo box and embed a query in its row source.

If you're not storing any info about the trucks (driver, VIN, number plate etc..) then you won't need a table for them.

Sure, and if you want to use a fork to cut through your rare steak you can also do that but is that what it's meant for? PS: not agreeing with my suggestion doesn't grant you the right to call it foolish

Sounds like a messy situation. If you're getting the info from a linked table to an external SQL DB, then you can't really touch it. What you can do is use that table as a temporary import buffer sort of thing. Create a new table that you can control with the right fields and that's where you...

Ok I found an even easier solution to this :) Dim i As Integer, iPrevious As Integer, strNames As String, tempName As String strNames = DLookup("column6", "table1") 'add a trailing semicolon to check end of string later If Right(strNames, 1) <> ";" Then strNames = strNames & ";" End If i...

First you define the below function in a module Function GetNetWorkDays(startDate As Date, endDate As Date) As Integer Dim objFunction As MSOWCFLib.OCATP Set objFunction = New MSOWCFLib.OCATP GetNetWorkDays = objFunction.NETWORKDAYS(startDate, endDate) Set objFunction = Nothing End Function...

You can download the dll from here: http://www.dlldump.com/download-dll-files.php/dllfiles/M/MSOWCF.DLL/download.html I just tried it and it worked perfectly

Can you share with us the code that's causing this error?

There's a reason for that and that's because tables and queries are not meant to be printed, you should ONLY print reports.

That's a great initiative on your behalf, God bless you

Yes, in the combo box properties, change column count to 2 and column widths to 0";1" for example

If you have a multi-select textbox then you can run the loop in the listbox itself like this: Dim i As Integer, strEmailTO as string For i = 0 To Me.ListName.ListCount - 1 If Me.ListName.Selected(i) = -1 Then strEmailTO = strEmailTO & [wherever your email address is stored] & "; " End If...

YourAnswer = DLookup("max(yearmonth)", "tbl_Revenue_Assets_Split")

I understand the forum requires time & money to maintain and since unlike auto-forums there are no paying vendors on this forum to generate income, AD's are the only way to go. I'm just worried that it might drive traffic away from the site, competing Access Sites are hosting ADs and they seem...

Great! Get the function to count and import the namelocations working first then move on to the next challenge and do keep us posted pleaes :)

It will be, because that timestamp will tell you if that current action has been imported into your current DB or not. You will have to store the "last imported" date & time in your DB.

So a truck can have more than one shipment, and a shipment can have more than one truck?

If your tables & relationships are well setup then you won't have any problems printing the desired reports (sorry if this sounds too generic)

I couldn't agree more. I've been using Access for almost 10 years now and still learn new things every day. Great forum and welcome aboard.