Search results

Hi all, I'm getting a "System resource exceeded" error when inserting a Modern Chart into a Continuous Form. The old charts do not allow the option so the modern charts work great except for the error I'm getting. 1. It does not come up every time - maybe every 3rd time I open the form. 2...

Ahh - very nice - that also works thanks. With it I could clearly see the linebreak char in the text which was previously hidden. The WordWrap was set to 'Yes' and had not effect, but setting the Multiline to 'Yes' worked 100%. Result displays the same as CJ_London's suggestion. Thanks so much...

Using the replace option is not that simple. The linebreaks is a bit more complex to do since I will have to check for "/20" and then revert back a few char to check for a space to cater for single or double digit days/month etc. So a mission. BUT you second option worked like a charm :) Firstly...

Hi there, I have a textbox based on existing data from a table (Long Text field data type). I don't have control over the input of the data which is done via a website but it appears to have linebreaks because if I copy and paste the exact text into Notepad, it shows with linebreaks, but in the...

Thanks for the reminder :)

Very interesting idea. Thanks I will also try that as an option. For now I'm using arnelgp suggestion.

arnelgp - "you are the man". Cutting the time from forever to about 6 seconds. This will work. Thanks a lot. I'm still surprised that the FormatNumber idea could not work for text. Anyway maybe one day I will know why :)

Hi all, I have a csv file that I download and then import into an Access db. There are around 100,000 rows One of the columns contains a serial number which could look like a number or text. Some containing only number and others a fix of letters, numbers and even symbols. After importing it I...

Great - so I'm not the only one. Sure Microsoft will attend to it soon enough. In the meantime my Client's IT guy will uninstall Access 2016 and install 2010 else they cannot work. Maybe he can try it again when the problem is solved. Thanks for the valuable post

Hi all, I got a call from a Client who has been using an Access app for about 18 years (I imagine multiple Access versions in that time). The app is used on most machines runnnng Access 2010 without a problem. Last week two machines were upgraded to 2016 and now those 2 machines have errors...

Works like a charm!! Thanks a lot!

Might very well be but I tried a few options but not sure how to use it (syntax) in the code I posted.

Hi all, I'm using the code below to count the number of emails in an Inbox but I want to narrow it down to just the flagged emails. Sub HowManyEmails() Dim objOutlook As Object, objnSpace As Object, objFolder As Object Dim EmailCount As Integer Set objOutlook =...

I agree with keeping the User off the database while updating so I made provision for checking for the locking file and a few others things and then promting the User to exit so the update can happen. The above was but a summary of the process but the the "proof is in the pudding" 20 years no...

Wow - that method would have been too labour intensive for me being the sole dev of a commercial app used by clients all accross the country for the last 20 years. So I had to do things to save me time and not force me to travel or spend time with each user. So the FE at each user would check...

OK say I have a BE table and suddenly due to some request I need to add an extra field to that table to make provision for additional data to be captured. I sure don't want to have to go to each User and add the field to their BE table one User at a time. So I normally just add the field that I...

I want to create a new table in the BE that does not exist already. And in the other cases I want to add some fields to existing tables.

Hi Doc, thanks for the advice. So is the On Error resume next not just skipping the following line. In otherwords if the field already exisits it will bring up an error which the on error resume line will skip. So this will cause the field to be added just once (the initial time) and never...

Hi Doc, local as in same hard-drive :) Since the problem was fixed I did not spend all that much time on it, but the it suddenly came back after I ran un update on the backend from the frontend. So then I realized the code that makes the changes to the backend is to blame. Funny thing is that...

Hi Doc, So in my attempt to upload a copy of my db app for you to check, I had to strip all sensitive data and covert all linked tables to local tables. Then to my amazement all work 100% both ways. So I thought the cause must be a delay due to the linked tables (although they all reside on a...