Recent content by ListO

Thanks, islaDogs. I just finished getting that to work, and yes, PlainText() was the answer. It simplified my cleansing quite a lot.

FWIW, the SQL SELECT Cues.Dialog, Cues.CharID INTO TestResult FROM Cues WHERE (((Cues.CharID)=68));

I'm encountering a problem when exporting query data. I need to create flat clean textfiles of compiled data for use by other parties. Some of the data is held in Long Text (memo) fields, and is generally verbose text with some RTF underlining or BOLDfacing. I use an action query to create...

No, it’s not the name of the table. Just trying to be clear with my question.

I’m simplifying this question for brevity. The real database is more complex, but I can apply a viable answer to my database. I have created a database with several of tables, such as NAME, TASK, CATEGORY. I have a main display query which selects a collection of data taken from those tables...

YES! That's great. I can see exactly how to adapt that to what I need. I was stuck thinking about how to adapt the built-in charting, but this is relatively simple. Thank you.

Greetings all. I want to make a chart and I can't see how to accomplish what I want. I'm seeking suggestions about the best approach. I have a query with a list of selected names which I want to use. I have a query with a list of events. Each event has a start time and end time field, and the...

Success! Thank you, thank you, thank you. I couldn't find anything in my books that would lead me to this solution. I've very glad that I didn't simplify my example by changing variable names. I appreciate your detailed attentions. -Curt

On a form called "MainLarge" I have a field from my table called "Tag," which is Boolean. I want a public subroutine to process the state of that field with the following code (truncated here for simplicity). The MainLarge form is open when the subroutine is called. Sub ToggleTag() Dim...

Wow- good for you to search back for this solution! I did not find a better way to do this. It was pretty easy to paste the module into my program, then it only requires a call to fIsComboOpen to check for open combobox. If it helps, here is the code I use within the form. It is called in...

Bob, you're a wiz with this stuff. Thanks for the great reference. I'll have to study it a bit, but it appears to be just what I want.

I would like to create a form with a selecting matrix. One set of records as Column Headers and one set of records as Row Headers, with a grid of checkboxes at the intersections. The user could check or uncheck those boxes, and I would then like to select data which has coincidental checks. As...

Yes! Exactly what I need. Thank you very much for that. I haven't gotten a chance to study the code, but it looks to be what I'm seeking.

No. The problems are across the board for all common dialog calls using the ActiveX object. I'm not having any special problems with the API call for the ChooseFonts, except that I cannot find the information required to make the call correctly. I can't get it to work on my Windows machine...

I want this to be a pop-up. I had been using the common dialog ActiveX object, but this is not working correctly for a couple of my users who are running Windows on Macs. Some research through the Microsoft knowledge base leads me to believe that MS is discouraging use of the Active X object...