Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ParyGoal
  • Content: Threads
  • Order by date
  1. ParyGoal

    Reference Autonumber Primary Key

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

    Database Updates/Users

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

    INSERT SQL STATEMENT

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

    Populate Multiple DataGrids

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

    Syntax error in sql

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

    Combo Inside Grid/FlexGrid

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

    Shape object

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

    Shape object

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

    Data Types/Performences

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

    Type Mismatch

    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, _...
  11. ParyGoal

    Database Design

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

    Database Design

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

    INSERT SQL STATEMENT

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

    ASP.net Application

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

    And/Xor Operator

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

    Referencing Field in Subform

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

    Assign Value to Text Box

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

    Unbound Forms/ADO/VBA

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

    Unbound Forms/VBA

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

Part and Inventory Search

Back
Top