Search results

Could you please try the suggestion in this link (turn Calculation to Manual before RefreshAll then back to automatic - see the second to last post): https://www.tek-tips.com/viewthread.cfm?qid=1786888 You might also be interested in having a look at my code that creates a (in Excel) pivot table...

Click in the field then click Conditional formatting and click on the Edit rule. Cheers,

Eberhard, care to elaborate my bad expertise? I gave the OP a solution to the original request instead of your hyperbolic and diminishing reply in post # 5. Maybe highlighting the existing duplicates sometimes is not such a bad idea such as when importing some existing data that needs to be...

Here is a sample showing how to use DCount to do conditional formatting. Cheers,

Sorry but the code you have makes no sense, (like the FName.Recordset). I suggest you study some more the use of DAO recordsets and refine your code. To get what you need (the exact date or the closest to it) you would simply use: =DMax("[YourDateField]","[tblYourTable]","[YourDateField] <=#" &...

Here are some links that might help: https://stackoverflow.com/questions/25767162/msaccess-conditional-formatting-in-adjacent-rows https://www.access-programmers.co.uk/forums/threads/conditional-format-based-on-previous-and-current-record.80802/...

And don't you think if there is much more to it you should share that when asking for help? You cannot do it in a table\recordset but might\should be able to do it in a datasheet form as long as we get the "more to it".... Cheers,

How would you come to this conclusion when forms and reports are the main Access user interface objects? Cheers,

You don't, you do it in a form instead using conditional formatting; for duplicates you could use dCount("*","tblYourTable","[callno]='" & [callno] & "'")>1 in the Conditional Formatting expression. Then set the desired back\fore colors as desired. Cheers,

You say the FE and BE will be in the same folder (=only one user), so you can get the path to the BE form the FE itself (CurrentProject.Path). Notice in arnelgp's code the check for a linked Access ("DATABASE=") table before attempting to refresh its .Connect property (it is missing in your...

A bit confused with what the problem is, do you want to print the record that just disappeared or the next record? What is happening now that is the problem? Cheers,

Try to open the form directly from the navigation pane (open the app holding the Shift key to bypass the startup). According to this link having the Data Mode empty should open the form locked with your settings in place...

Puzzling.... Do you open the form from the Access built-in navigation pane? Could you add the form and its recordsource to an empty accdb and upload it here? Cheers,

To open the form locked switch to design view and go to form properties and set the three .Allow properties on the Data tab to No and save it. Remove any other code in the Load or Current events that are dealing with those properties. Alternatively you can leave the 3 .Allow properties set to...

I think you're make it too complicated; open the form in design view and set the AllowEdits, AllowAdditions and AllowDeletes to No. Save the form. Do not attempt to change it anywhere else but your button. See this small sample. I have included another button that toggles the form RecordsetType...

Please see updated file with code comments. Cheers,

From your scenario I think you are trying to edit a record then turn off the AllowEdits while the record is still dirty. Try to add a Me.Dirty=False before your existing code and see what happens. Cheers,

You don't seem to requery the subform after you pass the value to the listbox (Me.sfrmYourSubform.Form.Requery). Cheers,

Could you maybe have a table in your SQL server BE to hold the users and passwords and use a pass-through to retrieve it into a variable at run time whenever is needed by your dbConn.Open line? Cheers,

You can link the main form\subform by multiple fields separated by semicolon: https://www.access-programmers.co.uk/forums/threads/link-multiple-fields-from-a-subform.118748/ Cheers,