Is it possible to change the background color of tab controls? If so, please tell me how. -- Todd

I'm trying to copy a value from a control to a table using INSERT INTO. The problem I'm having is referencing the control properly. I'm running this in the...

Hi everybody i'm using a Spreadsheet in a form to manage a schedule. My problem is that i want to manage the double-click on this Spreadsheet. How can i do...

I'm having a problem with my calendar control, that is, I can place the control on my form and it functions in design mode but I can not select any dates...

Hi, I want to open an Excel spreadsheet from an Access form using Call Shell. This is what I have so far: stAppName = "C:\Program Files\Microsoft...

I know the problem is with my Where clause but I am not sure how to fix it. Here is the error. Syntax error in date in query expression '(= 'Athletics' AND ...

I am trying to set the default value of an unbound text box using a macro. In the AfterUpdate property in the combo box I've added this macro using...

I have a multi-select list box on a form. The first column (bound column) has values ranging from 1 to 10000. Shouldn't I be able to type the first few...

Hi, how can I make sure input in a text box would be like following: xxxx/nn where xxxx is a number and its number of digits (one digit or more) may vary and...

Our server was updated to a Windows Sever 2003 Since then, all the forms designed in Access containing an IIF stament in some textboxes, began to have a...

I would like to change a field to a null value if a condition exists. If a checkbox = no or is not checked i would like to create a macro that would change...

Does Access have this capability, and if not, I would just like some code and where to place it to do this. I would also like code taht I could connect someway...

I have 3 text boxes on one line in my report. I would like to eliminate any spaces between the boxes due to variable length text The first box is a product...

In this form, when selecting 'Create New Record' form auto-clears as to create a new record. However, no data entry is available for input. Allow editing,...

Hello All: I have a incident table, action_taken table and incident_action_taken table. incident table ------------------- iid(PK) name desc

Please see below query when I use any digit instead of X it works but X is not working: Set Rs = Db.OpenRecordset("SELECT DetailPicknote.DTime,...

I have six command buttons on an Access form. Four of the six buttons display the tool tip message when the mouse pointer is over the button, two of them...

I have a button on my switchboard that will allow a user to edit an existing form. After we send the form to an area, they will provide a PO number and we...

Is it possible to have the input for a new record, appear at the top of a form rather than the bottom?

Hi All, Afraid I am relatively inexperienced with Access, so please excuse the question if it seems silly. I have created a from/subform based on 2 tables....