Search results for query: *

Update: I am using SyncFusion's XLsIO library. Also, this report will run from the desktop version of Earthsoft EQuIS Pro as long as the user has write access to the C:\ drive.

I have a remote, hosted SQL server that I'm interfacing through Earthsoft's Enterprise web portal. I have created a custom report as a dll that includes a excel document as a resource within the dll. How do I go about providing the final product (Excel document with my datatable) to the user...

That query caught a few records that were not dates. So I changed the calculated field to: Final Report Due: IIf(IsDate([Date and Time EZEDD Released from Lab]),dhAddWorkDaysA(10,[Date and Time EZEDD Released from Lab]),#1/1/1999#) Yet still any comparisons run against the calculated field...

I have a calculated field that returns a report due date. It uses a function I found to account for weekends/holidays. The function returns a date type. Public Function dhAddWorkDaysA(lngDays As Long, _ Optional dtmDate As Date = 0, _ Optional adtmDates As Variant) As Date ' Add the...

SO I have included the dbFailOnError and have been unable to reproduce the bug. Any database I attempt to merge now includes every table. I'm glad it's working now but wish I knew what was going wrong before. Thanks again, Golom.

Thanks for the suggestions. I haven't tried them yet, (busy with priority work) but I will let you know what happens when I do.

I have perused the forum and found a thread similar to what I'm looking for but not quite: thread705-449900. I have multiple (60+) daily databases with 10 tables. Theoretically there are no duplicate records and to date this has held true. I am merging all these databases into a master...

The plus sign was not supposed to be there, also the () surrounding the field names after SELECT were throwing an error I didn't see until I copied the generated SQL statement into the Access Query Builder and tried to run it. Once those issues were resolved it at least appears to be inserting...

I am pulling the primary keys from each table with this: For Each idx In tbl.Indexes If idx.Name = "PrimaryKey" Then PK_field = idx.Fields End If Next idx Should I be doing anything else to the string that is returned? I have tried adding the brackets as PHV...

I guess my question is more geared towards the SQL syntax, as the strSQLDupIns is the string I thought I needed but it still isn't inserting anything into the Master_Duplicate db. I know that there are duplicates in my test Source db and Master db. I want to copy a record from the...

I have 3 databases with a set of redundant tables: Source - with the field data entered (Primary Keys same as Master) Master - containing all the merged data from the Sources Master_Duplicate - to contain all duplicate records from an attempt to merge a Source into the Master I...

I have 3 databases with a set of redundant tables: Source - with the field data entered (Primary Keys same as Master) Master - containing all the merged data from the Sources Master_Duplicate - to contain all duplicate records from an attempt to merge a Source into the Master I...