Recent content by Rene vK

  1. Rene vK

    Is it a good practice to use "intermediate" tables?

    Thank you Doc_Man. I will keep that in mind!
  2. Rene vK

    How to get name of current field in table?

    Dave, your welcome. Hope we got you on your way. My idea is not directly written for your automation. Good luck.
  3. Rene vK

    Is it a good practice to use "intermediate" tables?

    I only created the table to make change possible during the salesmoment. It is a 7 field table and makes life easy. The FE is less then 1.8 MB in size. Thx. guys!
  4. Rene vK

    Form Flickering after set recordsource

    Man, forget my post (no-4) I am trying to fit it in.... That is hard to do. the flickering is because of the coloring. Try to toggle the visibility of the subform in the manner I showed, maybe that will help. I know it is not much of an answer, but I try to manage your coding but am not getting...
  5. Rene vK

    Is it a good practice to use "intermediate" tables?

    Is it goodpractice to have a small temp table in your FE or is it better to CREATE TABLE when necessary? My wife sometimes sells a product or two during a consult. The table will be used in a listbox for overview and emptied after the invoice is done or when choosing another client.
  6. Rene vK

    Form Flickering after set recordsource

    I use the call like this: (ClientScreen is the SubForm, ClientInfo is the form in it) SQLstring = "SELECT * FROM Mz_Klanten WHERE KlantNr = '" & Me.kze_Klantnaam & "'" With Me![ClientScreen] If .SourceObject <> "ClientInfo" Then .Visible = False .BorderStyle = 0 .SourceObject = "ClientInfo"...
  7. Rene vK

    How to get name of current field in table?

    As long as we are all pro's..... but we're not! For most of us it is an extra task. We do try to work in the way it should but sometimes you need a path to find a way. If people like it or not, some of us just want it to work. If most of us are pro's we would not try to find answers on a forum...
  8. Rene vK

    ExportWithFormatting with current date in file name

    Stupid idea (maybe?): .xls instead of .xlsx ??
  9. Rene vK

    Can anybody provide me a virtual keyboard code for on screen entry data?

    or https://www.access-programmers.co.uk/forums/threads/trigger-windows-10-on-screen-keyboard-using-vba.290628/
  10. Rene vK

    How to get name of current field in table?

    People, I totally agree on the normalisating an good practice but this guy wants a solution... Let him try and do the good stuff later, he says he is a beginner! Dave, I hope I understand your question and ,my attribution, will help you on your way. Open the form, click the field and see what...
  11. Rene vK

    How to get name of current field in table?

    True but with a Select Case situation he can find the different files. I only try to get him on his way...
  12. Rene vK

    How to get name of current field in table?

    Something Like this? Private Sub PersonsName_Click() Debug.Print PersonsName.Value dim NameToFind as string NameToFind = "P:\" & PersonsName.Value & "\Driving Licence\" & fileName If Len(Dir(NameToFind)) = 0 Then Msgbox "This file does NOT exist." Else Msgbox "This file does exist." End...
  13. Rene vK

    How to get name of current field in table?

    you can make a _Click on your fieldname and start a function, create a string and try to find the file with Dir$ Sorry, this tablet is not very sufficient to browse my own code in Access. To be clear: in my dbase I have a form which I click with the mouse. I catch one of the fields in that record.
  14. Rene vK

    Hi, I'm Theo

    Welkom Theo.
  15. Rene vK

    Access VBA Conditional Loop

    Mickel, I am trying to see your sequence..., 1. you open a form with your recordset 2. you scan the emailadresses in your records 3. if wrong you check the record to be excluded. 4. you start the loop for sending the emails If I am correct, you can run through your records and create a new...
Top Bottom