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 Rhinorhino 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: ADoozer
  • Content: Threads
  • Order by date
  1. ADoozer

    Excel 2010 Worksheet.copy with CSV file

    Hi All. I have a "simple" little question... I use the following few lines of code all the time for importing a worksheet from an external excel workbook (xls, xlsm, csv) into my current excel workbook. Public Sub LoadData() Dim xlWB As Excel.Workbook Dim xlMain As Excel.Worksheet...
  2. ADoozer

    T-SQL (From C#) query taking progressively longer on 1 machine

    Hi All. I am having an issue with a T-SQL statement from a C# application on 1 machine. The more times the query executes the longer the time it takes to return. On my test machine the query takes less than 2 seconds (and can finish the batch in about 6 hours), but on the box in question the...
  3. ADoozer

    How to create table in SQL with Constraints

    Hi all... Please see thread183-1652081 I am trying to create a table with constraints to mimic an existing table. Any help would be greatly appreciated If somethings hard to do, its not worth doing - Homer Simpson Jack of all trades, king of none!
  4. ADoozer

    Creating a SQL statement to copy the structure of a table

    Hi folks. I have recently taken over a project which has a lot of SQL related elements. (SQL is really not my field but I can muddle through it). Anyway, the question. When I go into SQL Server Management Studio and right click on my table and select "Create To", A nicely formatted SQL...
  5. ADoozer

    writing bits to file

    having a rough day today so thought id throw out a post for help. the scenario is this, i have a program that creates datasets, with my original coding the data was outputted as padded char's as such:- type 1 data [byte][byte][byte][byte][byte][byte] [type][ set1 ][ set2 ][qual] type...
  6. ADoozer

    FTP or file sharing solution

    Ive run into the same problem everyone else seems to have regarding an FTP server on a local network. Im trying to access the ftp server from the internet, however it is located behind a router with NAT and this is obviously not allowing the connection. the router is a belkin f5d5230/4 which...
  7. ADoozer

    Annoying "Bug" involving regional settings

    ok, i know what the problem is.. and i can work around it. But i cant find a solution to the problem and hope that somebody here has encountered and overcome the problem. im working on a project which currently supports 3 languages (English(UK) Dutch(Netherlands) and Polish) the font size is...
  8. ADoozer

    exchange 5.5 and exchange pop3

    first off, i am not the network guy, he's on holiday until 17th july. im just the lucky mug whos trying to get it back working. setup: ADSL modem->hardware firewall->LAN 2 servers on the LAN, Vic running exchange 5.5 and Bob runnning exchange pop3. both incoming and outgoing emails are...
  9. ADoozer

    free source control programs

    hi, im looking to replace sourcesafe for reasons i wont go into. so the question is, can anyone recommend a free (pretty much unlimited*) secure source control app? features id like if possible: version control secure web checkout a decent database multi platform isnt a requirement but would...
  10. ADoozer

    "inserting code into a dll"

    im not realy sure if this should be posted in visual c++ or here, but this is the scenario. (note: i am no assembly programmer, i just understand the basics) i have a project which loads a DLL (win32). this dll manages connections to a server. anyway. i dont have access to the code of this...
  11. ADoozer

    error C2146 in winnt.h?!

    i know this is a basic error.. and im sure ive seen/solved it before but i need sleep and its driving me mad. im getting the following error when trying to compile very simple code. now im pretty sure theres nothing wrong with my winnt header file, can anyone spot my error cos i surely cant...
  12. ADoozer

    crazy problem, need another perspective

    background: over the last 4 years i have been writing modifications for a popular online game. the modifications are to original source released by the company back in 2002 and until this week i have never encountered this problem. the zip file containing the code was written to CD in 2004 and...
  13. ADoozer

    build and clean causing memory violations

    i was compiling a project earlier when my PC crashed. now whenever i try and build or clean i get MSDEV memory violations. i tried deleting the intermediate files, which stops the memory violations. But this causes 100s of errors sayiny cannot open vc60.idb (despite it being in the directory...
  14. ADoozer

    changing from value to %

    i have imported a bunch of CSV files into an XLS file, im hoping there is a quick fix that wont involve VB/VBA. there are 9 worksheets with this aproximate layout set1A set1B set1C set2A set2B set2C setnA setnB setnC 1 1000 2000 100 9999 8888 7777 xxxx xxxx xxxx 2 etc 3...
  15. ADoozer

    using DISTINCT with 2 tables INNER JOIN'ed (SQL syntax)

    SQLStr = "SELECT PlayerName FROM PlayersInHandData AS PIHD INNER JOIN ActionsData AS AD ON PIHD.HandID=AD.HandID WHERE AD.ActionType='DealCards' AND PIHD.SeatNumber=AD.SeatNumber" now that SQL command works, but returns multiple instances of the same PlayerName. i tried adding a DISTINCT into...
  16. ADoozer

    SQL statement problem

    firstly i cant change the structure of the tables. its an Access2000 DB, i have 3 tables tableA containing 2 fields (TableAID,TableAString) tableB again containing 2 fields (TableBID,TableBString) then tableLink containing 3 fields (TableLinkID,TableAID,TableBID) (i think this is set out this...
  17. ADoozer

    Access MDB and dates

    i know this has been covered a lot, but i cant get any of the solutions ive tried to work. i have a type Public Type HandData g_HandID As Long g_HandDate As Date g_WasSeated As Boolean g_XMLDump As String End Type Public Hands() As HandData i read values from a SQLite database...
  18. ADoozer

    strange behaviour of DLL

    i was going to post this in the VC++ forum but im having problems viewing it, anyways. i wrote a DLL in VC++ with a bunch of functions that i wanted to call from VB, this part is fine. however when i test my code from VB, i get different results from testing within VC++ i wont post all the...
  19. ADoozer

    regular expressions again

    having a stinker of a time writing an expression. ive managed to bodge it to work but i know it can be better. RE.Pattern = "(Deal|Show|Muck)(Cards|Flop|Turn|River)([\s\S]*?)<Card value=""([\s\S]*?)</Action>" (values im looking for are DealCards, DealFlop, DealTurn, DealRiver, ShowCards...
  20. ADoozer

    AUTO_INCREMENT now causing error

    im hoping this is a simple one. im using ADODB.Execute to run an SQL command. it worked perfectly fine at work, but now on my home machine its kicking up an error "incorrect CREATE TABLE syntax" Public Const sqlCreatePlayerTable As String = "CREATE TABLE PlayerData (PlayerID INTEGER NOT NULL...

Part and Inventory Search

Back
Top