Recent content by AppStaff

Thanks very much Gavin. I was hoping I could have it guess given the range is variable and I'm too lazy to code more :) It does work with a specific range as you suggested instead of just the range("A3") that I was trying. Star awarded.

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

Yup, its a string. Unconvential naming I know. In my experimenting I didnt change my convention to match my method. It works fine unless I run it with excel already running and I don't have clear enough understanding of how the various instances of an application object are declared and...

Right click on the task, select "bar styles" from the menu, click on "wrap text in bars". Good luck.

This is one way i tried in the sub procedures. objwkb is a string name of the workbook being acted on. Set db = CurrentDb Set objXL = Excel.Application Set objsht = objXL.Workbooks(objwkb).Worksheets(2) This works fine unless I have another instance of excel open when i run it. Then it...

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

Most likely it is taking you to problem area in your code. Try compiling the code and see what happens.

Thanks for responding. I'm confused by this method however. This seems to give me a means to call a procedure to run in another database but I want to run the procedure in the current database but refer to the objects in another one. Does this do what I need? If so I'd appreciate code to...

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

Thank you both! These links look like a great place to start.

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

Thanks for your reply. The user can add new records to both the main form and the sub form on the tab page. I'll see if I can get this to work for me. Star awarded for your effort.

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