Search:

Type: Posts; User: vanleblanc; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    5
    Views
    815

    that's it ! eureka! thanks muchly John ...

    that's it ! eureka!

    thanks muchly John

    Regards,
    Van
  2. Replies
    5
    Views
    815

    Thanks Jezza. Can you get yours to work if...

    Thanks Jezza.

    Can you get yours to work if the control source is a table?

    I don't see why it works ok if the source is a query and not if it's a table.

    Thanks,

    Van
  3. Replies
    5
    Views
    815

    Just tocheck Van, is the control source of the...

    Just tocheck Van, is the control source of the form the table or query that holds the [dateofdeath] field.I ask as I have just tried this on a test database of mine and it works fine.

    ="Date of...
  4. Replies
    5
    Views
    815

    Hi, I would like to join the text "deceased: "...

    Hi,

    I would like to join the text "deceased: " and a date field [dateofdeath] in a textbox so the box would show, for example: deceased: 10/5/2001

    I've tried: ="deceased: " & [dateofdeath] in...
  5. Replies
    6
    Views
    626

    Can this task be done using code?

    Can this task be done using code?
  6. Replies
    4
    Views
    590

    OK. That's what it will have to be. Not ideal,...

    OK. That's what it will have to be. Not ideal, but 2nd best solution.

    Many Thanks,

    Van http://windowssecrets.com/forums/images/smilies/smile.gif
  7. Replies
    4
    Views
    590

    the page footer doesn't seem to be able to grow /...

    the page footer doesn't seem to be able to grow / shrink. If the data in the sub-report is more than a few lines, the sub-report only shows part of the data, not all of it, and the report stays with...
  8. Replies
    4
    Views
    590

    Hi All, I've been trying to work through this...

    Hi All,

    I've been trying to work through this w/o any luck.

    I have a report with 2 sub-reports. I would like the 2nd sub-report to print at the bottom of the last page only.

    I've tried...
  9. Thanks Hans, that works really well. just the...

    Thanks Hans, that works really well. just the solution I was looking for.

    Regards,
    Van
  10. merci boucoup! works great. Van

    merci boucoup!

    works great.

    Van
  11. Hi Francois, doesn't that just find the next...

    Hi Francois,

    doesn't that just find the next day (ie. today +1)? what if the next meeting date is 5 days from now for example?

    Van
  12. Hi All, I know this is likely easy to do, but...

    Hi All,

    I know this is likely easy to do, but I can't seem to get it.

    In a query, I want to return the next record from a table whos date is greater than today. For example, the table has 2...
  13. Replies
    2
    Views
    317

    thanks Hans. that's what I suspected. ...

    thanks Hans. that's what I suspected.

    Regards,
    Van
  14. Replies
    2
    Views
    317

    Hi All, I have a form that has 3 combo boxes. ...

    Hi All,

    I have a form that has 3 combo boxes. All have row source type set to "value list". All have the same row source values. I know this can be done if the row source type is a table/query,...
  15. Replies
    15
    Views
    877

    Thanks Muchly Hans. you're help has helped me to...

    Thanks Muchly Hans. you're help has helped me to fix the problem. seems the tabctrl10 visible property was set to "no". I was trying to make the tabs visible, but the actual tab control was not...
  16. Replies
    15
    Views
    877

    As far as I can tell, the cause of the crash is...

    As far as I can tell, the cause of the crash is that if no treatment has been selected, you try to hide ALL tab pages of TabCtl10 on frm_TxDelivered.
    This probably clashes with setting the...
  17. Replies
    15
    Views
    877

    I have attached the frontend, decompiled,...

    I have attached the frontend, decompiled, compacted and zipped, with some of the changes I recommended. You'll have to relink all tables to the backend, so first open the database with Shift held...
  18. Replies
    15
    Views
    877

    thanks ever so much Hans. I've made all the...

    thanks ever so much Hans. I've made all the changes you've suggested and so far I haven't been able to make it crash....fingers crossed!

    Now to pilot it with the users. I'm sure they'll find a...
  19. Replies
    15
    Views
    877

    Hi Hans, My dB is still crashing. It occurs...

    Hi Hans,

    My dB is still crashing. It occurs when I scroll from record to record on the main form ("patient data" on the switchboard). It happens intermittently, but fairly often....can't figure...
  20. Replies
    15
    Views
    877

    There's a setting in the Tables/Queries tab of...

    There's a setting in the Tables/Queries tab of Tools | Options... for automatically creating an index on a field if its name startsor ends with one of the specified strings. By default, ID is among...
  21. Replies
    15
    Views
    877

    Thank you very much for the help Hans. I had no...

    Thank you very much for the help Hans. I had no idea there were so many Indexes in use and how they got there! perhaps these changes will help.

    Kind Regards,

    Van...
  22. Replies
    15
    Views
    877

    To attach your zipped db, click on Browse, find...

    To attach your zipped db, click on Browse, find the zip file and click on UPLOAD.


    ok done. sorry about that
  23. Replies
    15
    Views
    877

    Hi all, I have developed a small dB that keeps...

    Hi all,

    I have developed a small dB that keeps crashing and I can't seem to identify the cause. I have attached the dB back-end and was wondering if someone could please have a look at the design...
  24. Replies
    8
    Views
    824

    thank you Hans. works great. (ps. having a...

    thank you Hans. works great.

    (ps. having a bit of trouble working out how to send reply in the new Loung layout) http://windowssecrets.com/forums/images/smilies/unsure.gif
  25. Replies
    8
    Views
    824

    In an expression such as =[Salutation] & " " &...

    In an expression such as

    =[Salutation] & " " & [FirstName] & " " & [LastName] & (Chr(13)+Chr(10)+[Address1]) & (Chr(13)+Chr(10)+[Address2])

    the use of + instead of & means that the part...
Results 1 to 25 of 129
Page 1 of 6 1 2 3 4