Search results

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

Does anyone have a template for an API call to the ChooseFont of Windows Common Dialog? I've searched everywhere I can think of and have only encountered examples which don't really work. I can get the OpenFile and SaveFile to work, but I can find next-to-nothing on ChooseFont.

Hey, Bob. Thanks for the response. Perhaps I did not explain this well enough, but I don't believe my db is working correctly. When the application is first opened, I can press the Alt key and the little keytip letters appear over the tab buttons in the ribbon. If I type one of the keytip...

I have an application with a custom-built ribbon which includes keytips for the tabs and for buttons in groups in those tabs. The first time that I use the keytips after starting-up the application, the keytip letters for the tabs show up after typing 'Alt,' but the letters DO NOT show up when...

Am I the only person here having this problem? A long internet search reveals a few others out there with similar problems, and a couple of solutions which involve some very complicated coding to force Access to recognize certain colors as transparent. Have any of you successfully used .png...

Thanks, Bannana. That worked as desired. I was trying something a lot more complicated on the theory that three right turns would make one left. But I missed a turn.