Search results for query: *

A friend of mine was no longer able to get into Windows XP on her PC and wanted to save a lot of digital photos. So I took her PC, removed her HD and swapped it with my secondary HD. (My PC has a primary SATA drive w/ the OS and a secondary IDE drive for storage). When I turned on my PC, for...

I am extremely frustrated by the problems I'm having with my hard drives. Any help is much appreciated! I have an almost year old Dell XPS. Tried partitioning my 120gb SATA HD and the software f'ed it up! My partition with my data is still there but I have no way of accessing it. I figured my...

I'm having a difficult time doing what I would hope would be an easy task. I'm using CR in .NET...here is my example table: Week1 Wk2 Wk3 Wk4 WkN Total User1 3 8 7 2 20 User2 5 6 1 2 1 15 User3 1 4 9 5...

I have a form with a combo box. When a command button is hit, the value of this combo box is displayed on a label. I've placed the following error-check in the code for the command button click to make sure a value is selected in the combo box. If cmbJob.Value = Null Then MsgBox "No job...

I have a workbook with forms that interact with an Access DB. I want to just connect to the DB on Workbook-Open and close the connection when the workbook closes so I won't have to keep opening and closing the connection repeatedly. I tried "Global DB as DAO.Database" but it won't let me do...

I have a SQL query set to run and return a recordset from Access to Excel. When the user hits the 'Search' button on the form I hide the search form and would like a small 'Please wait...' form to display while the query is running and then close when the results are returned to Excel. My...

Is there any difference between executing a SQL command, based on user input in a spreadsheet, from Excel VBA to modify records in an Access table and loading an Access table into a recordset, modifying the recordset, and then updating the DB? Right now I'm using dbs.Execute SQL COMMANDS for...

This is probably easier than I'm making it out to be but I'm having trouble doing this: A user enters an account(s) on a spreadsheet, when they submit the file with the account(s), I want the macro to query an Access database to make sure that account exists, if not, I'll have an error message...

Anyone know how to get the User ID of the person who created a file in Novell? I know I can right-click on the file and go to "NetWare Info" and it's listed under "Owner:" but I would like to be able to use this attribute in VBA to send an email to the user. Thanks!

Anyone know how to get the User ID of the person who created a file in Novell? I know I can right-click on the file and go to "NetWare Info" and it's listed under "Owner:" but I would like to be able to use this attribute in VBA to send an email to the user. Thanks!

I'm using Excel & Access 97 on NT 4.0. Right now I have users entering data into an excel template which then saves as a .txt file. I'm working on saving the template data to a large database instead of .txt files. I've been reading up on DAO and ADO but am still not clear which I should go...

I have the following line to run an FTP script which transfers a file to a remote server and records the log in 'FTPoutput': Shell "cmd /c ftp -s:" & FTPscript & " > " & FTPoutput I want a msgbox to pop up after the transfer completes indicating that it was successful...

I've tried numerous resources online to ftp upload and am having no success. I'd rather not use a batch file, but whatever works I guess. I just want an excel macro to login, upload a file under a different remote name, logout, and preferably have a transfer log saved, that's all. Any help is...