Search results

  1. M

    RE: A Sorely Missed Feature (The UNRELATED posts)

    Re: A sorely missed feature Mean't sight rather than site DOH !!!:banghead: And I'm mean't to be wanting to teach English abroad fairly soon - Heaven help those learning from me :D With regard to the Wirral/Liverpool rivalry - feelings mutual !!! Was up in the Pilbara (North West of WA)...
  2. M

    Macro to display selected data only

    Thanks for that. Will give it a test once I have solved another issue involving blank forms. I was thinking of getting the Command button to run a query to get the info in my subform. The Query Builder invites me to choose numerous actions. 'Open Form' from 'Form Commands' and 'Run Query'...
  3. M

    Form showing blank in Formview

    I have a form which I intend to input data from a total of 6 tables (School_Ministry, Bases, Nations, TeamMembers, Focus City & Regions), numerous fields from the School_Ministry table and 1 field from each of the remaining ones. I am slowly building the form to add in the main fields from the...
  4. M

    Euro 2012

    The European Championships are almost on us now, beginning this Friday (early hours of Saturday morning where I am though). For once, England's expectations are lower than previous tournaments, which is probably no bad thing. The new England Manager is getting slated for picking untried...
  5. M

    Macro to display selected data only

    I have a form that records the stats of teams working in one particular city in the world. The form displays the Base where the team comes from and the nation where that base is located. It also displays the region of the city where they will be concentrating. I want to create a macro (or...
  6. M

    Creating a grid on a form

    BUMP!! Managed to get tables normalised and referential integrities established. Combos and Data Entry fields are now working :):). (Could do with a thumbs up smilie here). Pat, you presented a table earlier in this thread showing your data in a grid form. I would like to know how you...
  7. M

    Join Key not in Record Set!!!

    S'ok Lions deserved it, probably more because the Eagles were so bad in the first half, they didn't seem to want the ball. Don't know why but WA teams don't seem to have a good record against QLD sides in any sport, although the WA Raiders did beat QLD Sundevils in the Gridiron Australia...
  8. M

    RE: A Sorely Missed Feature (The UNRELATED posts)

    Re: A sorely missed feature There is also a theory that true Scousers were/are born within the site of the Liver Buildings, which would make half of Wirral scousers as well, despite the fact we (Wirralians) have traditionally been a different county. We were originally part of Cheshire until...
  9. M

    Join Key not in Record Set!!!

    Thanks Rain, works much better now. Have changed a few table and field names to comply better with Naming conventions, as you suggested, and have slightly revamped some of the Normalizations. However, the Base and School relationships ARE correct. Because they are one above the other in the...
  10. M

    Join Key not in Record Set!!!

    Have got an empty DB here, no entries made in any fields. This could actually be the cause of some of my problems, I am trying to set my form up as a Data Entry form so the user will key in the information as they have it. The form is intended to be a progressive report and therefore be...
  11. M

    Date count

    I'd drop the '=' bit and just use '<>', which is basically "not equal to". Failing that, use '<=' and '>=' as seperate expressions.
  12. M

    Join Key not in Record Set!!!

    OK, after much googling, trolling of this and other websites/forums and reading up in various books, I think I've come up with the right codes to establish Joins. Unfortunately, the books, especially, don't necessarily tell me WHERE a lot of the codes go. select school or ministry name, Base...
  13. M

    Dropdown boxes - filtering alphabetically

    Sorry, my mistake. I had changed a couple of Table headers and other relevant field names to help make writing a query code a bit simpler for myself (the old names were a bit long winded). However, I ended up corrupting the form so I deleted it and started again. I had forgotten to mention...
  14. M

    Leading "0" in Phone Area Code

    Also, setting your format to text allows you to input certain symbols eg hyphens, if you local directory displays number groupings seperated by such symbols eg 555-5555. Also, you can then add in such anomalies as Ext.123 if you are recording department Nos. within large companies. A number...
  15. M

    Dropdown boxes - filtering alphabetically

    Thanks for your suggestion. I tried the code in the OnChange event but now it just shows a blank dropdown. I have set up a new combox using the relevant wizard. Should I be adding other lines to the code to get it to display the relevant data options?
  16. M

    Join Key not in Record Set!!!

    So nice to be called young again:D On my base, the vast majority of staff and students are young enough to be my own kids (if I had any). Although to count those older than me, I'd still need the fingers on both hands and those of a colleague or two - much safer than taking my shoes and socks...
  17. M

    Join Key not in Record Set!!!

    Good idea about the Maintenance Table/Form, although for our Nations table, it is unlikely to be required for sometime, at least until we get a Base or two established in any of the 40-odd Nations not currently on our list. In fact the only maintenance I can currently envisage is to REMOVE a...
  18. M

    Dropdown boxes - filtering alphabetically

    My form has a combobox recording the nation a team comes from when going to our Focus City, selected from a predetermined list. When I try to key in the first letter of the nation in question, the filter selects only the first nation in our list beginning with that letter, instead of all...
  19. M

    Join Key not in Record Set!!!

    I found, from another forum, the following code for adding new data to the School or Ministry field in my form. However, the writer of the thread says it should go in the NotInList event procedure - something I cannot find. Dim ctrl As Control Dim strMessage As String Set ctrl...
  20. M

    viewing old SQLs

    I'm looking through some of our older DBs and am trying to access the codes behind some of the queries, so that I can view what they say and try to work out, from those examples, the codes I need for my requirements. However, I only seem able to run a New Query option, rather than view the...
Back
Top Bottom