Search:

Type: Posts; User: Patricia W; Keyword(s):

Page 1 of 9 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    7
    Views
    712

    THIS IS GREAT! Thank you, after reading your...

    THIS IS GREAT! Thank you, after reading your suggestion to Christopher, I tried it, and also found out that you can also accomplish the same by putting values, separated by commas, in the field...
  2. Replies
    6
    Views
    760

    Thanks, John. I agree with you that it is...

    Thanks, John. I agree with you that it is visually easier to store long message string to a variable, which I would definitely do if it were my code. Thanks for your note on the efficiency & of...
  3. Replies
    2
    Views
    1,219

    On your toggle button -- or, perhaps, from a...

    On your toggle button -- or, perhaps, from a dropdown combo selector -- check the value of the toggle or the dropdown, and change the record source of your subform:
    ...
  4. Replies
    4
    Views
    568

    What does the "xxxx" stand in place of? I don't...

    What does the "xxxx" stand in place of?
    I don't remember this, as I usually re-learn it only when I have to, but can you paint the highlight via report code in the "on format" or "on print" events?...
  5. Well, just for starters, I wouldn't put it in an...

    Well, just for starters, I wouldn't put it in an "on current" module, because -- won't you want someone to be able to make a selection, first? Unless I'm not understanding what you are trying to...
  6. Replies
    6
    Views
    760

    Hi, Judy, If it were me, I'd skip the...

    Hi, Judy,
    If it were me, I'd skip the intervening field declarations, and just stick the fields in directly -- does anybody have a comment on this, and if it is more efficient?

    Instead...
  7. Replies
    1
    Views
    368

    I do something (originally stolen from MSAccess...

    I do something (originally stolen from MSAccess help files) commonly on a form I create originally with all the field names. Then, I create the field names in a fixed format (prefaced by "qbf_" for...
  8. My question would be, although it's not the...

    My question would be, although it's not the likely culprit, but does this school system have occasional network issues and slowdowns? (I don't see how that would delete the data just typed,...
  9. Replies
    9
    Views
    686

    And the problem seems to be restricted to just...

    And the problem seems to be restricted to just one user.
    The reason I bring this up, is, if the user does not have the requisite permissions on the folder that contains the report, that may prevent...
  10. Replies
    9
    Views
    686

    Another question, is, is it happening to other...

    Another question, is, is it happening to other users, if any other users run this module.
  11. Replies
    2
    Views
    865

    4) Another form in the same DB with conditional...

    4) Another form in the same DB with conditional formatting (and many of the same expressions) DOES work!
    Joe,

    I'm not one of the experts here, but often when something like this happens (and it...
  12. Replies
    9
    Views
    742

    Re: Unusual happenings (2003)

    This problem happens (rarely, but occasionally) to us on a network, and the more I type this, the more wrong I think I must be in how it actually occurs -- but let me describe what I was first going...
  13. Replies
    7
    Views
    1,529

    Re: Data Type Mismatch (Access 2003)

    Hello -- I felt certain that I posted something about this earlier, but I can't find it, maybe I didn't. I found that I got this in one or two databases. I can't remember if I remade or dragged ...
  14. Replies
    13
    Views
    1,940

    Re: Connect to SQL Server via VBA (2003 SP 3)

    . Thanks, Ken, I'm glad you got it working.
    . There were really two parts to this question -- the SQL connect and exec, and the actual build of the string.
    . As far as the sql connect &...
  15. Replies
    13
    Views
    1,940

    Re: Connect to SQL Server via VBA (2003 SP 3)

    Ken -- it's possible that the query window is more forgiving. I know from experience here, that sometimes happens.

    I am not that much of a virtuoso with connection code, and like so many things,...
  16. Replies
    13
    Views
    1,940

    Re: Connect to SQL Server via VBA (2003 SP 3)

    Ken -- I think your "EXEC SDUpdate @SID = " is fine, if SDUpdate is the actual name of your procedure. I have the Chr(34) around the procedure name because it is a variable containing the name of...
  17. Replies
    13
    Views
    1,940

    Re: Connect to SQL Server via VBA (2003 SP 3)

    This isn't the answer to your problem, but noting your EXEC string, I wonder if you need quotes. The following is just a sample of a call I make. I pass a procedure and a starter date into a...
  18. Re: Filter Excluding Selection excludes nulls too

    Yeah, this is the null "gotcha," and believe me, others have ended up in the same boat. My commiseration!
    Pat
  19. Replies
    7
    Views
    600

    Re: Too many left outer joins (2000/XP)

    Not sure I have quite got it, but, couldn't you just add one field that you populate with a plot counter for each plot for each Landowner, and then when you go to output, use as the column title a...
  20. Replies
    8
    Views
    438

    Re: Running Sum in Group Footer (2003 SP2)

    Well, I think if Han's method works fine for the first person, it should work for the next -- if you do use the running sum over group. I think (maybe I'm not figuring this out correctly) but I...
  21. Replies
    8
    Views
    438

    Re: Running Sum in Group Footer (2003 SP2)

    Did you chose to have the field accumulate as a running sum "over group," or "over all?"
  22. Replies
    9
    Views
    519

    Re: Not like Statement working (2003)

    So that those of us who don't open attachments can help, can you paste a simplified version of your query to show what you are trying to do to attain the goal of excluding that line?
    thx
    Pat
  23. Replies
    2
    Views
    343

    Re: One-to-Many Relationship (2003)

    Monica,

    I would start by creating a query with the information that you want on the report. In order to join all the tables, you need to identify what information in each table can join the two...
  24. Replies
    5
    Views
    413

    Re: Gray Header (Access2003)

    Can't you make the "backcolor" of your header be gray, (click on your header, or, if no open space, your header bar) and then "lasso" all your labels in the header (select all), click on "properties"...
  25. Re: Locked Data Message (2003 (11.824.8202) SP3)

    Sometimes, on a network, I cannot delete an .ldb. It gives me the same error message you get. If I log off & then back on the network I can delete it.

    In addition to what Hans said about...
Results 1 to 25 of 220
Page 1 of 9 1 2 3 4