Search results

  1. Q

    Email from Access - reply from outlook

    I am busy with a database that mails a few documents via email. No problems: The mails are sent inclusive a few attachments. The solution is something proposed in this topic: http://www.access-programmers.co.uk/forums/showthread.php?p=856186 Now my problem: Is is possible to get a kind of reply...
  2. Q

    Strange thing filtering weeknumbers

    Something strange: In my query is a calculated field "Week" (=DatePart("ww",[Datefield]) I want to filter the results. I used the filter "<=20": I get all week 1 to 20. But this filter should be flexible. So I changed the filter to: "<=forms!form1!textfield1". In the textfield1 I again filled...
  3. Q

    Sum of a queryfield in a formfield

    Hopefully a very simple question for you guys, but I don't know how to start. I have a query (let's call it Query1) 3 fields: ID, Date and Amount. In a form I want a field with the sum of Amount, for a choosen ID. (this choosen ID is already somewhere in the form: Textfield 'FormID'). Let call...
  4. Q

    how to do a cumulative count

    I think this is a very simple question, that (I think) is asked a lot before,but I don't know the correct search terms... :confused:. The searchresults I get are to complexed to understand for me (at this moment): I first need to start simple with this. I have recordset that has the following...
  5. Q

    not updateable recordset

    First I really don't know a correct title... I have 3 tables, that should be connected to each other. But something goes wrong with the thirth table. I really don't see what I do wrong. Maybe one of you can help me! Tbl1: ID (autonumber) customer (number, long integer) conn_A (number, long...
  6. Q

    Best ways to update date

    Hello all, I am creating a database with prices per customer per product. Let's say 100 customers, 1000 products, max 10 prices per product. The database is working as I want. But now I do need to find a way to updates prices. This updating needs to be done partly manually, partly...
  7. Q

    import crosstab excel-file

    My first post.. I am not a native english-speaker, so hopefully I can make myself clear. I have the following problem I have a excel-file that will be used to update information in a easy way, so outside Access. It is a kind of a crosstab-format: Product - Client1 - Client2 - Client3 - ... -...
Back
Top Bottom