Search results for query: *

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

I'm trying to figure out how the recordset object works. How do you read through a recordset and capture variables? 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'")...

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

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

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

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

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

How can I get the layout of a table to display? I've used DRAW but that only shows the fields. I'm looking for fields, data type and length. Thanks in advance, Rus

I'm sending keys from access to another application so I can FTP a file. Everything works fine until the SendKeys accesses the FTP site which takes a second or two. Is there a way to send a second or two pause via code so the code will wait until the FTP site is displayed completely? Thanks...

How can I get the current date, formatted to "mmdd", to show in an exported filename? Thanks

Is there a more relible connection than ODBC. I'm connecting to Oracle and receive a call block error many times. Thanks