Recent content by crujazz

Hello everyone, I'm building an application at work and i'm wondering if there's a module for creating an UI or an UI like MS Outlook. Can someone point me in the right direction? Thnx for your support

thnx, i'll give it a try....:D The purpose of this all is that i have an excel sheet with tons of data based on date. What i want is to import that excelsheet and let access calculate, but it ain't that easy cause each date has a value what decrease. For example: date L R 07-07-09...

query is based on simple table: id, name, date in query3 the following argument: SELECT gdt() AS Expr1 FROM Test; based on Function GDT() As String Dim db As Database, Lrs As DAO.Recordset, LSQL As String, LT As String Set db = CurrentDb() LSQL = "select date from Test where date =" & Date Set...

Hearby my calling query: SELECT gdt() AS Expr1 FROM Test;

Hi folks, by using this code i'll get in my query the answer 4 times....:confused: what am i doing wrong? Function GDT() As String Dim db As Database, Lrs As DAO.Recordset, LSQL As String, LT As String Set db = CurrentDb() Set Lrs = db.OpenRecordset(LSQL, dbOpenDynaset) LSQL = "select...

Well let me start with the fact that i was trying to use recordselect but i ran into the problem that the date field is basicly leading in all todays date has a different value than yesterdays date and the value is neagtive if i follow the rules of counting Take a look at my attachment (its...

Oke, i get your point but do u use a dloopup function for each date field or is it easier to dim an array and if so how to cause in my ex i picked just one record of 1200.....:cool: Forgive me but i used to use access but it has been several years ago...

Goodday all, I used to create sheets with excel but now i want to transfer everything to access. This is my problem: a table with: column Date (D) column Pressure Left (PL) column Pressure Right (PR) for example: D1 06-jul-09 PL1 250 PR1 0 D2 07-jul-09 PL2 221 PR2 0 In excel i can...

Hello everyone, I have a table named tblGases, with a primairy-key and a 2 textfields. What i like to do is to let the primairy-key appears in the first textfield. Example: idGasID (Autonumber) txtGas (Text) (Default Value: "A-") txtLocation (Text) idGasID = 1......999 txtGas should...

Hello everyone, I have a table named tblGases, with a primairy-key and a 2 textfields. What i like to do is to let the primairy-key appears in the first textfield. Example: idGasID (Autonumber) txtGas (Text) (Default Value: "A-") txtLocation (Text) idGasID = 1......999 txtGas should...

Dear Col, I named my first column dtmDatum u are not picky..the flow is calculated from the right pressure for instance last friday Pressure right was indeed 188 en today 170, the weekend the systems continues with the process but i don't collect the values until mondy morning Regarding the...

Hello everybody, I'm new here. I do have a little problem calculating in a query. I have a query with 4 coloms (colom 1 = Date, 2= Pressure Left, 3= Pressure Right, 4=Flow). Each day i enter the date, and the pressure. I want to calculate the Flow. Example 12-06-09 Left= 300, Right =...