Search results

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

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

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

Hi I need to know how to set a rule to a password field that the user only be able to type english letters and numbers . Any idea how? Thanks

How to stop access from saving the record Hi I need to know how to stop access from saving the record when the subform query is on focus? Thanks

Hi I Have a main form and a subform query and I use subtotals calulations in the subform query. In the main form I have some fields that assigned to the subtotals calculation of the subform query. I also did a code that change the forecolor of the values in the main form if thier values exceed...

Hi 1. I need to know how to update the field list of the query after adding a new field into the table and the query? 2. I need to know how to update the records table after adding calculated filed?

Hi I need to know how to stop acces from update the record when the subform query is on focus? Thanks

Hi I need to define this query: I have 2 unbounded fields : ShowMonth and ShowYear (Each field represent the month and the year of Date field) And UserName field I need to define query that shows the dates and the UserName accordding to ShowMonth,ShowYear and UserName field (Without SQL)...

Hi I need to know how to increment the autonumber (Record Number) after that some fields were filled? Thanks

Hi I need to define this query: I have 2 unbounded fields : ShowMonth and ShowYear (Each field represent the month and the year of Date field) And UserName field I need to define query that shows the dates and the UserName accordding to ShowMonth,ShowYear and UserName field (Without SQL). I...

Hi I am trying to count records from underlying query with unbounded fields in the criteria and I get of course type mismatch. [c] = DCount("[Dat]", "PTable", "[ShowMonth] = '" & Me.ShowMonth & "'" And "[ShowYear] = ' " & Me.ShowYear & " '" And [ENT] <> 0 And [EXT] <> 0) When ShowMonth and...

Hi I need to know how to print all the Form (Like a print screen way)? Thanks