Thanks, my access query field is called ProjectDescription, I replaced textfield with ProjectDescription, and inserted that between 'Test HTML Tag Fix here 'End HTML Tag Test Fix.
I get error 'Invalid use of Me keyword' on PlainText(Me.ProjectDescription). I also tried replacing me with...
Access Query Result
Complete6
Project Description
Test Project Phase 1 in progress
Excel export using access query above
<div class="ExternalClass8A13BE74CB1A417988BCA0FA2D0219DA"><p>
Test Project Phase 1 in progress </p></div>
Export to Excel column not formatting correctly, need HTML Tags removed help.
Good afternoon, I have a process that is getting data from sharepoint page, containing 2 list. Both list contain one field I am having issues in my export, a 'Multiple Lines of Text' type field which is Rich Text in...
I got my data type mismatch error cleared up. I still have one problem tho I hope I can get some help with.
I had previously built a access query, that a user can select data criteria from dropdown boxes, and leave any of them empty if they did not want to filter by the box. Here is the...
thanks for taking a look. the problem has to lie in the dataquery3, where i have a where clause pointing to a drop box on the form. if you manually run the query, it works fine, but thru the vba code, it does not.
I tried attaching the database, but i am blocked from doing so with my work...
I have also slimmed down the data query listed below. and still no data returned. but if hard code an item number, it returns data as expected. So my syntax in the Where clause for the form fields has to be throwing the query. Thanks all for your help.
SELECT ITEM_FE.WM_YR_WK...
First off, I would like to say this site has helped me out so so much. I have been coming here for almost a year now. Thanks for the great site.
My problem:
I have created an Access query, that has a where clause based on a Form fields that user can filter by. User hits run report button to...