When using a predefined date format for a field, I get null values in the table and controls in forms as expected. But when I use a custom format in the...

Is it possible to update the fields on a subform from a command buttom on the main form? I'm trying to recalulate the fields on a subform if someone changes...

can i attach a word document into access database

Hi, I quoted this project before exploring Access 2007 vs. 2003, so I really don't want to make a switchboard or menu from scratch - is the wizard really...

I have an existing database that I need to add a column to one of my tables and move 2 product types in to because they are a secondary product. When I...

Hi, I already tried a query to do this but did not work. I have this form showing 5 text boxes for Status Date and 5 text boxes for Note like this Statusdate...

Help, I have the default view in my form set to datasheet view, However when i run the form from my switch board "open form in edit mode" it always opens in...

I have two check boxes on my form. Nothing fancy. If you check box 1 it sets the field LevelID in Table1 to 1 or if you check box 2 it sets the same field...

I have the following code that adds a trend line to my chart. I want the color of the trendline to be red. It's default is black. How can I set the color to...

On form load, I am a creating a new query replacing the old one for use by the me.recordsource. I have to run the form twice in order to see the effect of...

Hi All, Sorry but it is a long question: In a Form called: Orders I have a drop down combo box as shown below: cboAccountType Account Trade DIY

I have a Form that's based on a query. (only those that has a blank date on the data field). Is it possible to create a button of some sort, that when i...

I have a simple calculated field in a query based on the following expression: $/sf: IIf(0,Format(/,"Currency"),"") In the query, Rent is set to...

I have a continuous subform and I'm trying to make each record displayed numbered 1, 2, 3, etc. I personally see no use for that - at least in this...

When I filter one form (Suppiers) the predictive function works ie if I key 'Pr' it fills in the first word starting with those two letters - say...

We have created several forms for sales order entries and have set them all to "yes" on data entry. This has worked well for all forms but one. When we...

I have created a Chart. I want to add a button to my form and pull up the chart. The data will be based on an item on the form. How would I change the charts...

I have made a Form that has my controls - Now I want to make it stay on top so that any query or table that I open can't cover it. I don't want to use the...

Hi, our business was needing to organize when we talked to clients. So, I downloaded the “Sales Contact Management Database� template from the MS...

I am a beginner, with no real training in access, working on building a database using Microsoft Access 2000, but I am running into some problems. I...