Recent content by Brockers

I have made a solution to my problem by using an update query in Access that references a linked table coming from the Excel file! I've added a nice form and some error handling and am currently looking at training Monkeys to use it, it's that simple! It works a treat, just hope the client is...

My (training) client needs a way of being able to use Sheet2 of a Workbook to update values in a List stored in Sheet1. It's my birthday and I don't need this today!!!! The breakdown is: Make a Text Entry in Sheet2:A2 to search for, Search Sheet1:Col G for exact matches of the (Sheet2:A2)...

A predecessor of mine who was familiar with VB, wrote a model with the following command. Application.CommandBars("WORKSHEET MENU BAR").Controls(1).Delete It has deleted the menu bar throughout excel and I cannot get it back. I fear I may have to re-install Excel, is there an easier way! Can...

Thanks PHV It didn't quite work but it put me on the right line of thought (as did a couple of asprin!), rather than having it as an unbound field, I placed it in the query the subform is based on and put the IIf statement in there...

Hi I've created (and stole!) the 3 functions below, the first 2 taken from Tek-Tips to work out the Start and End of Months the 3rd Created by me to work out how much a customer should be billed for storage based on Total Days something has been stored in that month (MonthOfCharge) multiplied...

Sorry guys, I've solved it!!!! a Dlookup! Private Sub Combo6_AfterUpdate() DoCmd.RunCommand acCmdRefresh Text8 = DLookup(Combo6, "tblFields") End Sub The refresh updates the Text Box if you change the field value! Regards Brockers Instructor New Horizons Manchester England

Thanks but it's not quite that simple or at least my head doesn't se it that way! Lets say I have 3 fields F1, F2 and F3, F1 has a Entry of A, F2 = B, F3 = C F1, F2 and F3 are also the possible selections in the Unbound Combo so when I select F1 in the Combo I want an Unbound Text Box to = A...

I have a combo box on a form which displays the list of fields for that form. When I make a selection I want it to fill out the value of the field selected into a text box below. At the moment I have managed to return the name of the field, but not the value with the code given below. The combo...

Hi Could you please help? I have a v. large spreadsheet (30Mg) that is linked to several others. Problem being the formula link is a SumIF, it will only update when the other worksheets are open. Otherwise there is a #Value error message in the cell. The formula must be created in a separate...

Make sure you still have your parameters in the Criteria row as well, then use the Parameters in the menu to define the Data Type, it then links to the Fields Criteria row by using the EXACT (Inc Spaces etc) same Text you had used in the initial parameter otherwise it has no logical way of...

I'm trying to pull out all the Memberships in a Report that expire in a particular Month i.e. July 2003 (UK Format 07/2003) I can pull the appropriate records out using the Query Criteria: Like *07/2003 Can't seem to get it to work with a Parameter Prompt instead. The field it's using is a...

If you are opening these from Command buttons, try adding an Echo action to the Macro or Code (Event Procedure) for the On Click Event for the Button! The Echo turns the display off while the Macro or Procedure runs and then turns it back on at the end! For a Macro just insert a row before the...

In the Design View, you simply have to define the Parameters Data Types. This is done from the Query Menu then choose parameters, In Column 1 type the Text you are Using in the Parameter prompt for the user eg. Enter Start Date In Column 2 choose the Data Type eg. Date/Time Run the Query again!