Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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)...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. kevlray

    Works on MS-SQL not Access

    We have an Access (2007) DB with a MS-SQL (2008) back end. I was struggling in Access to get the results I wanted, so I switched over to MS-SQL and got a query to work. When I bring the query over to Access (Create, Query Design, SQL). When I try to execute it, I get a syntax error in From...
  14. kevlray

    Theorical question

    We have an Access 2007-2010 database (converted from Access 2003) with an MS-SQL 2008 backend. Each user has their own copy of the front end. We have the case where a sub-form accesses the same database as another form in the same Access application. Right now I see that there is no record...
  15. kevlray

    Issue with text field on linked table

    We have a database (Access 2007) with several linked tables to an MS-SQL 2008 instance. All the text fields that I have issue with are nvarchar(255) on MS-SQL. The odd thing it will not allow a full 255 characters to be entered into the field. It will fail to save unless the number of...
  16. kevlray

    Need combo box in header to be default object selected

    I have a request from users to have a combo box in the form header defaulted to the selected object when they open the form or search on a new person (same object they want to be default). Currently it defaults to the first box in the detail section. (I hope this makes sense) I believe I can...
  17. kevlray

    Linking two databases to same SQL table

    This may have been answered before, but when I googled for answers, I did not come up with anything. We have a case where there is an append query in one database that is is updating another database table. We have moved all the tables to MS-SQL (2008) using the SSMA tool. We were wondering...
  18. kevlray

    Wierd report issue solved

    I do not know if anybody has come across this issue, but it confused me for a few hours this morning. I have a report that I was trying to modify. Every time I replaced a particular field it was changing to another field any time I ran the report saved it. Now some background. The DB in...
  19. kevlray

    tab stop issue

    I have an odd issue which defies the logic of tab stops. I working with an old database (created about 2003). There is a form on this database which has a couple of sub-forms. In one of the sub-forms there are three more sub-forms. The tab stops have been set to No on the main form. In the...
  20. kevlray

    List box not displaying properly after SP

    We are running a Access 2000 DB on Access 2003. I was working fine before we upgraded from SP 2 to SP 3. Here is the issue. We have a list box that is has a query for the row source and some of the fields are not displaying (i.e., we have a header for Vendor No and all the values are being...
Top Bottom