Hello -
I am trying to write some code which moves through sheets and colours certain cells on each sheet. However, if the workbook contains a sheet which is only a graph, an error occurs. I would like a way to identify a sheet as being a chart object, so that then I can skip over it. Is...
Hello -
I have a field called 'Date' which has been set to Required in the table settings. I also have a data-entry form used to populate this table. If the user tries to move to the next record while leaving 'Date' null, the usual message box pops up telling them they must enter a value...
Thank you for the suggestion -
Problem was actually that I was adding lines/changing text to the cells that served as the combo box's list source. Not very smart of me!
I have a macro attached to an combo box on an Excel worksheet. The macro calls two other macros which hide/unhide rows and update a graph:
Private Sub ComboBox1_Change()
Application.ScreenUpdating = False
CompareGraph
GraphColors
Application.ScreenUpdating = True...
Is there a way to create a list of all tables, forms, queries, etc. in a database that could be easily imported into a Word or Excel table?
Have tried Access Help to no avail.
thanks!!
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.