Search results for query: *

Hi I need to read blocks of a binary data file with Visual Studio 2005. I can't seem to find a way of checking for Eof (End of file) looping around a FileStream ReadBytes operation. I can't find Eof values in the FileStream class and I tried to catch the possible error during ReadBytes but...

Hi I got an odd but very irritating problem with Excel 2002 (XP) I have 5 sheets in a workbook. If I select a sheet and key a value into cell A1 the value also appears on 2 of the other sheets in cell A1. If I format the cell the formatting appears on the other sheets. Any idea why this would...

Hi I have an exchange 5.5 server. A few weekends ago the server became unstable, ran slow and erratic, and for some reason sent the last few weeks of already sent emails again!!! Does anyone have any experience as to why this would happen? stella indigo Regards Stella There are 10 types...

Hi Got a problem with my Exchange 5.5 Server. I use IMAP4 for roaming users and Direct EXCHANGE (Outlook) clients for in the office users. Our Exchange server crashed over the weekend and since a reboot the IMAP4 clients can't connect. SMTP and direct-EXCHANGE access is OK. I can't telnet...

Hi This maybe a simple solution to something I've lost the plot with, I have a text box on a form that is filled with status data as a process is running. The box fills OK (normally with 900 lines of status data) It has 10 lines of text in view. My problem is that the box does not Autoscroll...

Hi I've just installed office 2007 and the gui is different. Any one know how to get the new style windows, menus, dialog etc? Regards Stella There are 10 types of people in the world. Those that understand binary and those that don't.

Hi Everyone I'm having problems reading a datafile full of XML data into a dataset then posting it back to a database table (access). Here's my code, Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim cnTrackConnection...

Hi Everyone I'm writing an application that stores data in an Access table. It receives data from an XML file (15mB to 20mB in size). Is there a quick way to load the data into the Access table, like Access VBA Application.ImportXML? I don't want to invoke Access as the client PC's might not...

Hi I have an MS Access 2002 database with a table that I need to insert values into from VB 2005. I have defined the dataasource and everything works OK except the insert does not insert any data! It doesn't report any error so it looks like it works but the table remains empty. Here's my...

Hi I'm having a problem setting up my win2k server as a network router with RRAS. I have 2 ip ranges running over the same cable, 172.16.0.0 and 172.17.0.0. The 'single' NIC in the server has been assigned addresses 172.16.0.254 and 172.17.0.254. from the server I can ping clients on both...

Hi I'm having problems with getting the cursor to change from the pointer to hourglass and back again. I'm using Access 2002 with Service Pack 3 The following code is called from an OnClick event from a form "Form_SwitchBoard". The code does run, as it loads data into a table then deletes...

Hi everyone. I have a problem creating an xy scatter chart in excel. I have a series of XY data that I want to plot on a chart. Which does not present a problem, however each point has a unique name. I want to be able to hold the pointer over a single point and the correct name to be...

Hi I have a problem where my admin staff have a large number of Excel workbooks that have links to external data sources. They need to send the workbooks to mobile users so the formula and external links need to be converted to values so they can read. My thought is to copy the workbook and...

An app I am to develope requires a database of products. The app could be running on a single PC or multiple PC's connected together all accessing the same DB. Any suggestions on the best database to use? The only requirements are it must be able to support multiple users and have the facility...

Hi I am writing an app this will be used in several countries and I want to provide the user with messages etc. in their native language. I was looking at having an xml file with all my text for each supported language then when the app launches I load the text for the appriopriate language...

I have a query which needs to execute some VBA before and after the query runs. I can't find an event for the query like Before or After. Can I do this? There are 10 types of people in the world. Those that understand binary and those that don't.

Hi I have a db with 250,000+ stock records. Each record has amoung other fields the usage for each month, jan, feb .. dec. If I ran the report at any time I want to sum the last 3 months. So, I run the report in Apr, the sum is (jan + feb + mar), if I run it in May it's (feb + mar + apr). I...

Hi I need to do to emulate the MOUSEOVER event on an access form. Similar to mouse over on a Web page. Is there any way to do this or am I going to have to do it with data pages. Ta There are 10 types of people in the world. Those that understand binary and those that don't.

I have a table, order_number (number) status_code (number) date_of_status (date/time) An order_number can have several entries for each time the status code is updated/progressed so, for example, 000001,100,10/11/2003 11:00:00 000001,101,10/11/2003 11:20:00 000001,102,12/11/2003...

Hi everyone OK, I'm new to programming with Access Basic and/or Visual Basic. I'm trying to import data from xml files that are present in a folder. The whole process should scan the folder, load each xml file and delete each file afterwards. I'm getting stuck with my ImportXML method. I've...