Search results

  1. MsAccessNL

    Hide extra data in continuous form rows

    You can use a Temp table as recordsource of the form. Load your query in a recordset and Loop the recordset to put the values in the Temp table, the double days are replaced with a null string. I can give you the code if it’s to difficult. I think it’s also possible with sql, i have to check my...
  2. MsAccessNL

    Hide extra data in continuous form rows

    Do you mean, Monday followed by 3 empty days and then Tuesday followedby 1 empty day?
  3. MsAccessNL

    Optimising Routes

    I have made a shortest route dispatch system for a courier business in Amsterdam. Solving the traveling salesman problem with vba and the googe api, took my a lot of time, but was really fun making it. For me it is still not clear what your business is doing. (I have not read all the posts). Is...
  4. MsAccessNL

    Help filling in a web form from access.

    Sorry didn’t see the other post.
  5. MsAccessNL

    Help filling in a web form from access.

    Did you try right click > inspect to see all the html elements. You need a htmlElement.Tagname or elementid to tefer to the specific inputbox.
  6. MsAccessNL

    Open pop up form at mouse cursor position

    I have used the absolute postion times the the detailheigth (in designform) to set the Form.Top of the popup form (if the Mainform is a continuous form). But i don't think it will work correct with scrolling. You could put the continuous form on a Mainform and stretch the anchor of the...
  7. MsAccessNL

    Looking VBA Winsock/JSON Consultant

    I might be interested, if you have some more info?
  8. MsAccessNL

    Attack on Israel

    If we could sent you back 150years as president. How would you solve the problems with the indigenous? What would be your solution? do you think that you could (as a white not indian person) invent a solution that would have been excepted bij the native residents? I am writing this words, not to...
  9. MsAccessNL

    Hello all, newby from Amsterdam here with an ACCDE security quest

    It’s not hard to retrieve the backend password from the linked table connection string (as you probably know). I think that the accde hack is useless without access to the vba code and the possibility to change the forms/reports.
  10. MsAccessNL

    Attack on Israel

    Some of the native American’s had this “terrorist” tendency to scalp innocent white colonists. Luckily the government could retaliate with a strong well equipped army. Otherwise the poor colonists could have been ended up in “white reserves” without any rights, suppressed by these scalping...
  11. MsAccessNL

    Hello all, newby from Amsterdam here with an ACCDE security quest

    Hello Orny, I am from Amsterdam to. Iam experimenting with php api requests to get data into Access. Your question is not really clear to me. You want to inject a form into an existing accde? Daniel.
  12. MsAccessNL

    When to stop learning...?

    I think that learning is a very essential part of life itself. Life is one big learning experience. If you are religious or not, somebody or some entity or life itself, istrying to teach you something, if you can’t crasp that, you will miss the true essence of being alive..
  13. MsAccessNL

    Civil War Beginning in Russia

    Storming the capitol didn’t affect much people, T is running again.probably the Russians wiil react the same, why?, because they are humans like you and I. There is only a difference if you want to see a difference. Let it go, if you where born in Russia, you would have hated Americans, it’s not...
  14. MsAccessNL

    I think I need to pay for some Access help....

    I am not in your timezone (Amsterdam Netherlands) but i am currently working on this fishing contest database for somebody from New Zealand. I am available if you want me to have a look at your db.
  15. MsAccessNL

    Performace - multiple forms opened

    I mostly use a menu at the side or the on the top. The menu wil open the form inside a subform control called FormContainer1. You can set the sourceobject: FormContainer1.SourceObject = "FormName". In this way you never have a lot forms open at the sametime. When i use more forms then I add...
  16. MsAccessNL

    Hide combobox arrow. A better method

    The continuous form must be a subform, the listox is placed on the main form, adjusting its position to current control on the subform.
  17. MsAccessNL

    Hide combobox arrow. A better method

    Use a listbox or subform beneath the text box, listbox.left =text-box.left . You can show the listbox with the on click event or on double click. You can use one listbox for all search textboxes, just set position and rowsource. I even have code to use this system on a continous form.
  18. MsAccessNL

    Preventing end users from using copies of your front end - the solution

    If you ever get in problems with your timer code, I have been experimenting with checking data from the server with Javascript or PHP. This will run async and i got a way to catch the async return into vba. Php code is especially interesting because this code wil run on the server side and will...
Back
Top Bottom