Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. leifoet

    Code does not run in Microsoft Edge - it does in Google Chrome

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

    Code does not run in Microsoft Edge - it does in Google Chrome

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

    Code does not run in Microsoft Edge - it does in Google Chrome

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

    How to send HTML emails with ASP classic?

    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 _...
  5. leifoet

    How te filter by date ?

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

    How te filter by date ?

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

    Error in Select query

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

    How te filter by date ?

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

    Error in Select query

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

    Error in Select query

    ...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, "&_ "(Select sum(Amount) FROM 2023_SV999_od) AS TotAmount, "&_...
  11. leifoet

    How can I update the input of a form (rows and columns) to the database in one query ?

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

    First execute an input command and only then proceed with displaying the next record of the table

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

    How to check if a datatable is empty ?

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

    Wrong code in a href ?

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

    Wrong code in a href ?

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

    How to store decimal numbers in an Access database?

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

    How to store decimal numbers in an Access database?

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

    How to store decimal numbers in an Access database?

    @ 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...
  19. leifoet

    How to store decimal numbers in an Access database?

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

    How to store decimal numbers in an Access database?

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

Part and Inventory Search

Back
Top