Search results

Why doesnt this work? =DLookUp("[Masternr]";"Masterinfo";"Masterinfo.Masternr = " & [Masternr]) cant i look up values from other tables in a report? Masternr is both a field in my recordsource, and a filed in the table Masterinfo, which is not in the recordsource. What is wrong here?

hehe. ok ok i'll make a query.

Ah.. smart. Every value in Field B all has the same value in Field C and D. What do i do if i would like to show the Field-B's value in C and D?

Ok, i red as much as i need now to understand what is ment by normalization, and i can say that my database is as normalized as it can be. But the adress-fields could potentially be different for every primary key, that is not likely to be the case, but i have to make the database able to put...

What is the rules of normalisation? I understand that i can put all the values in the controls into one field, but how do i evt. split them? How would you do this? it is just that there is two adresses for every primary key, and it would add another 8-10 fields. I think that would be a bit messy.

Thank you sir

but isn't there an easier way? cant i just write two tables into the recordsource?

I have a query, where i have a Field A that is the primary key. Field B is not primary, I can have, lets say 70 records. Field B can contain only 2-3 different values. What i want to do here is to make a report, where the lines is not every record, but every different value of B and the number...

How can i make two tables my recordsource? what do i write in the recordsource-property? The tables are linked.

Lets say i have variables that i want to be stored after i click buttons. So i cant declare them in the click of the button. I want the variables to excist from the start, and i am able to change them and get value from them when i click buttons. The point is that i dont want to use a table for...

Could i store the adress in one field of the table? and seperate the lines by some sign? are there a way that i can seperate the text by these signs when i want to display it in 4 different controls? if i have name, street and city in 3 different lines. Could i store it like name;street;city ...

I agree with you on that one. I use several controls for it. But in the same database i have a field where i want the user to be able to write a little text, like a comment, with no limitation in length. What is the smartest way to do this? A textbox? i want this comment to be shown in the...

How do i get an adress into a textbox. Lets say i want to write the adress over 4 lines, which is pretty usual, how do i make that happen in a controll? And also in a report.

I dont think thats the case, since i am able to edit in a query, and in that way edit it in the table.

Thats smart. It doesnt trigger until i open it manually. I make tha change, close, and open, and thats when the msgbox displays. Should not requery do this for me?

Should not the current event fire when i requery the form? There is no problem with the test, so isNull should be ok. Its just a problem with firing the visibility while in the form.

Send and sendt is two different controls. This is what i do after i click the button. Me.Send = Null Me.NyStatus = Null Forms!MainSearch!Results.Requery Me.Sendt.Requery Me.Status.Requery Me.Requery Me.Refresh Me.Repaint Forms!MainSearch!Results.Form.Requery Me.Repaint didnt work either. I...

I have two tables that are linked. I have a table with a lot of products that is in a warehouse. Each product has a serialnumber that is unique, and a masternr that is not unique. every product has a masternr. I want a repport that print out how many products of each masternr that is in stock...

Interesting. My case is a bit different. In that case you just set it to visible, in my case it has to check if the controll is Null or not, and then set the visibility according to that. What i've tried is to write this test in current event and then requery the form after the click. Here...

I have a form with a textbox that has visibility = false. When i click a button i want the visibility to change. I have tried allmost everything possible. The visibility doesnt change before i close the form and reopen it. I have the visibility = false if the value in the texbox is Null, and...