Search results for query: *

Hi! I have created a record browsing window (data is displayed in datagrid in subform) which includes custom navigation buttons (first, next, last and previous). The custom buttons are disabled as appropriate (e.g. if at the first record, the GoToFirst and GoToPrevious buttons are disabled)...

Thank you to both PHV and pjm. I will now also check microsoft for my answers first. Regards Peter

Hi! I have reviewed the many other threads on RecordCount and have no reason to think my code should not work, however, it returns the incorrect answer. Private Sub Form_Load() MsgBox(Str(Me.[ctrlPatientBrowser].Form.Recordset.RecordCount)) End Sub ctrlPatientBrowser is a subform - datasheet...

Thank you very much - problem fixed. Regards Peter

Sorry for the time to reply but have had a sleep and a full days work - thanks for the replies. I sadly did not make myself clear with my code example so have attached the code with further explanation and highlighted in red the line that I need help with. Private Sub...

Thank you for the quick reply. Duane, I have a form with a subform "sfrCustomerBrowser" which is a datasheet view of customer details (name & address only) I use the datasheet view to quickly find the relevant customer by scrolling down by surname. Once the relevant customer is identified the...

Hi! As opposed to starting a new thread I have decided to ask an extended question within this thread as I too have done what GelC did and have now taken the advice from dhookom and disabled my navigation buttons as appropriate. However, I wish to know how to use the BOF and EOF functions when...

TheAceMan1, Thank you very much - sorry to hear you lost all your good work though. Regards Peter

Could someone please advise where I can find out the order in which some of the events associated with forms and fields occur? Obviously some only occur when an action occurs, however, I believe there are times when several events occur upon a single action, e.g. opening a form. Thanking you Peter

I have made several changes and still do not understand how to get my form to work correctly. Changes made include: 1. Tables tblInwards link to tblFileSubject no longer linked to tblFileCategory tblFileSubject link to tblFileCategory 2. deleted all space characters in field names...

Hi! I believe I may be trying to do something that can not be done. On my form where I have the two combo boxes, the first being file category which is simply looking at the tblFileCategory and the second being the dependant list, I am trying to use the form to view a registered document...

PHV Thanks for the advice provided and sorry to take so long to reply. We currently struggling with Cyclone Hamish off our East Coast. I have tried your solution without success and would appreciate you explaining some of the details as your solution is somewhat different to my original attemp...

Remou, Sorry for the delay in replying. I'm not sure what you mean as the dependant combobox does not have a Current event. I added requery to the form's Current event with no effect. I then spent another couple of hours searching for a solution only to find many solutions which were...

I am running Access 2007 on Vista Business. I have used faq702-4289 to get one combo box controling (filtering) the list on a second combo box and it works very well. However, what doesn't work is: (1) as I cycle through records the second combo box does not display the record from the...

Thank you very much for your explanation. I was too focused on the combo box to relaise the fix was associate with detail section. Thanks again - all is well. Regards Peter

Paul, Thank you for the pointer to the BUG. I have had a read and tried to implement the work around, however, I don't understand the fix set AlternateBackColor to another color. I don't think ComboBoxes have an AlternateBackColor property. I apologise for my lack of understanding and would...

I have searched the logs for my problem without success. I am running Access 2007 on Vista Business. I am using a new Lenovo laptop with 2Gb ram etc - no spec/performance issue. I have a small database with two forms. One form works perfectly, however, the other form causes me problems in...

Remou, Thankyou. Adding the FilterOn=True line of code has resolved my problem. I had tried JB's requery suggestion without siccess. As mentioned by JB I thought simply "Allow Filters = yes" in the properties was sufficient, but obviosly not. Thanks again to both of you for your help and...

JB, Sorry for my last post, you must have written to me whilst I was typing. I will try your solution and let you kmnow the outcome. Thanks Peter

JB, Thankyou for explaining the use of Me and parent. However, I would realy appreciate knowing why the following bit of code (i.e. the filtering) doesn't work? Forms![frmpatientBrowser]![ctrlPatientBrowser].Form.Filter = "surname LIKE '" & strFilterValue & "*'" Thanking you Peter