Search results

Sorry, I didn;t make myself clear. I meant I have 10 Textbox on the form. I have set the TabIndex value for each one in the sequence. from 0 to 9. I hope the system can automatically switch curser from one textbox to another after I fill one textbox. So in this case, we don;t need to use...

Thanks for you guys.. scouser's solution seems to require some manual work on setting the code in each TextBox event, but the most essential solution :) If no other choice, I will stick with this one. I will try to see if I can play around with Bleslie88's one, which may avoid some duplicated...

Access a control in certain form in Access: [Forms]![FormName].ControlName For accessing property of certain form [Forms]![FormName].FormpropertyName

On the Form, I get several Textboxes for users to input the value following the sequence. I set the 'TabIndex' value for each TextBox (from 0 to 10). Is there any chance the system can automatically move the curser (focus) from one Textbox to the next after setting the value? So without using...

set the validation codes in the BeforeUpdated event. within those code, using Me!TextBoxName.Undo It will highlight the content of TextBox. or you just don't use Undo function, which the cursor will set back to that TextBox automatically

Just one more comment on the code in the link above: Cancel=True or -1 will be required when you set those codes in the events like BeforeUpdated() Cancel (as Integer) is the argument of that event

Thanks for your reply. I just notice (Me.TextBox.Undo) function can help me highlight the whole TextBox. P.S. I just came across a DLookup() function. It can also be used to validate the entry value , which is based on the existing data in the Table. Hope this can give some help to whoever...

[Forms]!SearchForm.SetFocus Can this help you sort the problem out?

You should filter the datasource of that Form. In the property of the Form, in the 'Data' Tab, it gets a 'Filter' section. You can set your filter the datasource of the Form by using the criteria on ID field. Hope this can help

Thanks :) Quote From MSDN.microsoft: ======================= The BeforeUpdate event occurs before changed data in a control or record is updated. Private Sub object_BeforeUpdate(Cancel As Integer) Object The name of a form or a control. Cancel The setting determines if the...

Referring to the previous post 'Textbox Validation' issue, I met a problem on set the focus back to the TextBox. I used the 'OnLostFocus()' event on the Textbox to validate the entry. After that, I want to set the focus back the Textbox, which allows the user to correct their entry. But the...

Referring to Meltdown post, I find you some more detailed infor as the following: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac11/html/acproRecordsetClone.asp Sign the RecordsetClone's Bookmark to Form's Bookmark

May not the good solution, but I did similar thing before described as the following: I still use the automatic number, I use a variable to store the value (lastvalue+1) separately without creating new record into the table. After confirmation with other information, then I create the record...

Thanks for the information. I've been looking at that post. The last paragraph which mentions how to keep the Parent combox react to any changes in child combox will be vital in this case. in Parent Combox AfterUpdate event typing code: Me.cboChild.Requery.

Hi guys, Thanks for your help. Due to all your description, it seems two things will be the key issues in this case: 1) Isnumeric() function helps us validate the input value 2) Use the right event to call that Isnumeric () function. Many Thanks. :)

Oh..... Could you please give me a quick indication on using validation rule if convenience? Thanks

I created a TextBox in the Form, which supposes to only take general number value. In the properties box of textbox, I set the Format property (in Format Tab) to general number. This did help me validate the value I input with the system warning message pop-up box if data type doens't match...

Thanks :D I found some relevant previous posts. I gonna have a look. Many thanks

I've used 'Tools->Security->User and Group Account' wizard to create several users for access my MS-database. Is there any chance that I can retrieve those information (logging username etc) through VBA code? I try to use those security information to create a logging file (maybe saved into a...