Recent content by ListO

I found the source of this slowdown problem. I have not found the solution, but if others bump in to this, it may help them. My database application is designed to be used for specific projects. On almost all forms, the name of the active project is shown at the top corner of the form. The...

Thanks for the quick response, AH. I did as you suggested, and VBE did open faster, but I think it was a function of having no code windows open, and all the folders in the project window were closed. I saw no improvement in the database performance. When I opened the folders in the Project...

Those are all excellent questions, which i've been asking myself. The sluggishness DOES act as though the data tables were on a slow server in Ashgabat, but they really are here on my laptop: C:\CueMaster\Tables\Essex 2 The "C:\" is the virtual drive within the VM. I don't suppose this...

I'm using VMware Fusion because it worked the best 10 years ago, and up until VMWare was purchased by another conglomerate, they had excellent customer service. I know times change, but I forgot to. I did increase the memory allocation to Fusion, and it improved quite a bit, but it's nowhere as...

I am having that sort of problem on a VM, although I'm using VMWare Fusion. What do you know about this slowdown?

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