User Profile

Collapse

Profile Sidebar

Collapse
spudpeel
spudpeel
Last Activity: Sep 6 '07, 03:51 PM
Joined: Jul 27 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • spudpeel
    replied to INSERT INTO statement, what is wrong with my syntax? :(
    in Access
    Huge thanks, that works perfectly!

    To itsya - you were clear, i just didnt know if the commas were quoted.

    Thanks very much!
    See more | Go to post

      Leave a comment:

    • spudpeel
      replied to INSERT INTO statement, what is wrong with my syntax? :(
      in Access
      Does text values include the commas between the items?
      See more | Go to post

        Leave a comment:

      • spudpeel
        started a topic INSERT INTO statement, what is wrong with my syntax? :(
        in Access

        INSERT INTO statement, what is wrong with my syntax? :(

        Hi,
        I have to insert 10 pieces of data (8 from text or combo boxes, and 2 from variables), into my table. I'm sure Im getting the quotes wrong somewhere, but whatever I try I just cant see anything wrong.
        I'd really appreciate it If someone could help me with this, Its driving me crazy!
        The Code is below:
        Code:
        DoCmd.RunSQL "INSERT INTO tblDocs ([Doc Name],[Doc Code],[Description],[DepC],[Version],[Master],[Authorised],[Physical
        ...
        See more | Go to post
        Last edited by JKing; Aug 22 '07, 12:41 PM. Reason: [CODE] Tags
        • spudpeel
          replied to How to Add, Edit Records programmatically?
          in Access
          Thats awesome! Thanks very much, and thanks for offering further help, I may probably take you up on your offer!
          See more | Go to post

            Leave a comment:

          • spudpeel
            replied to Dependant Combo Boxes
            in Access
            Thanks so much! Got that working nicely!
            : )
            See more | Go to post

              Leave a comment:

            • spudpeel
              started a topic How to Add, Edit Records programmatically?
              in Access

              How to Add, Edit Records programmatically?

              Im still finding problems in my document control system, and have arrived at one of the most important bits. (Im completely new to access so Ive been learning as I go).
              Part of the system involves adding a new version of a document to the database, by setting the old one to obselete and adding a record of the new one. To reduce the likelihood of typos I made it so that the Name of the document is picked from a list of the existing records...
              See more | Go to post
              • spudpeel
                started a topic Dependant Combo Boxes
                in Access

                Dependant Combo Boxes

                Hi, I am currently making a document control system through access, and yet another hurdle has come up. Rather than give the user a table to sift through, I want to be able to use dependant combo boxes to pick a document name from a list. There are two tables involved: the first contains Department codes and Department names, i.e. 1.Sales, 2.Production; and the second contains Document Details, including the Department Code.

                I want...
                See more | Go to post
                • spudpeel
                  replied to Document Control System through Ms access
                  in Access
                  I have also just been given the exact same task!
                  I'm trying to also make a login form, and restricted access depending on the department that each person is in. Im completely new to Access other than the dull stuff in school I never paid attention to! But Im sure your script will be very useful.. thanks very much!
                  See more | Go to post

                    Leave a comment:

                  No activity results to display
                  Show More
                  Working...