Search results for query: *

Worked perfect!!

Thanks again! I did try to figure out a way to use SQL. Not my strong suit. I found you have to use SQL a lot to really be proficient with it. I'll give that a shot for practice. :-)

Thanks!! I will work with this. Helps a lot.

I have two databases I am trying to replace a fields in one. I know it might look crude, just after functionality. My question is why does the statement on the very last line only replace one record that matches when the usaworking has multiple records that match the customer field? SET SAFETY...

I am importing from an xml using simple statements such as: Xmltocursor("&Mxm", "cxm", 512) however, on field in the xml is needed as character I my new table. The problem appears to be that there is a '-' in the xml field. As an example in xml it is 45987-8. on import to cursor, the field...

That worked Olaf! Thanks!!

No. that didn't work either. I checked and indeed no password is required. Should I be trying a connection string instead? I don't know what Management Studio is.Has me stumped on what to do.

In the query, I used remote view wizard, opended data2 dbc, selected ODBC data source, selected my data source. This appears fine. In the ODBC Data Source Administrator, I have the userid stored. It is named it Mycom. It appeers to be fine. Again, there is no password required.

Ok, this looks like it will do what I want and get me closer to finishing this. However, I am in Connection Designer. I used the drop downdown to highlight my data source, filled in Userid, there is no password, and added data2 to the database field box. I then checked off never for 'when login...

Creating and using remote views is new to me. I figured out how to create a remote view using the wizard. Now I am attempting to create a small program that opens the view and copies it to a dbf file. So far so good. I have this: USE Data2!mycom IN 0 ------------------> login screen opens up...

yes! Thanks to you all. Mike your sample code was something I can understand adapt to my needs. Have a great 4th everyone

thanks for the replies. This looks a bit over my head. I will give it a shot though.

I've searched this forum with no success. What I am trying to do is locate a string of text in one file, in one folder of one drive on my network. The string is always unique. For Instance, I want to find the string "123456789123456" that is contained in any of the many .csv files in the folder...

Thanks Olaf. I was sure there had to be a simple simple solution.

This code works great for me to open a pdf however, what I want to do is not open it but have it saved as a new pdf. For instance when the operator chooses MYPDF from the form, it would not open it per se, rather it will copy it, create the temp.pdf and then open TEMP.PDF. I want to do this to...

It seems "thisform.tdisplay.refresh" was in the timer and not the init. I think that's what it was.

turns out it had to do with the clock. Got it solved.

This is something i've not seen before. My cursor is bouncing around in the field of a form. generally it is moving to the right most of the field as I enter information into it. Doesnt seem to matter if its a text field or a date field. I have tried using different fields as the control source...

Thanks everyone, finally got it to work great thanks to your input.

One more question if I may. One of my folder paths is: Y:\Digital Output Files\Working One-Off's\data. I am adding the final path as a variable <<mpre>>(for instance "\53698". When I hover over the final link in completed email,it looks perfect however, once I click the link it says "cannot...