Search results for query: *

When I export a table to Excel I get an apostrophe in all of the cells. I assume this is a transition key but when I go into options/transitions the transition navigation keys box is not checked. How can I stop this? Thanks in advance for any assistance.

I know how to close an open database in code (Application.CloseCurrentDatabase) but is it possible to close Access as well? My users click on a form shortcut to bring up the DB and I would just like it if my app closed Access from a button on a form instead of just the database. Thanks in advance.

O.K., why in the world can't you change the back color of buttons. I have used VB6 and done it. Do I have to do something ridiculous like create a custom button? Is it me or does it seem like Microsoft likes to have developers checking into rubber rooms? Thanks in advance for any assistance.

Why do the form mouse events seem to take so long to respond? For example, if I put some logic on a form_mouse_down event (if button = 1 then msgbox etc.), it only responds occasionally. But if I put the same logic in a control mouse_down event, it responds instantly as it should. Even if there...

Does anyone know a way to change the error message that you get from an input mask violation? I would like to change it to a message box that would specify the field and why it's in error, instead of the message that you get. So I don't have my end users asking me what an input mask is when they...

Does anyone have suggestions for creating a find function on a form that doesn't involve DAO. I cannot get the Jet database engine on my computer and I have been designing everything with VBA and docmd stuff. My boss wants a form that searches for a record using a customer number field. The...

Does any one know a way to put leading zeros in a field automatically? My employer wants a customer number field that is 8 numbers long and shows the zeros for empty spaces ( 00000001 ). I'm pretty sure I could figure a way to do it with VBA but I would rather put in the table design for...

Is there a way to stop the scroll button from scrolling through active records on a form? I have a form with fields bound to a table that I want to use for updating only one record at a time. I took off the navigation buttons and the scroll button still scrolls through the records.

I cannot access the Month() property of a Date data type, but I can access the Year() and Day() on the same form. When I try to get the month, I get a type mismatch error, but again not with year and day. Why would the month not be accessable but the year and day are? Please HELP!!!