Search results
-
B
BackEnd getting corrupted since (I think) Win 10 updates
Hi, Thanks for your reply, For years networking Workgroup, controlled by MasterBrowser & avoided homegroups as some advised, always worked well without. MS just depreciated MasterBrowser control so a few months back added HomeGroups to be on safe sidfe (The same folder sharing as before still... -
B
BackEnd getting corrupted since (I think) Win 10 updates
Hi, That's the odd thing, I don't have the ROWD property on the working BE, never really noticed it before. -
B
BackEnd getting corrupted since (I think) Win 10 updates
Hi Again, reminder: If FE running on PC A (also has the BE) & PC B (on wired LAN) tries to update anything it corrupts the BE on A. (Been rock solid for many years before this) 4 days solid at this and going mad. Just something I have discovered, Different Tables Properties on the different... -
B
BackEnd getting corrupted since (I think) Win 10 updates
HI, Thanks for the replies, as I say I decompiled etc & tried on other PC's. There has been some improvement with the trusted locations but strangely still not helping on the original setup. Just not following any logic I can see. accdb or accdb /runtime seems to be better than accde /runtime... -
B
BackEnd getting corrupted since (I think) Win 10 updates
Spoke too soon, seemed to help some of the testing PC but the original setup still crashes. What the difference is I don't know. Trusted pretty much anything I can & reboots etc etc. I did find that when I tried to point the BE to a new PC not trusted I go a very clear message that I might not... -
B
BackEnd getting corrupted since (I think) Win 10 updates
I think SOLVED. It appears DOES have to be in the trusted location? Seems *** obvious now. So far minimal testing but OK now The BE was not listed in the TL in the networked other PC FE's However why this has suddenly changed I don't know. I am guessing it does need to be there but for years... -
B
BackEnd getting corrupted since (I think) Win 10 updates
Office 365. All Windows 10. all PC's recently had the big win 10 feature update. I have a FE & BE on PC 1 all wired LAN I have FE on PC 2. wired LAN again. With PC 1 FE running When changing data on PC 2, after anything from few to 10 or so edits within the space of usually under a minute the... -
B
html - colspan not working
Yes, I have RTF memo field, table & on a form. the field on the form is RTF format (I know they call it RTF but really html) The data is imported from the incoming email, I can see all the html code if I view in a text box with plain text properties but the same table data views in a RFT...- bignose2
- Post #9
- Forum: Modules & VBA
-
B
html - colspan not working
Hi, Many thanks for your reply, This is exactly how I receive the message, including the colspan html I might be able to search/replace and put in different fields as you say but initially looks really tricky to decide what is the number, message & date/time. Mostly are normal emails which...- bignose2
- Post #7
- Forum: Modules & VBA
-
B
html - colspan not working
FROM:...... MESSAGE:.......... DATE/TIME 123456..... Hello..................16-05-18 .................How Are You ................Today You........... I am................ OK 18-05-18- bignose2
- Post #5
- Forum: Modules & VBA
-
B
html - colspan not working
Not that clear as forum seems to remove the spaces- bignose2
- Post #4
- Forum: Modules & VBA
-
B
html - colspan not working
<html><head><META http-equiv="Content-Type" content="text/html;charset=iso-8859-1"> </head><body> <table width="100%" border="0" cellspacing="5" cellpadding="0"> <tr> <td colspan="2"><font face='Arial, Helvetica, sans-serif'><b><font color='#000000'>You have a new<i><font color="#FF0000">...- bignose2
- Post #3
- Forum: Modules & VBA
-
B
html - colspan not working
Hi, I have Access getting imap emails for me via Chilkat ActiveX basically I get the html email body OK & generally looks fine for normal email. However I get SMS/text messages via a online service and they have a rather fancy format with columns. Looks nice in email cilents & any other html...- bignose2
- Thread
- Replies: 9
- Forum: Modules & VBA
-
B
OnClick does not fire on 1st, dblclck works on 1st attempt.
Hi, Clicking a bound text box on a continuous form of records does not fire the on first click. Focus starts & is mostly set on a search text box at top. The first click does select the record & the 2nd click then fires the onclick. I sort of know why this is happening. My OnCurrent always... -
B
Want Search Textbox to filter form but keep focus & highlight
Hi, Thanks for your advise. In the end I thought i would try a different approach. I use AllenBrowne FAUY, find as you type, a lot & is really great as don't get any of these problems. I assumed perfect for just one field search but always avoided if wanted to filter on 2 or more fields... -
B
dim TestName as control = a module is not a valid type
That it is! I feel such an idiot, I had this module when I first created the database 10 years ago & never noticed. I was looking for functions with the same name but not the module itself, Is it SAFE to rename this, I know its more of a folder but the fact the the compile picked it up makes... -
B
dim TestName as control = a module is not a valid type
Hi, I was trying to have a variable as a control name I have seen lots refer to Dim ControlXYZ as control I get a compile error on this line, a module is not a valid type No matter what name I use, so I know not it is not duplicated anywhere. Sure my references are OK, never had problem... -
B
Want Search Textbox to filter form but keep focus & highlight
The best I have managed so far is Private Sub FindNames_AfterUpdate() FindNamesUpdated = True End Sub Private Sub FindNames_Exit(Cancel As Integer) Me.Filter = "[Names] Like '*" & [Forms]![regFAYT]![FindNames] & "*'" Me.FilterOn = True Cancel = True ' Cancel either way, but... -
B
Want Search Textbox to filter form but keep focus & highlight
This is driving me crazy, over the years ended up having lots of different tricks to achieve this but always messy & all over the place. There must be a clean & proper way. Basically I have a text box. I type a name & it filters the form. For speed & ease I type the name, either press tab or... -
B
Filter Report Base On form query/filter with LIKE *
SOLVED: really weird, working now, PC restart & lots of compacting & working. Have not change anything. I compact pretty much every time if compile so very surprised.