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 strongm 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: horak
  • Order by date
  1. horak

    Speed of two large joined access tables!

    I have a many (~240) field Access table with only a few records in it joined onto another similar table. Populating these tables takes a long time - for the first record, then it seems to wizz along after that. Anybody know what might be going on, or if there is a way to speed things up...
  2. horak

    Loading a access record into a vb variable

    Best way is to use Open database method in code - there are many examples of how to do this - and then cycle through the data table, filling program variables. eg do until rs.eof for x = i to 100 thisvalue(i)= rs(i) next x rs.movenext ...............where rs(i) is the column of the...
  3. horak

    Keeping info together on a page

    In Crystal Reports, if a subsection has either memo fields or boxes, Crystal seems to ignore the 'keep together' requirement for the subsection It's even mentioned in the Help file for Crystal 7 'Keep Together' (in regard to memo fields). I would love to know if there is any work around -...
  4. horak

    writing query in sql expression field

    Simply set up a relation - database menu and set the common fields (hopefully unique!) to a 1 to 1 join relation. Otherwise you'll need unique id numbers linkin both tables,

Part and Inventory Search

Back
Top