Search results

Hi, I'm getting an error while trying to import from an Access-table to a sql-table, but 2/3 of all records are imported correct, 1/3 is ommitted because of this error msg: Messages Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code...

No, every employee has his Barcode. So barcode=MaID. I could not define a subquery (subselect) therefore I took a UDF, but this was not my preferred solution.

Well, I could not get to the Min(EinsatzZeitvon) (=start time of work for the employee) in which Teams he starts and the Max(Einsatzzeitbis) (=end time of his work). The employee has maybe two times. he starts at 09:30 in Team A until 12:00 and from 12:00 to 16:00 in Team B. How to find...

Well Rx, here is the way which made it work for me: This is one of my UDFs, I made two of them, the same way: CREATE FUNCTION[dbo].[sfFindEvLocBerID] ( -- Add the parameters for the function here @Evid int, @Barcode nchar(11), @Einsatzzeitvon datetime ) Returns nchar(10) AS BEGIN -- Declare...

@RX You are right, my sql is much to difficult to understand for another person not knowing my construction. Meanwhile I solved the problem by using a scalar UDF for my subqueries and it works. Thanks! Michael

Hi! I have a huge problem with this SP: I nedd to get the first time (earliest time) togehter with some other field from a table by using a subquery. I get the error above, but I cannot modify the query to get my result. Please be so kind and help me with this subqueries: SELECT...

Hi, I googled for a long time but could not find a solution for my problem: the user opens a certain mail and THIS mail should be either saved as PDF (for example by CutePDF - as it works with a word-doc) to disk or be imported to my Access datebase in a certain field (the Body of the...

Great!! IT WORKS! Pretty EASY, pretty SHORT As long as you know how to do it. Thanks a LOT!!!!!!!!!!

Hi, I have to create codes with a certain algorithm. It consists of 6 digits (positions) and looks for example like this: 6D45F3 On each position the sequence is "0", "1", "2", "3", "4", "5", "6", "7", "8", "9", "A", "B", "C", "D", "E", "F", so it has 16 possibilities. Beginning from the...

Hi both, It seems that JHB found the reason of the jumps: somehow Lotus gets confused when I delete the mail during the Loop. within the Loop I now fill a collection, after finishing the loop I move all mails at once in another folder and delete all mails at once from the Inbox folder...

Hi JHB, I did not find the reason for it, but I could limit it to the specific type of mail from our homepage. Meanwhile I am looping through two different folders, one has standardized mails form our homepage (with or without attachements) and the other folder includes also mails (with or...

Hi, I have a problem whithout a explanation for it and no solution, so please help me with it: I am looping through a Lotus Notes view through mails which comes with standardized content from our homepage. Some of them have one or more attachments, some mails do not have attachments. I loop...

@BlueIshDan: thats all you can give me for help? ;)

Thanks for your fast reply. Regretfully, the result is still NULL. By the way, a table with more than one columns cannot be set as 'newcolumn'. But even when i changed to SELECT * FROM (SELECT InventurDifferenz as newcolumn from fncBerechnungInventurdifferenz(1, '2014-06-30')) As tmpQry...

Hi! I have an inline table-valued function (with parameters) which if course returns a table. I can use a query 'SELECT * FROM Myfunction(par1, par2)' which returns ALL records. I can also use a query 'SELECT * FROM Myfunction(par1, par2) WHERE myfield=1', but I cannot use a query 'SELECT...

Thanks for the hint to have a look on the design. Not the field type changed, but when connecting the view I defined the wrong field as Primary Key. But what I do not understand is, that the number of records have been correct, although the wrong PK should have "filtered" the records to the...

Hi! Front end access 2010, back end SQl-server 2008 R2. I have all talbes and views connected to the server and due to incorrect results I found out, that the views from the server deliver incorrect data. Of course I refreshed the views in the access front end I even deleted them and...

Hi Galaxiom! Thanks your reply, it would be great if you could let me have some code examples how your solution with the recordsource for a subform works, as I have indeed some performance problems with subforms. Thanks a lot. Michael

Hi Galaxiom! Thanks your reply. I will try it. FYI a system procedure starts allways with "sp_" and in literature it is recommended to start user defined sp's with "sp" without unterline to distinguish between functions and stored procedures. BTW I use DAO in my project (Access2010), can I...

Hi! Please help me to understand this scenario: For sending a pass through query from Access to SQL-server I have a function to "convert" Access date Function DateTimeForSQL(dteDate) As String DateTimeForSQL = "'" & Format(CDate(dteDate), "yyyy-dd-mm h:nn:ss") & "'" End Function the...