Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    705

    Thanks John. Using the sub-query worked...

    Thanks John. Using the sub-query worked perfectly. It deleted multiple occurrences in table2 of every matching record found in Table1. No indexes, no keys.
    Thanks again,
    Lance
  2. Replies
    4
    Views
    705

    Andrew; The real life data situation is a bit...

    Andrew;

    The real life data situation is a bit more complicated and not necessary to go into.
    To see if I was on the right track, I created 2 tables: Table1 and Table2

    Each table has just 1...
  3. Replies
    4
    Views
    705

    I'm using Access 2002 / 2003. I wroe a simple...

    I'm using Access 2002 / 2003. I wroe a simple delete query and I can't get it to run. I keep getting the error "Could not delete from the specified tables."

    I have table1 and table2 and I want to...
  4. Replies
    2
    Views
    428

    I have a report generation form that allows the...

    I have a report generation form that allows the user to i/p selection criteria and run various reports. Some of the reports are saved to a default folder.

    I want to provide the user with the...
  5. Guess I was over thinking that one! Once again...

    Guess I was over thinking that one!

    Once again - You're The Man!

    Thanks
    Lance
  6. I've encountered this before but wrote a...

    I've encountered this before but wrote a work-around. Just encountered it again and decided to sese if anybody knows why this is happening - or more likely, what am I doing wrong.

    I have a date...
  7. Replies
    3
    Views
    370

    Thanks Wendell; Unfortunately, I'm working in...

    Thanks Wendell;

    Unfortunately, I'm working in 2002 / 2003. I found some code on the posts you referred me to so I'll try and see if I can get it to work.

    Thanks again,
    Lance
  8. Replies
    3
    Views
    370

    I need to create / save my reports in PDF format....

    I need to create / save my reports in PDF format. I will be creating them one at a time within a loop through a Recordset query. I don't want the user to have to select the PDF printer and a Save As...
  9. That's exactly what I'm trying right now. Great...

    That's exactly what I'm trying right now. Great minds think alike http://windowssecrets.com/forums/images/smilies/smile.gif

    Thanks
  10. I've already linked Master and Child fields where...

    I've already linked Master and Child fields where appropriate. There are several sub reports on this particular report. I can't use them in all sub-reports because some have criteria such as: "<=...
  11. I have sub-report that needs to change it's...

    I have sub-report that needs to change it's record source based upon values in the parent report. This sub report is used in multiple main reports so I can't reference the control directly since I...
  12. Replies
    7
    Views
    511

    There was no lock file for this db. I...

    There was no lock file for this db.

    I downloaded the UnLocker program you suggested. It was not able to unlock the db but it listed the Process that lwas ocking it. I have some backup s/w (Memeo)...
  13. Replies
    7
    Views
    511

    Hans; A follow-up to last weeks 2 dbs editing...

    Hans;

    A follow-up to last weeks 2 dbs editing problem - This is strange and has been happening lately - I made a copy of my front end db and now when I atempt to open it I get a messge that it's...
  14. Replies
    7
    Views
    511

    Hans; I'm just glad you're here. You've gotten...

    Hans;

    I'm just glad you're here. You've gotten me out of trouble many, many times in the last several years.

    I work alone out of my home with no one else to talk to, no one to talk through...
  15. Replies
    7
    Views
    511

    You must have misunderstood my post. Sorry if I...

    You must have misunderstood my post. Sorry if I was not clear enough.

    Since version 2000 Access prevented you from editing objects if another copy of the same db was open.

    That is not the...
  16. Replies
    7
    Views
    511

    I've been developing Access apps for over 10...

    I've been developing Access apps for over 10 years and this is the first time this happened.

    I have 2 db files, 1 for the data and 1 for everything else. I usually have them both open so I can go...
  17. Replies
    12
    Views
    1,645

    Tried it - no luck. I'm not sure this can be...

    Tried it - no luck.

    I'm not sure this can be done. I have a lot of boxes drawn on the report so it looks like a data entry form when printed out. I think those boxes are causing the problem since...
  18. Replies
    12
    Views
    1,645

    I tried that. Still getting a blank second page. ...

    I tried that. Still getting a blank second page.
    I also set the page length to really short and really long. Had no effect.

    I'm still trying stuff - looking to see if I'm running over from the...
  19. Replies
    12
    Views
    1,645

    Hans; That worked - sort of. When I have...

    Hans;

    That worked - sort of.

    When I have page 2 data, it prints. When there is no page 2 data, nothing prints but I end up with a blank page.

    Any ideas on how to stop the blank page?
    ...
  20. Replies
    12
    Views
    1,645

    Hans; Thanks. That should work. Lance

    Hans;

    Thanks. That should work.

    Lance
  21. Replies
    12
    Views
    1,645

    Hans; That sounds like it could work as long...

    Hans;

    That sounds like it could work as long as I print one record at a time. i.e. A given test record may or may no have "page 2" data.

    However, if I print multiple records at a time, i.e....
  22. Replies
    12
    Views
    1,645

    That's probably doable, but we'd need to know...

    That's probably doable, but we'd need to know much more to be able to provide more specific help.

    The report is a free form report with data seperated in preformatted areas (boxes). It looks just...
  23. Replies
    12
    Views
    1,645

    Backgroung: Depending on the data, sometimes I...

    Backgroung:
    Depending on the data, sometimes I have to generate a "page 2" of a report. Page 2 contains additional data that is sometimes available. When collecting the data into the db, based upon...
  24. Replies
    2
    Views
    365

    Re: Union qry truncating memo flds (2003)

    Hans,
    It worked perfectly!

    Thanks so much,
    Lance
  25. Replies
    2
    Views
    365

    Union qry truncating memo flds (2003)

    I have 2 queries that select various fields including one memo field. The queries work as expected when run seperately. When I create a union query combining the two of them, the memo fields get...
Results 1 to 25 of 82
Page 1 of 4 1 2 3 4