Search results for query: *

Hello, I am very new to linux - I have just installed Yoper on a laptop that I have. I am not sure how to get it to connect to the internet. I previously had windows xp running on the machine and did not have any trouble to connecting. I have a DSL modem connected to the laptop. Is there a...

hello, I am using the following code to create a formula in a cell which refers to a cell on another worksheet - xlSheet.Range("I21").Formula = "='Worksheet Name'!E29" Every time I try to run the code, a browse for file dialog box opens up. How can I tell the code to use the named worksheet...

Hello, I have the taskbar set to autohide, but sometimes it does not disappear. This causes problems because sometimes I can't see action buttons at the bottom of the screen because they are hidden by the taskbar. Does anyone have any idea what might be causing the taskbar to not autohide...

Hello, I have a table that lists all locations for a customer. I have to create a seperate report for each location. How do I set a query to use the values in the location table as the filters for each run. I want to use vba to run through the query multiple times using each location value in...

Hello, I am trying to use vba to create an excel spreadsheet. The problem I am having revolves around 1 column. Some of the values in the column are numeric (eg, 1). There are a few with a value 09, which are coming in as text. I would like to do automation with vba, but I can't get these...

Hello, I am getting a page not found error when trying to access an ftp site using internet explorer. I can access the site just fine using the ftp command from the command prompt. Anyone have any idea why this might be happening? Other users can access the site just fine using internet...

Hello, I have 1 pc and 1 laptop at home. I would like to load the laptop with linux and am running windows on the pc. I was thinking of using the laptop to serve as my internet firewall. My question is this - what hardware do I need to set this up. I have a DSL internet connetion and would...

Hello, I have a strange problem with some queries. I have created an append query to append records to a table. It takes about 30 second to run. I saved the query, came back the next day, and the query takes a ridiculous amount of time to run. I have compacted database hoping to clear up...

Hello, I am using the following code to transfer data from an excel sheet into access. The code works fine except that it leaves an instance of excel running in the background. I thought that I have killed all objects running, but I can't get rid of the excel. Is there something I am missing...

Hello, I am running an Access query using vba. I would like to turn off the alert for running an append query. I thought the code to use was - DoCmd.SetWarnings = False But when I try to run it, I get a compile error saying 'Argument not optional'. Is this the wrong code to use? Thanks...

Hello, I am using transferspreadsheet to load an access table from an excel spreadsheet. It is working fine except for one thing. I want to load a second table from another worksheet within the workbook I am in. Is this possible? I switch worksheets before I use transferspreadsheet, but it...

Hello, I am having a problem creating a named range using excel vba. I am using the code below, but instead of inserting the named range for cell B899, it is putting it at B1795. Anyone have any idea how this could be happening? With xlBook .Names.Add Name:="Count", RefersTo:="=B899"...

Hello, How can I open a password protected excel using vba. Can this be done using the GetObject method? I was using xlApp.Workbooks.open, but would like to try using GetObject. Thanks

Hello, I am creating an Excel sheet from access queries using vba. Everytime I run the report, I have an instance of Excel running in the background until I close Access. I realize that I have to set all objects = nothing. Is there a way to find out what objects are present? I feel as though...

Hello, I am using the following code to delete some sheets from a workbook. I keep getting the error: "Object doesn't support this method or property". Could someone please tell me the proper object to use with this code? Thanks With Excel.ActiveWorkbook .DisplayAlerts = False...

Hello, I have found that I can create a directory using the code: MkDir "C:\My Documents" I was wondering if there is a simple way to check if this directory already exists before it is created. Thanks cmz

Hello, What code would I put in the click action of a command button on one form to launch a second form in the same database? Thanks cmz

Hello, I have a vba macro which uses access queries to create an excel workbook. Each Excel workbook is created from a command button on an access form. After I create the workbook, save it, and close via the macro, I still have an instance of excel running in the background. The code I use...

Hello, How can I determine which version of Flash a presentation has been done in? It is on a web page. Thanks cmz

Hello, I have a workbook with multiple sheets. I am trying to reference a cell on sheet "Basic 07-05" from my summary sheet. The "Basic 07-05" sheet has a named range called BasicCount. I know that the cell value I need would be "='Basic 07-05'!BasicCount. The problem I am running into is...