Recent content by dd*

Display the pop-up only for records that meet the Conditional Formatting. The form is Continuous View

I would like to display the pop-up only on records that meet the Conditional Format Rule. Is that possible? TIA

If a conditional Format Rule is triggered, I've applied specific text formatting to highlight on the form. If the conditional Format Rule is triggered can I also display a help pop-up bubble Is this the Property ControlTip Text. And how can i do this. This is currently my Conditional Format...

Thank you Doc_man for your response, and will do on your suggestion to search the forum

A Database design question I need help with designing a new table and which keys to use. I'll do my best to explain what I want. I have an existing table named tableTitle with the fields key ITNum titleName VersionNumber I have an existing table named tableBill with the fields key itNum...

thank you That was a good link regarding lookup fields. Another question, is there a good link for best practices in Access database table designs.

Thank you. I'm currently in the design phase, so I can build in and incorporate your recommendation. Many thanks again...

nope. I didn't know it was bad practice to use lookup fields at the table level. I was reading the articles/ documentation ' Create or delete a lookup field' by Microsoft :) What do you recommend I do. for instance manually create the values in each field. I'll check out the link...

Thank you. Mockups uploaded. On the Details form, the field Checkbox 3 displays as a checkbox. On the Summary form, the same field Checkbox 3 displays as a drop down list with value 'Y' In the table, Checkbox 3 data type is Yes/No. The value stored is a ticked checkbox. I created the field...

Yes the questions are kind of related. One question is for a field checkbox. The other question is for a field drop down list.

Many thanks. As a datasheet, Ive added the relevant text to the Controltip property for the controls. The results, not so obvious in the Status Bar. I'll need to train the users to read the status bar, and the users are unlikely read the Status Bar. Yes I'll use the Continuous form,as it...

Im not sure which forum to post this in Tables or Forms. In my table design I have a lookup Field to obtain data from another table. I have 2 forms The first form: 1. Details form. The field is a drop-down list The second form: 2. is a Summary form On this form the field displays the value...

Im not sure which forum to post this in Tables or Forms. In my table design I have a Field with data type set to Yes/ No. I have 2 forms The first form: 1. Details form 2. Summary form 1. The Details form The field is a checkbox. If the checkbox is ticked - in the table, the value is stored...

On a split form - datasheet on the bottom When I resize the columns, the results are unable to see the column headings. Can I have headers displayed on multiple lines like excel allows for example I resize the column to data width. Instead of the column heading displays like Categor Display...

Hello, I'm not sure which forum to post this thread in, please point me to the right forum. I'd like to achieve the following, pls let me know how I can do this. I would like a 'blank' row separator between new data sorted in a specific order I would like a 'blank' row separator between...