Date compatibility in VB and Oracle

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Visual Basic
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Backwards compatibility of VB6 with VB5? I've some concerns regarding backwards compatibility issues with VB6. I have this situation where an application developed in VB6 is to be deployed on a system running an application developed in VB5. The installation package for the vb6 application replaces common microsoft component files like COMDLG32.OCX on the system it is installed on. Would the VB5 application be affected by this installation? I've been trying to do a detailed comparison between the components (COMDLG32.OCX, COMCTL32.OCX, etc) used in VB5 and VB6, but i havent been able find any good resources documenting this. Pls recommend some gd links if u have any? Thanks! Tag: Date compatibility in VB and Oracle Tag: 675429
  - 2
    - VB.NET - Delete a registry key the same way RegEdit does? I have no idea how to word this. There is a bunch of registry keys. The default user has permission to delete these keys, but NOT change the value. (Read/Write = Allow, Set Value = Deny). The normal user (non admin) can open RegEdit, browse to the Key, and delete it with no problem. I figured it was a bit annoying to have to keep opening Registry Editor, browsing to the key, hitting delete, confirming the delete, etc... With a program I've written in VB.NET 2005, when the program is supposed to delete the key, it gets an Access Denied type of error. ('OpenRegKey, "keyname", True' throws an denied access exception) I don't know if it's trying to clear out sub-keys first or what. I want it to just attempt to delete the Key without even looking for anything under the key. Is there a way to make VB.NET (2005) DeleteKey the same way RegEdit does? As a work around, I ended up having the VB program create a REG file and then import it, as that allows you to delete the key without checking the contents. Tag: Date compatibility in VB and Oracle Tag: 675425
  - 3
    - Ctrl Space problem Dear all, I want to use CTRL Space for autocomplete typing. I have change the Input Method setting of XP to use CTL Shift Space for changing input method. VB does not auto show variable when I press CTRL Space. Is that mean I need to set something in VB in order to use Ctrl Space. Please suggest me how to configure the VB to use Ctrl Space. Thanks Tag: Date compatibility in VB and Oracle Tag: 675417
  - 4
    - How that is done? watching Randy Birch sample code at: http://vbnet.mvps.org/index.html?code/shell/shdirectorycopy.htm the GUI interface has frames with rounded corners, ditto for the buttons and the buttons, check/option boxes have shaded background. How that is done? Jack Tag: Date compatibility in VB and Oracle Tag: 675415
  - 5
    - Editing embedded manifest Is there a way to edit / modify a manifest that's already embedded in a resource file using the IDE / VB Editor? The only way I've been able to is to recompile the edited manifest into a res file and then re-add all of my other resources. ( icons, strings etc. ) If not, I've found a way to do it using a 3rd party program but I don't want to post it and pat my self on the back if I'm missing something already available in the editor. You can also "replace" the manifest resource in a compiled exe with it, for example updating them to Vista standards. I also embedded a resource manifest in VB6.exe so it no longer needs the vb6.exe.manifest file in the VB98 directory. Getting ready to add the Vista version and see what happens in Vista because "supposedly" in Vista the manifest must be embedded, unless I'm misreading MSDN and other how to pages. So before my head gets to big, someone show me something I've obviously missed ;-) -- Steve Easton Tag: Date compatibility in VB and Oracle Tag: 675413
  - 6
    - Dockable Windows; Help Hi, I've been futzing with this for over an hour now and getting nowhere. And, they're dumb questions, so they should be easy to answer <g>! Somehow, with a mouse-slip I managed to grab the docked Properties window and draw it across the screen so it's displayed horizontally. That's not bad enough, but in futzing around, I also managed to screw up the Project and Form windows by "practicing" on them to see how it was supposed to work! I've never seen anything so elusive to dock in my life as VB seems to have. And here's the real killer: If I set the Properties bar so dockable is unchecked, it'll go to the screen as expected and I can move it around, resized, etc.. But, the very second I touch the Docked checkmark, it jumps up and goes clear across the screen again! I -think- it's probably still docked to the right side of the screen, but there seems to be no way in hell I can resize it to anything less than the screen width! There are a couple of screen shots here for clarification: http://s198.photobucket.com/albums/aa116/apopriveta/?action=view&current=NotDocked.jpg shows the window with the tools undocked. And: http://s198.photobucket.com/albums/aa116/apopriveta/?action=view&current=Docakble.jpg shows what happens with Properties the second I click the unchecked "Dockable" dropdown. It won't let me put it anywhere else! I -think- I should be able to drag it to an edge and dock it there, no? In addition, now I seem to have the Projects window docked to the Form window, instead of them being one above the other and I can't fix that either! I sure hope someone can help me; it's nigh' on impossible to use VB like this unless I use those windows undocked. TIA, Pop` Tag: Date compatibility in VB and Oracle Tag: 675384
  - 7
    - Textbox change event -- respond only to user input? I want something like the textbox_change event but I want it to only respond to input typed or pasted into the textbox by a user -- not when the text is changed by VB code. How can I do that? Stan Hilliard Tag: Date compatibility in VB and Oracle Tag: 675381
  - 8
    - Looking for API equvalent of xcopy command Hello, I came across the problem with Windows copying files problem and I have decided to write my own utilty if unable to find ready made solution. The problem is as follows: When copying files (whole folders with subfolders) into different location and when some error occurs (for example "cannot read from disk" error) then Explorer quits copying files. When I restart copying I want to copy only the remaining files, not overwritng already copied files. However Explorer does not give me such option (it quits copying when the answer is No to "overwrite file?" question). Any comments appreciated, Jack Tag: Date compatibility in VB and Oracle Tag: 675377
  - 9
    - DataReport in Visual Basic 6 Hello, I would like to know if we can bind the same DataReport (Visual Basic 6) to two recordset at the same time. For example : Qr1 =" Select EMP_ID, FirstName, LastName from Pers where Function like 'Employee'" Rs1.open Qr1, mdbEmployee, adOpenDynamic, adLockPessimistic Set DataReport.DataSource = Rs1 DataReport.DataMember = "" DataReport.Sections("Detail").Controls("txtName").DataField = Rs1(1).Name If Rs1.RecordCount > 0 then Rs1.MoveFirst Do While not Rs1.EOF Qr2 = "Select DateShift From EmployeeShift Where " & Rs1!EMP_ID & _ " = Code Order By DateShift" Rs2.open Qr2, mdbEmployee, adOpenDynamic, adLockPessimistic Set DataReport.DataSource = Rs2 DataReport.DataMember = "" If Rs2.RecordCount > 0 then Rs2.MoveFirst i =1 Do While i < 30 Find = inValue(i, Rs2) Txtday = "txt" & i If Find = true then DataReport.Sections("Detail").Controls("txtday"). DataField = Rs2(0).Name Else DataReport.Sections("Detail").Controls("txtday"). DataField = "" End if i = i+1 Loop End if Rs1.MoveNext Loop End If DataReport.Refresh DataReport.Show End Sub During the execution I have the following error message: Runtime error '8526': DataField 'LastName' not found I just want to know if we can bind two different RecordSet to the Same DataReport. If we can't do that, which method can be use to view for example the calendar of employee ? Please, give me your answer if you have any information about that. Regards, Djamila Tag: Date compatibility in VB and Oracle Tag: 675366
  - 10
    - Sending a finished prorogram to others Hi all. Wold really appreciate someone explaining (or pointing me to a source) exactly how to make a package out of a vb application. The references are confusing (to me anyway!). I have made a project which works well with an exe file, but I understand that sending someone an exe file isn't the best way. I want to be able to send a friend or two this app on a CD and have them automatically set it up on their hard disk, and specify which directories will hold which program and data files for example, and I don't want the installeee to mess up any of his system files while attempting to install my application. To confuse things further, the installee may have XP and he may have Vista! Tag: Date compatibility in VB and Oracle Tag: 675365
  - 11
    - adding current date to mask edit control I have two masked controls for entering a date. Both have a mask of ##-##-####. The first uses a fixed date of "01012004".I put it into the first control with the statement meStart.Text = Format("01012004", "0#-##-####") - this works just fine The second control is to contain the current date. I am trying meEnd.Text = Format(Format(Date, "MMDDYYYY"), "0#-##-####") which does not work. I don't understand why this shouldn't be Ok. I have tried every way I can thing of to get the current date into the control but with no luck. What am I missing here? Chance Tag: Date compatibility in VB and Oracle Tag: 675363
  - 12
    - How to get the path from Windows Explorer? I need to retrive the current path Windows Explorer is pointing to. How to do that? Thanks, Jack Tag: Date compatibility in VB and Oracle Tag: 675358
  - 13
    - IDE layout Today I did something that caused my screen layout to change. Previously, there were three panes (frames?) on the screen. The left most panel showed the control icons, the middle pane showed the form and code layout and the right panel contained the Property and the Project displays. When I loaded a project the forms and code windows in the center pane were reduced. If I clicked on the expand icon in the upper right corner the form or code window filled the center pane. Now there are just two panes - the left control icon one and one other. I can click on View|Project Explores and View|Properties and show the section but they occupy the same space as the form/code sections. If I expand the form/code section they occupy the entire open space blocking out the Property/Project Explores windows. I have tried everything I can think of to get back to what was but no luck. Anyone have any suggestions as to how to rearrange this as it originally was? Marv Tag: Date compatibility in VB and Oracle Tag: 675356
  - 14
    - Find The Text :-) Hi all. I ask this question to see what (if any) ideas are given, it's a kind of find the Rect of the text question. Below is some code I quickly wrote as a demo, put the code in a form and on the form put 2 comboboxes named 'cboFind' and 'cboAlign' set the Style property of both to 2-Dropdown, the code will do the rest. The question is how to find the left and top (in pixels) of the text that is selected in the cboFind combo box with in the serch text. This is to do with a project that displays varied text in various places on a picturebox. The Rect of the main text is known and the text to search will allways be in the main text. The main text will be drawn first, then the find text will be highlighted, so it would be no good to draw whats left of the main text, then the find text then the rest of the main text. If the find text occures more than once in the main text then only the first occurance of the find text is needed. Any ideas? Have fun Ivar The Code: Option Explicit Private Declare Function DrawText Lib "user32" Alias _ "DrawTextA" (ByVal hdc As Long, ByVal lpStr As String, _ ByVal nCount As Long, lpRect As RECT, _ ByVal wFormat As Long) As Long Private Declare Function SetRect Lib "user32" _ (lpRect As RECT, ByVal X1 As Long, ByVal Y1 As Long, _ ByVal X2 As Long, ByVal Y2 As Long) As Long Private Type RECT Left As Long Top As Long Right As Long Bottom As Long End Type Private Const DT_LEFT As Long = &H0 Private Const DT_RIGHT As Long = &H2 Private Const DT_CENTER As Long = &H1 Private Const DT_WORDBREAK As Long = &H10 Private Sub cboAlign_Click() If Not Me.Visible Then Exit Sub DrawTheText End Sub Private Sub cboFind_Click() If Not Me.Visible Then Exit Sub DrawTheText End Sub Private Sub Form_Load() Me.ScaleMode = vbPixels Me.AutoRedraw = True With cboFind .AddItem "goes" .AddItem "er fo" .AddItem "programming" .AddItem "ile cer" .Move 350, 20 .ListIndex = 0 .Visible = True End With With cboAlign .AddItem "Left" .AddItem "Center" .AddItem "Right" .ItemData(0) = DT_LEFT .ItemData(1) = DT_CENTER .ItemData(2) = DT_RIGHT .Move 350, 50 .Visible = True .ListIndex = 0 End With DrawTheText End Sub Private Sub DrawTheText() Dim S As String Dim R As RECT Me.Cls S = "This chapter goes beyond the fundamentals of " S = S & "Visual Basic programming and introduces a variety " S = S & "of features that make it easier for you to create " S = S & "powerful, flexible applications." S = S & vbCrLf S = S & "For example, you can load multiple projects into " S = S & "a single session of the programming environment, " S = S & "work with Windows registry settings, or selectively " S = S & "compile certain parts of your program." SetRect R, 20, 20, 280, 500 DrawText Me.hdc, S, Len(S), R, _ cboAlign.ItemData(cboAlign.ListIndex) + DT_WORDBREAK End Sub Tag: Date compatibility in VB and Oracle Tag: 675343
  - 15
    - Track "WINWORD.EXE" VB6 Hi everyone, I have a case where there will be multiple "WINWORD.EXE" instances running at the same time in Task Manager. Each "WINWORD.EXE' might be controlling one Word document or a few Word documents or even none. (1) My question is, is there anyway to track like which "WINWORD.EXE" is controlling which Word Document(s). I want to do it programatically in VB. (2) And also, is there anyway to track any hanging "WINWORD.EXE"? As i can see sometime "WINWORD.EXE" is not close even though you close the word document. I want to do it programatically in VB. Help PLEASEE... Thanks.. Tag: Date compatibility in VB and Oracle Tag: 675339
  - 16
    - User control misunderstanding... Having a bit of a nightmare with user controls. Any tips great fully received... Project1 has Form1 and UserControl1 - works find Project2 has Form1 (from Project1) and UserControl1 (also used in Project1) - Every time I load Project2 I get an error relating to Form1 because Form1's UserControl is declared as Project1.UserControl1 Question is: How can I reuse a UserControl across different projects without compiling it into an OCX - or maybe I can't Cheers Nigel Tag: Date compatibility in VB and Oracle Tag: 675335
  - 17
    - Where to put my DLL's and OCX's This is a really basic question and I should be too embarrassed to ask... When distributing my app, where should I put my DLLs and OCXs. I've been putting them in the users SYSTEM32 directory and now I'm beginning to realise this is a BIG mistake. I think I should put them in the app's directory, is that so? Cheers Nigel Tag: Date compatibility in VB and Oracle Tag: 675330
  - 18
    - IconDisplay code, what's wrong? Hi, Just being beginner, and had to ask: I try to display an icon of my icon choice with following code as exactly as instructed in my VB6 book, but no icons displayed in my message box, however "display message box" code is written in further parts of code page of course, which is not present here due not to make a mess. What's wrong? Dim IconChoice As Integer If OptCritical.Value = True Then IconChoice = vbCritical ElseIf OptQuestion.Value = True Then IconChoice = vbQuestion ElseIf OptExclamation.Value = True Then IconChoice = vbExclamation ElseIf OptInformation.Value = True Then IconChoice = vbInformation ElseIf OptNoIcon.Value = True Then IconChoice = 0 Else MsgBox "Abnormal Icon Choice. Terminating Choice!" End End If Tag: Date compatibility in VB and Oracle Tag: 675328
  - 19
    - Read from an Unicode file Hallo. I'm trying to write in Cyrillic. I can Display it in a Label and also in a text File written with notepad. If I open the file and put it in the label caption i could not see the same Cyrillic text. Is there a way to solve this problem? Thanks, Qwerty Tag: Date compatibility in VB and Oracle Tag: 675327
  - 20
    - ID and Data in Combo Box Dear all, I want to populate a Data combo box . I want the combo box to store two value. One is the ID of the record and other is the UserName of the record. When the user select a Username, then the corresponding ID will be passed to other function. I do not want the ID of the record being shown in the Data combo . How can I do that? Tag: Date compatibility in VB and Oracle Tag: 675320
  - 21
    - Background When I log on I receive a message that C://windows/privacy-danger... can not be found or loaded. The background stays blank. If I go to the Control Panel and select a theme or background, I receive the same message Tag: Date compatibility in VB and Oracle Tag: 675318
  - 22
    - Random Access Data File Treatment Hi, Random File Access vs. creation of data file. When my program starts up I want to display selected fields of each record right on the Form itself as a reference for the user. Basically the program monitors and informs the user of when prescriptions and doctor visits need to be scheduled based on medications, refills allowed if any, and calculated dates of same. Therefore, the Form screen should be more than enough real estate to display 99.99% of user's medications without problem. According to my doctor, the most prescriptions he's ever seen anyone use was 21, which will fit on the screen for a resolution of 1024 x and up. I'll tackle 800 x when I'm more experienced <g>. My problem is: If it's the first time the program has run, or if the data file has been deleted or moved for some reason, the screen shows vertical bars "|" for data (00 according to my Hex Editor). I understand why; the file has been created by the access, but contains no data. At first I thought something like -------------- Function FileExists(filename) As Boolean If Dir("adata.dat") = "" Then FileExists = False MsgBox ("File does not exist. If this is the first time ... ") ' go to ... End If Stop End Function ------------- might work, but in the Procedure, it does nothing and I can't get past compile errors in the form code. I've tried it in a module, a ... form_activate, and even inside a ...click() procedure. The "Stop" is there just for a quick way to know whether anything ran in the Function or not. It has never executed for me. No part of the "If" will execute. Oh, the name "adata.dat" was chosen simply to get the file to always be at the top or bottom of the Explorer window so I could delete it quickly. I think basically it comes down to needing to smoothly handle the opening screen for the first-use of the program or in case the file is accidentally moved or deleted, meaning the program can't access any data. Example: If I previously entered Lodine and Effexor, the screen should look something like this when the program starts: Lodine 2 2-22-07 60 2 2 (date) (date) Flag Effexor 1 3-21-07 60 ... Then, as the user adds meds, they continue to append to the bottom of that list. That's also working OK; it only takes a Print statement, and next time the program runs, it's all included. But, if no meds have been entered yet, the screen, on first run of the program, will show |||||||||| | |||||||| || || || ||||||||| |||||||| (Don't count them; it's not accurately depicted) How should I handle that? I'd much rather put "no data" or something similar in there, say in place of the med name. I have the feeling I'm making a mountain out of a molehill here. I can provide code, but it's not very meaningful since there isn't anything there yet to detect whether the file exists or not. I hope this makes at least partial sense? TIA, Pop` Tag: Date compatibility in VB and Oracle Tag: 675311
  - 23
    - Is there a way to turn volume control level up or down with VB code? Is there a way to turn volume control level up or down with VB code? I have a application that uses sound features and need to find a way to turn up & down the volume with VB code...if it can be done I would appreciate your help. Tag: Date compatibility in VB and Oracle Tag: 675305
  - 24
    - VB 6 installation on a Vista machine I am trying to load VB6 onto a Vista machine. When installed I get the following error message when I start the program: Automation error: Error accessing the OLE registry. Can anybody explain how to overcome this problem. Thanks for your help Brian Smart Tag: Date compatibility in VB and Oracle Tag: 675292
  - 25
    - Time Puzzle VB6SP6 Puzzling on an efficient way to determine if a date-time is within a start-date-time and finish-date-time. Start and Finish can be hours or days or months apart. Maybe if datediff for start is neg and datediff for finish is pos, it is within the start ot finish time? Is there some other VB function that will do this? Tag: Date compatibility in VB and Oracle Tag: 675287
