Search results for query: *

Skip, I have tried this several ways, as I said. When I cut that code from the larger Proc to give you an example of what I was doing, I didn't remove the bit you referenced--and yes, it does open correctly when the function OpenTextFile fires. Trying it various ways, I can always copy the...

Here is generally the code I am using--this is one of many iterations. I made things visible so I could see what is happening. I open the first (existing) spreadsheet and then open a second one (blank). I have also tried creaing a new one. I pastespecial from the first to the second. Color and...

I am working in Access using VBA to processes spreadsheet lines. I copy failed lines to a second spreadsheet to re turn to the user. It is working using a range of cells and pastespecial to the second excel file. However, I can't get the column width to go from the original to the second...

Thank you for the reply--and for your help! It is much appreciated

Thank you for your help--the quick reply is much appreciated. We did check the Oracle_home variable and it was missing. It is hard to say for sure, since we tried several things and could have been better testing after each, but it appears that the presence of a sqlnet.ora in the same directory...

I got a new version of Toad version 9.1, and since then I cannot connect to my Oracle databases and get the message -TNS could not resolve service name. I am using the same TNSNAMES.ORA which worked before, and it is in the right location i believe ( becos i can select the database read from...

It worked PERFECTLY! Thanks you so much for the quick--and correct--answer. I really appreciate it! Have a star. Jax

Hello, I am familiar with SQL and VB, but am new to Access. I need to update a column in a table based on a heirarchy of other field values in that same table. I can't find a syntax that works using a SQL query in Access. I have tried IIF, but it only gives me one true, false--and I need...

Thank you for the suggestions. I will try a load and timeit--and I will review the FAQs

I am new to Access although I have used Oracle and Sybase. I need to use it to import a text file containing a list of IDs with some other descriptive information. The text file will have about 800,000 rows. The import will be to a shared network drive tuned for database performance. Can anyone...

I have figured out how to acomplish this, and have some clues to what I was doing wrong. So I thought I would share them. In my original forall, I tried to load all of the eligible items into a cursor and use it in the forall statement. I could not figure out how to get that to work. Instead I...

Good Afternoon, I need some help understanding buld collections and their use in a forall statement. I want to update multiple rows in a table based on the results set of a query (cursor). A simplified example of my current statement is shown below. It's been thought several interations as I try...

Mjia, There are different versions depending on features you want. The professional Suite, for excample, has lots of DBA stuff and trace/explain plan, etc. For a try-out of the database loader, the roacle Suite one works well. Download it and answer the questions about yourself. They will...

I use TOAD (Tool for Oracle Developers) from Quest software which allows you several options to load data as well as view and query. You can download a free 30 day copy from their web site. It's worth a try, I like it. Jax

SantaMufasa, I have benefited from your posting to others, and I also want to take this opportunity to thank you for your excellent help. Your clear explanations are works of beauty! Jax

Just to tie out this thread- I have figured out the problem. Somehow, out of the box or during re-installation of software, the file MSDART.DLL got broken. It was also an older version. I installed an updated version into the system32 subdirectory and all problems went away. I found it by...

Thanks for the questons--I'm still stuck. I installed the same VB and Oracle that I had on the old machine although it is a diffeent (newer) version of XP. I do not have any missing or invalid references when I check the project. I have personal Oracle 9i on the machine, and the database I am...

Kevin, Thanks for responding. I think that this is a VB error, possibly related to installation on the new XP machine, not an Oracle error. OR it's an Active X error. The message I am getting tells me that the method (open) of the object (_conection) failed. That is different than not getting...

Hello, I hope someone can help with this --its driving me crazy!! My trusty old machine crashed and I have a new XP professional which is so far a lot less than trusty. I have installed VB6 and a local Oracle database. When I run my VB app, it fails on the opening connectionstring with the...

thrybergh, Its not clear if you have a record in the time_record table, or no record for employees who have not entered hours. Depending on that, you have several choices for your query: If there is no record in time_record for an employee for the week you want, this will find it: Select...