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!

  • Congratulations Chriss Miller 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: jhrs
  • Order by date
  1. jhrs

    Query two different tables with one criteria

    HI PHV, thanks for your answer I have to tables of customers with different estructure, and I have to filter in both with the same criteria, for example: Like *main* AND *3* and to apply it in both tables at the same time, I hope I war clear
  2. jhrs

    Query two different tables with one criteria

    Hi my friends, I need to filter two tables with one criteria, e.g. *main* in two tables and get the result thanks a lot
  3. jhrs

    group by number of week of the month

    hi, is there a function in access to group by the number of week in a month, I have found one but it is for the whole year (53 weeks) and if i could count from the first day of that month, example if the month begins on friday it would be the first week til next thursday Thanks a lot
  4. jhrs

    Access equivalent of PictureBox of Visual Basic?

    Hi my friends, could somebody tell me which control is equivalent to the picturebox of visualbasic in Access thanks soooo much
  5. jhrs

    Visual Basic and Map info

    Hi my friends, Dos anybody worked with Mapinfo and Visual Basic? I need to store the coordinates of a point in a access table through Visual Basic Or if you know about a mapinfo forum please Thanks group
  6. jhrs

    update a column while value in other not changes

    Qué paja!!!! ".moveprevious... .movenext" was the answer hope thanks really could express how i feel for your help
  7. jhrs

    update a column while value in other not changes

    Hi again, dyarwood, what i'm really trying to do is this (i'm not native english speaker i hope i'm clear) it is not really autonumbering it is making operations with 2 or 3 columns while other columns keeps the same value and do it again if it changes. col0 col1 col2 col3 col4 A 0 7...
  8. jhrs

    update a column while value in other not changes

    Hi, I hope somebody can help me, I want to autonumber a column while the value in other one no changes, if it changes, begin again the autonumbering, I want to do this with DAO. the result would be something like this: columnA columnB A 1 A 2 A 3 A 4 B 1 B...
  9. jhrs

    Update field from another table

    Hi, Wayne thanks for your attention, the problem is that I have the stockid already defined and is not autonumber, but can i update the table stock with the transactions of receiving and shipping on a determined day?
  10. jhrs

    Update field from another table

    Hi, I have a problem with these tables in a inventory database: I have table1 like this: Id In Out date 100 23 15 01-10-2003 100 45 18 01-11-2003 ad so on, many id, and many dates and many IN and Out fields what I want is to create a table where I put Stock = In + Out, it...

Part and Inventory Search

Back
Top