Search results

  1. O

    Update a specific field in a specific record in another table

    Hi I have a table ("Vare") which contains products and stock. When I make an order in my order module ("Lagersystem") i would like to update the field "Antalpålager" in the table "Vare". The information comes from "Form_Lagersystem.Antal" which I want to use to subtract from "Vare.Antalpålager"...
    • Ole
    • Thread
    • Replies: 6
    • Forum: Queries
  2. O

    Solved Filter on Date

    Hi I try to open a report using a filter. I manage to set the filter correct (DRDate=28-02-2022), but the report won't show me any data. It's blank. If you're wondering - it's in Danish. DRDato has the correct format. I can't get my head around it - need fresh set of eyes on this.
    • Ole
    • Thread
    • Replies: 5
    • Forum: Reports
  3. O

    Display all attached files in a report

    Hi I'm creating a report in which I want to display all attached files for each record. My problem is that the report only display the first file instead of all the files. What am I missing here? /Ole
    • Ole
    • Thread
    • Replies: 3
    • Forum: Reports
  4. O

    Converting Time into a string (text field)

    Hi I'm trying to convert Time (hh:mm) into a text string (hhmm). I'm using 24 hour not AM/PM. It is working fine except when it's before 10 o'clock. When it's 09:15 the text string is 915 instead of 0915. How do I keep the leading 0? OpgaveStart is a Date/Time field (hh:mm) My code is simple...
  5. O

    Pick and email a specific file (.ics) in a directory?

    Hi I've created an .ics file (which is working perfectly) and saved it in C:\iCalender. The file is called "SendToTechiCalendar795" were 795 is referring to an errand number. Since I can't use the same method as when I email .pdf files, I need to make this workaround (save the file first). I...
  6. O

    Avoid new record

    Hi I have a form to witch I import some data. These data need to be update manually also. But I need to avoid to go to a new (and empty) record. I can't really figure out how to make sure that i only can choose records with data in :banghead: Any ideas? Best regards, Ole
    • Ole
    • Thread
    • Replies: 7
    • Forum: Forms
  7. O

    Converting date from yyyy/mm/dd to dd/mm/yyyy

    :banghead:Hi I would like to convert the date format (Swedish) yyyy/mm/dd to (Danish) dd/mm/yyyy. And I need it to be done via programming. The reason is that I need my database to work in both Denmark and Sweden. I will use 2 databases who needs to be synchronised, but we are using different...
    • Ole
    • Thread
    • Replies: 4
    • Forum: Tables
  8. O

    Send an email based on a report, from a specific form

    :banghead:Hi I'm trying to send at report based on a Query from a specific form. Everything is (almost) working fine, except the fact that I can't get a criteria into DoCmd.SendObject method. My code is: ------- Private Sub Kommandoknap212_Click() On Error GoTo MailTilGodkendelse_Err...
    • Ole
    • Thread
    • Replies: 6
    • Forum: Reports
  9. O

    Empty reports

    Hi I've made this code for printing out 4 different reports. The reports are as following: Invoice (Faktura), Specifikations1 (FakturaSpec), problem is that every time I open these repports, I only need "Faktura" and one of the 3 specifications. The remaning 2 are empty. But they will be...
    • Ole
    • Thread
    • Replies: 7
    • Forum: Reports
  10. O

    New user

    Hi My name is Ole and i live in Denmark. I run a small company called Scanlogic - transportation, logistics and distribution. I'm 44 years old and my hobby is programming. I have made a complete system for errand booking, customer registration, invoicing, subcontractor registration (payments in...
Top Bottom