Search results for query: *

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

Cheered too early - still a problem popped up presumably in this line of code <INPUT TYPE="number" step="0.01" max="9999.99" value="<%=rs("amount")%>" NAME="amount"> At the start of the application, 'value' always shows the already saved amount from the Access database in the input box...

I have tried to solve the problem of the decimal separation factor (point or comma) as follows : of each input (XYZ) the decimal point is replaced by a decimal comma with the 'replace' function before storage. As a result, all amounts are now stored in the Access database as 1234.56 regardless...

@ strongm When typing a decimal directly into my Access database, there is indeed a different result depending on the separator used : "," versus "." typing 1234,56 gives 1234,56 but typing 1234.56 gives 123 456.00 in the table - Sorry Andrzejek previously overlooked this distinction. When...

Yes, I have tested strongm's suggestion separately, but with no improvement in results => 123 456.00 By the way, this suggestion was already included in your code anyway.

My normal procedure is always the same (also in these messages): via the html code <Input type="number" ...>" in my program, I enter the amount XYZ, for example 1234.56 ... with the known storage result in the Access table Ch22 : 123 456.00 ;-( On the other hand, if I type 1234,56 directly into...

Andrzjek, I tested/used your code (cfr. above) - with the following (initial) settings for the Access field XYZ : -Filed size : double precision -Format : general -Decimal Places : 2 -Input Mask : (none) Whatever I input, for example 1234.56 or 1234.56, the storage always remains 123 456.00...

Andrzejek : tried other field settings e.g. decimal - no solution to the decimal problem dhookom : sorry, I misunderstood your question. Update query : 'record number to be updated strSQL = "SELECT * FROM Ch22 WHERE Nr=" & lngRecordNo rsUpdateEntry.CursorType = 2 rsUpdateEntry.LockType = 3...

@dhookom : an update query is required to save the changed fields in the database - strings and integers are saved with this without any problems But maybe the problem is in the wrong declaration @Andrzejek : can you help me with the correct declaration of the field of the table in which the...