Search results for query: *

I have an Excel Comma seperated values file (A) and a macros file (B). On my machine B reads A perfectly but on another machine B does not read 2 columns which are formatted custom H:mm:ss. Does anyone know why this would happen, or what I can do to fix it.This is a copy of the code I am...

Hi I have an Excel Comma seperated values file (A) and a macros file (B). On my machine B reads A perfectly but on another machine B does not read 2 columns which are formatted custom H:mm:ss. Does anyone know why this would happen, or what I can do to fix it.

Hi Apologies if I am not in the right forum but I have a vb6 application which inserts an xml file into the database record by record. I make up the insert sql stmt and do an execute. however it takes 4 minutes to insert 4612 records. I had originally gone it using .NET and it takes 37 seconds...

Hi I have recently moved from Windows 2000 and Access2000 to Windows XP and Access2003. One of my reports references public variables on a form. It works fine on Win2K/Access2000 but not on XP/2003. Some of the machines it works on have access2002 on them so I am wondering is it a file or...

Hi, i want to import an excel spreadsheet using Visual Basic. I have done it in VBA using the docmd.transferspreadsheet but I cant seem to find an easy way of doing it using vb. anyone any ideas. thanks,

Hi, Does anyone know if you can pass in a filename for a DTS package. I did the import and saved the package but I want to run the same procedure on different filenames. When I did the import I had to select the filename.At the moment I have three different packages even though the structure of...

Hi I have an Access2002 database with forms, reports etc. I have a report that displays some public variables from one of my forms. It all works fine in Access2000 (database was created using this) but when I run it on Access2003 all that comes up is ?name# as if it can't find the public...

Hi, I have an asp page which opens an Excel object, fills out a spreadsheet, renames it and opens it in a new window. Works fine on all the machines except for one. It creates the excel spreadsheet but the window does not seem to open. I have compared the Internet settings and they are the...

Hi, I get an excel file everymonth which is cumulative so it contains the previous months details plus this months. Is there any way I can compare the two files so that I can then delete the ones I have previously dealt with. It has to be a cumulative file because its a 3rd party product. Its...

Hi, We are using SQL Server 2000 and I have Enterprise Manager on my local machine. When EM is open the firewall says that the Slammer Worm is active. When I close it down it goes away. I have read all the Microsoft info on it and their best solution was to install the SP3 which we have done...

Hi, does anyone know if there is a way of dynamically changing the text on a gif file. This is the code I have which has text on the graphic. I don't want to hardcode the text though. <!--webbot bot=&quot;ImageMap&quot; text=&quot; (286,31) (404, 161) {Solution Product Description Version...

When you move items from the sent items to another folder it gives your name as the from person.Does anyone know if there is any way of keeping the original sender? thanks a mill, Sinead

Hi, I was wondering if its possible to work with Outlook the way you can with Access (ie. VBA). When I move an email to another folder I want to automatically send another email. Does anyone know if this is possible and where would I start. Is there a VBA option with outlook. much...

Hi, We have a shipping database where a user enters the address given on an online order form. We have found that in the majority of cases the address is invalid and would like to trap it when the user enters the address into our database. (We have no contact with the customer). The majority...

Hello there, I was wondering if its possible to restrict what a user can enter in to a column in a table. I am using SQL Server 2000 with an Access front end. I know in Access you can use the lookup wizard which shows a drop down of the valid values but when I exit the database its not saved...

Hi, We upgraded our database from Access to SQL Server and it went very well. We kept the Access front end for our users and noticed that the tables that had a currency field was displaying the currency in Pounds and not Euro. We tried to set the format to euro in the access database but when...

Hi, Has anyone had any experience with the Label Wizard in Access. I have created a report which is 101mm*152mm. I have a labelling printer connected and this is the size of the label. When I do the size of the label in Word and do a print preview the page is the size of the label whereas when...

Hi, I have exported all my access tables to sql server and created some stored procedures from my access queries. I have a couple of reports and forms that use the access queries and now I would like to update them to reference the sql server ones instead. Does anyone know if this is possible...

Hi, I have a table with some text fields with the Allow Zero Length = No. I am creating a sql statement to insert the record into the database. The statement fails if some of the fields are not entered.Is there an easy way to check if the fields are null rather than having an 'if' statment for...

Hi, I have an access database and I was wondering if its possible to generate the create table scripts so that I can create the database on other machines rather than doing it manually. If not does anyone know how to create a table with an autonumber using SQL. thanks in advance, Sinead