Search results

Pat/Access Blaster Thanks for trying. When in design view, the form is only 4.3cm in height (as short as it possibly can be) and the hyperlinks are already in the form footer but when I then switch to form view the form stretches to that shown in attached screen grab (full height of window)...

I have an 'Alert' form (continuous form) set to pop up in front of the navigation form when the database opens with two hyperlinks set at the bottom edge of the form. Currently the length (vertical height) of the form is full height of the window which means that the hyperlinks are not visible...

ridders/arnelgp/bastanu Thank you so much for your help. What would we amateur Access Users do without you guys?

Hi arnelgp Thanks for helping me out. Your solution seems the most logical. I have looked at the various methods of achieving but, as I am a relatively inexperienced Access user, I don't understand any of them. Could you please expand a little?

I am using a modified Northwind database as one of my databases. This is set up so that when opened, an ‘Alert’ (a form) opens automatically. But another form also opens behind the alert form so that when you close the alert form the other form remains open. I am trying to replicate this in...

Thanks a lot Minty. Your solution worked fine.

Can anyone help please with a conditional formatting problem? I have a form where two adjacent fields are 'Requested Date' and 'Response Recd Date', as follows I want the background colour of the 'Requested Date' field to change where the value of the 'Response Recd' field 'Is Null' and the...

Hi Minty Just tried your solution to the 'Test Due Date' and it worked fine - thanks a million. PeteB

Although I have been working with Access for a while, am still finding it challenging. Not sure what happened to my last post, but am still struggling with the following: I need to calculate a 'Test Due' date which is one year later than a 'Date Tested' date but as there are multiple 'Date...

I need to find the most recent date in a 'Date Tested' field in a table of records relating to test history, then add one year to arrive at a 'Test Due Date' and display this on the 'Testing' page (subform) of an 'Asset Details' form (whilst there are multiple past test dates, there can be only...

Hi Gasman I also favour a mid to light blue for the form header but your comment has me foxed as when I select either the form or the form header there is no 'Autoformat' under the 'Arrange' menu tab. What am I doing wrong?

Thanks ridders Success!

Hi arnelgp Tried that, but it's not a picture and nothing moves the orange background to the form header. Any more suggestions?

Thanks again arnelgp, I'll give it a try.

Thanks Arnelgp - I've tried themes but the orange back colour seems to be 'locked in' and does not change.

I am trying to make changes to the sample Northwind database, specifically to change the colour of form headers from the standard orange to something else but the facility to edit the colour reference in the propery pane seems to somehow have been disabled. I would appreciate help with this.

Hi Ranman - thanks for your quick response - I'm not familiar with field 'mark' - can you expand on this please?

Hi All I have created a 'Find Duplicates' query where all of three fields in any record must match for records to be duplicates. I now want to create a 'Delete Duplicate' query to delete the 'unwanted' duplicates. I have tried following the Microsoft Help but the query I end up with wants to...

Steve & JHB With your help I think I've cracked it. If with the data labels selected you uncheck the 'Auto Scaling' feature in the Format Fonts dialog box, and adjust all the fonts manually, it stops the data labels text from wrapping. Thanks again PeteB

Hi JHB I think Sneuberg's solution might work but if not I will try redoing the chart. Thanks very much for your help. PeteB