Search results for query: *

Dim d1 As New Date(Now.Ticks), d2 As New Date(2000, 12, 25) Dim weekDays As Integer = Convert.ToInt32(New TimeSpan(d1.Ticks - d2.Ticks).Days / 7) * 5 If d1.DayOfWeek = DayOfWeek.Saturday OrElse d1.DayOfWeek = DayOfWeek.Sunday Then weekDays -= 1 If d2.DayOfWeek = DayOfWeek.Saturday OrElse...

Boy, I guess I need a cup of coffee. All of the above discussion pertains to the Xsd file created by Visual Studio when a strongly typed DataSet object is created. Sorry for not being more clear on the front end.

Sorry for my lack of clarity and imprecise language in my original post and response. Could you please post a link to where you found the above information? Thanks for taking time to respond!

Not sure if this is easy, but if the projects are included in a solution file, do the following: 1. In solution explorer, right click the project name and select Remove 2. Open a file explorer window and move the project file and its associated files to a new folder 3. In solution explorer...

Hello, From a Visual Studio Schema file: <Connections> <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="RbdmsConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="RbdmsConnectionString (MySettings)" ParameterPrefix="@"...

Hello all, In a schema xsd file, the connection string information is stored in a Connection element. What are the possible named attributes within that element and what do they mean? Thanks in advance for any ideas and/or suggestions!

Hello all, I have both MS Office 2003 and MS Office 2007 installed on my laptop. Whenever I switch Access versions, I get the Preparing to initialize Dialog. After impatiently waiting, it then opens up fine in which ever version. How can I get rid of the dialog? Thanks in advance for any ideas...

Hello, Sorry for the lack of clarity in my original post. I think we are saying the same thing, only I am using a separate Access.Application object to open another Access file from inside my current Access file via VBA. Dim AccessApp As Access.Application Set AccessApp =...

Hello all, I am opening up another access file and iterating the controls collection. I have a variable named AccessApp that I use to get a reference to a given form using DoCmd as follows: AccessApp.DoCmd.OpenForm "MyFormName", acDesign, , , acFormEdit, acWindowNormal I can iterate over the...

thread1462-1078826. I ran into this problem when I forgot to set up references to custom libraries in the subreport when using library functions.

For the benefit of others, here are some links pertaining to using SourceSafe with Access. You have to download and install Access Developer Extensions, afterwhich SourceControl options will be added to various menus and/or ribbons, depending upon the Access version you are using. Using Visual...

Hello all, Any ideas and/or suggestions on implementing version control with Access? I am working on a project which will require modifications to a 3rd party written Access database. There are a couple dozen forms, a few classes and modules, etc. Any ideas would be much appreciated!

Here is the code. In the Project, Compile tab, Option Infer must be set to On. Dim orig = dsOriginal.Tables(0).AsEnumerable() Dim updated = dsChanged.Tables(0).AsEnumerable() ' First, getting new records if any. Dim newRec = From u In updated _ Where Not (From o In orig _ Select...

Hello Jason, None of the language translators I normally use will handle this. Do you have a specific link I could try?

Can anyone help me translate this C# Linq code into VB.Net? It came from Comparing DataSets using LINQ: http://sql.codeproject.com/KB/linq/Comparing_Datasets.aspx?msg=2784336#xx2784336xx. Thanks! var orig = dsOriginal.Tables[0].AsEnumerable(); var updated = dsChanged.Tables[0].AsEnumerable()...

Hello karerda, Thanks for taking the time to post your code! I have been looking all over for examples of how to apply an Xsl transformation programmatically.

Hello, Regular expressions will do the trick for you. The pattern below needs to be tweaked because it leaves a blank line when doing the replace. I apologize that I don't have time to do that tweak but hopefully this will at least get you started. using System.Text.RegularExpressions...

Hello, This code in the main form load event worked for me in VS 2005: PanelForm pForm = new PanelForm(); pForm.TopLevel = false; pForm.Visible = true; this.Panel1.Controls.Add(pForm); pForm.Dock = DockStyle.Fill; Good Luck!

Can anyone help me translate this C# Linq code into VB.Net? It came from Comparing DataSets using LINQ: http://sql.codeproject.com/KB/linq/Comparing_Datasets.aspx?msg=2784336#xx2784336xx. Thanks! var orig = dsOriginal.Tables[0].AsEnumerable(); var updated = dsChanged.Tables[0].AsEnumerable()...

Hello all, If you mouse over a dll file in a file browser, you see the Assembly Information such as Company, Description, Version, etc. How do I retrieve that at run time from a user's selection out of an OpenFileDialog? Thanks in advance for any ideas and/or suggestions!