Search results for query: *

Hello, I have recently designed some Microsoft Access Forms which can be used by users to manipulate data in an SQL 2000 database. The forms are linked to the SQL tables. The problem I am having is in one environment the forms are able to access the data and manipulate data within the SQL...

For you info, Found the answer, my primary keys in the SQL table were defined as bigint which Access did not like. Once I reduced these to int data type they linked fine

The Data in the SQL database has been restored from another machine, I think this may be the issue that is cuasing trouble. When I view the data in SQL however all primary keys, data types and data appear to be correct. Have tried creating a new SQL database, restoring data again and defining a...

Hello to all, I am trying to Microsoft Access link tables to an SQL database. My ODBC is ok, there is definately data in the database (when I import data to Access it populates OK) but when I try linking my linked tables appear with every cell having #Deleted in it. Any help would be...

Just wondering if there is a way to convert a word document to excel. My issue is I am trying to retain formatting, so the Word>Select All>Copy>Excel>Paste Special>Text isnt really returning the formatting as I would like it. Also trying to achieve the result without preparing a macro. Any...

Hello all, Will list some code below I am trying to execute. Have a client who will execute a program from a shared network drive. Wanting to automatically load a file from network to my excel sheet program. My issue is that on different users computers it might be mapped as F or J or X drive...

The following code was designed using a macro in Excel 2002. It is designed so that when a user clicks a command button it exports external data from a .csv file. This code is not running however in Excel 2000. Am hoping to find a solution that will work in either Excel 97 or 2000 for our...

The following code was designed using a macro in Excel 2002. It is designed so that when a user clicks a command button it exports external data from a .csv file. This code is not running however in Excel 2000. Am hoping to find a solution that will work in either Excel 97 or 2000 for our...

Have tried that option but it still wont change positions??

hi all, Was wondering if Crystal Reports offers the ability to set a default file location for the dialog box when you select File Open or File Save as I seem to think that it defaults to the last location you were accessing but was wanting to know if this could be set at all Thanks