Search results

  1. kevlray

    Conditional formatting of combo box entries

    I suspect this is not possible. But I give it a try. Clients want entries of a combo box to be conditionally formatted. I have looked around the internet and not seen anything. So the conditional format would be in the form of, IsNull(( [TermDate] ) = False, then set the text to red. So...
  2. kevlray

    Odd table issue.

    So we have a FE/BE database that has an MS-SQL BE. In the past few days we have had it were one table was showing all the rows as #Deleted (in Access). They use Windows Authentication for rights to the database. I downloaded SSMS to see if the user had rights to the database and table and...
  3. kevlray

    Exporting data to a Teams folder (is it possible)

    So I have a request to export some data (MS-SQL backend) to a Teams folder (as an Excel file). Since they want it near real time, I know I will have to write some code when a value changes, but I am not sure if is even possible. Thanks in advance. So further information that (might) be...
  4. kevlray

    ODBC Office 365 issue.

    Our organization recently upgraded to Office 365 and now we need to create an ODBC (32-bit for Crystal Reports) to a new database. We currently have a few other Access databases with ODBC's already (which are working fine). But now when we try to create a new ODBC (System DSN, Microsoft Access...
  5. kevlray

    Linked table manager oddity

    So we are now on Office 365 and I need to link one of the tables to another database (test). But I go through the procedure. Create a new link. Id the table I want, click on re-line. But when I check the table's link data, it has not changed. Any ideas?
  6. kevlray

    Cannot get fore color to work in text box

    So we just migrated to Office 365 and I am adding a new text box and I cannot get fore color to accept an custom color (come out as black). I am using the hex notation. Copied the color from another label on the same form (which is working fine). I tried some random colors and the y seem to...
  7. kevlray

    popup.ocx missing

    Our organization has just moved from Office 2013/2016 to Office 365. Now we have database reporting that popup.ocx is missing. First, can I download an popup.ocx and install it to work with Office 365. Second where can I get a copy that I can trust to be safe?
  8. kevlray

    Office 365 question

    Our organization is planning to move of Office 265. We have a lot of Access databases. I believe that most of them are 2007+, I know that older databases will have to be converted to 2007+ before going to Office 265. Most of the departments have Office 2016. Are there any issues I should be...
  9. kevlray

    Numeric String comparison

    So I have some code that is most of the time a number, but sometimes be a string (i.,e "1000000" or "<1000000"). But I have to compare to a number (i.e, 600000). The values come from an MS-SQL back end. I tried using Format() (i.e, Format(rst!.DMSCC.Value, "#########") ) and compare that to...
  10. kevlray

    Importing Excel into Access (you think it would be easy)

    I had been using DoCmd.TransferSpreadsheet to import data into a table. But now the user wants to change one of the column headings in Excel to a name that does not match the field name of table. I found some code that looked like it would work (using ADODB), but we are on Office 2016, 64 bit...
  11. kevlray

    E-Mail button disabled on Print Preview

    We have a user that wishes to e-mail from the Print Preview window. But for some reason the e-mail is disabled. I opened a different database ( I do not have access to their database) and opened Print Preview window and the e-mail button is not disabled for me. What should I be checking on...
  12. kevlray

    Reset Named range.

    I have an existing named range called TotalActions. But I want to use VBA code to change that range. But the code I have basically does nothing (i.e., the value for the named range TotalActions does not get modified). Everything I have found so far indicates that my code is correct. With...
  13. kevlray

    64 bit compatibility

    I got assigned to fix the code for a user. I thought I had an idea what I was doing but still getting an error. So here is the original code. Private Declare Function apiShowWindow Lib "user32" _ Alias "ShowWindow" (ByVal hWnd As Long, _ ByVal nCmdShow As Long) As Long Function...
  14. kevlray

    Deleting an Access lock file

    Unfortunately some staff members created an Access DB on a shared network drive, the dtatabase has linked tables to an MS-SQL database. At one point the database became corrupted (I was able to fix it by copying the DB to another directory and opening it from that location and saved it back)...
  15. kevlray

    VBA code not running on all machines

    I created a small DB for another user. It has one macro (VBA) assigned to a button. When I try it on my machine (Office 2007 32 bit) and a test machine (Office 2013 32 bit), it works fine. But when I try it on the user's computer, nothing happens when we click on the button. I have checked...
  16. kevlray

    Odd issue with Find and combo box

    I have a very simple form. It has a combo box (list of budget line items) and an amount. I dropped a 'Find' button on the form and it will find any amount just fine. But if I try to find a line item (value from the combo box). It does not find anything. I thought this was working...
  17. kevlray

    Looking for a graphics card

    I am looking for a graphics card for my PC since it is pretty basic (Windows will not run FreeCell without complaining). I do not need much (not a big gamer). I have a PCI Express 3.0x16 slot for the video card and 400w power supply for the PC (one card I looked in a store needed a 12V at 20A...
  18. kevlray

    Odd issue with Forms

    I put question in this thread since it probably really involves more than forms. We have a few users that recently got upgraded to Office 2013 64-bit on Windows 7 (64-bit). The Access database probably was originally created as a Access 97 database. The database has been updated to Access...
  19. kevlray

    Error on switchboard

    We have one user that is getting the following error when she selects one of the buttons on a switchboard (Access generated switchboard). The expression On Click you entered as the event property setting produced the following error: The expression you entered has a function name that Microsoft...
  20. kevlray

    Ability to add rows from query results

    From a Access database that I inherited. Users used to be able (from a form) run a query and then add data (i.e, new rows). But now that the the database is split and the backend is on MS-SQL, they no longer can do this. I do not think this will be possible. I think they will have to add...
Top Bottom