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!

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

Search results for query: *

  • Users: Hasse
  • Order by date
  1. Hasse

    Update (?) faq700-1584: How Do I relink a table during runtime?

    The source code example mentioned in section 1. & 3. has moved to: http://www.mentalis.org/apilist/GetOpenFileName.shtml instead of the mentioned link: http://www.developer.com/net/vb/ref/g/getopenfilename.html ps Sorry for abusing the forum for this one, but as I wanted to send this remark to...
  2. Hasse

    Data exchange - standardisation: issues & project management

    Hi - thanks for your replies... johnherman, you're right... Probably I'll come up with more practical questions later. Actually, major concern isn't XML yet, but the organisation & discussions needed prior to that technical work-out. I'll be back!!
  3. Hasse

    Data exchange - standardisation: issues & project management

    Dear Tek-Tip members, do you have any experience, tips or links which might be helpful while I'm preparing & planning a project to develop a data standard & framework to facilitate the exchange of (in my case pro-cycling) information (like race results,...)? I'm not heading into XML yet... I'm...
  4. Hasse

    <B>Really Difficult Hierachical Query</B>

    Sorry [morning] - ESquared... I didn't notice you have to be logged in first... Indeed now the link works fine here too; - I didn't realise I was living in the SQLserver-neighbourhood over here... Too bad you can't delete & modify any posts here :-[. The stuff I wrote is mostly from the (more...
  5. Hasse

    <B>Really Difficult Hierachical Query</B>

    [blush]Indeed this took me a few hours... and spare time, actually... so I hope that what I wrote is a bit clear as well [blush] (is it?) If it's of any use, Noonoo may always offer me a drink when I come around :-). Actually, it was fun too. I remember some past (idea's for) projects in which...
  6. Hasse

    <B>Really Difficult Hierachical Query</B>

    ps I guess it's sometimes more appropriate to build the query'SQL described here from code, like when you have/want to include an indefinite/variable number of levels...
  7. Hasse

    <B>Really Difficult Hierachical Query</B>

    Noonoo, I probably won't be of much help, but who knows... You're lucky with only a limited number of levels :-) because then I might provide you a first step... (As I've not enough time to read it all over again & work it out in detail, I hope I didn't make any logical errors...) (And, in the...
  8. Hasse

    Address fields in selected area for fill/copy down function

    Hey, I'm trying to improve a friend's function which add's Excell's "Copy/fill-down" functionality to Access (a great idea by the way). When you have an area selected, it copies the values in the first row to all selected cells below. It should work both in tables/queries and...
  9. Hasse

    access2000 - crashing on network

    Total Access Tools (Analyser,...) seem to get often good critics. Though, I don't know the program you mention. However: why spend this money & time to it when the problem might be solved by one of the suggestions done here? Did you try out any of the tips yet? Creating an mde takes less than...
  10. Hasse

    access2000 - crashing on network

    I don't know if GDGarth agrees, but... if it's really corruption you're dealing with, and you can't put a front-end on each desktop and the file must be available for use by multiple users, I suggest converting the frontend to an mde - this might work too (according some tips I once read...
  11. Hasse

    Database Corrupted?? Permissions Problem?

    Graham, I don't know what the others think but... concerning security, I definitely don't use Access' security feature. (...) When you work on a network/..., you can 'get' the user name with a function executed when opening the database. In a table you can describe all users' rights/profile and...
  12. Hasse

    Automatically mail a word document

    Can't help you except, maybe: - recently, I remember having seen a procedure that waits untill a certain (any used) process is finished. Unfortunately I didn't bookmark it, but maybe, if you try mvps/google/... - if you create and store the result in Word, have you already tried to incorporate...
  13. Hasse

    Problem w/ Query

    Illini, as rtammer suggested, this isn't really the appropriate forum for such question... Take care of this! Tek-tips is good structured - we must try to keep it that way. But I hope you learn ;-). So let's see... First of all, at least if I understood rtammer correctly, I have to agree with...
  14. Hasse

    How To Get Good Answers To Your Questions

    ps In the end, I decided to try to solve the problem I mentioned by discussing it with a FAQ-contributer first. It's still sad you can't delete your own posts when they're not relevant anymore ;-)
  15. Hasse

    How To Get Good Answers To Your Questions

    Thanks for the tips!! In 15 minutes tehy'll result once again in a better written question (Microsoft Access Modules - Automating Netscape to send (address dependent) attachments using table data). Thanks for the tips! Hans - Belgium
  16. Hasse

    how to update field in table when the field is calculated from a form?

    Thanks UUTanh, it was a pleasure. See you around [santa2] (i.e. not wishing you anymore troubles ;-) ) - Hasse
  17. Hasse

    how to update field in table when the field is calculated from a form?

    Rereading my previous post, I've got to apologise for the hurry in which I wrote it which made me forget words,... I hope it's clear enough anyway. - Hasse
  18. Hasse

    how to update field in table when the field is calculated from a form?

    uuthanh, you should indeed leave the form and use the query as 'platform' for your calculations. To realise this, (1) build the query with calculated fields using your VBA functions (2) change the recordsource of the form in Queryname instead of TableName (3) change the recordsource of the text...
  19. Hasse

    how to update field in table when the field is calculated from a form?

    uuthanh, I think that the conclusion is that you should build a query with (among eventual others) those two calculated fields: Y = funcionY(X) Z = functionZ(X) This should be quite simple when you store them as public procedures in a module in the same database. In a further step, you can use...
  20. Hasse

    Why have a one-to-one relationship?

    Thanks! - (and for what it's worth: I think I'ld have chosen the same solution) - greetings - Hasse

Part and Inventory Search

Back
Top