Search results

Yes, i did actually.. Printed it out, going through them as we speak. Cheers!

ok, the problem in one sentence: I cant enter any data. Unless i either take tblopv out of the query, or change the relation between the tables. Wups thats 2 sentences :D

Allright: Ill try to clarify it for you. The lab gets 9 samples. They will number each sample by using a form which is based on the table Labgegevens. Each sample number will also get a monsternr which is a autonumbering field. The next step is to determine the watercontent of each sample...

Ok, Ive changed the Massa field to a Number data type. I checked the relations between the tables (as in the screenshot attached in the previous post) I also ran a quick check through all the other tables to see if there were any data types that needed to be changed. But when i fire up...

Thanks, ill have look.

To clear things up a bit i'd like to attach two image files. Works is an image of the designview of the query, where the query works, but doesnt have the end result that i would like. Worksnot is an image of the designview of the query, where the query just locks up.

Here it is.. Ive stripped it down to just tables and 2 queries. Querystabilisatieinvoer is the one that is not working correctly. What i wanted to achieve is that all the monsternr's made in table labgegevens will be displayed in the table stabilisatiecilinders. But if i change the join...

Good Morning / Afternoon, Ive got the following query: SELECT labgegevens.monsternr, tblstabilisatiecilinders.*, (([massaschlmonnat]-[massa3])/([massa3]-[massaschl]))*100 AS watergeh, (([massa]/(100+[watergeh]))*100000)/[opvinh] AS drgdchthd, tblstabilisatiecilinders.opvnr, tblopv.opvgew...

Aah i figured it out. And it was easier than i thought. I simply used: IIF(avgd7="";avgd28;avgd7) DOH ! Thanks though :)

Good Morning everyone, I am currently working on a database to determine the compression strength of a sample. The main idea is to have 6 samples in total. (3 sets of 2) Each set has its own mixture content, moisture content and Dry density. That data is used to calculate the compression...

First of all, thanks for your example. It helped me a lot. [Edit] : Problem solved.

I ended up doing just that. Just made all the forms. Now i need to make a form with a search function. Cheers for your help!

Its not really a rapid development process i want, its more that i want to be able to do as much in one form, and not having to change forms. But then again, if it cuts back on the funtionality of the application, then obviously its better to make seperate forms after all. I am just doing a...

Thats what i thought.. thanks for the confirmation :)

Good Morning, I was wondering if it was possible to let the user select a table, in which he/she need to add or edit a record. The reason is as follows: I am making a database to determine the relationship between Regulatory Requirements and Standards used in our branche sector...

Yay it worked.. Thanks m8 !

Access ofcourse. There are no queries in Excel ;) test: IIf([Drukdatumd7]="";"";[d7]) Only works when Drukdatumd7= empty. If i enter a date, i get #error as result.

Good morning, Ive got a small "problem". Ive got 2 values. D7 and D28. And i want to filter it by using a date/time field. Both D7 as D28 have their own date/time field, and i would like to filter it like this: D7 Iff (Date/time field D7 = "";"";D7) Same with D28: Iff (Date/time...

the checkboxes are called chk1 and chk 2 The global variables are called Checkbox1 and Checkbox2 The fieldname (in query) is called Rondd7. The whole idea is to make Rondd7 invisible. But when checkbox1 = True then Rondd7.Visible. On the form i used the same concept. On the open event...

Aah ya ofcourse, The thing i cant get to work (for some reason) is making a value unvisible on the report. Not through VBA at least. It sais it cant find the method or dataset. Example If checkbox1 = true then me.rondd7.Visible = True ^ .. .. .. .. .. .. .. .. .. .. .. .. ..^ Global...