Search results for query: *

I'm trying to automate from MS Access an excel spreadsheet and programmatically add an autofilter to the 3rd row. The problem is every syntax I use puts it on the first row. Does anyone know how to code adding an autofilter to the 3rd row of an excel worksheet using VBA. Thanks much for any...

I am trying to save an mpp project file as a project database file via vba code in an access module. It doesn't like the formatID "MSProject.mpd" even though I took it directly from the help file. Does anyone know how to make this work. The end goal is to open a series of project files in...

I have a program that is structured like this sub Main Dim objXL as excel.application Dim objwkb as excel.workbook dim objsht as excel.worksheet Set Objxl=.. set objwkb=.. set objsht=... Do stuff here Call Sub Procedure Call Sub Procedure set objsht=nothing set objwkb=nothing set...

I have this code (from MSKB) tied to a combo box on a form. Unfortunately, I want it to refer to another databases objects and not the current one. Can anyone tell me how to revise this code to call the objects in another database? Thanks for any assistance! Dim accObject As...

I have been developing in MS Access for over 10 years and now find myself in an environment using an application designed in visual fox pro 6.0. Can anyone suggest some books or reference links that will get me up to speed on the basics and beyond? Specific topics of interest... Interface...

Can anyone help me code this feature? The objects design: Main form with a tab control and multiple tabs. On one tab is a sub form with continous forms type. Functionality: The user can enter currency values in several fields on the tab specific sub form records. After each value is...

Anyone know of a method for importing in a scanned image and then converting the image to editable lines, circles, and other shapes? I'm using visio 2003. Basically, I have a paper drawing of an office layout that I need to convert into a visio drawing. Unfortunately I am required to make it...

For some reason when I attempt to import hyperlinks from excel to access I lose the hyperlink and only import the "Name" of the hyperlink (not the path). I tinkered around with excel and access trying to find a solution. I tried importing into an existing table with fields defined. I tried...

I have an application that will be storing documents names files paths in relation to projects numbers. Where I am having an issue is trying to use that path as a hyperlink in code. How do i tell access to open a file based on a path? Keep in mind that these files are in a variety of formats...

' Create a new instance of Excel. Set objExcel = CreateObject("Excel.Application") ' Show the instance of Excel on the screen. objExcel.Visible = True ' Open a file named SampleFile.xls objExcel.workbooks.Open "\\Ntfrfddls08\CCT_Share\Project Reports\Prioritized Demand List\Prioritized Demand...

I'm sure I can probably do this but not sure how. Can anyone suggest a solution? I have a table that looks like this 1,bill,Design 1,sally,test 1,tom,test 2,frank,design I'd like to return to a cell all names from the second column that have the number 1 in the first column and test in the...

Can anyone suggest a function or procedure to return a cell location based on these conditions in this type of worksheet? Worksheet is Project Status Date Date2 Date3... CR0664 Complete 1 1 CR0664 Complete 1 CR0884 Cancelled 1 I'd like to...

Does anyone have code they can post for Excel that uses the autofilter command to delete any blank rows in a worksheet? Thanks for any responses

This code errors at the Set rstTL = db.OpenRecordset(strQ2, dbOpenDynaset, dbReadOnly) I can't figure out why. Is there a special syntax for calling a query in a recordset? The help files show that its possible though do not show specifically how to do this by calling a variable. Perhaps...

Dim db As Database Dim rstDIS As DAO.Recordset Dim rstTL As DAO.Recordset Dim rstCR As DAO.Recordset Dim rstDef As DAO.Recordset Dim strQ As String Dim strQ2 As String Dim strTL As String Dim IDN As Integer Set db = CurrentDb ' Define Selection...

This line produces error 3709: The connection cannot be used to perform this operation. It is either closed or invalid in this context. I suspect it has to do with the strQ variable that stores the name of a query. however, the name produced from the debug window is a valid query object. The...

Dim RowStart As Range Dim RowFinish As Range Worksheets("sheet1").Activate Set RowStart = Cells("A11") Set RowFinish = Cells("A500") RowStart.Select Do While ActiveCell < Cells(RowFinish) If ActiveCell = "" Then Rows(ActiveCell).Select Selection.Delete Shift:=xlUp...

I have box that's produced in a report as a result of unseen characters in a field on my datasource. ? I use ODBC on an oracle database to retrieve data to an MS Access 2002 database. My report is in Excel 2002 and uses MS Query to select data from my Access DB. I'd like to program a way to...

="Enhancement Total Hours= "& SUM(K11:K185) This is an example of the formula I'm using to label my total for a range of cells. I can't seem to find a way to format the sum so that it includes a thousands separator. I've tried things like ="Enhancement Total Hours= "&...

Below is code i found by MS that writes any entries in text1 for tasks to text 1 for resources and assignments. What I need to do now is figure out how to set text1 for tasks = to the current active projects filename. For example a project file will be saved as a project reference number...