Search results

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...

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.

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"...

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...

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

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

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...

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

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...

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.

Welkom Theo.

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...

Maybe you can create your recordset with a SQL query with a WHERE clause. SQLstring = "SELECT * FROM MyTable WHERE EXCLUDE <> 'Yes' "

getnm = Me.Combo47.Column(1)

Found on Microsoft: Combobox; search as you type.

Fastest way is to use a combobox with your field as source. A situation that I use quit often is: a subform showing a table, typing in a textbox rolls-up my table with the result. It works with a sql query.

Maybe a bit improper but, "Did you try to find or create something like a search?" People here try to help, not do your work. You will not learn anything if you don't try to invent stuff yourself. Google or Bing is your biggest friend and off course forums like this one.

Welcome!

Your sum is calculated with figures from your table. Create the expression in the textbox on Report2

Use the dirty way, fill a variable in the report_Close. Declare the variable in a module!