Search results

I found the error! It had nothing to do with any versions 2010 or 2016. I changed a field in a SQL table from "Null" to "not Null", but did not refresh the links in Access accdb and did therefore not create a new accde. Although there where NO orphan records in the child table, there has been...

Randomly I have a trace what causes the crashes, although I have no clue why: In my forms (which crashes) I have tabs (pages). Whenever a "main record" has linked records from another table, displayed in the tabs, the app crashes. Whenever I delete the related records in the other table I can...

I am sorry, you are right: But the message is absolutely MEANINGLESS. It says "Execution of this application has stopped due to a run-time error. The application can't continue and will be shut down." Nothing more. Thats why I cannot continue searching as I have no glue where it could come...

Without giving notice an administrator changed from Win 7 64 bit with Office 2010 32 bit to Win 10 64 bit with Office 2016 32 bit on a certain machine. Now, our production database application based on Access 2010 Runtime 32 bit does not work anymore, ALTHOUGH I installed the neccessary...

Thanks your advices. The strange Thing is, that is works on one subform but not on the other two. I do not use dynaset because I want to execute it on the Server directly, not on the connected tables. And as I said, I cannot even run the code, putting a Debug.print straight after the...

Frontend Access 2010, backend SQL Server 2008: I have a Problem which I cannot solve at all. on a form there are 3 subforms which get their records through 3 passthrough queries from the Server. All 3 subforms have the same Settings like AllowDeletions, allow Edits,Lockings, etc. All...

I found the reason why it behaves like this: not the marked Control was missing or incorrect, but another one, which Comes in a later part of the code. Why this control is marke only MS knows!! Anyway, it is absolutely missleading!

I get crazy with an error which is not MY ERROR at all. I copied a form from one database to another. In this form is a control named "Invoicedate". After changing a few other controls and adding new fields from a table I debugged the Project and suddenly I get an error "method or Name...

Ha, I recently found a solution. The difficulty is just to understand that Notes have front-end-classes which "serves" the NotesUIworkspace and back-end-classes that handles NotesUIDatabase. The only thing that I could not solve yet is to import a mail as HTML, which should be possible, but...

Hi! reading all mails from a Lotus Notes database, a view, a collection is not that difficult. What I Need, but no where found is HOW TO Import the actual marked or opened mail, so only ONE mail, the current mail. Does anyone can help me please as I cannot find any solution for that. In...

Spikepl don't be that angry. RT means Access runtime, as I used this term in the subject already, I assumed that every Body can follow. PTquery is passthrough query which which I ussed the Long term one line above. So I did not want to confuse anybody - but reading the thread I think...

I have a Problem which I cannot solve at all. On a customers PC (Win 7 32bit) runs an app in an acc 2010 RT (SP2 already), backend is a SQL Server 2008 Express. I have a couple of reports which do not work properly. Before that I have to state that I did everything I know to check my database...

Thks yr reply. The Thing is, it happens on different PCs which are mostly on customer site. I cannot check things like this. The question is, is this a known issue with MS updates? Does others have these experience as well?

I made already many applications as accde or addcr and deployed it to users, which only have an Access Runtime 2010. Since a few month (it might be accidential) all the accde crashes on start saying something like "You have to delete the VBA Project..." (translated from the German...

Just for info: collection works best, but you have to use "On error resume next". Otherwise you fail by error if another letter will be sumitted.

I could not find any Problems when Decoding "adhl" for example by Choose, the results where correct. As adhl is different to ADHL or any mixute of it, I convert the string By LCase("AdHl") before Splitting it. I will try Collection too, which I never used before. Thanks both of you!

Aah, now I got it!! Choose.. and until the first comma, its the calculation of the position!!! The values behind are the indexed values...!

Hi stopher! This works even smarter!! I still do not understand choose (although I found it on the net - never used choose before!) and why to have 13 values for 12 letters, but it works. I had to add an if-clause to avoid letters larger than "l" For i = 1 To Len(textstring)...

No stopher, not yet, but I will do it tomorrow in the Office and Report. Thanks yr. efforts.

@stopher Thanks yr. reply, but as I said, it cannot be solved with ASC as the numbers are not in any correlation to the letters. There are just numbers in a sequence of 12 without Zeros that they cannot be mixed up with letter o.