Search results for query: *

I don't know if that is a viable alternative for me... I'm maintaining my current site for my job... they may not want to upgrade just yet. What? Who? ME????

Whenever I try to do certain things, such as add a new entry to a list, Internet Explorer hangs up on me. It doesn't matter what list it is, every time I click 'New Item', I get a dialog box saying that "Internet Explorer has encountered a problem and needs to close." How do I get this...

Thanks guys... I have downloaded the MDB Doc as well as looked at the Analyse / Documenter. What? Who? ME????

I am currently documenting my Access application and would like to list the tables and their definitions for my systems manual. Is there a way to export the table definitions alone (and not the data) into a document that I can use? What? Who? ME????

ok... I got the code behind it... how do I put it back exactly where it was? I'm trying to add a new column to the layout, but for some reason, I can't get it right. Is there a way to look at the layout table itself so that I can add a new column to it? What? Who? ME????

That's a bummer... lol. Alright, thanks... :-D What? Who? ME????

yes, that worked... thanks :-) What? Who? ME????

It's telling me "Object required" when it gets to the CommandButton's .Visible property. As I figured, it's not seeing the CommandButton. What? Who? ME????

While stepping through my code after adding the above code snippet, I realized when I hovered my mouse over the CommandButton1 after the focus had passed the "with CommandButton1" code that CommandButton1 as an object appeared empty! (CommandButton1 = empty) I will try it and see if it works...

Thanks PHV, that worked... What? Who? ME????

This is a Control Toolbox control. The name in the name box when I right click it and choose Properties is CommandButton1. What? Who? ME????

I will go back to my Range.Select... that worked... I can't find IsEmpty as a function in this implementation of VBA, either :-( Actually, regarding this code snippet (in order to remove the unnecessary Range.Select) If Trim(WHATWORKBOOK.WHATSHEET.Range("E3").Value) = "" Then...

I tried that, but actually I get the message that "Object doesn't support this property or method." when I try to use that code snippet. What? Who? ME????

Thanks mintjulep... that's what I wanted... I'll try it. What? Who? ME????

How do I find out the name of YourCommandObjectName - would that be the CommandButton1 name? And YourSheet would be the mame of the sheet - LPO: so that I reference it by Sheets("LPO")? What? Who? ME????

It's on a sheet in Excel... sorry about that... What? Who? ME????

I had placed the deletes before the save, as the save was happening via a command button... but that works as well :D What? Who? ME????

How can I access a CommandButton's properties etc via code? I want to disable or hide the command button based on a condition (tested by an IF-THEN-ELSE statement) but I don't know how to access the CommandButton1.enabled or .visible properties using code What? Who? ME????

ok What? Who? ME????

I was writing code for my Workbook_Open stub. IsBlank() wasn't supported... I wanted to test for E3=""... the Trim() worked fine - like this: Range("E3").Select If Trim(ActiveCell.Value) = "" Then VBAProject.ThisWorkbook.Worksheets("LPO").Range("E3").Value = Date End if What? Who? ME????