Search results

  1. S

    Encapsulate embedded Marco with IF THEN..

    Thanks for the reply Is this for an embedded macro? (using access 2010) still can't see how to move the End IF to wrap everything else. Excuse my seeming ignorance but I've only just started playing with the new macro type
  2. S

    Encapsulate embedded Marco with IF THEN..

    I’ve recently started using access 2010 and am busy updating my A2K databases. Just started getting to grips with the beast (table level calculated fields are great). However, these new embedded macros seem to have a mind of their own. I’ve used the wizard to create a delete record button with...
  3. S

    "Function not available..."

    No corruption in the front end then. If all else is equal, same references, no missing references, same access version, same patch, same user privileges, same drive mappings, then I think a reinstall might be worth trying.
  4. S

    "Function not available..."

    What happened when you copied the front end from the offending pc to a good pc. Did it still produce the same error?
  5. S

    "Function not available..."

    Shot in the dark - I wonder if there's a bit of corruption creeping in there. I would try 1. copying a fresh (known good) front-end to the offending PC (I assume all PC's have their own front-ends) On the flip side you could copy the front end from the offending PC to a known good PC and see...
  6. S

    Screen resolutions

    Thanks my friend, I'll give a spin. SmallTime
  7. S

    Screen resolutions

    Form size measured in cm and screen resolution measured in pixels is one of those things that really angsts me I always find it a hit and miss affair getting a form to the right size and end up continuously manually resizing a form for the best fit (so the scroll bars don't show). Not a very...
  8. S

    Pop Up Form To Add Information When A Record Value Is Changed

    Also try to avoid using empty spaces when naming fields as it makes coding a little more tricky and also use and stick to a naming convention. here'r one to consider http://en.wikipedia.org/wiki/Leszynski_naming_convention but you could make your own. the important thing is that you always...
  9. S

    Populate text boxes based on 2 combo boxes?

    Fantastic job jzwp22. I tip my hat to you. Smalltime
  10. S

    If without end if odity

    certainly for multiple actions after THEN such as; f Me.GenericForm.Visible = True Then Me.GenericForm.Visible = False : Me.AnotherThing.visible = True : Me.AndAnotherThing.visible = False could certainly use the underscore but then I suppose that's the whole point of using the block...
  11. S

    Pop Up Form To Add Information When A Record Value Is Changed

    Forgot to mention that you should make sure the new record on the opened form relates to the specific record in your first form, I suspect the related field is 'Item ID'. If so play around with IF me.status = "submitted" THEN DoCmd.OpenForm "YourNewFormName", acNormal, , Item_ID = Me.Item_ID...
  12. S

    Pop Up Form To Add Information When A Record Value Is Changed

    Try something like On the after update event of the status field If me.status = "submitted" then DoCmd.OpenForm "YourNewFormName", acNormal end if SmallTime
  13. S

    If without end if odity

    Just read the access Hell-p for the If statement. Lucky I didn't read this before learning the hard way otherwise I'd still be sitting here trying to decipher what it all means. IF the help was easier to understand THEN there wouldn't be such a need for forums. Does this qualify as a...
  14. S

    Populate text boxes based on 2 combo boxes?

    I'd go with jzwp22's suggestion about all contracts in one single table. It'll make life a lot easier as you system grows. Alternatively, depending on how your tables are structured you might be able to base your forms and reports on a query where your tables are related by a common field.
  15. S

    Enter another form based on a subform without writing code

    If you really don't want to write code yourself why not create a button and use the wizard, it'll guide you step by step and write the code for you. Eventually you'll have to join the fray as the wizard is limited to quite basic operations. Take care SmallTime
  16. S

    If without end if odity

    Ah I knew there was sensible explanation. I punched it in by mistake and then realised that the red sqiggly hadn't appeared. Maybe I'll go back and change all those block IF's that I've used when a one-liner could have done the trick. Cheers SmallTime
  17. S

    If without end if odity

    This isn't a problem just a question out of curiosity why doesn't this throw an error If Me.GenericForm.Visible = True Then Me.GenericForm.Visible = False whereas this demands an End if If Me.GenericForm.Visible = True Then Me.GenericForm.Visible = False How odd. SmallTime
  18. S

    Broken the 800 barrier!

    Agreed. In my early days with access they were invaluable and fantastic, a great bunch of people that bent over backwards to be helpful, in fact I owe them a lot and remain in awe for their abilities.
  19. S

    continuous form

    Hey, How about: Dim stDocName As String Dim stLinkCriteria As String stDocName = "NameOfFormToOpen" stLinkCriteria = "[YourLinkIDFieldOnFormToOpen]=" & Me![YourLinkIDFieldOnTheCurrentForm] DoCmd.OpenForm stDocName, , , stLinkCriteria Take Care SmallTime
  20. S

    Broken the 800 barrier!

    Caught this a little late I'm one of the new users. Got here because for some unknown reason I can no longer log into TekTips. Upside was that I had to look around for another forum and here I am, glad to be a member and enjoying the forums. Congrats on the 800 + users SmallTime
Back
Top Bottom