Search results

I am really thankful to all of you.. The problem is solved

I tried setting both properties and I am still having same issues. I just used frame for presentation puprose without undestanding its implication. The should rather use Labels...

Please find attached DB. The Fame object is called Frame163. Thanks

Issue I am using frame for presentation purpose in the form. The frame is in the background and all the text boxes and labels are populated on top of it. When ever I click on the empty portion of the frame, all labels disappears. All I see is values in the text boxes. I think I need to disable...

Just curious... If I bind text box or combo box control to any control source, I have use that in my code? Thanks in advance

Thanks a lot. It is working now...

Here is my Table and Form..

I tried ur code with slight change as I got data type mismatch Error. Me.RecordsetClone.FindFirst "str([Employee_Id]) = '" & Str(Me.Employee_ID_Text) & "'" If Not Me.RecordsetClone.NoMatch Then MsgBox Me.RecordsetClone.Bookmark Me.Bookmark = Me.RecordsetClone.Bookmark Else MsgBox...

I am using DAO. Dim Rstest As DAO.Recordset I tried printing values for Me.Recordset = ? and Rstest.Recordset = blank (Null)

I am getting this error and somehow I can’t figure out what is wrong. All I am trying to do is select Employee_ID (Primary Key) from combo box (Employee_ID_Text). If employee id is found load the employee information. Error Message: Runtime Error: 3022” Changes to you requested to the were...

Here We go... Private Function Load_New_Employee_Data() Dim SSQL As String Dim Employee_ID As String Dim db As Database Dim rs As Recordset Employee_ID = Employee_ID_Text SSQL = "Select Employee_Last_Name, Employee_First_Name, Resource_Type, Employee_Title, Home_Office_City," SSQL = SSQL & "...

Hi All, Do any one know how to load new record dynamically in the form from table rather then going sequentially? I have Employee Info Form, it shows all relevant information for given Employee. (See attached Form image). Now when I manually enter another valid employee ID, Before_Update...

I am getting following error “You can’t go to specified record” I am validating Employee ID entered in textbox Employee_ID_Text. If I find Employee ID in the table, I load all relevant employee information in Form, to do so I call “Load_New_Employee_data” function. It works fine, but some how...

check this link http://forums.aspfree.com/t31575/s.html Its working by adding If Me.Dirty Then DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 End If I don't understand what it is doing....but its working

I did change my code and made sure all variables/database/Recordsets are defined before they are used.... still getting the same error....

Microsoft DAO 3.6 Library was not selected.... Moving forward.............

Dim rs As Recordset Dim db As Database Give Error : User Defined type not defined.... Any clue? I even Tried Dim rs As DAO.Recordset Dim db As DAO.Database

Not Working.... I am getting error on this line Set db = CurrentDb() Error Message : "Variable not defined"

Here is the Code Public Function Project_Status_Tracking() As Boolean Dim Assigned_Project_Status As String Dim DB_Project_Status As String Dim SSQL As String Dim SSQL1 As String Dim Project_ID As Integer Dim RecordCount1 As Integer Dim RecordCount2 As Integer Project_ID = Oppt_ID_Text...

Hi All, I am getting this Error " The Command or Action 'SaveRecord' isn't available now" I am using one of those Ready Made Save Button (Drag and Drop button) that Access Provides. I made small change to "Save Button" Code to call two functions for data validation before saving the current...