Search results for query: *

Didn't see your last message until now. Great idea! Thanks.

That does sound pretty cool but I really think that I need to do this from within Access. Access has to determine which customers get the message and control the entire pop-up operation of the messages and perhaps the drawing of pre-written messages from a table depending on circumstances. I...

Thank you so much! There's a wealth of knowledge there, and I believe that it has provided me enough information to proceed. I don't have a green light from the owner of the company yet to implement this. I was investigating what was involved and whether it was even possible. Regardless of...

We have a long-established A16, SQL Server 2016 DB for an insurance company with about 20 users. I've been asked to investigate whether Access has texting capabilities. It's an easy matter for me to create the list of clients to whom we would like to send a text message. I'm trying to find...

I got sidetracked off of this thread once everything was working the way I wanted, but I really appreciate the additional thoughts that you offered. They make sense and definitely a better way to do things. Life is a learning experience, isn’t it? Thank you again for all of your assistance. I...

I wrote essentially this same post and it disappeared. Either I'm losing it or Tek-Tips is! If it suddenly reappears and posts and you see it twice please don't think I'm any crazier than I actually am! I have no idea what happened with the formatting issue. For some unknown reason it...

One more thing. I further modified the formatting to read +#,###;-#,###.##[Red];0;"Empty" since I didn't want the word zero, but instead the character 0 displayed. I also tested the text alignment and found something curious. If I set the alignment to Left then all the text including the...

Thank you both so much. This worked...but there's one small problem. The + numbers are text aligned left, while negative numbers are text aligned right. It doesn't matter what I set the alignment as. Is there some way to get the numbers to align normally to the right? BTW Duane, I modified...

Thank you both. Quick question. Is +265 from the custom formatting treated as a number or text?

Really, the subject is the whole question. I have text fields on a report (General Number format), and if possible I'd like to display a + before positive numbers. Any suggestion is appreciated.

Maybe you do want to return to UNION with 103k records. Your 297k records - you may have 194k 'repeated' records of your 'really needed' 103k recs. Check your data. Actually, I have checked it and I do in fact need all the data to draw from. The numbers are working correctly now!

Another question on a different subject. Is there a way to make Access display a + sign in front of positive integers, just as it automatically displays the - sign for negatives?

I can't thank you enough. One very minor change made hours of my work evaporate! I'd love to buy ya a beer if you're ever in my neck of the woods in Southern CA!

Since I didn't know what to do and wasn't sure if or when I might get a reply here, I resorted to creating a Make Table query and an Append query and put all the records into a table. That table was working as the record source, giving me the desired results. So I ran the table and compared...

It seems so! I had 103k records returned from original UNION, and 297k records returned from UNION ALL. I haven't checked specifically yet but it's a world of difference. Can you please explain UNION ALL, what it does, and when it should be used? Meantime I'm going to run tests with the...

...WHERE (((Reps.Rep)<>"Laura Lake - 2020 Promo" And (Reps.Rep)<>"Laura Lake") AND ((Reps.Inactive)=False) AND ((AllVehicles.InsCo) Not Like "Can*")) UNION SELECT "Laura Lake" AS Rep, AllVehicles.QTDate, AllVehicles.EffDate, Reps.PartTime FROM Reps LEFT JOIN AllVehicles ON Reps.Rep =...

I have finally had a chance to test all the suggestions made in the link. Workaround 1 – Use Single Step Mode to Test the Macro I thought this had the most promise but it turned out that the single-step was never triggered. The error occurred before any of the macro steps were run. That's...

Thank you so much. This is an excellent resource. Many of those suggestions have been included in my database for a very long time but some are new to me.https://www.tek-tips.com/viewthread.cfm?qid=1825531 I really appreciate the help. It gives me several different directions to go. It's...

Yes, of course there is VBA as well, and it does compile. Let's say that I have a macro attached to the OnOpen property of a report. Among other places, I would get the error message there. I just want to clarify that the problem itself is new, while the database has been up and running with...

This DB has been up and running since 2010. I have relied fairly heavily on macros in its development. I know that the coders see them as being somehow an inferior way of getting the job done, and maybe they are, but they are also a valid part of the toolbox that Microsoft designed and...