Search results

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 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...

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 have an unbound form with 3 combo's to look up a record from a table and the record is displayed in a couple of textboxes. I'd like to save the values of the textboxes to a record in another table by clicking a save button. I don't have relational tables.. Does anybody know how to do this? I...

I tried to search this forum but so far no results. If this question was already asked I apologise. In my VB I use the following script. I was wondering if there's a way to make this script shorter

I have a slight problem with my acces DB and I don't know how to solve it. I tried to install the mousehook module and something went wrong the first time, it corrupted my DB file. Fixed the issue but uninstalled the mousehook module. Today I tried to install it again but I get a compile error...

I have a button and I have an invisible field. When I press the button I would like the button to make a combo visible and jump to that same combo On the click event I tried: cbo_method2.Visible = True DoCmd.GoToControl "cbo_method2" But since the combo is not visible when the button...

In my form I have 30 checkboxes named chk1 to chk30, whenever I check one of these checkboxes I would like chk_reject to be checked as well. Is there a way to do this without editing the afterupdate of 30 checkboxes?

Does anybody know if it is possible to let the cursor jump to the first character in a textbox and combobox when you select these controls with the mouse?

I have a single table and a form to filter out and display the correct record. To select a unique record I would have to create 4 cascading combo's which would look like this: cbo_method - cbo_un - cbo_psn - cbo_pg My columns are also named method, un, psn and pg I would like to reduce my form...

Hi all.. I have a form with 3 combo's and so far it works like a charm however I'd like to change 2 things. I'd like to make the selection using my cursor keys. Second I'd like to turn off the autofill on my last combo. This combo only has 4 values which are : III, II, I, N .. Whenever I type...