Search results for query: *

thanks for the input!

i'm trying to export a file thru access vba with a filename that has more than one period (".") in it. the filename is omtctr_brc.mth.20060401.gz i can't find anything on this subject. is there anyway to do this in access? thanks, rus

Thank you much Dave. I appreciate your help. Rus

...I have the rst open but I can't get anything to display. Dim rstTemp As DAO.Recordset Set rstTemp = CurrentDb.OpenRecordset("SELECT * FROM Agent WHERE [SITE]='GGTF'") Dim vararray As Variant rstTemp.MoveFirst Set vararray = rstTemp.GetRows(1) msgbox vararray rstTemp.Close My...

Thank you.

I'm trying to share a folder on the hard drive but the option is not available. I think it's the FAT file system that is preventing this. Is there a way to convert a FAT file system to NTFS without losing any software already installed? Thanks, Rus

Thanks for sharing your knowledge!

There is a workbook that has an auto_open macro that updates and calculates. The workbook sheets want to be password protected after the auto_open macro updates and calculates. Is there a VBA statement that will disable password protection at the start of the code and then enable just before...

Kevin, The code is running through the process but it doesn't like to add up the values of the cells when they are formatted to percentages. How can I get the code to accept the percentages? Rus

Thanks for sharing your expertise Kevin. It's right on the money. Rus

Hello, I'm trying to setup code that will, when a spreadsheet is opened, go thru 12 sheets, specific cell ranges, find the number of cells that are not blank in the cell range and store that value in a variable. From the stored variable, I'll be able to determine how many I should divide by in...

Hello, I'm trying to retain the "Wrap Text" cell format when I link a cell to another worksheet but it's not working. Both cells, the source cell and the linked cell, are formatted with wrap text. Any ideas how I can retain the format from the source cell to the linked cell...

A.C, you are right on the $$! Thanks for the help.

Hello, I'm trying to save a spreadsheet on a shared drive and also on my hard drive. The shared drive file is saved using the "Save" command, but when I'm saving the hard drive file I'm using the "SaveAs" command. How can I disable the Save Prompt via my code? Here is the...

Chance, I'll need some direction on how to give you a star.

Chance you're great, it works! Skip thanks for your response.

Thanks Chance...I'm on my way. How would I paste the value from another spreadsheet (file "1gar.xls" Cell "B2" and "B9") to the Var.Column& and a specific Row in the master (file "Interim_Data")? The column will change each day based on the date but...

Hello, I've got a spreadsheet with dates across the top (03/01...03/30) and each day I pull data to the hard drive that I want to populate in the right cells according to the date. I recorded a macro that opens the data files, the master sheet and transfers the data from the data files to...

When I click to export/save a report the default directory is the C:\TEMP directory. How can I change this so that the default is C:\My Documents? Also, do you know of a way to have a scheduled report automatically export a file with a "hard coded" file name? Thanks, Rus

I'm using sqlldr80 to import records into an Oracle table. Is there another method of getting the records into the table? Thanks in advance, Rus