Answer Questions

• nairB im very confused...

  hey all looking for some help. i have designed a multi layered database in access and have designed a front end for it in visual basic. now im stuck. i have never used either program befor but seem to be doing ok and collegues are giving that impression too. i just need to know how to link the front end to the back end no one here can help me and i have been stumped for ages on this. the database is stored on a server. eventually the program will be the main entry point for data from a chemical system.   many many thanks to anyone that can help   claireabell p.s. the data entered into the forms i have created as part of the front  end are stored as arrays and variables. See if the data ac ...Show All

• Spydaz Timed Duration Run

  I need to create a loop on the same thread that will loop for a given number of seconds and provide a means to stop while counting. How might I do this The following will start a subroutine iterating for 10 seconds when you click button1, while its running you can click button2 and it will tell you how long its been running and when its finished a message will indicate that it has finished. Public Class Form1 Dim startTime As DateTime Dim LoopTime As Integer = 10 '//Duration of Looping Process in seconds Dim EndTime As DateTime Public Sub Test(ByVal EndTime As DateTime) Dim x As Integer startTime = Now Do Until Now >= EndTime Application.DoEvents() ...Show All

• jay1234 How to detect Caps Lock or Num Lock or Scroll Lock state please?

  Hi,  I was creating my answer in this thread.>> http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1134317&SiteID=1 ...then i thought. 1) Is it possible to detect whether any Caps | Num | Scroll Lock is active at all please  I don't want to set a value based on whether or not the Caps Lock key was pressed.   I'd like to read from the system the bit value that illuminates the LED's on most keyboards instead, possible, anyone, please 2) Anyone know too if there is an online list of the Microsoft KB articles by KB article number or a way to bring up a list such as typing KB****** in a search engine So as to browse the KB articles numerically   Regards, S_DS   I'm n ...Show All

• goflorin Creating an Excel Object using VB.NET.

  Hi everyone, This is my problem: I am trying to create an excel object so I can run an excel macro. This is the code I a using: Dim oExcel As Excel.ApplicationClass Dim oBook As Excel.WorkbookClass Dim oBooks As Excel.Workbooks Dim missing As Object = System.Reflection.Missing.Value Me .TextBox1.Text = Me .TextBox1.Text + " Report Creation in progress Please Wait..." + vbCrLf 'Start Excel and open the workbook. oExcel = DirectCast (CreateObject("Excel.Application"), Excel.Application) oExcel.Visible = False oBooks = oExcel.Workbooks oBook = oBooks.Open("C:\Developpement\Project_RCP\RCP_App\Job Bruts\Job RCP.xls", missing, missing, missing, missin ...Show All

