User Profile

Collapse

Profile Sidebar

Collapse
usha2
usha2
Last Activity: Apr 17 '12, 01:14 PM
Joined: Mar 7 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • usha2
    started a topic Insert string value in a field with where condition.
    in Access

    Insert string value in a field with where condition.

    Sir,
    I have some value in my main table:All_Table
    A columh(Net_Logi n) with value:"xyz"
    I have a string:strValue

    I want to insert/update(which will work fine?)my table"All_table ",strvalue where xyz found.

    What i tried and saya error msg'Semicolon (;) missing '
    Code is:
    Code:
    strUpdateTbl = "INSERT INTO All_Table
(Net_Login) VALUES (" & strvalue & ")
    ...
    See more | Go to post
    • usha2
      replied to Inserting records from different source to a single table.
      in Access
      Yes sir Neopa, it works with ADo.
      It append all my records from All_Table to TempTbl,
      But in the field "Net_Login" ,only the last value of strValue displays repetedly.
      Number of records in strValue are same as num of All_Table.
      Please rectify.
      should i loop some where?
      See more | Go to post

        Leave a comment:

      • usha2
        replied to Inserting records from different source to a single table.
        in Access
        Thank you sir,
        I will definitely use this code.

        I am using ADO so can i use this same in my project?

        But i am not anything about "QBE design grid".
        As per your guideance i will definitely try.
        See more | Go to post

          Leave a comment:

        • usha2
          started a topic Inserting records from different source to a single table.
          in Access

          Inserting records from different source to a single table.

          hellow Experts,
          I have created a table:Temptbl
          with this code,
          Code:
          strCreatetbl = "CREATE TABLE TempTbl " & _
               "(Login TEXT(64), " & _
               "Email TEXT(64), " & _
               "Department TEXT(64), " & _
               "[First name] TEXT(64), " & _
               "[Last name] TEXT(64), " & _
          ...
          See more | Go to post
          • usha2
            replied to Error in SQL INSERT INTO statement.
            in Access
            Thank you.
            When my field values are in string then what will be the syntax.
            See more | Go to post

              Leave a comment:

            • usha2
              started a topic Error in SQL INSERT INTO statement.
              in Access

              Error in SQL INSERT INTO statement.

              Table name:All_Table
              I have a string value in string:strdata
              A column in Table:login
              How can i insert the string value in column"login"?
              I tried this following code,but give syntax error msg.
              Code:
              strIns = "INSERT INTO All_Table
(login) VALUES " & strdata "
              See more | Go to post
              • usha2
                replied to Splitting field value
                in Access
                Refering field value with the symbol "!" ,AMAZING.
                It was new for me also works magically,succe ssfully.
                Really the name of yours"EXPERT" justified.
                See more | Go to post

                  Leave a comment:

                • usha2
                  replied to Splitting field value
                  in Access
                  I want to go with Split.
                  Using ADODB.
                  I tried this ,
                  Code:
                  strTable = "All_Table"
