Search results

  1. K

    Florida banns social media for minors.

    In Florida, as of January 1, 2025, children under 14 are barred from establishing social media accounts under a new law enacted by Governor Ron DeSantis. The legislation requires 14- and 15-year-olds to obtain parental consent to maintain accounts on social media platforms equipped with...
  2. K

    Ordered By Warning in Sql Server

    Can anyone explain in simple words what does this warning mean? I have a complicated query in Access that works fine and returns the expected results. If I copy its sql to a view in SSMS, I receive the above message when I try to save the view. Clicking OK bypasses the warning and the view...
  3. K

    List of methods of a class in intellisense - 2

    According to the solution that was given by @MajP in this thread I use the following structure to access the methods or objects on a form; Dim frm as Form_MyFormName set frm = forms("YourFormName") With frm . ---> List of methods are included in intellisense End...
  4. K

    Missing SQL Server Logs

    This question is an extended question to This post. Since the nature of the question is different, I preferred to start a new thread. When I use SMSS to login to sql server, I can see the sql server Logs under Management. ( I have 6 Files, archived included) If I add a login trigger to the...
  5. K

    Preventing login to server from a client PC

    Studying and learning Sql server. Environment : Windows domain with a sql server machine. The FE on all client PCs can access the data on sql server using DSNless linked tables. (Trusted_Connection) Anyone from a client PC, can install SQL server management studio (or something else) and...
  6. K

    Querying an Excel file

    I use the following to create a query from a csv file. SELECT ..... AS ....., ..... AS ....., ..... AS ..... FROM [TEXT;DATABASE=D:\test\;HDR=Yes].somefile.csv; How about if the file is Excel? Is it possible to query a table in a specific worksheet in an Excel file? If not...
  7. K

    A Safer Way to Use TempVars

    Still in new year holidays and having nothing to do, I'm trying to understand what Mike Wolfe's trying to achieve in this article: https://nolongerset.com/a-safer-way-to-use-tempvars/ It seems that he adds a tempvar and then in the class, he sets a property to read the value of a tempvar and...
  8. K

    Resizing images

    Not a suggestion but a question. When you’re on a touch panel (phone - tablet - touch screen) and you insert an image into a post, how do you drag and resize the image? Thanks
  9. K

    Solved Delay in Alt+F11

    I need some confirmations on bellow case. I have an accdb database with 212 forms, 72 modules, 12 class modules & 51 reports. This database is used for developing and an accde is distributed for use. For the past few months I'd noticed that ALT+F11 takes around 20 seconds to open VBE...
  10. K

    Crime, Verdict & Sentence

    I’m obsessed with crime documentaries. And America as a country with one of the highest rate of crimes, has always been a good seed for these documentaries. More than %99 percent of what you find in Netflix, Amazon, YouTube ,… is about some crime in US. I’ve always had a question but never had...
  11. K

    Duplicated items in Intellisense

    I've recently noticed some items have been duplicated in Intellisense. I narrowed down the problem and found out it's because of the following two references. Microsoft Scripting Runtime Windows Script Host Object Model Deleting any of them solves the problem. Because of the nature of our...
  12. K

    How to change the source of a linked table?

    I have 3 linked tables to 3 csv files. These csv files are downloaded from an on-line order system. Because of some changes that our IT has put in place, I have to change the folder the csv files will be downloaded to. (From shared folder of domain controller to another File server). Is there...
  13. K

    VBA Limitations - Restrictions

    Having nothing to do, I decided to run MZ-Tools' Review Quality on one of my databases. In Programming Rules Review, I'm receiving some weird errors I've never heard of. The number of parameters of a method cannot be greater than 5 (Receiving on API with more than 5 parameters) The number of...
  14. K

    Solved Continuous Sub forms

    A while ago, I saw a post from a member asking help for having a continuous sub form in continuous Main form. Since it's not actually possible, @MajP solved the problem by having multiple data sheet subforms. (If my memory serves me right) My search doesn't bring up anything. Does anybody...
  15. K

    Tip Culture

    I've never understood Tip culture in other countries. Not only we don't have it, we don't even understand why customers should tip someone who is being paid to do his/her job. Up to now, it was a mystery why tipping exists but I was just OK with it. Different cultures different methods And now...
  16. K

    Solved How to add a signature to a mail

    This is a simplified version of a vbs script to create a mail Sub createOutlookEmail() Dim appOutlook Set appOutlook = Wscript.CreateObject("Outlook.Application") Set objMail = appOutlook.CreateItem(0) With objMail .To="Some mail address" .CC="Some mail address"...
  17. K

    Solved Changing Form's width

    I have a problem with changing a form's width and hope someone can shed a light. (I hate long questions, But I couldn't make this post shorter. Sorry.) This is a simple form in design view: Two buttons and a checkbox. I change the width of the form on OnOpen event to something that is not...
  18. K

    Solved List of methods of a class in intellisense

    I have a form with several public methods. Private m_PK As Long Public Property Get PK() As Long PK = m_PK End Property Public Property Let PK(ByVal NewValue As Long) m_PK = NewValue End Property When I open the form as following, intellisense doesn't show the list of methods...
  19. K

    Solved Webdings Translator - Faking a checkbox

    I'm trying to fake a textbox to show as a checkbox (somehow). If a textbox named PrintedOn is empty, the faked checkbox should show a X. Otherwise I want it to show a tick mark. Textbox font is set to Webdings Its control source reads as : =IIf([PrintedOn] & "" ="","","ü") I'm trying to find...
  20. K

    Solved WithEvents Class

    My first steps to learn how to use WithEvents in a class module. Here's a simplified version of what I have in a class module called clsFrm: Option Explicit Private WithEvents m_form As Access.Form Private WithEvents m_Closebtn As Access.CommandButton Const fEvents As String = "[Event...
Top Bottom