How, after I submit a record from a subfrom, do I refresh the form to have its original defualt values.
I wrote
For Each ctl In Me.Controls
If ctl.ControlType = acTextBox Then
ctl.Value = ctl.DefaultValue
End If
Next ctl
But this puts quotes in the field with defualt value...
WHen I open it I cant edit it. I want to edit the fixed width delimated table, and it wont let me edit it. I 'm in the table but I can't edit it....
SLC: Greatest snow on earth!!!
Is there a way to unlock the system tables.
If I go into to tools>option>view(tab) and then under show select "system object"
I want to be able to edit those tables. DO you know of a way to do this.
SLC: Greatest snow on earth!!!
That was the way I was thinking about doing it, with a form resize code. But I was wondering if there was a fancy way to make it slide out, kinda a cool effect.
SLC: Greatest snow on earth!!!
Can anyone reccomend...
I want my form, when I press a button, to show another part of the form. Kinda like a menu but the menu contains buttons and other controls...
I actually want to SEE it slide open also when it does this.
I was thinking that there would be a good activex control for...
Anyone have a macro to remove all digital signitures assigned to a workbook. Or what about a macro that deletes all the digital signatures in the signature holding area, except for Microsoft's
SLC: Greatest snow on earth!!!
Anytime I try to edit some charts I have, it gives me an error that states
no more new fonts may be applied to this workbook
Any suggestions for getting around this.
Dave
SLC: Greatest snow on earth!!!
I know you can mine the data in the file by opening a new workdbook and setting up in each cell a reference to the corrupted files cell.
something like =workbook1!Sheet1.A1
SLC: Greatest snow on earth!!!
There are no external links, I think it is a bug in Excel.
It will not recalculate unless I actaully go in the cell and then press enter.
SLC: Greatest snow on earth!!!
I've tried to re calculate Excel cells but for some reason using F9 or Shift+F9 will not work. I have to actually go inside the cell and then press enter and it will recalculate. I'm not changing anything when I do this.
Any suggestions?
SLC: Greatest snow on earth!!!
Fast way to change text in a column of cells into comments?
I dont want to go through each cell and manually insert a comment and then paste the data into it.
Thanks in advance
SLC: Greatest snow on earth!!!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.