Search results

Problem solved! For some reason the DELETED bit field didn't have a defaultvalue anymore (should have been ((0)) ), like in all other tables. I have no idea how the defaultvalue could have been erased in the SQL-table but after setting it and refreshing things left and right it works again...

I have an Access-application working on SQL-server with ODBC. Since last week I have a problem that in one of the linked tables records "lock" after inserting them, or to be more precise, when I want to edit/delete an existing record, I get: "This record has been changed by another user blabla...

Yes, that's it! So obvious afterwards :) Changing strMessage to Replace(strMessage, "<", "'<'") was enough to fix the problem Mucho thanks

Yes, it displays correctly Just tested a bit more: Exact html-code from the textbox: Access displays a red > behind line 3, squarefree HTML editor doesn't. Maybe a little bug in Richtextfields in Access (version 2013 btw)?

I'm trying to output some logging to a form with a Rich text textbox This is what the form is displaying: 14:16:32: check OK: 500<10000andS235='s460'> 14:16:32: check OK: 500<10000andS235='s355'> 14:16:32: check failed:too short 500<1000231231 > 14:16:32: Ready ... There is some coloring in...

I'm sorry, probably a doubleclick unintended. This thread can be removed.

For a certain database I'm looping a record which fills an Excel worksheet. All working fine. in simple: Sub WriteExcel() rst as recordset rstDifferent as recordset for each Record in RST Wsht.Cells(t, "A") = "EUR" & "000" Wsht.Cells(t, "B") = Round(RST!Amount,2) * 100 Wsht.Cells(t...

For a certain database I'm looping a record which fills an Excel worksheet. All working fine. in simple: Sub WriteExcel() rst as recordset rstDifferent as recordset for each Record in RST Wsht.Cells(t, "A") = "EUR" & "000" Wsht.Cells(t, "B") = Round(RST!Amount,2) * 100 Wsht.Cells(t...

One part of the problem is solved: I CAN set listindex, but only if the listbox has focus :confused: So: Me.selectie.RemoveItem (i) Me.selectie.AddItem t1, i + 1 Me.selectie.Selected(i + 1) = True This part removes the selection, the third line "highlights" the line that was removed and...

I have a form with a listbox in which users should be able to move the items up and down. The listbox has 4 columns and multiple selection is enabled. For a NON multiselect box I have it working, and also for a multiple selection box but in that case it works only for one row at a time. For a...

Well...maybe I misread some parts of this topic :) I think the topicstarter wants to do what I'm trying to do, that's what pulled me to this topic. I now see you write about a "similar" problem, so I could have know the subject had slightly changed ;) Didn't realise you were trying to solve a...

Still an old topic :) but I'm trying to tackle this problem a.t.m. and this post is the only discussion I could find on the internet regarding this exact functionality: a RTF-memofield in which a user can type and format text and then replace certain parts of it with a "code" that allows for...