Search results for query: *

I have a table with an identity column and would like to get the next value that it will use programmable before inserting into the table.

I have a new system with more processers and have copied a database from my existing system. On the existing system everything works fine, however on the new system any updates performed on fields with a datatype of text fail when the update text includes a call to a function that returns a...

I have two queries from seperate data sources; Source 1 Field1 Field2 1 Fred 2 Chris 3 Matt Source 2 Field1 Field2 1 1000 2 2550 3 5000 I have linked the two queries via Field 1. However, when I combine them in a table I get Field1 Name...

I have a textbox,held on a SSTab control, which when the form is displayed if is filled with large amount of text the textbox seems to disappear. When you click over the location of the textbox, the actual text is displayed but not the control outline.

I have an MSHFlexGrid with many rows, each cell on the top two rows have identical text across all columns. When I merge the two rows, the first is aligned to the left and second aligned to the right. Does any one know how to align both rows to the left.

I have created mobile application that detects the connection to an access point. The app works well, but returns the IP info for the device itself. What I need is the IP info for the access point?

I have a Winsock control that is to be used for SMTP email. When connecting I get the response from server through the DataArrival Event. However, once connected I start to sent the commands and get no response. If I try the same commands through telnet everything works OK.

Using a SSTab control with 4 tabs, each containing a number of additional controls. Is there a way that from the individual controls, I can determine which tab they are sitting on so that I can programmaticly select the correct tab?

I have added a menu to my application using the menu editor, is there any way that I can add graphics to each option? ED

I have the code below which pastes the contents of a listview into Excel. A number of the fields are dates which are shown in the system short date format (dd/mm/yyyy). The data is first copied to the clipbaord and then pasted. On viewing the spreadsheet, Excel converts those dates with a day...

I have two tables with the exact same structure, but contain different data, in two seperate schemas. I want to create a view so that too the users it looks like they are looking at one table.

I am stepping through a sequence of dates and formatting them for the week and year according to ISO Standards. (i.e first day of week is Monday, First week of Year has at least 4 days of January.) Format(selecteddate,"YYYY/WW",vbMonday,vbFirstFourDays) I don't get a problem until I reach the...

I have an issue when selecting a control with the mouse. I am using the SelStart and SelLength properties in the GotFocus event on my controls, but when I get focus on the control using the mouse the text selected starts at the begining and only selected the text upto the point at where the...

Is there a way that I can generate a list of all the forms in a project at runtime?

I have a procedure in a database which requires to be run every 30 minutes. Is there a system trigger setting that will fire this procedure at the determined intervals.

I have an application that uses the SQL Server DTS package, and want to compile for distribution. I've added the files specified by the SQL Server redist.txt file but the application still errors with 'ActiveX can't create object'. In addition to the files below, does anyone know what other...

I want to provide the list of available outlook profiles from within a VB application. I know where the Profiles sit within the registry; HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows Messaging Subsystem\Profiles But since they are keys and not values, I need to know...

I am trying to create a outlook type view for my application. I don't want to display mail message's but just want the layout. Basicly the view needs to be a combination of the treeview, where I can collapse and expanded grouping information, along with a listview where, once expanded specified...

I have created a VB application, and want to distribute it using the Windows Installer. Does anyone know of a program that will generate the MSI file automatically from the VB Project?

I am using the code below to connect to a Lotus Notes Client, but when it gets to the Initialize command the error message 'Can't find ID File' appears. I've tried with both with and without the password and the same error message appears. Dim NotesSess As Object Dim NotesDBase As...