Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.11 seconds.

  1. Are you actually importing a report, or is it...

    Are you actually importing a report, or is it something in RTF or comma delimited format? As long as you are able to get it to Access in a text field, then you can use the concatenation capabilities...
  2. Replies
    13
    Views
    1,104

    Some further questions and thoughts based on the...

    Some further questions and thoughts based on the posts of others:

    It's still not clear as to whether you are deploying the front-end to each workstation - from your description it doesn't sound...
  3. Replies
    11
    Views
    475

    If you decide to adopt Office 365, you will face...

    If you decide to adopt Office 365, you will face some choices. Assuming you get the version that includes Acccess, you will end up with what is effectively 2013, though there are hints that a new...
  4. Replies
    13
    Views
    1,104

    The advice from Mark and BHarder is spot on. I...

    The advice from Mark and BHarder is spot on. I don't see any reason to abandon Access completely. I've spent over 20 years developing client/server applications, starting with a beta version of...
  5. Replies
    1
    Views
    93

    The result you see in the debug window is 12:00...

    The result you see in the debug window is 12:00 noon with a zero day - remember that Access stores all dates with a time component as well. Are you doing this in VBA, or in a query? If it is the...
  6. Replies
    1
    Views
    161

    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...
  7. 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...
  8. Replies
    8
    Views
    1,478

    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...
  9. Replies
    4
    Views
    1,109

    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...
  10. 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",.....).
  11. Replies
    8
    Views
    1,478

    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...
  12. Replies
    8
    Views
    1,478

    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...
  13. Replies
    3
    Views
    720

    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...
  14. Replies
    6
    Views
    494

    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...
  15. Replies
    6
    Views
    494

    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...
  16. Replies
    4
    Views
    879

    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...
  17. Replies
    6
    Views
    494

    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...
  18. Replies
    7
    Views
    1,047

    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.
  19. 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...
  20. Replies
    4
    Views
    397

    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...
  21. Replies
    4
    Views
    397

    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...
  22. Replies
    4
    Views
    840

    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...
  23. 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...
  24. Replies
    3
    Views
    945

    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...
  25. Replies
    3
    Views
    945

    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...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4