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

    Problem with Batch File.

    Hi, I am using the following DOS command to loop through all directories within my current directory and retrieve the Size and Size on Disk properties: FOR /D %G in ("*") DO "c:\Eds Stuff\Get Directory Sizes\du.exe" -l 0 "%G" >>"c:\Eds Stuff\Get Directory Sizes\dir_details.txt" This works...
  2. Ed2020

    Upsizing to SQL Server.

    Hi, My employer has asked me to investigate options for migrating some of our larger MS Access 2003 databases to a more secure, stable and scaleable platform. One of the options I am looking at is migrating the databases to SQL Server 2008 whilst retaining the existing frontends. As a...
  3. Ed2020

    Strange Happenings with Several Databases.

    Hi, Over the past couple of weeks a number of different developers within the company I work for have been having problems with their Access databases. Users have been receiving three different error messages when opening the systems: 1. You do not have permissions to open this database...
  4. Ed2020

    vbCrLf in Memo Field.

    Hi, I have an Access table that includes a memo field. The memo field contains commments that frequently contain a vbCrLf character. When I export the resutls to Excel, the comments are split onto new lines each time a vbCrLf is encountered, however there is also a square box at the end of...
  5. Ed2020

    Conditional Formatting.

    Hi all, I need to create a subform, which will be displayed in datasheet view, and apply conditional formatting to each row based upon the value in a single column. So far, no problems at all, however I have eight separate conditions and Access 2003 only allows up to three. Placing code...
  6. Ed2020

    Web Pages Not Displaying.

    Hi all, I have a laptop running Vista Home Premium. After connecting to a wireless network I can ping websites by IP address and URL (so not a DNS problem) however no browser (IE, Firefox, Safari) will display web pages; I just get the standard “page could not be displayed” message. Ping and...
  7. Ed2020

    Maximum Row Length?

    Hi, I have been asked to perform some analysis on some tables within a large Oracle database to determine the maximum row length. I thought I could get the information from ALL_TAB_COLUMNS, with something along the lines of: SELECT SUM(?????) FROM ALL_TAB_COLUMNS WHERE...
  8. Ed2020

    USB Mouse Freezing Intermittently

    Hi all, I have an odd, intermittent problem with my (wired) USB mouse (optical) and I'm hoping somebody can help. Occasionally (perhaps once every few hours, sometimes less frequently) the mouse pointer will freeze, and when I look at the LED on the bottom of the mouse it is flashing on and...
  9. Ed2020

    ParentTable property of fields in pass-through query?

    Hi, I am attempting to write some code to identify all pass-through queries in an Access database, and return a list of all tables & fields used in them. The problem I have is that when iterating through the Fields collection the Field.ParentTable property only returns the name of the...
  10. Ed2020

    Width of drop-down list in Excel cell.

    Hi, I'm sure this is a really simple thing to do: I have a cell with data validations set as limited to a list. Some of the entries in the list are quite long, however I want the cell to be narrow (and only display the first character of the selection. When the user presses the arrow to...
  11. Ed2020

    Listing contents of a .zip file?

    Hi, If I have a list of .zip files is it possible, in VBA, to list the names of the files stored within it? I've done some Googling, but haven't found anything so far... Any help would be much appreciated. Cheers, Ed Metcalfe. Please do not feed the trolls.....
  12. Ed2020

    Copying photos off my iPhone.

    Hi, I'm trying to use the Windows Scanner & Fax Wizard to copy photos off my iPhone. As it runs through the process of copying the files it will copy a few and then displays the message "the current picture could not be copied". If I press retry it continues on for another few pictures and then...
  13. Ed2020

    Router causing cable modem problems?

    Hi, For the past week or so I have been having problems with my cable modem dropping its connection to the Internet. My cable provider has been out once to check the line and swap the modem, but I've been having the same problems since. Earlier today my Linksys WRT54G has turned its toes up -...
  14. Ed2020

    Removing References to Other DBs at Runtime.

    Hi, I have some code (pasted below) to search the modules in another database for instances of keywords. The code adds a reference to the target database, performs the search, and then removes the reference (References.Remove ref) The line to remove the reference isn't working for some reason...
  15. Ed2020

    Security Centre & Windows Update

    Hi, I have spent most of my weekend cleaning up a friend's PC which was absolutely *loaded* with malware of various descriptions. I'm pretty confident I have removed everything now but I have two issues outstanding that I haven't got to the bottom of yet: 1. If I try and get into Security...
  16. Ed2020

    Tracking files that have moved in VB6

    Hi, I have some code that generates a file listing for a specified directory or drive. My intention is to run this once a week for a number of weeks and maintain a list of a particular file type. I need to be able to track additions and deletions however some of the files get moved during the...
  17. Ed2020

    WHERE/GROUP BY Clause on Memo Field.

    Hi, I have a table in MS Access containing a list of Business Objects report files. The table contains a FileName field and an SQL field. FileName is stored in text and SQL is stored in a memo field (owing to the length of some of the SQL statements). It seems we have numerous copies of the...
  18. Ed2020

    VBA To Return Field and Table List?

    Hi, I need to create some VBA to analyse an SQL statement and provide a list of tables and fields referenced in the SQL. I've made a start, but the further I get into it the more complex it's getting! Does anyone already have anything that does this? Unfortunately I can't interrogate the...
  19. Ed2020

    Find DBs Accessing an Oracle Data Source?

    Hi, I have been asked to carry out a piece of analysis to identify all Access databases on our network share that access our Oracle MIS database. I need to come up with some code to cycle through each Access DB (details of all of them will be stored in a table of some description) and...
  20. Ed2020

    net2ftp.com - Is it safe?

    Hi, I've been taking a look at net2ftp.com as it may be of use to me in sending files to my website. I am a little uncomfortable with putting my user name and password details into a website when I can't be 100% sure that they're not being stored somewhere. Has anyone used this site? Or could...

Part and Inventory Search

Back
Top