Search results for query: *

I am trying to access the autonumber primary key of the newly created records through code. The datasourse is an access table. The code was working fine when I used a connectionstring using AppConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\HECP.mdb;Persist...

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

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 = '" &...

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

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

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

Hello I am getting an type Mistmach error every time I try adding a new record by calling a function. I am really clueless THe code break on the calling function with all the parameters. If ADD_ROLLNUMBER_RECORD( _ txtRollNumber.Text, _...

First of all I hope in the right forum. I am trying to design an Access Database that consists of keeping truck of Procedures for handling equipments. Each Equipment has its own procedure. There are 9 sections that need to be filled out for each procedure. Sections are more of details...

First of all I hope in the right forum. I am trying to design an Access Database that consists of keeping truck of Procedures for handling equipments. Each Equipment has its own procedure. There are 9 sections that need to be filled out for each procedure. Sections are more of details...

Can anyone see a problem with this insert statement please? strSQL = "INSERT INTO tblPersonalProgressReport(MngWorkWith,Date, Manager " 'strSQL = strSQL & "MngWorkWith, Date, Manager, " strSQL = strSQL & "Plant, Week, Department, " strSQL = strSQL & "WhatDidyouDo, Safety...

Good Morning Everyone. Can anyone shed some light to this issue I have been facing. I looked at microsoft kb, but with no success. I tried everything, but still no result. I inceased the session time-out in IIS as well as in the webconfig files from 20 minutes to 1440. So basically If you stay...

This is really stupid question to ask, but I am stuck. I am trying to evaluate expression in the form of Xor and operator. If (CheckBoxControl1 Xor CheckBoxControl2) and (CheckBoxControl3 Xor CheckBoxControl4)and etc... then Do this else do that End if My Problem is that I have many...

Hello everyone. I have multiple nested forms within an unbound main form. I have an unbound combo box from which user selects a name, and all the information associated with that name is displayed on all subforms. All I am trying to do is when I select a name from a combo box I want to capture...

Hello everyone. I have a Main Form with several subform. There is a direct Parent Child relationship between the main Form and the all the subform. On the main Form I have a combo box from which user select employee name. I want to fk empid in all the subforms to be set the value of the employee...

I already posted this question in a different forum, but I got not answer. I am hoping someone will be kind enough to help me. I am trying to create/enter records in my access database with a parent child relationship. I have several unbound subforms. Each subform reprents rating for the...

I am trying to create/enter records in my access database with a parent child relationship. I have several unbound subforms. Each subform reprents rating for the corresponding section (Category). I do not want to create one subform and link it to the parent form and let access handle the...