Search results for query: *

Thanks Dave, I did know that, what I wanted to do was drill down and actually delete the text1 control under that column which I found out how to do this way.... Select text1 under the specific column from the list, then click the Form Designer's title bar to make it active and then press DELETE.

I have a grid that I have added a combobox in a column, can I delete the reference to the text box under that column? I think you can, but am stumped on how to accomplish this. Thank you in advance.

In the interest of science I went back and tried Mike and Olaf's recommendations. Alas, they also worked fine. It's nice to have so many experts at hand. I'm sure I'll come up with another stumper(for me) soon. Until then.....

Imaginecorp, That did the trick, thank you ever so much. That little problem has been driving me nuts for quite a while. Again, great forum guys and gals.

Thanks Mike, I was afraid of that. I got the ShellExecute information from you. Do you have any recommendations on which of the two to use, remember I am slow, and where I might go to read up on them.

Dave, Thanks again for the timely response, but that did not work. Mike your method got me the line breaks I needed but as soon as it hits a '?' it truncates the rest of cDes. If I take the '?' and '&' out of the memo field all is well.

Thanks for the quick answer Dave. The only problem is I have no idea what you are talking about. Could you dumb it down a little.... Steve

I have an app where a user can type in a brief description of an activity in a table and then email that information to an outlook user. Here is what is in the record(a memo field)..... Hi, Does this way work any better? Please let me know, would you? Dave & Steve This is what gets into...

Thanks to all! I finally got it with this (thanks to all the feedback).... ( IIF( SEEK( "ROL" + STR(acontact.role,2), "MCT", "MCT" ), mct.name, "n/a" ) ) That has had me stumped for sometime, and since I use this technique though out the application I was getting very frustrated. Again...

Marcia, Thanks for your prompt reply. I had actually seen your response to this on another site and tried it. I obviously can't figure out the ('s and ['s and _fk's. I tried a lot of different combinations but just kept getting the error message that the record source had to be a variable...

Hello, I've been wrestling with this problem for some time now and I look to the experts for help. I have a form that contains a grid of a few of the fields that exist in my record for a quick view. I display that information and the remaining pertinent information of the current record below...

Thanks Mike, that makes sense. I just couldn't for the life of me figure out how to get that done. Would that be the same technique to use for declaring variables I may need throughout my form? I have vowed to get away from declaring public variables. Your continued help is greatly appreciated.

I'm having a real problem understanding scope within a form, method, whatever. I want to populate several different arrays with certain records from a code table and have them available for different combo boxes on different forms. When, where, and how should I create these arrays so that they...

Thank you one and all for your help. I decided to make the common field a character field and then I can index all the child tables with that field and whatever other field I want to order by in the grid. It might not be the best method, but it is the one that I understand the best. I...

Thanks for the input. I think that White you are a little closer to my specific situation. The one difference is my main realationship between the tables is a numeric field. I think that if I changed the appno numeric field to a character field in both the parent and child table and then...

I have a grid on a form that shows child records from another table. The child table has an index on a numeric, 4 length field that relates back to the parent table. I have them both set up in the data environment and things work fine. Now I realize that I want to show the child records in...

Will do, all the help is greatly appreciated.

Okay, thanks Mike.

That was it! Thanks Jim. One more quick question, what is the proper syntax in that example to place the results in a cursor?

Hi all, I'm trying to pull some data from a SQL db that we have to run a report of active clients. This is what I'm using: LOCAL lnHandle lnHandle = SQLConnect("xxx", "XX", "XXXXXX") IF lnHandle > -1 #1. SQLExec(lnHandle,"SELECT * FROM ENC","Results") #2...