Search results

Good Morning, I am working on a report. The report as a query as a source, and from that query i would like to use the following data: PercentageAsphalt PercentageSand PercantageBrokenStab PercantageCement These fields represent the composition of a sample used in the lab. At this point...

Thanks for the input guys. I got it to work now.. cheers!

Good Morning, Currently i am working on a database which can be use to register incomming samples. Ive made a form, where the user has to enter a serial number, which belongs to the project the sample is from. But a lot of times a project has multipal samples. Which gives me the...

Well it worked like a charm. Thanks bob!

Well, i think im getting somewhere. I made an UPDATE query to update tablename.thrownaway. I guess all theres left for me to do is to make sure the update query runs when checkbox=True, and make sure it does a requery after that. Ill keep you posted.

Good Afternoon, I am working on a (continious) form with checkboxes. The checkboxes are stored in a table. What i want to do, is add a checkbox on the top of the form, and if the user clicks/checks it, then all checkboxes should be checked. The checkbox in the table is called "thrownaway"...

Omg, you are my hero. It worked like a charm.

Good Morning, Ive got a form which is based on data input from our lab. The query looks like this: SELECT queryveldgegevens.tbllabgegevens.proefnummer AS Proefnummer, queryveldgegevens.*, queryveldgegevens.prctrnr, queryveldgegevens.natdchthd, queryveldgegevens.mpdepd...

Update: Ive decided to split the form into 2. 1 will be used to enter the pre-test data, and 1 will be used to enter the actual test data. The query which is the source of the second form, will be : SELECT queryveldgegevens.tbllabgegevens.proefnummer AS Proefnummer...

Good Morning everyone, Ive got a question regarding populating a textbox by looking at the test input (value). Ive made a table which is going to be used by our people in the lab, by entering test data. This can be done by using a form. To keep it short (i try anyways), the field that is...

Well, its basically a ratio of the sample content. A sample consists of a % Asphalt and % sand. Example : 70% Asphalt and 30% sand But if the % Asphalt is 100 %, then the % sand is 0 obviously. And if thats the case, then its no point of having the text + 0 % Sand or + (empty) %...

I got it :D In the Detail_format section(print) i added the following code: If Me.verhoudingzand & "" = "" Then Bijschrift247.Visible = False Else Bijschrift247.Visible = True End If If Me.verhoudingzand & "" = "" Then Bijschrift252.Visible = False Else Bijschrift252.Visible = True End If If...

thanks, but doesnt seem to have any effect.:(

I used both If Me.verhoudingzand Is Empty Then Me.Bijschrift247.Visible = False and Select Case [me.verhoudingzand] Case isNull me.bijschrift247.Visible = false End Select In the open event of the report.

Good Afternoon, I am working on a report, and i was wondering if its possible to hide labels when a vaue of a field isNull or Empty. Ive tried an If statement, and a Select Case statement. But both methods result in not being able to open the report (it closes straight away). The names...

Yes it worked ! thanks m8!

Ya something must have been wrong with the field itself. Because when i removed it from the form and re-added it, it was a dropdownmenu. Which brings me to the following question, the form has an field named "id" which is an autonumbering field. At this point i have a total of 8 id's. (1,2...

Good Morning, Ive come across an old form i made somewhere last year. And it needed an update. I added a field to the table which uses a lookup function, and gets one single value from a seperate table. When i put this field on the form, the value of the field is shown, but the formulas...

cheers. Worked like a charm

Good point. Its jut that, When i first made the database, the user had to enter the Diameter for every sample. (samplenr is an autonumbering field) Which works, but the Diameter is the same for every sample. So if lets say the diameter is 150,7, and i have 10 samples. Then i'd have to...