Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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.....

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...

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 -...

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...

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...

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...

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...

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...

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...

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...