Search results

  1. A

    Bullies

    I was invited to one when leaving job where one of my significant reasons for leaving was style of management. My impression of the process was: They wanted to be seen to be doing the right thing (are exit interviews a stipulation of ISO9000 or something perhaps?) They might have been...
  2. A

    Choice of a Database System

    This is potentially quite a big and complex undertaking let's try to break it down... Database hosting: The database has to live somewhere - this could be on your own hardware, or you could buy hosting from a third party. If you host the database yourself, you have lots of control, but you...
  3. A

    Bullies

    As someone else said upthread though, you can't really be given a *bad* reference, except in whatever might be implied in the statement "We confirm this person was employed by us from [date] to [date] as [position]" But I'm just not sure what people hope to achieve by going out in a blaze of...
  4. A

    Choice of a Database System

    Sorry - it's more questions... How do you intend to implement this? Are you planning to choose a solution on the basis of recommendations, then get a technical contractor or support company to implement it? Or are you going to employ someone to do it? Or set it up yourself? Who do you...
  5. A

    How to Create a Reverse Crosstab Query

    If you have to repeat this process more than once with a different set of column names, you might find this solution useful - http://www.access-programmers.co.uk/forums/showthread.php?t=28110
  6. A

    Dynamic form? Maybe?

    This is where it's going wrong, I think - and it's because attributes should be a list in a table, not a horizontal array of fields. I think you need something like: TblEquipTypes: A table of Equipment type definitions TblAttrTypes: A table of attribute type definitions (with a foreign key...
  7. A

    Choice of a Database System

    If you're talking about 300 users concurrently connected to it, Access almost certainly isn't going to perform well - in fact, if it's 300 users, but only an assorted 25 of them at any one time, it's still going to be stretching the limit for Access. It sounds like you need a proper database...
  8. A

    Split string, execute function, delete split.

    Crikey, I'm completely lost now.
  9. A

    Bullies

    No - I was solely talking about the manner in which I think it is best to effect an exit. Effect change and stay if practical, grin and bear it if you have no choice, otherwise, leave as soon as possible, and be gracious on your way out the door, whether they deserve it or not. At best you gain...
  10. A

    Bullies

    I agree - never burn bridges - and anyway, if you leave in a huff, you just give the bully the satisfaction of knowing he/she upset you.
  11. A

    Question Table field looking at its own table

    But not orphans. Maybe that's never going to be a problem in reality...
  12. A

    Split string, execute function, delete split.

    But are you saying that these codes D, S and U may appear anywhere within the string? If so, haven't you still got a problem, because, for example, you might see the sequence -.. in there and decide this is a D, when in fact it may be any of the following: TEE TI NE TE plus the left part of...
  13. A

    Question Send HYML emails from Access

    If you use Outlook automation, as described here: http://support.microsoft.com/kb/209948 You can substitute .body with .htmlbody to create and send an HTML mail message
  14. A

    PLEASE--Need help with my query coding..

    Another thing to chew over - how will you handle deaths and divorces?
  15. A

    Split string, execute function, delete split.

    If there are no spaces between the groups of symbols, how can you hope to make any sense of it? A = .- E= . I= .. L= .-.. N= -. T= - So without spaces, the morse sequence .-.. could mean L, or it could mean AI, ATT, ETI, ETEE, ENE... After assuming the length of the first chunk of morse, the...
  16. A

    PLEASE--Need help with my query coding..

    It's sometimes easier just to check the length of the string, so instead of Parents: IIf(IsNull([Parent2]) or Parent2 = "",[Parent1],([Parent1] & " & " & [Parent2])) I think you could have: Parents: IIf(len([Parent2])=0,[Parent1],([Parent1] & " & " & [Parent2])) By the way... Are the people...
  17. A

    can somebody help newby ?

    You need an Exit Sub statement immediately before your error handler - otherwise it will always execute the code there when execution gets down that far Like this: ... Else MsgBox "Sorry, you do not have access to this form", _ vbOKOnly, "Important Information"...
  18. A

    create query

    Please try to understand that all we know about your problem is that which you tell us - which at the moment, is not enough to be able to understand what you're trying to achieve. What are you trying to achieve? What is the purpose of your database/application - what kind of data and process...
  19. A

    Record updatng

    'Me' is just a bit of convenient shorthand - when you're writing code in a form's own event modules, 'Me' just means 'this form', and saves you the hassle of having to explicitly name the form in your code. The 'dirty' property of a form is 'true' if there are updates pending to the table bound...
  20. A

    Google maps - with Access Postcode data

    :confused::confused: I just bashed my own postcode into Google Maps (via the search box on maps.google.co.uk) and it took me to my street. I changed the last alpha digit of the code and it took me to the next street - I tried a few other variations of the last digit and they all pointed at...
Back
Top Bottom