Recent content by Minddumps

Phew, I think my brain is just dead. I'm still not getting any where. Thank you again for your help. I'll try again on Monday and write back. Have a wonderful weekend. :)

Thanks for your response! Hmm please forgive my ignorance though, I'm playing around with what you suggested and am still not getting anywhere. I added what you provided to the on change event of the hidden textbox the query views in order to look up the search terms: txtSearch2. I also...

To search mult columns in a query, just ensure the Like "*" & [Forms]![frmSearch]![txtSearch2] & "*" is in each column (on a new OR field that no other column has info on).

how to use delimiter to search multiple filters [using john big booty's db] I implemented John Big Booty's dynamic search (found here: http://www.access-programmers.co.uk/forums/showthread.php?t=188663) using Access 2007 a while back and was recently asked by one of my work team members to...

I started playing around with varying features and figured out a solution. (Of course if you can think of a better one, by all means, please share!) I created a sub report and placed it in the report footer area. I named the query the same as the main, but added _sub to it (to get the same...

[SOLVED] In Report Grouping, how to first list the matching relationship, and then In Report Grouping, how to first list the matching relationship, and then sort others Ok as some background to this report: I have 5 Marketers, each with their own Partnership zone(PZ). They have Companies...

Thanks for the note; I haven't had any issues with the filter (perhaps I should say yet lol), but I'll look into that.... However, I'm still trying to figure out: How can I get the combo box (as an unbound text box pulling from a query, I imagine) to auto write the next biweekly date that I...

How to auto find “When’s the next biweekly date?” -Access 2007 Currently, I enter biweekly dates (always on a Tuesday, unless Tuesday is a holiday, then most likely Wednesday) that I’m to send my media releases out in a table. The form then pulls those dates for a combo box. I select the next...

Ok so I figured it out after reading through Kallal's notes again.... the absolute location is specified in the form event procedure NOT in the actual module... for some reason I couldn't get that wrapped around my brain!! For those looking for solution to this: Private Sub cmdWord_Click() Dim...

Well I tried a few different things with still no success. The system tells me "Compile Error: Variable not defined" for "MyPath, _" Any other ideas? This is the changed code, did I put something in the wrong place? Public Function MergeSingleWord(Optional strDir As String = MyPath, _...

[SOLVED] How to change Directory location in Albert Kallal's Word Merge program?? I’m using Albert Kallal’s word merge program and trying to tell the program to look up a certain location for the Word folder, instead of searching for it in the same location that the access file is location...

I should first mention I'm using Microsoft Office 2007 I've successfully implemented the Super Easy Mail Merge using filters. For those interested in how to use the filters, here's the code: Me.Refresh MergeAllWord ("select * from qryContactsMerge where " & Me.Filter)Everything works...

Hi everyone, As an FYI for anyone looking for this, here's my situation. I have some dates I needed to calculate in relation to the event date (for my horseblanket) and 3 of which MUST land on a Tuesday. For example I needed to know when to send out invitations for this event, I needed to set...

Not sure if this can help you figure out the spacing, but I was trying to figure out something similar. If field is blank than skip field basically. Though, all of mine were on one line and in a query. NameFull: ([AllPOCs**].[Title] + " ") & [POC First] & " " & ([MI] + " ") & [POC Last] the...

Re: How? Concatenate fields if Null/0 OR concatenate "these" fields instead if NOT nu Wow!! I'm jumping for joy! My final attempt, changing ; to , worked!! It's always the simple things that kill me. I was trying to make it much too difficult in my previous attempts. Thank you!!! For...