Activity Stream

Dave, I don't use Outlook, but you may find some relevant code if you google with outlook vba to extract part of email body into Access I...

catluvr, See this Richard Rost link re Not in list, it may be relevant.

But that does not have the same effect as Full Outer join. Union queries just appends the rows. They don't show the null values.

That is not a full outer join.

heres an example of the NIL code I refered to.

Access does outer joins. dbl click the join, select which table to show all records.

Yes. Create a left join and a right join then combine using a UNION query.

I keep getting an error with the edited code. I have zipped a condensed db. the file location to place the documents is F:\LogSuite\tblWorkOrder . ...

The suggested approach worked very well. Thank you, But as you suggested, now I will try to find an alternate approach to do this, to avoid...

If you have linked to tables in the BE, you should use those in your queries. Also to repeat part of my previous answer in post #7 You definitely...

Just a follow up note, In the front-end, I linked to related tables in the back-end. The tables in the back-end are related in a one-to-many...

Just to add to the previous answers, here are some results from the immediate window. As you can see Access tries to 'helpfully' interpret dates and...

Thank you for the follow up reply, June7, and for your feedback, isladogs! @june7 - So linking to queries in the backend is not possible. I...

Open event does not have NewData argument. Remove it.

It's not you: http://fmsinc.com/MicrosoftAccess/Errors/query_is_corrupt/

How would I know? I have no idea what code is behind the export button. What query? You don't provide enough information to get a cogent reply.

cross posted https://www.mrexcel.com/board/threads/combo-box.1115229/

A set of records needs to be created in ChartReview for each employee/category combination. This can be done by user one record at a time or code can...

An accde front end yes; I mentioned back end. You just have to make sure that the path you link to the back end with is valid on the user's...

Well, I'm about to give up on this ... I'm just not getting this to work. My code as it currently stands: Private Sub...

You can click on a member name and see what's on their profile page. You have a table field called "Max(ID)"? Bad idea - Max is a function thus is a...

You are correct that the calculation shouldn't be stored. You haven't said where this calculated textbox is but I presume it's in the form header or...

The ALL has been added in the combo box. When I selected ALL and click the export button, no data was generated. Is there something I missed. In...

You didn't follow the instructions and do a "Compact and Repair" before compressing the dB. You really need to read about normalization. ...

Select “ALL” FROM qryClient UNION Select clt.Field1 FROM qryClient GROUP BY clt.Field1 What are the red qualifiers? Try it without those. Also, I...