Search results for query: *

hi, I have access code that performs opens excel and runs web queries. Not all the time but randomly I will get this error. Run-time error '1004'; Unable to open http://www.xxxxxxxxxxxxxx The connection to this Internet site took longer than the alloted time. Set dbase = CurrentDb Set objXL...

I have some code that will save the excel attachments from messages in a certain folder to a folder on the network. I need some help in modifying this code only to look at emails with Todays date. The email folder has the same message in it mutiply times. I get a new excel sheet everyday with...

Hi, I have a excel sheet that has 2 columns. column A is a part number and column B has a string of text. there can be numerous entries in column A of one value. Column A Column B 1 1111111 1 2222222 1 3333333 1 4444444 2 1111111 2...

Need some help getting thru my brainlock. I have a form with 2 combo boxes and a tab form with 2 tabs. The combo boxes are used as criteria for 2 unbound subforms. My question is how do I insert the subforms, one on each tab. When I use the subform tool, it acts like I'm putting these on top of...

On a Win2K system, Office 2K When opening email attachment xxx.csv, the file opens correctly with Excel When opening email attachment xxx1.csv, the file opens a System32 folder and does not open excel. These csv files are from our own system. The same file name is emailed twice a day. We...

On a Win2K system, Office 2K When opening attachment xxx.csv, the file opens correctly with Excel When opening attachment xxx1.csv, the file opens a System32 folder and does not open excel. Any ideas of what could be causing this, and how could I fix it.

I'm looking for some help, I would like to create some code that I can take all the emails in my INBOX and move them to the INBOX of my personal folder. Any help would be appreciated.

I have a laptop with wireless on it. If I'm surfing the web, can somebpdy else see whats on my computer? If so, how can I protect my laptop for this type if intrusion?

I currently have the following code that loops thru a hard coded range of rows, looking for a sub-total formula that meets my criteria. Once I find a cell that meets that I change the cells color and border. Is there a way that I can set this dynamically instead of hard coding the range of...

This just stared happening and I dont know what I changed to do it. All my ms office apps open minimized and I have to maximize them manually. Does anybody have any ideas. I'm running Windows 2000 professional and Office 2000 SP1

Does anybody know how to replace an '*' from a cell. I've tried a couple different ways but can not do it. Example: Cell A1 = S02/A02* and I want it to be S02/A02. I can use the SUBSTITUTE function, but I want to search the entire spreadsheet. Thanks

I have the following code that creates a new worksheet for each store in a range and copies data into each sheet. Everything works ok except I loose all my page setup I have on the master sheet. I brainlocking on what to change to copy the whole sheet, formating and all. Public Sub StoreData()...

I'm stuck, I need to paste the data from an excel sheet into the body of an outlook email. I dont want to send it as an attachment, just paste it into the body. I already have the code for everything except pasting the data, any ideas.

Does anybody know how I take my access query results and have them automatically paste into a existing workbook on an existing worksheet? Thanks

Does anybody know how I take my access query results and have them automatically paste into a existing workbook on an existing worksheet? Thanks

I want to copy files from one directory to another. I can use the FileCopy command and get this to work but I have to hard code each file name and its path. Is there away to use wild cards to do something like this?? This code works FileCopy "C:\Temp\file.xls&quot...

I have a form with a import command button that runs thru a series of import data than running some update queries. I would like to add a progress bar that shows what query is running and the status of the query. Does anybody have any ideas or direction to point me in.

I have code that sends a query from Access to Excel formated. I want to freeze the top row of the worksheet. Any ideas??? Everything I've tried doest work

I am trying to connect from Access to an A/S 400 database and would prefer not to use ODBC. Does anyone know ADO code to establish a connection to query A/S 400 tables/views? Thanks

I am trying to connect from Access to an A/S 400 database and would prefer not to use ODBC. Does anyone know ADO code to establish a connection to query A/S 400 tables/views? Thanks