Search results for query: *

Hi guys, Thank you very much for the valuable information! I was able to schedule and output to a CSV file.

Hi all! I have a basic question. I have a query that takes two dates as parameters that needs to be scheduled vie SQL*Plus. What is the command that I would need to use? What are the steps that I would need to take? Basically, I need the output to be spooled to an Excel file (or csv, if Excel...

Thanks much to both of you!!! The problem, just like both of you stated, is not with VB SQL. It is the ODBC driver that causes a problem.

Hello everyone! I have a VB 6.0 / Oracle 9i questions. Basically, I have this query that uses "with clause" as a temp in-line view. The reasons I have to do that is because I can't use PL/SQL (our group is not allowed to create objects in the database) so this temp view is used many times in the...

Hello, Sorry for the confusion Guys. Let me clarify the problem again: 1.The Report with truncated data in the Text Box is based on the Query. 2. That Query is based on the Table 3. Table in sequence gets populated from the Form. Everything is looks good until it gets to the Query. What I...

Hey Guys, Just figured out that I was wrong in my previous post, saying that data are not truncated in the table. It is truncated in the Table, but all data fully displayed on the Form. (???) The following is the "problem" Text Box Properties: Text Box Scope: FORMAT EMTRY...

THANKS a LOT for all of your advises! But it seems like dhookom was right, the problem with that memo field is that the data is being truncated in the query that report is based on. Now I'm stuck again and hoping for some help. The Report that currently has this problem is based on the...

Hello, Thanks lameid for you advise, but unfortunately that hasn't work either. I created blank report that displays only the textbox with the can grows set for only that problem record. And it's still showing truncated on the same page. Please advise, Thanks in advance! Valeria

Thank you Guys for your responses! But unfortunately,tried all of your fixes,none of them worked. I've also tried to adapt VBA "TextHeightWidth" solution, offered by Stephen Lebans and it hasn't worked either. Please advise, what else could possibly cause that kind of problem? Thank you in...

Hello, I have Access 2000, and I have a report with a text box which has the "Can Grow" & "can Shrink" set to yes. Regardless, it still doesn't show all the data of the text box. Tips? Thanks, Valeria

Ok, Thanks!

Thank you very much for your quick answer! I don’t understand why it works, but it does. I created the event, with no code inside and it took care of the problem. What was causing the problem and why did adding event resolve it? Thanks you again for your kind help!!! Valeriya

Sure, I get this is the exception: The GridView 'GridView1' fired event PageIndexChanging which wasn't handled. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it...

Hi. I have a problem with my GridView (asp.net 2.0)...Here is what I'm doing. My GridView is bound (HTML tags) to a DataSet. This GridView displays about 8,000 records (paging is enabled). I have added a TextBox which works as a filter on the GridView. User enters search value in this text...

It worked, thanks much!

I'm using an ObjectDataSource...Would that be handled differently? Thanks...Valeriya

Hello guys! I'm using a FormView to Update(Edit) records in my database. Here is my problem. My FormView is bound to the stored procedure that based on the 3 parameters updates a record in the data base. First parameter is a filter to go to the specific record and the other two will take on the...

Thanks a million! It's works perfect now! Do you happen to know how(or is it possible)to attach a date stamp along with Network User ID to the file name? Sub TextIOWrite(sText As String) Dim sFile As String Dim iFileNum As Integer sFile = "Newtwork Drive:\Network_Folder\m/d/yyyy h:mm...

Hi everyone! I wanted to see if there is a way to get rid off double quotes when programmatically writing string to a .txt file. In order for me to further use data from the text file it needs to be without double quotes. I tried to use Left() and Right() on the string, however, that yields no...

Blind me! :) I found my mistake too, just a bit ago. Thanks to both of you for telling me about reusing same object!!! Books don't talk about these issues much. Again thank you very much for the valuable tips! Valeriya