Search results

Thanks CJ, I have tried the last option and the too works. Appreciated the advice.

problem fixed. I put plaintext( in front of the fieldname in the access query select statement.

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...

Got my query working and filtering correctly on whatever the user wants to filter by

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...

Thx RX, will try your suggestion here shortly.

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...

commented out, i get error message Too few parameters. Expected 1. Ill work on getting copy zipped and attached. thx

Sorry, but VBA newbie, I dont know the best coding standards yet.

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...