Search results

I use Office 2007 which has on the Database Tools toolbar 'Linked Table Manager' open this and it shows all your linked tables select the one you want and hit update...might be a bit simplistic for what you are looking for though :) Fi

:confused: Hi.. I have been looking thru the forum for a while for a way to change the back colour of a field [FeeNotCollectable] in a subform (continuous) and came across Conditional Formatting using this have set [FeeNotCollectable] with 'ExpressionIs [FNCDate]>Date()' back color turns grey...

Hi Peterson...I had to do something similar recently which works well, (all code and ideas given to me from this forum with great thanks..) have you sorted yours out ? if not I will try to explain how mine works...cheers Fi

Hi Gemma..thanks for your reply & apologies for not getting back sooner, unfortunately I'm not sure where to put this code ! and how it to make it relate to / show the value in my text box, would you be able to help further...thanks again Fi

Might be a bit cluncky but I have added to the after update event of cboManager to fill txtManager and made that not visible, the Command button then looks at txtManager and opens the report correctly, this seems to be working fine but if anyone can help me with something a bit smoother would be...

Hi...I might answer my own question shortly :) I created a text box and another command button the command button has the following code Private Sub Command17_Click() DoCmd.OpenReport "Debtors_Ageing", acViewPreview, , "[ManagerID]= '" & Me.txtManager & "'" End Sub this now works sopening...

Hi I have found, and amended to fit my field names, the following code Private Sub Command10_Click() DoCmd.OpenReport "Debtors_Ageing", acViewPreview, , "[Manager]= '" & Me.cboManager & "'" End Sub This opens the report but doesnt display any data, could it be the query the report is based on...

Hi Im sure the answer to my question is here but I cant find a solution that works for me, what I would really like is when a command button is clicked that an enter criteria box opens where the user would enter the Manager name and the report would run detailing all clients belonging to that...

Hi Gemma..thanks for reply, I copied and pasted your code but the line 'onerror goto novalue' turns red, bit of a novice here is the code I pasted, not sure where to put it and how to relate it to the text box i would likt the value to show !! Function getsubvalue() As Double Dim temp As Double...

Hi Rabbie...thanks for your reply ..tried your suggestion by putting it as the control source of the text box but still getting #Error when there is a blank record in the subform ...the subform is populated from a linked excel spreadsheet with [TotalDue] summing the records in the subform footer...

Hi MStef thanks for replying, I have tried your suggestion but it is still giving me the #Error message, would you have any other suggestions ?? thanks again Fi

Hi On the mainform I have a textbox with the following control source =[sfAgedDebt].Form![TotalDue] which is working fine however if TotalDue on the subform is blank the text box on the mainform displays #Error would anyone be able to help me stop the #Error message showing and the Textbox to be...

Hi maxmangion...I have come across code given to me a while back from this forum...which I have adapted to make this work, i also changed that it was to open a text box to opening a subform, still building up the rest of the subforms needed but here is the code working so far Private Sub...

Hi maxmangion..thanks for your reply, I have oput your code int he AfterUpdate event on the combo and it is sort of working, if I select No nothing happens but if I close the form and reopen the Text Box is visible ?? also if I select Yes it does disappear, should I change the settign on the...

Hi..On a form I have various combo box's which are part of a questionnaire, I am trying to open a particular text box when each choice is made eg if the user selects 'No' form the combo a text/memo fileld becomes visible for them to explain their answer ....have tried searching but not having...

thanks Chris I understand where i was going wrong now will try differant solution :) cheers Fi

Hi Gemma thanks for the clarification, understand what you are saying, need to find a differant solution as you say, will have a go at your suggestions and post back with my "success"...cheers Fi

Hi...thanks to both of you for your help but i just cant get my head round it... on page 2 I have 3 option buttons I would like to add the code which opens a login form to check passwords before the underlying form attached to each option opens, I did this with no problem on an option button on...

Hi Chris..I have the 2 pages set up and the button on page 1 which takes me to page 2 what i am trying ot do is add an event to one of the option button on page2 when I open the swithcboard in design view it only shows page 1 ie option buttons 1 to 8 what I dont know is how to see page 2 and the...

Hi Chris...I cant work out to make referance to the option button on page 2 i imagine it has to be something like Switchboard, Page2, option1 ??? thans agin for your reply..cheers Fi