Recent content by DubaiDave

Thanks Namliam. I have it working now: I have a button on my FE that checks if the BE is in use and, if not, compact and repairs it. Understand that the BE cannot be used during the C&R process. But there are only a few of us using the dB. Thanks for your help! PS Still struggling with...

Hello Again Namliam, What I want is to have a button on my FE that will compact and repair my BE. I am a newbie - so if this is a daft thing to do please let me know. DubaiDave

I would like to compact and repair from my FE, but would like to check if anyone else is using the BE first. DubaiDave

Have you had a look at: http://allenbrowne.com/AppAudit.html ? DubaiDave

Hi Namliam, I read on another forum that: One of the slight hassles with using a subform is that it doesn't exist as a member of the Forms collection so although you can open and filter the subform on its own with; DoCmd.OpenForm "frmPersonnelViewSub", , "qryLookUpSurname" you can't use...

Hi Namliam, I read on another forum that: One of the slight hassles with using a subform is that it doesn't exist as a member of the Forms collection so although you can open and filter the subform on its own with; DoCmd.OpenForm "frmPersonnelViewSub", , "qryLookUpSurname" you can't use...

Hello, I have a MainForm whose purpose is to allow users to apply various filters on a SubForm and then generate a report etc. However, when the MainForm and SubForm first open, all records from the query are being displayed, which takes some time. How can I limit the the records initially...

Banana, That did the trick. Thank you very much DubaiDave

I am using Lebans wonderful example of alternate colors for my continuous subform. However, I collapse and expand controls from a main form (setting height to zero) and need to update the subfrom backcolor because it stays at the original height. I think I need to update using: fbc.Create...

Hello All, My dB includes a very large number of comments made on documents. These are stored in a memo field. My form allows a User to search for a word or string of words in the memo field by typing these into a form textbox and then this is applied to a query: Like "*" &...

Galaxiom, Thanks for your help and encouragment. I have cracked it. It was a very small mistake I made..but a rather stupid one. Should have been Set objFrc = Me![fmSafetyNoticeReportContForm].Form![ClosedStatus].FormatConditions.Add(acFieldValue, acEqual, "'Closed'") What a...

Hi Galaxiom, Unfortunately that did not solve the problem. David

Hello Again Galaxiom, Closed Status is a textbox on the SubForm which is bound to a query. Does that help? Could you please add a little further explanation - I am a novice. DubaiDave

Apply Conditional Formatting to a subform by Check Box on Main Form Hi, I would like to apply Conditional Formatting to a SubForm if a CheckBox on my MainForm is selected. My SubForm resides on a tabbed sheet on my MainForm (although according to Labans, this makes no difference to its...

Thanks Galaxiom, That helps, but I am not quite yet there. My subfrom resides on a tabbed sheet on my main from (although according to Labans, this makes no difference to its referencing). The code I am now using runs without error but does not invoke the Conditional Formatting. Does...