Recent content by Chipcom

Hi I would like to make an event that occurs when the value in the textbox (unbound) is changed. Can you please show me how to do it? Thanks

:confused: Hi I have subform with datasheet view and I need to know how to select record in the subform and to show it in the main form? Thanks

Hi I would like to know how to cause to subform from not being on focus? I would like to know how to shrink and grow subform automatically (If the is a lot of data the subform will grow and if there is a little data the subform will shrink)? Thanks

Hi I am getting error 2105 and I don't know why, Can you please help me with that? The user needs to enter the user name and the password so it inserts into the database. After that a reference number is created. Here is the code: Private Sub Form_BeforeUpdate(Cancel As Integer) On...

:confused: Hi I am getting error 2105 and I don't know why, Can you please help me with that? The user needs to enter the user name and the password so it inserts into the database. After that a reference number is created. Here is the code: Private Sub Form_BeforeUpdate(Cancel As...

Hi I need to know how to avoid from overlapping between times per date when the user is isernt a new data. I thought to use dllookup function but it finds one result but if there is more than one result. Date Ent Ext 1/1/2007 8:00 17:00 1/1/2007 9:00 16:00 1/1/2007 10:00 15:00 In...

How to validate a date field? Hi Can you please show me how to validate a date field? Thanks

Hi I need to know how to mondify the message text of RunTime Error 2113 when the user type invalid value in the date field? Thanks

Hi I am getting Errors: 0,20,91 at the same subroutine What could be the reason for the error? Thanks

Hi I have this error when on: DoCmd.GoToRecord acDataForm, "PaycheckTable", acNewRec Whent I trace with the debugger when the ENTER keyy is pressed event. If I don't use the debugger I don't see any error. This problem occurs when I check a specific checkbox and trying to go to a new record...

Here is the Code Hi Bob THis is the code: When the user Press Enter Access opens a new record so it calls to beforeupdate sub and the same record is already found in the database it give customizes 2105 error and it have to stop calling the Next_Custom_Counter() . The problem is that I don't...

Your code is works But.............. HI Bob Your code is works But.............. If you try to debug the code you will see that line: DoCmd.GoToRecord acDataForm, "Test", acNewRec runs first then it shows the error message and what I need is to stop that line from generates a new record -...

Hi There is a problem , The program is generate the new record and not exits from the sub. I need that when it comes to : DoCmd.GoToRecord acDataForm, "Test", acNewRec so if there is an error in this line it will show the error message and won't run this command but it will exit the sub

Hi I need to Change the error messege to other text. I use command that generates a new record and when I type a duplicate record I get the error : Run-time error '2105': You can't go to the specified record. So I need to change this error text. Can you please show me how? Thanks

Thanks It's works fine