Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.11 seconds; generated 53 minute(s) ago.

  1. Replies
    1
    Views
    110

    Hi Jack, nice to see you back visiting. ...

    Hi Jack, nice to see you back visiting. Unfortunately the MS Graph applet (for lack of a better term) has a number of limitations, and the current MS party line is to use Automation to build charts...
  2. If I understand your situation correctly, you...

    If I understand your situation correctly, you want to add a new record to the underlying table which is being displayed on a subform, but you want to add the new record at the top of the subform, not...
  3. Replies
    7
    Views
    848

    It's reasonably easy to do. Click on the modules...

    It's reasonably easy to do. Click on the modules in the Nav Pane (2007 and later) or the Database Window (2003 and older), and create a new module, copy the code suggested, and that should make it...
  4. Replies
    4
    Views
    433

    Another option in Access 2007, 2010 and 2013 is...

    Another option in Access 2007, 2010 and 2013 is to right-click on the print-preview, and that gives you the option to export the report to PDF (as well as some other formats and options). Of course...
  5. You might consider using the IN() construct...

    You might consider using the IN() construct rather than doing so many ="x" clauses, i.e. IIf([Cams_Change_Data1]![Status_Code] In("D","E","O","P","S"),"At EB",.....).
  6. Replies
    7
    Views
    848

    A further suggestion - there is a function in VBA...

    A further suggestion - there is a function in VBA that will find the first occurrence of a specified string within a given text string. It is called InStr() and you can read about it here.. It does...
  7. Replies
    7
    Views
    848

    With that sort of data, the standard sort...

    With that sort of data, the standard sort routines really don't work. Do you need it sorted that way on numerous reports and forms, or is it just a single report or two. If you are dealing with the...
  8. Replies
    3
    Views
    452

    As long as multiple users will be using a...

    As long as multiple users will be using a database, and you want them all to see the same content, the back-end of the database needs to have a common file path, so you will already have the file...
  9. Replies
    6
    Views
    430

    It appears that you have chosen the automatic...

    It appears that you have chosen the automatic option on the alternate rows feature. Take a look at Access 2010: Change Alternate Row Color and follow the procedure shown there, even though it is...
  10. Replies
    6
    Views
    430

    It's difficult to tell what is making the dark...

    It's difficult to tell what is making the dark background without knowing what version of Access you are using.

    Some possibilities are conditional formatting, or alternating rows, but there may be...
  11. Replies
    4
    Views
    783

    Good to see you in the Lounge again - you've...

    Good to see you in the Lounge again - you've actually been here longer than I have! One question occurs to me in reading Mark's reply. Do you have people who work for a month or two, then don't for...
  12. Replies
    6
    Views
    430

    What version of Access are you using? In more...

    What version of Access are you using? In more recent versions it is possible for text boxes to be grouped together so they all have the same width. However, the design view suggests that isn't the...
  13. Replies
    7
    Views
    947

    I appears your answer is a UNION query - as long...

    I appears your answer is a UNION query - as long as the tables have the same structure that should give you all of the records in both tables.
  14. Is the query that serves as the data source for...

    Is the query that serves as the data source for the Excel Chart a saved query? If so, I suspect that query may be the thing that is giving you the warning message, as filters can be saved as a part...
  15. Replies
    4
    Views
    365

    One option would be to change the Labels to text...

    One option would be to change the Labels to text boxes, and set them to null if the condition that makes you want to hide the record is true, the desired text if not null, and also make them zero...
  16. Replies
    4
    Views
    365

    The basic trick is to set the height of the text...

    The basic trick is to set the height of the text boxes to zero, and to have the Can Grow property set to yes. It makes working on the design and testing it a bit of a challenge, but we've used it...
  17. Replies
    4
    Views
    699

    It's been a long time since I tried to do that...

    It's been a long time since I tried to do that sort of thing, but I seem to recall that you need to embed the mail merge field within the field codes in Word that define text to be a hyperlink. Can...
  18. Can you be more explicit about how you linked the...

    Can you be more explicit about how you linked the Access table into Excel, and can you also describe in general terms what you want to do with the data once you have it in Excel? The most common...
  19. Replies
    3
    Views
    767

    If no one has welcomed you to the Windows Secrets...

    If no one has welcomed you to the Windows Secrets Lounge, let me be the first to do so. I did take a quick look at your prior thread, and it seems you have undertaken an ambitious task for a...
  20. Replies
    3
    Views
    767

    Hi Kelly. I edited your message to put your VBA...

    Hi Kelly. I edited your message to put your VBA procedure into a code window so it's a bit easier to read and has indents, etc. You can do that by using [ code ] and [ /code ] tags without the...
  21. In 2002 (only older version I have up and working...

    In 2002 (only older version I have up and working at the moment), there were three options for Default Find/Replace Behavior: Fast Search, General Search, and Start of Field Search. Those same...
  22. Off the top of my head, it appearss to me that...

    Off the top of my head, it appearss to me that you are using the full recordset with the statement "set rsParent = Me.Recordset" where Me. refers to the form you are currently in. However I can't...
  23. I presume you are working with the .accdb format...

    I presume you are working with the .accdb format where you can attach various types of documents to a record, and that you are working with Access 2007/2010/2013. There are some issues with...
  24. Replies
    1
    Views
    264

    Welcome to the Windows Secrets Lounge and the...

    Welcome to the Windows Secrets Lounge and the Databases forum.

    There are at least a couple of ways of doing what you describe using Access and Excel, but both require some knowledge regarding the...
  25. Replies
    2
    Views
    614

    My personal opinion is that there is only minimal...

    My personal opinion is that there is only minimal danger is changing the sandbox mode in 2010. The security features that were introduced in 2007 and beyond were intended to make it less vulnerable...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4