Search results

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

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

:eek: So simple :eek: But thanks a lot: It works great.

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

I forgot to change it :) I should do it automatically instead of changing it afterwards: It will be easier to read the code when I need to change something in the future.

This does the trick (blue text is the real code: the rest isn't so interesting) Dim dbs As DAO.Database Set dbs = CurrentDb Dim strSQL As String Dim strSQL3 As String Dim rstTMP As DAO.Recordset Dim rstGRP As DAO.Recordset Dim count0 As Double Dim Nam00, Nam01...

Yes, I tried earlier a 'running sum'-function, that I found on the Internet. I tried it, but did get strange results. So after a while I stopped trying. But my vba-code now works. In a few seconds I have the results in a table. It's a temp-table, so I will empty it after use. It's only to give...

Running sum is no standard for queries, because I searched and searched for a running sum solution (for another database). But I already created a VBA-code that does the trick. In the 'locals-windows' I can see the correct data (when I halt before looping) My only problem now is to write the...

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

I think you are right. The problem was I tried to create a delete-query. I wanted to delete data from another table, based on this query. But this wasn't possible. I thought it had something to do with not being updateable of the data. But I now think the problem is that I try to delete data...

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

The database is a lot more complicated. I have a table 'customer' A table 'product' A table 'product-family' A table 'prices' And another few tables, that are less important, mostly some workarounds for exceptions. It is only a database for pricelists. So changing a pricelist, printing a...

Different volumes -> different prices. A big customer can negotiate better prices. The reason I created the database was that the current way of working is that 1 person manually writes new prices on a paper. The second types that prices in a word-document (sended to customers), the third...

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

My dbase in normalized. But the excel-format above is the most easy way for the person to change the values. Changing the values will be done manually, so the excel-file should be as easy as possible. Because otherwise the changing-part will take to much time. So I need a way to automatically...

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