Recent content by tfurnivall

  1. T

    Enumerating all Forms/Modules/Classes etc in an Access Database

    ]We have some progress! Thanks, Michael for your pointer. I have added it to my DBTool template, and it now allows me to manipulate a form in the Target database from within the Host database. (See attached DB). The critical code is: Public Sub ListTargetForms() Dim obj As AccessObject Dim...
  2. T

    file hyperlink in form

    Hi tb5038, You're providing some confusing information here. Let me see if I can show you where the confusion arises, and then ask you some questions. I hope that the two steps will help you ask a more instructive question - for what sounds like a fascinating application! You say: I don't...
  3. T

    Enumerating all Forms/Modules/Classes etc in an Access Database

    Well - 6 months seems a like a long enough time for people to forget about this, so let's see if we can whack the sleeping giants! I'm trying to get access (sorry about that ;-) to forms, modules and tables in another database. I can list them, but now I need to gain access to, for example, the...
  4. T

    Run time error -2146500594 (800f000e)

    Here's an update on my problem. I considered several possibilities; 1) Some Form_Load event handler was screwing me up 2) The problem was volume related (ie after 28 forms being opened, the whole thing just hiccupped) 3) The problem was form-related (ie there is something about the form that...
  5. T

    Time difference calculation

    Hmm Does the expression normalized database mean anything to you? Reason I ask is that if you have Time1 and Time2, then Time1-Time2 is only a calculation away. If you change either value, then Time1 - Time2 is still only a calculation away. Now imagine that an Evil User manages to change...
  6. T

    Command Button: red explanation point

    Would you please share some code, so we can get a better idea of what you're trying to do? If you already have a command button on the form, you can add an image of a red exclamation point by setting the value of the button's Picture property to the name of a file that contains the image you...
  7. T

    Time difference calculation

    Hi Manish Starting point is how Access manages dates and times internally. Dates are the integer part of a floating point number, and Times are the fractional part. So a time is represented internally as a fraction between 0 and 1. It's actually the fractional part of 24 hours that the time...
  8. T

    Request for Assistance naming a file

    Hi SupCom Without wishing to cause any offence, may I suggest that you not use abbreiviations like POD and SOW in a problem statement like this? My mind does not work the same as yours, and I had images of you throwing female pigs at a client.....;) However, if I am interpreting what you want...
  9. T

    Run time error -2146500594 (800f000e)

    Thanks, Rx and jdraw The environment is a local database (Access) that was used to construct a proof-of-concept tool for pitching to an organization in the UK. I now need to create the tool that will build at least the framework of the new environment (XAMPP). The easiest part, of course, is...
  10. T

    Import button to ask for location of file

    You probably want to use one of the Office FileDialogs. You'll need to establish a reference to the most current Microsoft Office Object Library. A quick check on the FilePicker dialog (Google msoFileDialogFilePicker to see how it's used) should give you exactly what you're looking for. The...
  11. T

    Run time error -2146500594 (800f000e)

    Hi I'm working on an application that will export and translate an Access database into a web-based (PHP/MySQL/Javascript) application. Small tests are going well, but when I try it on the 'production' scale database that is the true source for conversion, I repeatedly get the following error...
  12. T

    How does Access 'relate' a control and a label?

    Thanks, CJ I've already done that, and there's absolutely no indication (from simply listing out Control Properties Name/Value pairs) that provides a clue. (Of course, one zero can have multiple meanings, but nothing that I could find leapt out and said "Ta!Da!") Tony
  13. T

    How does Access 'relate' a control and a label?

    I'm getting waaaay to deep into Access' internals, but I have a nagging question - how does Access relate a label to a control? We can delete the label, and then re-'attach' it, but there seems to be no visible property that retains this information - in either the label or the control (only...
  14. T

    Heading In First or Second Row In Word Doc

    I don't know. However, using the following code (conforming to syntax published in 1999, and hopefully, therefore, preceding Word 2003 ;-) Dim MyRange As Range Set MyRange = Range(0, 0) MyRange.InsertAfter "This is the inserted text" + vbCrLf This did it for me, too! Good luck, Tony
  15. T

    Heading In First or Second Row In Word Doc

    Hmm! I just added it to a brand new document with nothing else, and it worked like a charm. I'm using Word 2010 - how about you? Tony
Top Bottom