Search results

*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?

Hi! I would like to enter data in table1 using a combobox as input source. The combo box gets its options (to choose from) from table2. I've tried setting the combobox record source to table2.xx and its contol source to table1.yy. However this only results in me being able to scroll through...

Thanks for your answer! The were set to dynaset. I believe the problem was that I had a field in the form from a table that related to the main table through two non-primary keys. When I made the field a primary key in on of the tables it worked.

Hi! I've made a form related to a table. I want to be able to display and edit records in the table from my form. My problem is that I can only view data, not edit or add anyything. When I look at the form properties I see that: Allow additions = yes Allow Edits = Yes What am I doing wrong?

Thx! I'll look into it :)

That helped, thanks! To be honest I don't quite understand the purpose of the & and citations. Is there anywhere I can read about it?