Search results

I figured it out, I tried: text1 = DLookup("[text1]", "Table Language", "[IDlanguage] = 1") And it worked :)

I'm trying to populate a textbox using DLookup. My textbox is called text1. I have a table called Table Language. I'm trying to get the value from the column text1 where IDlanguage = 1 The code I use: text1.Value = DLookup("[text1]", "Table Language", "[IDlanguage] = 1") I keep getting an...

I'm a beginner myself, but shouldn't you use the name of your control instead of the column name? Maybe you can add a print screen so it's more obvious what you're trying to do.. It's also a good idea to use 'else' in this case, what i mean is something like:

I got it to work now using the DLookup function: But I understand DLookup is slow, is there a better way to do this?

Oh yes, apology I see it now.. My form is not bound to any tables..

Tried to use the DLookup function lbl_chk1.Caption = DLookup("DGD", "tblReasons", "reasonID = 1") But must still be doing something wrong? :confused:

Thanks.. :)

I have a form with a couple of checkboxes, the labels of the checkboxes are named lbl_chk1 to lbl_chk10. I have a table that is called tblReasons, this table contains 2 columns: reasonID and DGD. I'd like my checkbox labels to display a value from this table, so I probably needs something like...

Thanks! ... Will try that tomorrow :D

true, i meant transparant, I'll try the empty conrol..

Thanks, you mean an invisible or empty control with a tabstop in the top of the header?

I have a form that's a bit too large for my monitor (I know, bad practise).. Whenever I tab through my controls it doesn't show the header anymore. Because of this a warning message in the header is not visible anymore. Is it possible to give a page up command with VB in the onfocus property...

I learned a bit more and your help was very much appreciated :)

Thanks :D Maybe it's just my form, I tried to bind it before and after closing the application it was no longer possible to access the data in the database. The data was there in the table but just not accessible through my form. That's when I decided to unbound it again.. Anyway, I got it...

I got it to work, thanks for the sample! I Finally finished my form and would like to thank everyone for their help, I doubt I would have been able to finish it without the people on this forum :D *thumbs up*

I get a runtime error '3251'. Operation is not supported for this type of object. I'm puzzled :(

Didn't work either, changed the date and time fields as well. My form is not bound, could that be the problem?

Thanks.. That's good to know, will change the date in a bit, I assume same counts for my time field then? Haven't tried either yet but I will in a bit.. Thanks..

Many many thanks, I'm very happy now.. I figured out the DLookup method but without succes as it's not a unique value.. Ah well, I'm learning (slowly) so it's all usefull. I will certainly try this method this evening and let you know if it works :) It's the very last thing I have to do to my...

Thanks and yes, awb is a text field.. Unfortunately the date doesn't show in the txt_warning textbox though, probably because the awb field is not unique? Is there a way to go around this? Don't necesarily need the date, would also be happy with a default message this number is already in the...