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!

Recent content by Remou

  1. Remou

    SSL Bindings

    Hello Wullie Thank you for your reply. I had the wrong type of cert, it is all sorted now. http://lessthandot.com
  2. Remou

    SSL Bindings

    I am very lost on this topic, so please excuse the beginner questions. I have successfully installed an SLL certificate on the server, and everything is fine for http://site, http://www.site and https://site, however, I cannot get https://www.site to work. I would be very grateful for any...
  3. Remou

    Add pages to google search

    Thank you very much, guitarzan. I will know better next time. http://lessthandot.com
  4. Remou

    Add pages to google search

    I would love to do this, that is, page lists etc, but cannot even find the right search terms, does anyone have any idea? Sorry about the beginners question. http://lessthandot.com
  5. Remou

    Pictures displaying on a Form - Referencing thread702-289543

    Are you using the attachment data type? http://lessthandot.com
  6. Remou

    Update query to replace everything after comma

    Adding WHERE may suit: UPDATE [PRODUCTREGISTER SCP] SET [PRODUCTREGISTER SCP].Manufacturer_Part_Number = Left([PRODUCTREGISTER SCP].[Manufacturer_Part_Number],InStr([manufacturer_part_number],"-")-1) WHERE InStr([manufacturer_part_number],"-") > 0 Or using WHERE with LIKE WHERE...
  7. Remou

    Update query not updateable

    Not ideal, but this may suit: UPDATE calc_Compare SET AcctName = DLookUp("PatName","dbo_rpt_dat_ARDetail","slid = " & calc_Compare.SLID & " AND eid = " & calc_Compare.EncID & " AND aid = " & calc_Compare.AID) WHERE AID=267658 Assuming that all fields are numeric. http://lessthandot.com
  8. Remou

    Having problems loading backstage ribbon

    Just as a matter of interest, when I added your ribbon to a form by setting the ribbon name property manually, your function ran. http://lessthandot.com
  9. Remou

    Print a few records from each table in a Access db

    Some notes. Dim qdf As QueryDef Dim tdf As TableDef Dim db As Database Set db = CurrentDb Set tdf = db.TableDefs("Table1") sSQL = "SELECT * FROM [" & tdf.Name & "]" If DLookup("Name", "MSysObjects", "Name='TempQry'") = Null Then CurrentDb.CreateQueryDef "TempQry", sSQL Else...
  10. Remou

    Create a new field based on values above select rows

    Good. It might be safest to add ORDER BY to the inner query: SELECT t.ID, t.Field1, t.Field2, (SELECT TOP 1 Field2 FROM Imp q WHERE Field1="Record" AND q.ID>t.ID ORDER BY q.ID) AS Expr1 FROM Imp AS t WHERE (((t.Field1)<>"Record")); http://lessthandot.com
  11. Remou

    Create a new field based on values above select rows

    You can try: SELECT t.ID, t.Field1, t.Field2, (SELECT TOP 1 Field2 FROM Imp q WHERE Field1="Record" AND q.ID>t.ID) AS Expr1 FROM Imp AS t WHERE (((t.Field1)<>"Record")); http://lessthandot.com
  12. Remou

    Create a new field based on values above select rows

    Can you re-import allowing Access to add a primary key? http://lessthandot.com
  13. Remou

    Create a new field based on values above select rows

    Do you have a field that contains a unique id? Something that determines the sort order? http://lessthandot.com
  14. Remou

    Exporting date to Excel causes day/month to reverse

    What happens when you use transferspreadsheet? http://lessthandot.com
  15. Remou

    Syntax error in SQL statement?

    What does strQueryName contain? You can set a breakpoint and check, or you can use debug.print, which means you can paste into the query window to see what is wrong. Note the addition of square brackets, it is safer when you do not know the query name. strSQL = "SELECT Count([Employee ID]) AS...
See more

Part and Inventory Search

Back
Top