Search results

in form design view look at the backcolor for a control that has the right colour. if it is a custom colour it might look something like this 1. if it does, copy the value (#66CCFF in this example) 2. if it is a description such as 'access theme 1' or similar, click on the 3 dot caret to the...

Aside from the fact you are not specifying a back color, perhaps the control back color is set to transparent

If you say so - they don’t matter, so I’ll drop off this thread because i think that is where the problem is Good luck

need to clarify what you mean - are you talking about the non red date in the new record row? Or something about the third row? Whichever it is you need to provide a copy of what your rule is and what field(s) it applies to together with an explanation of what the rule is supposed to do

Why code to do this? Assuming it is null why not use the format property of the control on the report On my phone so change to use the correct double quotes

Perhaps two queries , the first just the last % LIKE '@SearchTerm + '%' Which will use an index (assuming the field is indexed). And then a second query using LIKE '%' + @SearchTerm' On the results from the first query

You might need a field to allow for annulled marriages 😀

there is a display when property for controls So you can set to screen only (and use the can grow/shrink properties if required, they only work when printing the form) and of course you might have a control you want to show when printing, but not on the screen All depends on how your form...

Be aware that won’t always remove corruption - depends on the nature of the corruption

I’ve used the old web control to do something simple - display images from a windows folder, then using code to drag them on to the main form. However couldn’t get it to work with the new web browser control

Think the posts you are referring to were deleted by the poster, either because they were in the wrong thread or they decided to post something different. Not weird

To add to Colin’s comments- once you have created your post, report it to bring to the attention of moderators. They will then review and approve as appropriate. This is to prevent to posting of inappropriate or rubbish examples

If it is actually a query you are giving access to, you could set the type to snapshot

UK get all three, but rarely as destructive as in the US. Last destructive hurricane was earlier this year. I experienced an earthquake a few years back

you can on forms- I use it for different filters on the same table

Suggest step through the code to determine which line triggers the issue - perhaps this one?

Yes you can get a runtime for 365 access but a full version is included in most versions of office Ensure you install the 32bit version as 64bit is now the default If you decide to install 64 bit ensure you have a full version for development purposes - you will need to make some changes to...

the format function provides a text result - use the round function 48: round(((36/48)*(([Yards]*36)*[Inches])/1296)) and 48 is a dreadful name for a field - it will get you into trouble

the AI answer is only as good as the question asked.