Search results for query: *

Herman posted a link to an article that describes the problem in detail. See the second post above.

Thanks, Ray, but I believe that this article applies to Oracle. I'm using MS Access. But, the good news is that the workaround that I mentioned in an earlier post appears to be working out for me.

You should be able to uninstall from the control panel / add remove programs. By the way, I've found that the (free) Microsoft add-in Visual Studio Installer is much more robust than the P&D Wizard.

That's a good idea. I think I forgot to mention that this application will be installed on 13 client machines. So, multi-user access is a big concern. What I really want to do is get rid of the ADODC's altogether. I was just scouring one of my reference books and it said that ADODC's have...

I'm using VB 6 SP5 with Access 97. I created a database app in the textbook fashion using ADODC's. Now that I'm in the testing phase, I'm finding all manor of problems with multi-user access using ADODC. I need to reconfigure my application so that I have one connection string, one connection...

Engineer2100 - Are you still out there?

Solved on my own. Found a function called Int( ) that returns the integer portion of a number.

I have a datagrid that displays an age (in years) based on a date of birth (mm/dd/yyyy). The following SQL is the data source for the grid. I want to truncate the Age field such that only the whole number appears, rather than a number with decimals. I tried using Format$ to format the result...

Is this a SQL statemenet for an Access database? If so, the code that you wrote should work.

This is totally untested pseudo code. You mentioned that you wanted this in one "query." So, my code may not be applicable since it would be a Sub Procedure. Not sure if you were wanted to do this in a database query. Dim myMonth As String Dim myDay As String Dim myDate As String...

Sorry to be so dense, but I'm still not clear on what I'm supposed to do. Can you post some sample code? Also, I'm not clear on what event will trigger this code. Is it in the activate event of the MDI form? Probably not, because it's always active, right? During the application startup...

Where do I put the code?

I'm trying to make a menu editor that functions similar to the way that MS Office apps do. I have a File/Close menu option in the MDI application, but I can't figure out how to code it. If the user clicks close (or uses the shortcut) I want to close the MDI child that has focus. I want the...

Sorry dvannoy - I was hoping that something would jump out at me, but the code looks exactly the same for both Click Events (as you said). Good luck finding a solution. If I run across anything, I'll post again.

Can you post your code - the Form Load Event and the Click Event of the Command Button. Maybe something will jump out at me.

ConnectionString is fine. I referenced it in code, and it worked fine. The problem is using the Constant in the Properties Window of an ADODC. For example, this works fine in code. cn.ConnectionString = iConnectionString However, if I type iConnectionString in the Properties Window for...

dvannoy - this sounds like the answer to your problem. I ran across this article in the Microsoft Knowledge base: HOWTO: Set Focus on a Column in a DataGrid Control (Q293348) http://support.microsoft.com/default.aspx?scid=kb;en-us;Q293348

I declared a Public Constant in a .bas module. Public Const iConnectionString As String = _ "Data Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=c:\TCJPD\VB Project Files\Test_TCJPD_Data.mdb;" & _ "Jet OLEDB:Database Password=tcjpd" Now I'm trying to...

Found a workaround on another tech site: If Adodc1.Recordset.EditMode <> adEditAdd Then Adodc1.Recordset.Update 'update case record Else Adodc1.Recordset.Update Adodc1.Recordset.Requery Adodc1.Recordset.MoveLast End If Worked like a charm. :o)

Herman - I read the article. This is exactly the problem that I'm having. Unfortunately, I can't upgrade to Access 2000, and I must use an auto number field. :o( Surely, there's got to be a way to resolve this. I hope that I don't have to code the auto number by hand. But, at this point...