Search results

Ya i might just split the form/ query in a way that first the user can enter data, and that data will be saved etc... Then i am thinking of making a button to start the calculation (on a second form). Because i really need the query maxtotaal.

Yes, i just noticed it too. When i remove the Maxtotaal from the query, it works fine. Thanks for the info !

Aah ofcourse.. Ill have a look. Ill keep you updated! edit : Turns out, Querymaxttotaal is the problem. Looking further into it.

Youre right. Looks like a non updatable query. The question is, how do i turn it into an updatable query ? :P

Good Morning, I could need some help with the following Query : SELECT queryverdgrdzand1.tbllabgegevens.monsternr, queryverdgrdzand1.tblverdgrdzand.monsternr, queryverdgrdzand1.schaalnr, queryverdgrdzand1.massaschl, queryverdgrdzand1.massaschlmonnat, queryverdgrdzand1.td1...

Good Afternoon, Ive made a form based on the following query SELECT queryverdgrdklei.*, queryproctwtrgeh.dgrdichthdaanwh2o, ([drgdichthdmnstrinsitu]/queryproctwtrgeh.dgrdichthdaanwh2o)*100 AS verdgrdklei FROM queryverdgrdklei LEFT JOIN queryproctwtrgeh ON...

Good Afternoon, A few months ago, i added a function to a database to track changes that are being made using forms. Everything is working great, but i wanted to add some things to that module to see what the possibilities are. Ive got a question about the following code. If Not...

Good Morning, Just wanted to let you know that the link you gave me worked perfect. I made a textbox on the motherform, gave it the value of ProctorID. Then i went to the subform, made a label, and linked it to ProctorID of the mother form. I used that syntax as the criteria of my query...

Oooh thanks m8. That looks promising, ill have a look. Cheers!

Good Afternoon, I am having a problem with a graph thats based on a query. It does not respond to the buttons i made. The idea was: I have ProctorID 1 and 2, and each ProctorID contains data that eventually will be the source for a graph. I made a form with some subforms (tabs), and on...

Good Morning, Ive got a (sub)form with a graph based on the following query : SELECT IIf(IsNull([schaalnr]),[topwtrgeh],(([massaschlmonnat]-[massa3])/([massa3]-[massaschl]))*100) AS watergehproct...

Good Morning, I am in the final stage of creating the database. One of my last things on the list was to check all forms, functions etc.. to see if everything was still working. Ive come across one form that is not responding when i go to the next record. Ive made a form based on a query...

I might have figured it out, at least the merging part.. I made a "add" query, (not sure if that is the right english word), which simply adds the ProctorID and Samplenr of table tblProctor to table2. I am planning to run this query as soon as the user hits the "ok" button on the form to ass...

Good morning peeps, Ive got a question regarding merging 2 tables, using a query. Ive got a tabel : "tblproctor" ,which contains information about tests using the Proctor. The 2 (most important) fields in this table are ProctorID and Sample nr In this table the data looks like this...

Good Afternoon, Ive got a (small) question regarding a table with a Primary Key. Ive got a table named : tblProctor In that table i have several data, but the most important are ProctorID and Samplenr. A form will be used to enter data into this table. The user gets a list of the samples...

Right on. That wont be a problem due to the fact that the database will be used by just one person, in the worst case 2. Anyways, thanks again!

yay it worked Private Sub prctr_AfterUpdate() If prctr = True Then proctor = DMax("proctorid", "tblProctor") + 1 End If End Sub Cheers m8!

will do .. thanks !

Good Afternoon, I have got this form (see attachment for screenshot). The idea is, Theres a list of samples, and the user can select the ones needed to start a test. The user also gets to choose which ProctorID she would like to give the test (right now). But i want to automate that...

Good Morning, Ive been playing with different setups this morning, and i just wanted to keep u updated on this issue. The last thing i tried seems to work so far, well, at least i can add multiple samples to the ProctorID without messing up the Forms/Subforms. This is what ive done so far...