Search results for query: *

Hi joeschoe sounds like you're not releasing objects at the end of your procedure. remember to use set {object} = nothing for anything created. posting a bit of code will help to see what you're creating SteveO

Hi LaCour I've never had any need to do any replace after exporting, I'm assuming you're not exporting to an .xls file, then opening in excel anyway... you can do excel stuff in access vba... here's a snippet from one of my databases that exports to a spreadsheet, then does some formating in...

Ah right, I see what you mean. You wanted to exclude a section, I thought you wanted to loop back and try annother url. Thought you were all lost and guessing that "on error goto 0" would send the execution back to the start of the sub. appologies for that. That sees to be a solution to your...

OK, first a disclaimer, I have no experience with querytables, so I'm assuming the rest of the code works :) , but I can help you wout with the errorhandling... first thing, you need to include a label to return to, then once an error has been trapped, I would check to see if it is the one...

Are you talking about Access here? I think it's the only app that with default right click context menu for controls. In Tools -> Startup , untick the "Allow default shortcut menus" check box. You will need to close and re-open the database for changes to take effect. SteveO

The sheets have an event that will suit you just fine... Private Sub Worksheet_SelectionChange(ByVal Target As Range) call UpdateChart end sub in the sheet's code window (not a module) you might need to change your UpdateChart to a Public sub (I can't remember if the default is public or...

Give us a clue... An example of the kind of text in your spreadsheet would help SteveO

A hunch says that it is a stack overflow. From the keypress event, the program can execute cmdSave_Click or cmdAdd_Click. Have you any 'doevents' in these procedures? If your user held down the '2' key, your prog could be trying to execute a multitude of these calls. As an asside, for the...

The best reference is microsoft ... http://msdn.microsoft.com/ you should be able to add any control to a collection as you have done above. SteveO

I am positive that you can't change these settings. ...but you could cheat... how you do this would depend on where you want to use the calendar, but for an example I'll assume you have the calendar on a userform. On your userform with a calendar control, add a dropdown combo. place...

I would check your printer settings, i.e width and height of paper

... and references to the relevant pane in case the worksheet is in split view... ...there are porobably others... There must be a way to return the screen coordinates easier than this. SteveO

Hi Skip As you have discovered, the cells.top and .left are relative to the excel window, not the screen. you will need to add in Application.top / .left (the screen coordinates of the excel window), and also the .top and .left for the worksheet (if it's not maximised) These will give you...

[slightly taken aback] When I suggested starting from absolute basics, I honestly thought that that would work and we could build up from there. As I said earlier,I am using word 2K, but I would assume that M$ would keep backwards compatability in word XP , so now the question is: 1) is your...

Right then. Before I get much further, I have to say that it seems like it should be easy to me as well, and I have to admit to clutching at straws, but until any of the forums MVP's would like to step in and put us out of our misery, I would suggest that we keep on battling away. What do we...

I don't get the intellisense either for the enabled property. This should work, I have done similar things in Excel with no real problems Having no real Idea of your experience with VBA, I'll try to start from the simple things and work upwards, Please do not take offence... What is the...

Personnaly I prefer to use a global class objects This class can contain all global variables that you want to use. By using the get and let properties to control the flow of data, you can format and validate all data in both directions (writing and reading) It's overkill for simple programs...

Ok Word uses pages, so something else is causing a problem The multipage1.enabled property has no effect (you can still enable or disable individual pages with no errors if the whole control is disabled) can you give us some more background - are there any objects or controls in the multipage...

Weekday(date,[first day of week]) will let you determine the day e.g. weekday(#1/1/2004#,0) = 5 (Thursday) You could have a simple loop to check the 1st, 2nd, 3rd etc until you find a Monday, similarly if you start from the 1st of the next month and work backwards, you can find the last Friday...

Hmm. Are you using this in Access?, Excel?, Word?, Powerplay?, Outlook? The following seem to work: In Excel multipage.pages.item(i).enabled or multipage.pages("pagename").enabled In Access: me.multipage.Object(1).enabled or me.multipage.Object("Page1").enabled Don't...