Recent content by wdenboer

Hi Trevor G, No in the table the file location has been stored. But today I noted the first problem with this approach. When using an USB stick for storing the database the path cab change from F:\ to H:\, and than the file locations are wrong. is there a way to make the storage location...

Hello all, For a database project I am looking for some code which enable me to create a report which includes pictures from a query. The query is called; "Query report FST" and the result in the query is a link to a file location. f.e. 'c:\my documents'. The column which should be displayed...

Dear all, At the moment I am working on a program/tool where people can add a comment supported by a picture. The comment is stored in a table and the picture should be stored in a predefined location. After selecting an image (browse button, which I already have), the selected image should...

Hi David, First i like to thank you for the fast reply to my problem. If I understand it correct I should lock all fields on the form. After I click the edit button the locks for certain field will be temporarily removed. With the on current event I should make check whether a field is filled...

Hi All, I am working on a database which will be used for question and answering. Person A raises a question, by filling a form. After finishing his question he will push the save button and the record is saved and the form is emptied and ready for a new question. Person B will answer the...

No result again. I think I will try to change over to coding the criteria in VBA. I might need some help with that, but will come back on that. thanks anyway

If have used this code now: IIf([Forms]![FST_main]![OG_status]=1;"Like '*'";[Forms]![FST_main]![Sel_st])but it still returns nothing when OG_status=1. All other conditions do work as they should. Somehow it seems impossible to get an empty criteria for the TRUE situation.

Is not working. access in not accepting such an expression. It returns that the expression is too complex. Is there an other solution, or different approach. Maybe with VBA? thanks

Hi Ron, It does not work. In this way it uses 0 as a criteria and I need an empty criteria. thanks anyway

Hi KenHigg, Thanks a lot. I couldn't find the statement for an empty query criteria. I thought that only "" would do. But apparently * was needed. I have given it a few tries, but it doesn't work. The filter returns no records at all. But if I put only "*" as a criteria it returns all...

Hi all, I have the following problem. In the expression builder I have some IIf code for a filter criteria. When the value of an option group "OG_status" is equal to 1, there should be no filter applied. If the value of OG_status is unequal to 1 the criteria should be the value in the field...

Tnx DCrake, works fine now. Did try this solution before, but somehow it didn't work at that time. Probably there was a second error in the code. thanks a lot

Hi all, I am working on a part of a database but something is going wrong with my Dlookup function. I have a form called FST_main. On this form is an option group called "OG_status". The selected value in OG_status is used for a Dlookup is a table called "status". On the same form is textbox...

Hi all, I am rather new in the world of access and a search though this website did not give any results. The problem is as follows. background: I have a drop-down box with user names in it coming from a table. In time more user will be working with the database and therefore I added an 'add'...