Recent content by leifoet

Display drop down list in browser Microsoft Edge : Record 1 appears good IN the drop down list selection bar and is selectable But all other records (1, 2 , 3 ...) appear BELOW the selection bar and are not selectable Record 2 Record 3 ... Same program : NO problem in browser Google Chrome...

No change in drop down menu - selection still not possible. Thanks for tips.

Using ASP Classic application code on Windows server. Problem: A drop-down list field filled with records from an Access database and with the following code <select NAME="ActId" style="font-size: 12px;width:600px;"> <% rs.MoveFirst Do While Not rs.EOF %> <%If rs("var_datedif")<0 Then...

Until now I also used the following specific CDO-code for this sending. myMail.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/sendusing")=2 'Name or IP of remote SMTP server myMail.Configuration.Fields.Item _...

I need "RCDet" further in the queries. Just for the sake of completeness: the entire query has been running well for about three years. the only disadvantage that I would like to finally solve is the insertion of a date filter (so the code only after 'WHERE ...) I hope a solution comes from...

dhoocom : I applied your recommendations => the results below. Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Datum between #01/01/2023# and #09/30/2023# AS RCDet'. Microsoft OLE DB...

Thanks for the 'bracket solution', especially Dgillz. I confess Andrejek : 'bad design'. How can I allocate annually with as little (re)programming work as possible? Thanks again to everyone.

SQL="SELECT Datum, Number, Action, BInVKP, BUitAKP FROM journal WHERE Datum between 'DD-MM-YYYY' and 'DD-MM-YYYY'" &_ "UNION ALL SELECT Datum, Number, Action, BInVKP, BUitAKP, FROM bnkbk WHERE Datum between ''DD-MM-YYYY' and 'DD-MM-YYYY'' AS RCDet ORDER BY Datum ASC" Filtering the date field...

Thank you SkipVought for your response. "ORDER BY 2023_TafelUni.Tafels, 2023_SV999_od.Clb, 2023_SV999_od.name ASC" After this "ORDER" adjustment I still get the same error message. I don't understand why this is a syntax problem. Where else can I search? Thanks for tips.

Errormessage : Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression '2023_TafelUni.Tafels'. sql = "SELECT 2023_SV999_od.*, 2023_TafelUni.Tafels, "&_ "(Select Sum(Number) FROM 2023_SV999_od) AS TotNumber, "&_...

An (existing) form offers the possibility via <option> to change data (presence or absence) of one person - the result is updated to the database via <input>. This works. => My intention is now to have a (fixed) number of people (from the database) go through the above form and then update the...

A table is run through with a 'do while'. Elements of that table are subject to changes that are always entered via an input. Method do while.. display element 1 => input (possible changes) only then display element 2 => input (possible changes) only then display element 3 => input...

How can I check with asp classic code if a datatable is empty (= 0 records) ? Thanks for tips.

In the meantime I tried this code: <a href='<%application("adresslink")%>'>ABCDE</a> ABCDE is now shown as a link, but this link (ABCDE) is not responding (yet). Tips for a solution? Searched further and solved with this code. <a href='<%=application("adresslink")%>'>ABCDE</a> Sorry for...

application("addressLink") is created in a subprogram (ASP) and contains the following existing (variable) address : report/221.pdf (or report/222.pdf ...) In the main program (ASP) <a href="application("addresslink")">ABCDE</a> shows the contents of the address link : report/221.pdf and not...