Recent content by asu81

*bump........

Hi! I've got a project database which I want to be able to present in a nice way. In one table I've got the fields: project no resourceNo (person working in the project) documentA-progress ducumentB-progress documentC-progress etc.. Each project may have many persons working in it with...

I'll try that, thx!

Hi! How do I hide records in a report based on a critera, for example textfield value? I saw a version of this somewhere and applied it to my db: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Resursnr = "UL" Then Cancel = True End If End Sub But nothing...

That did the trick, thx!

Hi! I've got a report with a bunch of fields. One field contains a hyperlink and the text is usually quite long. Currently access wraps the field around the text and this resuls in alot of rows in each record. How do I disable text wrapping in a particular field? Thanks

I've got a project database where each project is a record. These projects have many parts (fields) that may be in different stages (A1, B2 etc). I want a field that calculates the least progressed stage in each project (record).

Thanks for your answer! I want an expression that calculates the minumum of a and b. In your example the result would be 1 2 3 4 5 I'm aware that it's possible to achieve this with nested IIF() expressions, but wouldn't a simple min() function been easier? If the MIN keyword is restricted...

Hi! It's possible to calculate fieldA*fieldB in a new query field. It's also possible to compare these fields with IIF(). But why is it not possible to calculate the min/max of a set of fields by using a similar min() expression? Thx

Thanks alot both of you! :D

Hi, I have a form (form2) based on fields in a couple of tables. Prior to opening the form I want to be able to filter based on EmployeeNo, ProjectNo or both. I use form1 to select the filter parameters with combo boxes and when I press OK it opens form2. In form2 I have an onLoad event...

Hi! I would like the "cells" in my report to change format (bold/color etc) according to the value of a checkbox in a query. The query is the same query that the report is based on. I've tried making a formatting rule on the field under "conditional formatting". The problem is that when I open...

Hi! I've got a report with alot of fields. 1) Would it be possible to include/disclude certain fields in the report based on some conditional (checkbox for example)? 2) Let's say it's possible to disclude say.. field no 5 from the report (counted from left side). Would it then be possible to...

Ok thanks for the warning! When I tried a second time it worked :) The first time I used the expression builder to set the control source to =[table1]![yy] That resulted in me being able to see the dropdown list but not pick a value. the second time I used the dropdown list to just pick...

Thanks, it contained some info I didnt know. It did however not specify how to transfer the chosen info on the combo to the input table, which was my problem :) But I realised the probable solution is to make the table field a lookup field type, am I right?