Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: atiaran
  • Content: Threads
  • Order by date
  1. atiaran

    SQL: Column populated by other table column names

    Hello people I've got this question. I have a view which has a column referring to the names of different columns in different tables and of different types. view: vw_call_history HISTID CALLNO COL-NAME PRE-VALUE CURR-VAL 50620 22038 OWNERID 16220 <NULL> 50620 22038...
  2. atiaran

    Date into SQL from MySQL via linked server

    Hi chaps I created a linked server within sql2000 to access data from a MySQL database. When the dates came across, they have a format of 13 digits that I cannot find anywhere on how to read it or how to convert it. Please can somebody help I am a bit desperate as I've looked everywhere...
  3. atiaran

    ODBD Connection within a SQL server db

    Hi there I am very new to sql server, so please help. I've got a database, which can be accessed via ODBC. But all the connection I had seen in the past with ODBC is always getting data from other db into Access db using the odbc data source. My question is, rather than using access db to...
  4. atiaran

    Access Error Message - HELLPPPPP

    Hi I've got a split database with mde, networked and used by more than 5 people. The db used to work to perfection before. One of the tables in the db was updated in the back end and every since it gets frozen quite often but unlock itself when left there for some time (sometimes for...
  5. atiaran

    automatic changing of email contents

    Hi I've created an html, the result of which is posted into a mailbox, that I am not able to access as it would be transferred somewhere else. But prior the transfer I need to change the content of the email. Could someone give me an idea or help with a solution for some kind of...
  6. atiaran

    Get rid of Action Queries confirmation in VBA

    Hi Whenever I used an Update/Delete Query I have to click on the message appearing &quot;You are about to run an update query that ...&quot; or &quot;You are about to delete ...&quot;. to confirm it and tick it back after. Could anybody know how to set that automatically in VBA so that I...
  7. atiaran

    Rounding numbers to fix (without decimal)

    I am using a Make table query to get the result of the query into a table. There are some decimal numbers in the results and although I changed the properties to be fixe (0 decimal) in the query design property, everytime I have the table the result change back to decimal. Is there anyway...
  8. atiaran

    Doing graphics in MS Access 2000 - HELPPP

    Hi all I am trying to get some graphics in Access 2000 and for some reason it does not work. I always get the following error: &quot;Microsoft can't find the file containing the linked OLE object you tried to update using the OLE/DDE links command.&quot; Could someone help me if they know...

Part and Inventory Search

Back
Top