Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    7
    Views
    1,417

    Wow - as I said; you assume a level of knowledge...

    Wow - as I said; you assume a level of knowledge that is flattering but incorrect! No wonder I couldn't get it going as you originally suggested.

    Thank you very much for this; I can use this with...
  2. Replies
    7
    Views
    1,417

    Hello Andrew and John Thanks for your tips. I...

    Hello Andrew and John
    Thanks for your tips. I have constucted a (very crude) solution to my problem using a combination of Andrew's tips plus some code I plundered from the Northwind DB (the bit...
  3. Replies
    7
    Views
    1,417

    My users want a field which links to a Word...

    My users want a field which links to a Word document.
    If there is nothing in the field, they want the DB to start Word and save the filename when they exit.
    If the field is not null, they want to...
  4. Thanks, both. All working OK, now. I used the...

    Thanks, both. All working OK, now.
    I used the Public variable method as I already had a module containing some general functions.

    Silverback
  5. Replies
    103
    Views
    12,340

    Hans I owe you a thousand thanks for all the...

    Hans
    I owe you a thousand thanks for all the help you've given me over the years. My knowledge of Access has improved enormously through your knowledgeable and patient replies to my problems.
    I've...
  6. I have a form A which contains a sub-form A-sub;...

    I have a form A which contains a sub-form A-sub; this subform contains a date, A-date.
    When a command button on form A is clicked, a second form B is opened; this also contains a subform, B-sub,...
  7. Thread: Lost VB?

    by silverback
    Replies
    10
    Views
    619

    I am hugely embarrassed to admit that this...

    I am hugely embarrassed to admit that this posting has been a waste of everyone's time. The reason the code page for this form object is empty is because there is no code to display; I moved it after...
  8. Thread: Lost VB?

    by silverback
    Replies
    10
    Views
    619

    Yes - have even opened the old DB's and still the...

    Yes - have even opened the old DB's and still the code won't show. That's the hope I'm hanging on to - it can't possibly have been deleted in DBs that weren't even open when i made my mistake, so...
  9. Thread: Lost VB?

    by silverback
    Replies
    10
    Views
    619

    Yes, Francois. And right clicked and selected...

    Yes, Francois. And right clicked and selected View Code. Nothing

    But the wierd thing is if I go to an old version of the DB, I still get a blank code window there for this object. Even if I've...
  10. Thread: Lost VB?

    by silverback
    Replies
    10
    Views
    619

    I was amending VB for my database. One of the...

    I was amending VB for my database. One of the objects in the Project Explorer window no longer has any VB so I was trying to delete it from the list. Didn't manage that, so moved to the code window....
  11. Replies
    7
    Views
    819

    John Thanks for your tip. I've used the method...

    John
    Thanks for your tip. I've used the method advised by Francois and Hans, but have filed your tip on how to read and restore these options for possible future use.
    Silverback
  12. (Access 2003 SP3) I have a query which is used...

    (Access 2003 SP3)
    I have a query which is used to extract all information required for producing a employee contract. This query has, in one field's criterion area, a call to a VB Public function....
  13. Replies
    7
    Views
    819

    Perfect! It's working just as we want it to....

    Perfect! It's working just as we want it to.
    Thanks to you and Hans.
    Silverback
  14. Replies
    7
    Views
    819

    My development DB uses action queries which...

    My development DB uses action queries which generate Access warning when they are run. I would like to switch these warnings off (Tools | Options | Edit/Find | Record Changes and/or ActionQueries)...
  15. I have a form with a sub form. In one...

    I have a form with a sub form. In one circumstance - where an employee already exists - I want the sub-form display to be continuous forms; in another situation, that of inputting a new employee, I...
  16. Replies
    4
    Views
    577

    Perfect. Many thanks...

    Perfect.
    Many thanks http://windowssecrets.com/forums/images/smilies/cheers.gif
    Silverback
  17. Replies
    4
    Views
    577

    Hans Thanks - that leaves the cursor in the...

    Hans
    Thanks - that leaves the cursor in the offending field OK, but how can the old value be reinstated? I tried setting the field to OldValue and got another error :


    The offending line where...
  18. Replies
    4
    Views
    577

    I have a Before Update event to test the contents...

    I have a Before Update event to test the contents of a date field in a sub-form. If the date has been set to before today's date I want to output a message and end up with the cursor back the...
  19. Replies
    4
    Views
    2,239

    Thank you, Andrew and Hans User has accepted...

    Thank you, Andrew and Hans
    User has accepted work rounds of
    a: resizing/moving the window on the rare occasions when she wants to see something under the email
    b: inserting her signature using...
  20. Replies
    4
    Views
    2,239

    Welcome back! I am using a DoCmd.SendObject...

    Welcome back!
    I am using a DoCmd.SendObject command to send an email; the code fills in a Bcc list and the subject line if the user has supplied one or, if not, leaves the subject line blank.

    The...
  21. Replies
    2
    Views
    331

    I have a table which holds salary information...

    I have a table which holds salary information about employees, each of whom can have multiple entries. The 'latest' salary record for an employee is identified by the highest value Salary_ID (an...
  22. Replies
    3
    Views
    443

    Oh dear. How embarrassing I really am getting...

    Oh dear. How embarrassing
    I really am getting too old for this business. I was absolutely convinced that the subform used to be displayed and that suddenly it stopped. As you have shown, it was...
  23. Replies
    3
    Views
    443

    I've attached a version of my development DB. To...

    I've attached a version of my development DB. To see the problem, the file will have to be unpacked and the read only property removed, otherwise you get an error which masks the current problem.
    ...
  24. Replies
    3
    Views
    474

    Yes - both sub-forms are part of a main form -...

    Yes - both sub-forms are part of a main form - the second sub-form is NOT nested within the first.
    They are linked using the 'Link Child Fields' and 'Link Master Fields' data properties of the...
  25. Replies
    3
    Views
    474

    I have a main form which contains two sub-forms A...

    I have a main form which contains two sub-forms A and B which are linked.
    A has multiple employment history records for each staff member including job title.
    B has multiple records detailing how...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4