Search results for query: *

Hi SBerthold You are right. It had to do the type of the cursor I was using. As soon as I changed it to adopenKeySet it worked. I wish I could use I stored procedure, but I am currently using an access database as backend. Thank you very much for your help

Hi dpaulson I am getting a run-time error Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. Parygoal

Hi BobRodes I did call it again after I call the update methods. It still does not work. I have no idea? ParyGoal

...Dim rsNewHECP As New Recordset Dim strNewHECPKey As String cnNewHECP.Open AppConnectionString rsNewHECP.Open "SELECT * FROM tblHECP WHERE 1=0", cnNewHECP, adOpenStatic, adLockOptimistic With rsNewHECP .AddNew .Fields("CreateDate") = Now...

I am actually using an Access Database. Is there a way to accomplish the same thing using an access database. I know that you can't create trigers on an access table. But is there another way? Thank you ParyGoal

Hi mrdenny Thank you for your reply. I agree with you on the fact that I need to store the info in the database. I already have a table set up with the required fields: RefNumber Number CreateDate Date CreatedByID Number FK LastAuditDate Date LastAuditedByID Number FK LastRevisionDate Date...

Hello everyone I have been looking all over the internet for an example that may help me with what I am trying to accomplish. I have a visual basic form that contain several tabs. Each tab is bound to a child table. The is a parent child relationship. The main form has a grid that keeps truck...

Hello everyone Can anyone see a problem with the following insert statement? I am getting an error message that says "Syntax error in insert statement" strSQL = "INSERT INTO tblAuthorizedGroupsDetails (HECPID, Group ) " strSQL = strSQL & "VALUES(" strSQL = strSQL & "'" &...

Hello everyone. I am hoping someone would help me with what I am trying to accomplish. I have a tab control on a visual basic 6 form. Each tab contains a datagrid, Total ( 8 Datagrids) On the first tab, I select equipment numbers from a combo box that get populated into the DataGrid. What I...

Thank you George very much for your help. It did the trick. Tarik

Hi George Very good questions. I am using an access database. Error message Microsoft ODBC Microsoft Access Driver Syntax error in Update Statment Err # -2147217900 Resulting TmpString UPDATE tblUserGroups SET FirstName = 'Sam', LastName = 'Samula', UserFullName = 'Sam Samula', MidInit =...

Hello everyone I am getting a syntax error in the sql statment while updating the database. I can't seem to find an error. Below is the update statement I am using TmpString = "" TmpString = "UPDATE tblUserGroups " TmpString = TmpString & " SET FirstName = '" &...

Hi Golom Carried over to the other DataGrids means that same values I selected from a combo box to populates the first DataGrid also populate the other DataGrids. There are a total of two columns. EquipmentNumber and its Description. So if I select 4 equipments, I want those same equipments...

SBerthold I just posted a a new thread before seen this one. I am trying to accomplish the same thing. I have multiple DataGrids which have a one to many relationship with the Main Grid. The other Grids are in tabs on the same form of course. While editing records in those Child Grids, I wish...

Hello everyone Can you anyone tell me if it is possible to display a combo box in a column inside either a DataGrid or MSFlexGrid? Ideally the combo box would display the values from a look up tables so that user can simply select a value from the list instead of typing while editing records...

Thank you both SBerthold and TedSmith for your responses. Unfortunately I can't see a better a way to handle the user interface requirements. Maybe I should use a flexgrid instead? I am trying to add records to a DataGrid from two different combo boxes. I am able to do with one combo box, but...

Hello Everyone. This is what I am trying to accomplish. I am hoping some one could direct me to an example that uses the same concept. I have tabbed form built in visual basic form. Each tab contais information regarding a child table (Detail Info). I have a total of 8 tabbs. Thus 8 child...

Hello Everyone. This is what I am trying to accomplish. I am hoping some one could direct me to an example that uses the same concept. I have tabbed form built in visual basic form. Each tab contais information regarding a child table (Detail Info). I have a total of 8 tabbs. Thus 8 child...

Thank you HughLerwill for your response. It makes sense to me now. Thank you ParyGoal

I have a question regarding the best and most effective way of storing database field. I have several fields that are going to store decimal values with a max scale of 3. I know that fields such as decimal and memo use a lot of space. Should I define those fields are text and save them from...