rstTable.Open strTable, cnnDB 'open data sources table with recordset
  'Do Until rstTables.EOF 'until end of tables is reached
  strnew = Split(rstTable!Login_Account, "\")(1)
    Debug.Print strnew
                  This shows the error msg:
                  Run Time error'91':
                  Object variable or With block variable...
                  See more | Go to post

                    Leave a comment:

                  • usha2
                    replied to Splitting field value
                    in Access
                    Sir,
                    Instead of split can i use Mid?
                    How can i refer to my Table ?
                    Is it by name"All_Table" ?
                    See more | Go to post

                      Leave a comment:

                    • usha2
                      started a topic Active directory data into Access Table.
                      in Access

                      Active directory data into Access Table.

                      Hellow Sir,
                      I am working with Active Directory.
                      I have some data in my access database.
                      i need to compare these data with Active directory's sAMAccountname.
                      I used the SQL statement to pull AD information into a recordset.
                      But unable to compare with access table.
                      If the recordset from AD is in a temptable then it may be possible to compare with my existing Table.
                      So am i going in the right direction?...
                      See more | Go to post
                      • usha2
                        started a topic Splitting field value
                        in Access

                        Splitting field value

                        I have a access database name:MainDataba se
                        A table inside this name:All_Table
                        A field inside this table,name:Logi n_Account
                        Structure of data in that field is:DOM\xyz
                        My question is:
                        How can i split this fiels value to get only'xyz'in a recordset.
                        Hope for some vba code and Thanks in advance.
                        See more | Go to post
                        • usha2
                          replied to Docmd.Transferspreadsheet
                          in Access
                          The existed table has 4 fiels:
                          Name(text)'Two space before this string.
                          Fname(text)
                          Lname(text)
                          Email(text)
                          Excel file try to import has 4 column;(All in Sheet1)
                          Name(text)'In A1 ,Two space before this string.
                          Fname(text)'In B1
                          Lname(text)'In C1
                          Email(text)'In D1
                          executing my 1st posted code,the error msg comes"F1.."
                          Next i tried by changing in my code:...
                          See more | Go to post
                          Last edited by usha2; Mar 29 '12, 06:09 PM. Reason: add code

                            Leave a comment:

                          • usha2
                            replied to Docmd.Transferspreadsheet
                            in Access
                            The existing table in data base has 4 field:
                            1A
                            2B
                            3C
                            4D
                            (This is the impoted excel file by using File->Import)
                            In this file i want to replace all my imported data of new excel file.
                            The new excel file has also same field name,same sequence,same data type.
                            only the thing is that,while it importing the new excel file,it join a autonumber field,with default naming"F1".
                            Which...
                            See more | Go to post

                              Leave a comment:

                            • usha2
                              replied to Docmd.Transferspreadsheet
                              in Access
                              yes the layout of both excel file and access table are same.
                              But when it impoting ,it automatically create a autonumber field,which is not matched.
                              So should i create a table in database with F1 field?
                              It again shows the error msg" F2...in destinationn table"
                              or any way is there to replace a existing file with imported file.
                              See more | Go to post

                                Leave a comment:

                              • usha2
                                started a topic Docmd.Transferspreadsheet
                                in Access

                                Docmd.Transferspreadsheet

                                I am trying to impot a excel file and replace with existing table in database.
                                Every time it import a extra automated field(F1),so it gives the error message:
                                "Field'F1' doesnot exost in destination table'table name'"
                                How can i impot my excel file into existing table,whose field names are same?And without autonum field?
                                The code i craft is:
                                Code:
                                Private Sub cmdImport_click()
Dim msg As String
                                ...
                                See more | Go to post
                                • usha2
                                  started a topic Run-time error'-2147217900(80040e14)': in vba access 2003
                                  in Access

                                  Run-time error'-2147217900(80040e14)': in vba access 2003

                                  I craft a access vba code.
                                  I got this error message while trying to run:
                                  Run-time error'-2147217900(8004 0e14)':
                                  The SELECT statement includes a reserved word or an argument name thht is misspelled or missing,or the punctuation is incorrect.
                                  The SQl code is"
                                  Code:
                                  strSQL = "SELECT " & strFldname & _
                        "INTO " & strTempTable & _
                                  ...
                                  See more | Go to post
                                  • usha2
                                    started a topic Read a file from Form.
                                    in Access

                                    Read a file from Form.

                                    working in Access 2003,Vba.

                                    I have a Main Table in my database.
                                    How can i merge or join more tables browsing files from Form.
                                    Result should be in the Main table or in new Table.
                                    How can i read a file from form That will merge/join with the existing table in the database.Is it possible?
                                    For More Clarification from my side.
                                    TableA
                                    ID Sub1
                                    1a XYZ
                                    2b ABC
                                    TableB
                                    ...
                                    See more | Go to post
                                    • usha2
                                      replied to FileBrowser in form.
                                      in Access
                                      As per Neopa For more clear,
                                      In access i have created a form.3 cmdbutton and 2 labels with some text.
                                      after following the link send by Neopa ,when i double click on form the path of current database is appear on two labels.
                                      So how the cmdbutton will work.
                                      and as i need to merge with existing table by choose a .mdb/.xls file from file browser how can i do,where i should write code,where the code need modification.
                                      ...
                                      See more | Go to post
                                      Last edited by usha2; Mar 13 '12, 01:31 PM. Reason: Spelling mistake.

                                        Leave a comment:

                                      • usha2
                                        replied to FileBrowser in form.
                                        in Access
                                        when i use this code ,by doubleclicking the form the current path of the database shows in labels.

                                        How can i choose file(.mdb/.xls) from file dialog box?

                                        Where can i modify the code?
                                        See more | Go to post

                                          Leave a comment:

                                        • usha2
                                          replied to FileBrowser in form.
                                          in Access
                                          Thank You NeoPa.
                                          Hope it will help in my project.
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...