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!

  • Congratulations Chriss Miller 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: mutley1
  • Content: Threads
  • Order by date
  1. mutley1

    Table update says must use updateable query.

    Hey guys, code below. Trying to convert a text field to date time and thought I would convert thwe text first using the below (from 20110131 to 01/31/2011 as an example), but I keep getting "must use Updateable query" Any help appreciated as its a long time since I programmed, but this loooks...
  2. mutley1

    Connecting SQL to Access 2010

    Hey Experts, I have SQL 2000 (old I know) and access 2010. I have looked up steps on google but once I have managed to get a linked server, I can't query the data even using full qualifiers (select count (*) from [server]..[table] etc etc.....) but it comes up with table not found. I have now...
  3. mutley1

    SQL2000 / Access 2010 connectivity

    Hey guys, I have an access 2010 DB on my desktop and want to connect SQL 2000 to it so I can use SQL to manipulate the data. I have googled but everthing that comes back is regarding access upsizing etc. or creating linked tables (which I don't really want to do I just want to access the raw...
  4. mutley1

    XLSX import to DTS (SQL 2000)

    Can anyone give me a good guide to serttingup an XLSX import? Does iot alway have to be the same file name? I set up the driver but it doesn't like the file. I keep having to repoint the packge setp to the specific sheet every time, so I have got round it by just saving the file off and thn...
  5. mutley1

    Dump attachment / scan / format / send SQL 2000

    I realise this may be considered for the DTS section but I have done all that formatting etc. already, so here's why I opted for the programming section. Inbound Excel, I convert, outbound file, I send. Does anyone know if there is a way that when the mail comes in with an attachment, that i...
  6. mutley1

    *2007* - Insert attachments into forms

    OK, I have a DB with 2 forms. both have a detail segment only. I also have a table with 8 forms imported into the DB as attahments. Ther fromt end is seperate from the DB. Nothing difficult so far (well, the rest isn't either, but....) The table has 2 fields, ID (Auto), Desc, Attachment and...
  7. mutley1

    Liven up Excel 2007 charts?

    Hi experts, I have a double column bar chart (each person has a given & received column) but wanted to liven it up a bit. I have a backgroupd, put it in 3D and changed bar colors. Quick question, is there a way to get the bars to flash, run thru all colors (like a glowing effect) or anything...
  8. mutley1

    Another date question (SQL 2000)

    Hi guys, I had a read through the useful date time items as always, but cant work this one out. I have 2 fields that are datetime for a diabetic - bloodlasteaten and blooddate (when blood is drawn). What i also have is a computed column giving hours between the blood being drawn and the time...
  9. mutley1

    Long mail message in Access 2007 using outlook

    I know i posted this in another thread, but I have found what seems to be a simple VBA to run the send of a message over 255 chars. Problem is, when I put the entire text of the email in, it doen not seem to like it and it auto add's speech marks etc. in the message body. Code is below. Sub...
  10. mutley1

    Send long message in email object. (2007)

    Hi all, I have a message that is probably about 500 words long and am using the Run Macro on a button then SendObject. I get the warning that the message is too long when I copy and paste it into message box in the create macro screen. Is there an easy way to do this without VBA etc., i.e...
  11. mutley1

    Count connections to my 2007 database

    Hey Experts, Just a quick question. I have a DB on a drive and the front end is on everyone’s machines (Access 2007). Is there a way I can add a table to the database that counts how many people log in - or not even a table maybe, just a way to see amount of connections? I want to get an idea...
  12. mutley1

    Directory listing at detail level of form (2007)

    Hi Guys, I have a form with an input box for the user. When they enter a code, it populates part of a directory link which works fine, and is based on the client ID. Basically, for example, lets say the client has an inbound directory, and outbound directory and a pending directory. Lets say...
  13. mutley1

    Multi user access db

    Hi Guys, sorry - the access newbie again. Couldn't find a specific Access forum but this is kinda form related too. I have been working on a DB which is quite small (about 50MB) and want to have about 30 users, maybe all logged in at the same time but pretty inactive so it is not taking a...
  14. mutley1

    2 Combo boxes cacel out the filter.

    I am trying to get a 2 drop down combo boxes in a form header to filter the detail in the form, but every time I select the value from the first it is fine, but when I select the 2nd it wipes out the filter from the first. Example data: Table being used for detail is called "Clm837PQualifier"...
  15. mutley1

    Storing and calculating current time

    OK, I give up. Googled all over the place and can't find a simple answer so hoping the experts can help me out here. trying to create a simple table of state codes, time difference and current time. In a SQL table, I have: StateCode - e.g. NY StateName - New York StateTimeDiff - 3 (i.e. 3...
  16. mutley1

    Data retrieval to Access 2007 from SQL with user input

    Hi Guys, totally new to this so please don't send a "let me google that for you link". I am a SQL DBA but never used access before and have a simple question. I am looking for a web site with quick lessons on data retrieval using access. I have linked Access to my SQL table and want a simple...
  17. mutley1

    US Medical HCPC / CPT Codes

    Hey guys, Does anyone know if there is a database available (or spreadsheet or some source!) for HCPC / CPT codes (preferably both) as I am trying to create a DB and am having problems finding a definitive source? TIA, M.
  18. mutley1

    Excel 2007 - Creating Radio Buttons

    Hi All, new to Excel 2007 so probably an easy one. I have 4 columns of data and in each one of the 4 I want 3 radio buttons saying "ACK" and "REJ" and "UNK". I can create the first 3 fine and only one can be highlighted at any one time. However, how do I create another set of 3 on the same...
  19. mutley1

    Viable quick restore cheat?

    Hi guys, SQL 2000 I have limited space on my snad box server and am testing multiple delete functions on a 10GB DB. Have a backup of the best cutdown I can get but it is tedious waiting 20 mins for it to restore to do next full test run. Q. If i get it to a decent start state, detach it, take...
  20. mutley1

    SQL 2000 Indexes

    Hi guys, I've written something in SQL 2000 to retrieve all the user indexes including table, index name, fields it is made up od and the position in the index. This has all come from sysobjects, sysindexes and syskeys. I can get everything from that, but cant find any field, indicator or...

Part and Inventory Search

Back
Top