Search results for query: *

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

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

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'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!!!

I hate when I cick on a cell with a formula, the formula covers all the surrounding cells. Is there a way to get around this? Dave SLC: Greatest snow on earth!!!

When looking at the database view, you can see on the left a list of all of your objects. Tables, Queries,Forms... when these are clicked you can see the different tables or reports or fomrs you have created. Changing the view to detail you can see a place for "description". If my description is...

Is there a way to put a user form into a worksheet? SLC: Greatest snow on earth!!!

Is there a way to change the folders on the left of the open dialog in excel. Right now there is a history folder, my favorites... can I add my own folders? SLC: Greatest snow on earth!!!

in excel, I need a function that test another cell to see if it is a hyper link and if it is then return true. Thanks Dave SLC: Greatest snow on earth!!!

I have an excel workbook, each row is a record, I want column A to be updated with the current date whenever anybody changes anything or adds antything into any other cell in that same row. Any suggestions SLC: Greatest snow on earth!!!

It give me =GETPIVOTDATA("Sum of Year",A3,"Month","JAN") how can I turn this off? I want it to give me the cell "A3" instead when I point to it, it gives me this =GETPIVOTDATA crap. It didnt do this in 97 SLC: Greatest snow on earth!!!

I have this macro that opens a table and then asks you a question about the table, if you answer "yes" then I want the user to be able to just right there enter a new record directly into the table. I do not want to use the input box in the macro to enter a new record. I have the table...

I do not want to use the input method to enter a new record. I have the table pop up and then I want to be able to enter the data right in the table and then after I'm done entering the data it just continues with the macro. SLC: Greatest snow on earth!!!

I have this module that prompts the user if he would like to add one record to this table before the module manipulates the data. Is there a way to actually enter the data while the macro is running. something like pause macro until I enter in all of the data? SLC: Greatest snow on earth!!!

I would like to have formatted text in a form explaining a procedure. I would like to center the heading... bullets, colors... What is the best way for having text in a form that can be formatted like word? What is the difference between "label" and "text box"? SLC...

How do I get a form to pop up right when access opens. Is it a specific form event? SLC: Greatest snow on earth!!!

Is there a scroll option that makes Word scroll more smoothly SLC: Greatest snow on earth!!!