Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.09 seconds.

  1. Replies
    6
    Views
    382

    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...
  2. Replies
    6
    Views
    382

    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...
  3. Replies
    4
    Views
    701

    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...
  4. Replies
    6
    Views
    382

    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...
  5. Replies
    7
    Views
    852

    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.
  6. 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...
  7. Replies
    4
    Views
    294

    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...
  8. Replies
    4
    Views
    294

    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...
  9. Replies
    4
    Views
    568

    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...
  10. 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...
  11. Replies
    3
    Views
    660

    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...
  12. Replies
    3
    Views
    660

    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...
  13. 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...
  14. 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...
  15. 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...
  16. Replies
    1
    Views
    228

    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...
  17. Replies
    2
    Views
    529

    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...
  18. Replies
    2
    Views
    262

    Unless you want to jump through alot of hoops,...

    Unless you want to jump through alot of hoops, entering "Nov" as a criteria for the report is not the easiest way to do that. Dates are stored internally in Access as a number (actually with both...
  19. Replies
    5
    Views
    325

    I feared that might be the case - the lesson here...

    I feared that might be the case - the lesson here is painful, but make sure your development directory is backed up daily.
  20. Replies
    5
    Views
    325

    Unfortunately Kevin, when that happens it often...

    Unfortunately Kevin, when that happens it often means the VBA project is really gone. But there are some possibilities to check out. First, are you still using Access 2007, and do you have SP3 with...
  21. Replies
    3
    Views
    348

    What version of Access are you using (2000, 2003,...

    What version of Access are you using (2000, 2003, 2007, 2010...) and what file format are you using (.mdb, .adp, .accdb, etc.)? There is a setting in Access on the General group that specifies the...
  22. Replies
    25
    Views
    1,336

    Most recent versions of Windows (post XP) allow...

    Most recent versions of Windows (post XP) allow you to right-click on a file and choose Send To/Compressed Folder as an option which creates a zip file.
  23. Replies
    25
    Views
    1,336

    If you want to attach an Access database,...

    If you want to attach an Access database, compress it to a zip file, and you should be able to upload that. Before you do that be sure to compact and compress it if you have done any significant...
  24. Replies
    3
    Views
    567

    The error about the record not being updateable...

    The error about the record not being updateable is typically because Access thinks you don't have a primary key on the table when you are running an update against a single table. Is your table...
  25. It is possible to export all of those VBA windows...

    It is possible to export all of those VBA windows to text files, which is a common way of repairing VBA projects that are corrupted for some reason, or you can simply copy and paste the contents of...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4