User Profile

Collapse

Profile Sidebar

Collapse
kv29
kv29
Last Activity: Oct 25 '09, 12:26 AM
Joined: Apr 4 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • kv29
    replied to How can I parse this string?
    in Access
    great! thanks for the suggestions
    See more | Go to post

      Leave a comment:

    • kv29
      started a topic How can I parse this string?
      in Access

      How can I parse this string?

      I have a few hundred records that look like this

      mcnn 123030040506
      mcas sa 123033
      mscc 223449
      mcnn sa 1000300300


      What I need is the NUMBER part of the string, which, as you can see, the lenght is not always the same, BUT is always separated by an empty space from the rest and always on the right side.

      Important: I need to use the query builder.

      thanks in adv...
      See more | Go to post
      • kv29
        started a topic Simple, but dont know how to do it
        in Access

        Simple, but dont know how to do it

        Hope you can help! :)

        I have 2 tables. Table "A" has 4 fields: ClientID, BANK, NUMBER and USED. Table "B" has several fields, ClientID and NUMBER among others.

        NUMBER (on table A) refers to cheque numbers that are still available (USED fields are unchecked)

        What I need to do is to auto assign available NUMBERS from table A to table B, according to ClientID. Of course, there is the possibility...
        See more | Go to post
        • kv29
          started a topic Importing several files with path according to field
          in Access

          Importing several files with path according to field

          Hello, I would really appreciate some help, Im quite a newbie with VB in access.

          What Im trying to do is to import several XLS files that are distributed in various folders in C:\

          I`ve made a table in wich one of the fields contains the PATH to each of those files, so what I need should be simple a simple task to do: a routine that iterate the full recordset reading all those paths and automatically import the files...
          See more | Go to post
          • kv29
            replied to Print different reports based on field value?
            in Access
            Stewart, your code works like a charm!
            Every report is to be sent to a printed form, so they are supposed to fill "empty fields". Do you suggest to put some kind of pause in between not to screw the printing order?

            btw, I was thinking to change the "code" field (and so all the reports) from numbers to text, do I need to change something on your code?

            thanks!!
            See more | Go to post

              Leave a comment:

            • kv29
              replied to Print different reports based on field value?
              in Access
              Stewart, the table is quite simple, has 4 fields and the last one ("code") allows numbers from 1 to 10 (that represent those 10 different reports, also named "1" to "10"). no need for the user to fill the "code" field.

              what I need is to print them all, each record on its own report, in a single print batch.
              See more | Go to post

                Leave a comment:

              • kv29
                started a topic Print different reports based on field value?
                in Access

                Print different reports based on field value?

                Hi everyone! I really hope my problem will be a piece of cake for an expert coder :)

                I have a table with 100 records, and I need to print them all between 10 different reports based on each record field value, all with a single click.

                As you guessed, I dont know much about vb, so I would really appreciate some code to do what is required.

                thanks!
                See more | Go to post
                No activity results to display
                Show More
                Working...