Search results

  1. jdraw

    Anyone with MiniZinc expertise

    I have an interesting scheduling requirement that includes constraints. This is more an academic issue, but I do have a colleague who has a similar real life assignment.
  2. jdraw

    Solved Steps to reDock immediate window

    Started this morning and my immediate window is floating. I tried clicking at the header/ top of immediate window, but it did not dock. It moved the immediate window full width at top of screen??? The immediate window is dockable when selecting options and when right click within the immediate...
  3. jdraw

    Bluetooth for older TV with criteria

    I have a smart-TV (samsung ~2015) that does not have bluetooth. I have seen/googled various BT adapters that can be used with BT Headphones. Seems like the obvious solution. Now the additional criteria: -The TV is on a wall mount that turns partially but difficult to get to all ports on...
  4. jdraw

    Solved You can't assign a value to this object??

    Has anyone else had this issue recently? I am trying to set a textbox to "" empty string. Me.txtCode = "" I have copied my form from backup and it has worked as expected several times. Now, I just encountered the error again. Have not found a solution? It seems (based on google) to have...
  5. jdraw

    Project is protected--Can't perform operation...???

    50289 --Can't perform operation because the project is protected. My routine calls code that uses the VBIDE to list the procedures in the user database. I am receiving the above error and can not determine why it is protected. I created the routine and did not do anything intentional (AFAIK)...
  6. jdraw

    Solved Form Issue

    ?? I have a routine to open a form from code. The form has a default type of Datasheet. This form has a header with buttons for Close and Refresh. When execute the code, the form opens as single form? However, if click the form name in the navigation pane it opens as Datasheet --no header nor...
  7. jdraw

    Hackers abuse Google Ads to spread malware in legit software

    Just a heads up from a colleague. Hackers abuse Google Ads to spread malware in legit software
  8. jdraw

    Multiple workspaces

    I'm looking for information or samples of Access vba programming involving multiple workspaces. If you have an article(s) or tutorial or sample code, I would appreciate same. Thanks in advance.
  9. jdraw

    Create database and load a module using vba.

    My requirement is to create an empty database using vba, and then load a module saved as text into that database. An example or advice would be appreciated. Thanks.
  10. jdraw

    MZTools customization

    Does anyone have sample code showing usage of custom MZTools vba Loop or other code favorites?
  11. jdraw

    A twist on BSOD

    Here is an interesting youtube video. For those questioning electronic vote counting or blue screen or bit flipping.
  12. jdraw

    Status of DatabaseAnswers.org ???

    I've noticed in the last few days that Barry Williams' site DatabaseAnswers.org is no longer available. It has been a long standing reference site for sample Data Models and related info. Does anyone have knowledge of status and/or future of this resource?
  13. jdraw

    Solved System.Collections ??

    In the past I have been able to use/reference system.collections to be able to work with Stack, Queue, ArrayList etc. I now have a new laptop and have move my O365 account to it. In addition I have moved to Office 64 bit. Bottom line is the previous code using System.Collections now fails...
  14. jdraw

    How to prevent Error message when using vba follow hyperlink

    I'm working with a new laptop and a new version of O365. I am trying to loop through a series of hyperlinks(see example below). I am getting this error when running code in vba . Process: ' Process the URLs 180 On Error Resume Next 190 sFileName = path & "Pat_out.txt"...
  15. jdraw

    Restrictions on Accounts

    I had a message from a user who asked about his inability to have attachments to his posts, I am not aware of any restrictions, so am asking the community at large, is there some setting/privilege that prevents a user who has >40 posts from adding an attachment to his post(s)? Perhaps I am...
  16. jdraw

    Solved Problem Inserting Data into Table

    I have a routine to create a table (LKX), the table has 1 field(firstName), that field is a unique index. I want LKX to have only DISTINCT values. When I try to loop through other tables(A,B,C) and Insert the selected field(firstName) values from A,B and C to Table LKX, the firstnames from A...
  17. jdraw

    Registering ADO data provider

    I have some data modeling software and am trying to reverse engineer an Access accdb database. I have O365 Access click to run. When I load the modeling software which supports several databases including Access (accdb) and select the Access file (it is standalone not split) the modeling...
  18. jdraw

    Type Mismatch ---traced to an issue with Decimal fields in Microsoft Access

    A heads up! Update 2005 12827.20268 (released June 2, 2020) appears to be causing various problems with Decimal fields in Microsoft Access databases. I just noticed this on another forum and posting this link to an ongoing review. The M$oft response is dated 2020-06-08 .
  19. jdraw

    Recent article Future of Access

    I just saw this link and thought I'd post it for others. The Access materials are of interest and the SQL Editor Addin is something I had not heard of. Has anyone tried same? Comments? This seems along the lines of what Crystal was doing --highlighting/coloring SQL key words, comments etc.
  20. jdraw

    How to place/overlay a textbox on an image on a form

    Does anyone have a link to or sample of placing a textbox or box control such that it overlays an image on a form (Access 2016)? I'd like to be able change the colour depending on some logic. Thanks in advance.
Top Bottom