- Next
  - 1
    - VB6.0 Keeps running my loop but freezes the application, Can't sto I have a VB 6.0 Application. Very simple I am trying to program a start and stop button so for example you hit the button the program starts and executes some loop non-stop. Then i hit button 2 and the loop stops executing. The problem is that when i hit start the system takes over and I can't click any of the buttons. The only way to stop the loop is to close the program in Task manager. What I am doing wrong? Why is the software taking over like that? The cpu usage is minimal at that point 5% for the vb application. So its not like my system is frozen all the other aplications can be used fine durning that time. Thank you for you help Lukas Tag: Date compatibility in VB and Oracle Tag: 675283
  - 2
    - Converting an OCX to 'in project UserControl' Firstly, I suspect I'm on the wrong group - please forgive me (or advise otherwise) I have a simple usercontrol, compiled into an OCX and registered and used in several of my projects... I'm having a 'tidy-up' - bad idea! No I want to get rid of the OCX (in component form) and use the raw usercontrol in my projects. Is there a set order to do this? can someone help Do I unregistered the OCX then load the project (along with all the warnings)? Do I add the raw usercontrol, save the project, unregister OCX then reload? Cheers Nigel Tag: Date compatibility in VB and Oracle Tag: 675275
  - 3
    - If you are looking for 1) If you are looking for the truth to soothe and please your self, just click on this link. 2) If you are looking for the secrt of the family happiness, just click on this link 3) If you are looking for solving any social problem you face, just click on this link. http://www.islam-guide.com/ Tag: Date compatibility in VB and Oracle Tag: 675269
  - 4
    - Fixed width fonts question In VB6, is there a way of identifying the fixed width fonts present on a system? Alex Balfour Tag: Date compatibility in VB and Oracle Tag: 675268
  - 5
    - Concatenation headache SQL Server 2005 Express ssql = "SELECT tbl_Employees.EmployeeNumber + ' ' + tbl_Employees.FirstName As WDS FROM tbl_Employees" I am trying to concatenate two fields in SQL Server Express 2005. Employees number is int (Number) and Employees Firstname is varchar(String) I get the error Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the nvarchar value 'Jason' to data type int. Please help... Thanks very much in advance Tag: Date compatibility in VB and Oracle Tag: 675265
  - 6
    - I want to know what ending key is sent by Scanner Dear all, I have a scanner. But I do not know what ending character is sent by the Scanner. I think it maybe vbCrLf or Tab key. How can I view all the key code that the scanner sent? I have tried to set keypreview of the Form to True. And then I add a textbox to the form. Then I type in "Enter" to the textbox but the Textbox does not show any key code for Enter. Please Help Thanks. I just want to view all the key code sent by Scanner or Keyboard. How can I do that. Tag: Date compatibility in VB and Oracle Tag: 675264
  - 7
    - Parent object question I have the following 2 classical Classes setup: Order class: Private status as string ... Private m_objOrderItem As New classOrderItem ... ... Property Get objOrderItem() As classOrderItem Set objOrderItem = m_objOrderItem End Property ================= After I create many new Order objects, is there a easy way to access the correct parent Order from the OrderItem object ? Thanks Tag: Date compatibility in VB and Oracle Tag: 675260
  - 8
    - Check if a DLL exists... Is there a 'correct' way to tell if a DLL is installed on the target system Currently, I'm calling the function and capturing the error. Is a call to DllGetVersion correct?? Nigel Tag: Date compatibility in VB and Oracle Tag: 675234
  - 9
    - Become MCSD Certified I have found a resource providing marvelous information on the key concepts for those who want to be MCSD certified. Must Read!!! http://it-visionist.com/Certifications/MCSD/MCSD.asp Tag: Date compatibility in VB and Oracle Tag: 675228
  - 10
    - Module definitions/usages Hi, Since day one of my now few-weeks long playing with VB6 SP6 I've had a thorn in my side concerning Public statements. It seems so simple and yet it eludes me. Here's my problem: VB6, SP6, XP Pro, SP2+ Open a new code edit window by clicking View Code in the Project Mgr menu; no other code in it, virgin state. I type: Option Explicit Public Type AddressBook RecordNumber as Long ' 4 bytes Fname as string * 20 End Type Public ab as AddressBook. ------- end - press F5 -------- Compile Error: Cannot define Public UDT within private ... . And you probably wouldn't believe some of the other permutations and interpolations I've tried without success <g>. Would some kind soul take my hand please, and guide me through creating a Public UDT step by step? I'm often not very clear with my questions, it seems, so below is basically the same thing stated over again, just with greater verbosity: HOW do I tell the difference between a "standard" module and an "object" module? Precisely WHERE and HOW do I create a "standard" module so I can place Public statements in it? I cannot seem to get past the error message about placing a Public UDT in an object module. The few code snippets I've found which use Public statements all seem to be functions and seem to work. But when I try to use a Type-End Type in that same place in the IDE, I get that now dreaded error message <g>. I've found myriad posts/articles about where the Public Type definition goes, but none of those will SHOW me the surrounding code so I can get a handle on it! Several of them tell me to put it in the General Declarations portion of the window: Well, when I go to the code window and select "General" from the left column, and "Declarations" from the right side, it still fails; obviously I've misinterpreted something and haven't yet focused on the right place. TIA Pop` Tag: Date compatibility in VB and Oracle Tag: 675225
  - 11
    - VBA - Retrieving Network Login Name for VPN login Hi, I have used the api GetUserName to retrieve the user currently logged in to Windows for the purpose of permissions for an application. However, if a user logs into a network using a VPN connection and the login name is different than the login name currently logged in for the pc and he/she is accessing the database application remotely through that VPN connection, the GetUserName api returns only the login name from the pc, not the VPN connection (which is what I imagine it is supposed to do). Does anyone know how to retrieve the VPN login so the users accessing the application remotely through a VPN login (same as their regular network login) will still be recognized if the pc that is being used has a different user login name? I have tried using 'Environ("UserName")' but that seems to, again, retrieve the user name for the current pc login, not the VPN network login. Any thoughts on how to achieve this would be greatly appreciated. Michael Tag: Date compatibility in VB and Oracle Tag: 675209
  - 12
    - Is there a way to prevent multiple instances of program open at once? Is there a way to prevent multiple instances of program open at once? The user sometimes does not see the progam open (minimized) and opens another instance of the progam. I would like to know if there is a way to prevent this from happening. Please help. Tag: Date compatibility in VB and Oracle Tag: 675203
  - 13
    - Immediate window in VB.net 2005 Hello, all. I am running Visual Studio 2005 Standard edition, using VB.net. Though I can show the immediate window when in design mode it disappears when I start running my program in debug mode, and I cannot find any way of showing it, and therefore of using it to evaluate expressions, windows states etc. Using either the menu debug->windows->Immediate, or the keyboard short cut there listed CTRL-G, nothing happens if my cursor is in the code window; if my cursor is in the command window, all that happens is that the title bar of that window goes blank. As soon as I hit 'Stop debugging' the Immediate window reappears I am sure I must be missing something, but I have been wrestling with this for some time: I have downloaded Service Pack 1 in the hope that this was a known bug, but no joy. Thanking you in advance Charles Geach Tag: Date compatibility in VB and Oracle Tag: 675196
  - 14
    - How to trun off "Use MS Word to edit email message" in MS Outlook VB Hi everyone, I'm looking for a way to uncheck "Use MS Word to edit email message" in MS Outlook programatically. Does anyone know the code in VB?? Thanks. Tag: Date compatibility in VB and Oracle Tag: 675185
  - 15
    - Date format help SQL 2005 I have a DateTime Field that stores Date as "07/20/2007 10:20:0 AM" in Access MDB. I am trying to upsize the mdb file to SQL 2005 express. The SQL below works OK in Access to retrieve the record's year and week. In SQL 2005 express I get the error "format is not a built in function" ssql = "SELECT Format([DateOpen],'yyyy') AS YearPart, Format([DateOpen],'ww') AS WeekNum" My question... How should I change the above SQL to retrive both year and week on a given longdatetime field in SQL Express 2005. I am using ADO connection VB6SP5. I have googled but haven't found a clue. Thanks in advance Tag: Date compatibility in VB and Oracle Tag: 675181
  - 16
    - How to retrieve Serial ports base address Hi, i'm looking for a way to programmatically retrieve the I/O base address of the PC's serial ports (both standard or non standard, i.e. an USB to serial adapter). What i need to get the data shown in Control Panel > System > Hardware > Device Manager > Ports (COM & LPT) > Serial Port(COMx) > Properties > Resources > Resource Setting. Looking at the registry should be the way to go, but where ? I've found a solution who seems to work on Win2000 / XP, but *not* on Win98/ME due to the use of WMI (WinMgmts) call to retrieve the proper registry key to start from. Can anyone point me to the right way to accomplish this ? Thanks! Paolo Tag: Date compatibility in VB and Oracle Tag: 675168
  - 17
    - Two CSV file data to new excel file I am having two CSV files. I need to generate new excel file while running VBSCRIPT. That newly generated excel file sheet1 data should be first csv file data and the same file sheet2 data should be second csv file data.Newly generated excel file sheet1 name should be name of the first csv file and the same file sheet2 name should be name of the second csv file.I need only in VBSCRIPT not in VBA Thanks in advance for your help Tag: Date compatibility in VB and Oracle Tag: 675158
  - 18
    - Performance/load testing in VB6 Hi all, I'm trying to improve the performance of a VB6/COM+/SQL Server app, which performs very badly under moderate load conditions (multiple concurrent users, etc. the scenario fairly clearly understood). Not being a VB6 developer myself, I was wondering if anyone could recommend good product(s) for: * load testing; even if it doesn't provide any analysis features and is simply a way of simulating ongoing user interaction with the frontend * profiling VB6 code * static analysis of VB6 code Though we recognize that some of the problem(s) are likely at the backend, we've got a better idea of how to address those. If anyone has been through a similar process and can offer any advice, I'd be glad to receive it. Thanks, Glyn Tag: Date compatibility in VB and Oracle Tag: 675135
  - 19
    - Problem with DTPicker in Win98 Hi, I am using the DTPicker in an app to set the date as yyyy/mm/dd, but when I run the app in Win98 or 98SE the date shows up as m/dd/yy. Even with all the updates to Win98 and installing the mscomct2.ocx, with the app. Is there anyway to get this control to work as it does in WinXP in Win98? Thanks, -- Norm My programming is self-taught and my teacher was not very experienced. :-) normfowler_don'tuse_@hotmail.com Tag: Date compatibility in VB and Oracle Tag: 675105
  - 20
    - VB.NET VS VBA I need to take a Visual Basic class for work. Currently we USe VBA for programming in Access 2003. Local colleges offer classes in VB.NET. If I take the VB.NET would I be able to apply the knowledge to VBA. Thanks for any feedback. Tag: Date compatibility in VB and Oracle Tag: 675101
  - 21
    - decouple gui from bo still trying to understand oo <g> principle was recommended to decouple gui from other classes in this little project I have (among other things) cClient (store info about clients, .Name etc) cClients(collection class of client objects) frmJobStart(form gui) frmJobStart shows list of client names for user to select from so it needs a list of names, but if i'm understanding previous advice, form shouldn't know about cClient or cClients so where, in the past, I would have given form the property: '-------------------------- .Clients As cClients and I would have had a private sub inside the form to load the listbox Private Sub LoadClientList() For Each Client In Me.Clients Me.Listbox.AddItem Client.Name Next Client End Sub this would have been "automatically" called when forms' .Clients property was set with a Clients object '-------------------------- but that means form needs to have a reference to cClient and cClients so to de-couple that relationship, i changed to the following '-------------------------- Form property .Clients As Collection 'have to make this public now and call from calling proc Public Sub LoadClientList() Dim vClientName as variant' just to use foreach For Each vClientName In Me.Clients Me.Listbox.AddItem vClientName Next End Sub '-------------------------- using a Main.bas file to"orchestrate" the forms and classes as a "middle man" Sub Main() Dim f As frmJobStart Set f = New frmJobStart Dim moClients As cClients Set moClients = New cClients'this loads all client info into collection '------------------------------------ 'to keep gui from knowing about cClient class I have to do this outside of form Dim oClient As cClient 'manually load forms' client collection For Each oClient In moClients f.Clients.Add oClient.Name Next oClient 'manually tell form to load it's listbox f.LoadClientList '------------------------------------ f.Show End Sub previous version where form knows clients Sub Main() Dim f As frmJobStart Set f = New frmJobStart Dim moClients As cClients Set moClients = New cClients Set f.Clients = moClients f.Show End Sub so to my eye Sub Main becomes more complex, but is this the correct way to do it? Thanks to all my very patient oo tutors <g> mark Tag: Date compatibility in VB and Oracle Tag: 675097
  - 22
    - RecLength for Random File Hi all, I'm on now to what I call phase II of my VB learning effort: Getting an actual Random file to work. I've made "pieces" work as I went along, but I'm starting now from scratch writing the actual code. And of course, I'm stumped right away. I can't seem to create a RecLength as the VB6 SP6 Help indicates I should do it; it keeps coming up '0' length. I can set Len to what I want (Len = 50) and know about what it needs to be, and it'll work that way, but ... . I'm probably doing something pretty stupid again because I have samples that work and I've duplicated them as best I can! I think <g>. Maybe. Umm, ... . Could someone peruse my code below and straighten me out please? It's pretty simple; nothing but the bare bones right now. Also: I don't see anything inherent that limits the length of the field inputs, so I assume it's up to the coder to restrict someone from entering 1,111 when the max allowed for a field by design is 2 digits. Therefore, it's up to me to enforce that, right? TIA, Pop` ------- code -------- ' txtMed; txtNumRefills; txtLastRefill; txtNumInRefill; ' txtNumOnHand; txtNumPerDay; ' cmdADD; cmdDone; cmd EXIT ======= Public Sub Load() Option Explicit Option Base 1 Option Compare Text Type Fields Med As String * 20 NumRefills As Integer ' 2 NumLastRefill As Date ' 18 NumInRefill As Integer ' 2 NumOnHand As Integer ' 2 NumPerDay As Integer ' 2 ' 46 total characters needed End Type Public MyRec As Fields ' Record variable Public Position As Long ' current record position Public LastRecord As Long ' Last Record in the File. End Sub =========== Private Sub cmdAdd_Click() Dim FileNum As Integer Dim RecLength As Long RecLength = Len(MyRec) ' RecLength = 50 FileNum = FreeFile Open "MyRandom.dat" For Random As FileNum Len = RecLength End Sub ======== Private Sub cmdEXIT_Click() Unload Form1 End Sub ------- end code --------- Tag: Date compatibility in VB and Oracle Tag: 675096
  - 23
    - Find existence of an element in an array of controls Hello, I'm using an array of control created at run-time in vb6. I would like to know how can I test the existence of a certain element. I'm trying with an exact index, but not all elements exists. For instance we can supose we have only the elements with index: 0, 5, 11, 112. I would like to make this test without rise a managed error. Thanks in advance, Qwerty Tag: Date compatibility in VB and Oracle Tag: 675093
  - 24
    - VB6 Regfree Com Ok. I really want to get this regfree com to work, but all of the info I can find is for clickonce (.net), which I have no interest in. For clarification, here is what I would like to do. 1) Place all DLL and OCX files in app directory, and create the appname.exe.local file to force the exe to use local files 2) Use Regfree COM to get those registered on the fly (I *do* need to do this, right?) Is this possible? This seemingly simply thing that would make things soooo easy? Can anyone point me to a good article on how to do this (complete with CLSID's) for the Regfee com manifests)? We have been using molebox for the past year, but it is extremely unreliable on dual-core processors (we are finding), and I have not been able to get timely responses from them for fixes, so I need to figure another way to do this. Any help is much appreciated. Thanks - -- Anthony Dunleavy http://blog.onenerd.net/ Tag: Date compatibility in VB and Oracle Tag: 675089
  - 25
    - VISTA and VB SQL Help problem Hello, I am running VB6 under Vista Pro. When I click on SQL word such as INSERT, JOIN etc., the help window opens but comes with an error message "There was a problem running the macro 1037". It still displays the help but all trhe See also, Example, Specifics menu items disabled. I installed WinHelp new version. Is there any work around for this problem? Thank you. Athena Tag: Date compatibility in VB and Oracle Tag: 675088

Hi

I have a oracle function, the function returns a date value.
The return value is in the format of 'DD-MON-YYYYHH24:MI:SS'.

For eg: the value of the variable which is returned is from oracle
function is
" 31-aug-2006 00:00:00 ".
(the data type of the variable is date)

And I am also formatting the return value using to_date in oracle
function.

When I call this function from VB, the returned value will be "20-
AUG-003100:00:00".

Could you please suggest.

Thanks.

Top

Re: Date compatibility in VB and Oracle by Dave

Dave
Mon Jul 23 05:43:52 CDT 2007

As you haven't actually asked a clear question I don't know if this will
help, but you can make Oracle use any specific date/time format by executing
the follow command:
ConnectionOracle.Execute "ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD
HH24:MI:SS';"
(Obviously change the format string to whatever you need).
This alteration will only apply to the connection that it is executed on,
there will be no effect to any other users of the database.

Regards
Dave O.

"sowjanya" <sowjanya.nukala@gmail.com> wrote in message
news:1185176415.904947.325010@w3g2000hsg.googlegroups.com...
> Hi
>
> I have a oracle function, the function returns a date value.
> The return value is in the format of 'DD-MON-YYYYHH24:MI:SS'.
>
> For eg: the value of the variable which is returned is from oracle
> function is
> " 31-aug-2006 00:00:00 ".
> (the data type of the variable is date)
>
> And I am also formatting the return value using to_date in oracle
> function.
>
> When I call this function from VB, the returned value will be "20-
> AUG-003100:00:00".
>
> Could you please suggest.
>
> Thanks.
>

Top