Search results

I have been playing around with a way of having an employee select their start or finish time from a combobox that references the current time and shows time options in 15 minute incriments. The nearest thing I have found is the ActiveX LANDesk Time Control. It displays what I need but I can...

whoops ...and of course the first line should read... If KeyAscii > 31 And KeyAscii < 48 Then KeyAscii = 0 to actually trap the space bar entry.

Thanks Linq. The key point I got from your reply was "the Text property holds the value of the textbox before it is saved". That totally relieved my stress. I used this point and came up with a fairly elegant solution that traps on key entry so I was even able to detect for non number entry...

I have a text box in which I wish to restrict the characters to be typed (no spaces) and set the length to a 10. I have placed a simple statement in the "On Key Press" to restrict the spaces "If KeyAscii = 32 Then KeyAscii = 0" and this works great. The issue I am facing is that the...

Thanks Linq. I was trying to use this format earlier but with no success - was attempting to apply it to the On Enter event only. I note that you are using both SelStart and SelLength. I am now using both to see if there is already data in the textbox and selecting the entire field if there...

Hi guys, I have a text box with a simple input mask to force numbers only. My problem is that I want to be able to click in the box and have the cursor always go to the beginning of the mask on initial entry - not directly under the mouse pointer. Is this possible? Thanks.

Combo box binding I tried that however the box still initially appears blank. When you click the drop down the first entry says "select one of the following". A bit late then... Probably the only solution is to make the field label speak the obvious "Select one of the following". Thanks for...

Combo Box Binding The combo box is set to only display column 1 however column 2 is needed to be displayed in a text box. As an example... column1 Column2 Xmas Santas little helpers are coming Easter The bunny is bringing eggs Sunday All busy people should rest The problem...

I have bound the control to the second column of a combo box as it is used to fill a text box. I still want the combo box to have a default value but it will only display if I set the bound column to the first column. Any ideas here?

Still need some help Hi RuralGuy, All is now going according to Hoyle except for one small detail. Re the combo box: I have bound the control to the second column as it is used to fill a text box. I still want the combo box to have a default value but it will only display if I set the bound...

Oops! Whoops... was looking for the hard way as initial requirement was to get the data from an Excel file. Forgot all about the wizards. Thanks for the nudge in the right direction RuralGuy.

Within a database called "FB.mdb" I have two tables, a form and now a combo box problem. The form gets most of its form data from a table called "Vouchers". It also has a two column Combo Box "WordType" which I would like to populate from the other table "CardTypes" which obviously also uses...

A change of heart I have had a change of heart, mind and socks and decided to attempt a read from another two field table within the current project which would serve the same purpose of the Excel data but keep the whole job neater. A two column combo box and a two field table. Should be easy...

I have a two column Combo Box (titled WordType) that I would like to populate from an Excel file (called CardTypes.xls) which obviously also uses two columns (A & B) and a varying number of rows. I have spent hours searching for ways to do this seemingly simple thing but have had little success...

The Dirty Problem Relatively new to this stuff myself however it sounds like you have two fields on seperate forms accessing the same data. Modify one and the other has the wrong data displayed. Why not use unbound fields on the subform and then copy the contents from the main form. When you...