Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jpcurrie

  1. jpcurrie

    Subform data not right...

    Cracked it - THANKYOU for pointing me in the right direction :) Me.searchSubForm.LinkMasterFields = "" Me.searchSubForm.LinkChildFields = "" Effectively resets th properties after selecting the records don't know why that started happening but it fixed it.
  2. jpcurrie

    Subform data not right...

    Debugging the code the offending settings are set when the record source is set: Me.[searchSubForm].Form.RecordSource = sq ' set record set based on results
  3. jpcurrie

    Subform data not right...

    Ah right the linkchild & master fields seem to be set once the search button is clicked for some very strange reason. Could I have corruption?
  4. jpcurrie

    Subform data not right...

    FindClient is a query that is basically a select all of the bookings table. SELECT Bookings.* FROM Bookings;
  5. jpcurrie

    Subform data not right...

    Gotcha, but no they are both blank. Any more ideas why this code is going wrong? It seems to be only search the current record not the whole table.
  6. jpcurrie

    Subform data not right...

    Apologies I meant "Record Source is blank" Subforms are linked by way of a SQL statement in hte record source are they not? In my case that field is blank - I also searched the project for any mention of LinkMasterFields or LinkChildFields and there is nothing. What am I missing
  7. jpcurrie

    Subform data not right...

    I don't think so the data source is blank. How would I check? Brain fart here, sorry :)
  8. jpcurrie

    Subform data not right...

    Hi all, I don't do this stuff much anymore but I have had a database in which I wrote a long time ago. Anyways I wrote some vb (with the help of this site) that creates a sring and sql based on search criteria and then sets the recordset of the subform to the results. However something...
  9. jpcurrie

    Excel - Refer to a different column/range each week (variable)

    Sorry I should have been clearer: This is what I have =OFFSET('Current week'!AY7,,wk_Incr-1,1,1) I want to make the "'Current week'!AY7" bit variable and set from a value in another cell. Say H9 = 'Current week'!AY7 I want to be able to change that if needed without reworking the formula...
  10. jpcurrie

    Excel - Refer to a different column/range each week (variable)

    Reviving this thread... How can I make the Original cell reference variable? i.e. To have a cell where you set the start cell reference Say Y1 = 'Current week'!FF6 Then adjust this formula to use the Y1 cell as the starting point? So you could adjust it to 'Current week'!YY6 and not have...
  11. jpcurrie

    Excel - Refer to a different column/range each week (variable)

    Geoff, You are a star!! Thank you that worked perfect. John :)
  12. jpcurrie

    Excel - Refer to a different column/range each week (variable)

    Hi guys/gals. Can anyone help? I need to pull value through from one workshhet to another but the range will change from week to week. What I have done to get the inital value is use the following formula and smartfill, but obviously it will need to be variable somehow.: ='Current...
  13. jpcurrie

    Hi hope this is in he right forum!

    O.k, done that and it is all blank, both on 98 and 2k. John
  14. jpcurrie

    Hi hope this is in he right forum!

    O.k here it goes... The main form is bound to table jobook It has 6 tab controls and various subforms bound to queries from jobbook and parcelcupboard (another table) all of which work fine. I then decided to implement a search form so what I did is created a blank tab control and moved it to...
  15. jpcurrie

    Hi hope this is in he right forum!

    Hi sorry for not being totally clear, JobNumber is on the Main for [Main] When a user clicks on the record on the subform (which is a cutdown record clone of Main) the code baiscly changes focus to JobNumber on the main form and searches for the records clicked [using jobnumber] Hope that...
See more

Part and Inventory Search

Back
Top