I have one form in a database that is giving me fits. It will not open to a 'new' record for entry of new data. I set the data dentry property to 'yes' and...

Can I set conditional formatting to white out a date field on the condition that a second field on the same form is not null. If so, how? -- DMainland

I use a form that accepts text in a memo field. The data in the field is ultimately displayed in a text box on a report. What I would like to be able to do...

Hi, I have a subform in datasheet view and need 4 conditional formats based on a percentage (every 25% a different color). Thought I would could do this via...

I need to replace a field in a database with a calculated variable field on a form. Any suggestions?

Help. I need to add a calendar to an access form which is similar to those in outlook. I want to be able to see a month calendar and see appointments on...

I am trying to add a calendar to a form in access so that I can click on a date and see the events that occured on that date. Similar to an outlook calendar.

What i would like to be able to do is to customise the error messages that appear in Access. For example when you create a Table and you specify that Required...

Hi What I would like to do is when a value is selected in a Combo box a set of values a change in another combo or list box. how can I do this. Many...

I have created a pivot table, in a form, which shows the series values as a rounded number (i.e. no decimal values are displayed on the chart). The number...

hi I want to synchronize two forms that have the same record source one data sheet the other single form in an unbound form I used this code in the load...

hi i have a form in data entry mode and a subform showing the related records of that frm. i need to click on a record in the subform that shows me the details...

I am using Access 2000. Each time my database is 1st open, the database opens to my Main Form (Switchboard). On the "On Open" event procedure for this form,...

I am using MS Access 2000 In the footer of my form, I would like to create a command button that will sort my City field from A to Z. I know that you can put...

I am using Access 2000. Each time my database is 1st open, the database opens to my Main Form (Switchboard). On the "On Open" event procedure for this form,...

I am having difficulties capturing query parameters from my form. I just added a tab (it was working fine before the tab) and I think this is causing the...

Hello- I am trying to set field captions based on a query. So when an individual opens up a form (datasheet view, form view, etc.) the field captions...

I have a form that is the main information for an event, I then have a sub- form that I want to list all the members in my db. With that list I want to click...

Help would be much appreciated! I'm trying to add a combo box to a form that uses a tables lookup field to search for a record. It works fine, however the...

I have a form that returns records based on a combo box selection. I have a field (open\close) that indicates whether the record is open or closed. The...