• ttfo Placing Picture Control Inside Another Pic Control

  I have an old VB6 program I wrote that I want to convert to VB2005. I have a picture control that is initially a long thin black band across the window ... then I have a second small picture control that has an image in it and I want to position this in the middle of the band and as the user hits the left or right arrow keys move the image left and right within the band. I am not sure how to get the bmp image in the band to begin with. This sounds ridiculously simple but I cannot figure out how to do it. I tried just changing the X,Y-coordinates of the small image to a point inside the black band but VB2005 says that I cannot change these coordinates in a picture control ["Expression is a value and therefore cannot be the target of an ...Show All

• jwize VB Express debug adds missing file to directory when starting???

  This is in reference to my previous post concerning changing Access databases. It seems VB Express in the debug mode does not use the Access database files defined in the code. Instead it loads a copy of the database from somewhere unknown and writes that copy to the directory where the code specifies the database should be, whether it is there or not. If it is there it replaces it. Here's the code: dbpath = "C:\XData\PPPos.mdb" DB1 = DAODBEngine_definst.OpenDatabase(dbpath) rs1 = DB1.OpenRecordset( "ModeTable" , DAO.RecordsetTypeEnum.dbOpenDynaset) I have been working with computers since 1960 and I have never seen anything like this where the code is ignored and the compiler goes and gets a copy of ne ...Show All

• J. Nail Hide/Show form causes form to reload

  Using VS 2005. Creating windows forms application. I have a search form that the user can enter their search criteria and then find records. The records found populate a grid. The user selects a record in the grid and then clicks open record button. The click event of the open record button does the following: Dim frm As New frmRS_ModMenu frm.Show() Me .Hide() 'This is frmSearchForm This works great. The user can enter data for the selected record and then close the form. When the data entry form is closed I do the following: frmSearchForm.Show() Me .Close() However, when I close the data entry form and call show on the search form the form load event fires only on the initial hide/show. This causes the sea ...Show All

• nativecpp Macro Certificates for Local use

  I have written an Excel application in VBA and need to have my coworkers access it regularly. However, they have to set the security to low or medium to use the macros I've created. Is there any way to create a local certificate for my coworkers so the medium security does not open the disable/enable window, and high security does not block the macros. Our IT guy insists that no one run on low security, and would prefer to see us all use high security. Can anyone point me in the right direction Thanks, Paul ...Show All

• Mehmet Metin Altuntas Full Text Search in Visual Basic

  I am trying to create a simple full-text search application in Visual Basic (2005 Professional trial version). I have been successful in doing full-text searches within SQL Server Management Studio using SQL queries, so the database has a working catalog, index, etc. Here is a sample SQL query statement that I have used in SQL Server Management Studio: SELECT SectionText FROM Full_Documents WHERE CONTAINS (SectionText, ' "radio" '); This query returned all the rows containing the word “radio” within the SectionText column of the Full_Documents table. I have placed a textbox (SearchTextBox), button, and listbox on a form in VB. I want to be able to type a word in the textbox, clic ...Show All

• RayRayN ComClass and backward compatibility

  Can anybody tell me the recommended way to expose VB.NET classes to COM if we expect the interfaces to change The Microsoft documentation recommends using the ComClass attribute (or template) for classes that need to be exposed to COM, but ComClass doesn't seem to have any provision for backward compatibility when I later add properties or methods to the class. If I just add public members to the VB.NET class, I get a COM interface with the same IID but with additional members. This violates the COM rule which states that COM interfaces must be immutable. Clearly I need to assign a new InterfaceID to the VB.NET class, while still implementing the old interface, and I am struggling to find any documentation on how to do this in a VB.N ...Show All

• Natalie276398 Browse for Folder Dialog Box

  I've been looking around the internet and I found a few pieces of sample code that uses SHBrowseForFolder, but I have no idea how to use it, or how to tweak it. I'm looking for something that hopefully VB .NET can provide, and hopefully is a little less verbose. Basically, I just want to browse for a folder in one of those windows dialog boxes, and when the user presses OK, the program will set a textbox's text to the selected path. The last time I did classroom VB programming was 5 years ago, back in HS, and we were using VB6 back then. If anybody can shine a light on this issue, I would greatly appreciate it! Hi ahmedilyas Thanks it helped me Sure. Try this:   Dim theF ...Show All

• glooey NO SQL Servers node in VS 2005 PROFESSIONAL Edition Server Explorer

  I have VS 2005 PROFESSIONAL Edition. When I drop the Servers node in the Server Explorer, I do not see a "SQL Servers" node in the tree. It is my understanding that VS 2005 PROFESSIONAL should show this node. Any ideas why this is not the case Thanks for your assistance. Manuelmpf, I check the http://msdn.microsoft.com/vstudio/tour/vs2005_guided_tour/GuidedTourGoals.htm website and compared the difference among the Express, Professional and Enterprise edition of Visual Studio 2005. If you use the Express Edition, there is no Server Explorer at all but the Database Explore. However, if you don't install anyy SQL Server Database on your operating system, I don't thhink the Server Explore ...Show All

• Woyler storing excel.xls files in db - truncated. CSV files instead?

  My application read/writes binary file data from the filesystem to the data base and sometimes back again This is all in vb.net 2005/sql2005. It works fine except for excel file, .xls. They are the exception. All data is stored in a varBinary(max) column. Images, pdf's, word docs, whatever all work fine, but not excel. Even very small test spreadsheets of 5k fail. "binary data would be truncated" is the exception. Has anyone experienced problems with this type of file A bytes a byte, I thought I call the procs like this: (1) entry.Blob = ReadBinaryFile(tbLookup.Text) (2) If Not EntriesDB.AddEntry(entry) Then MessageBox.Show("The Entry was not added. ", "Data Base Error") 'entries = ...Show All

• Xzarian MSG Box/and simple text box question

  Hi, I have an msgbox to show the user information they have typed in, and a yes/no button if it is correct: MsgBox("Are the following correct " & vbCrLf & "length: - ", MsgBoxStyle.YesNo) How do I get the answer from the msgbox so I can use it in an if then loop IF msg aswer is yes then ' do something Else ' do something else End If Text Box question:- I am sure this question has been answered 100s of times, but i could not find it on the forum:- I have a text box that the users enters a value you in, lets say amplifier gain. As amplifier gain can only be a) A number b) A number between 0 and 48 How do i, when the user types in something wrong disp ...Show All

• Muhammad Adel Terminal Services Control (msrdp.ocx) vs Remote Desktop Client 6.0 (KB925876)

  Hello! I am writing simple application (on VB6 first, then VB.Net and C# with the same result) that uses the control MsRdpClient2 from msrdp.ocx. Everything works well until I install Remote Desktop Connection 6.0 client update (KB925876). My application now said it cannot load this control from msrdp.ocx. Cheking msrdp.ocx file ... and found it's still available in "C:\WINDOWS\system32\web\tsweb\". Then simple test "regsvr32 msrdp.ocx" ... and now my application works again (but seems it's not good idea to do this on any computer except test lab). Doing registry state comparision before and after update installed shows that MsRdpClient2 now lives in mstscax.dll and if I understand correctly it's not now UI control( ). ...Show All