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 Mike Lewis 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: *

  1. thewizz

    Problems Filtering Subform

    on the prob at the begining .... got 2 forms main_frm with a sub_frm (actualy many but same problem/diff. Frm.) this is actualy for parts of computers (in subfrm)my source for the subform is a query et the sub_frm has a fitler saved (& is applyed on oppenning) the thing is that when the...
  2. thewizz

    Checklist Report

    iv got 4 tables : tbl_PC: NoPc(auto_num & key) SOmeinfo... tbl_Items: NoItem(auto_num & Key) NoPc(num) NoProduct(num) Price(something...) etc... tbl_Products: NoProduct(autoNum & key) NoType(num) Desc.(text) etc... tbl_Types...
  3. thewizz

    Generate Reports based on multiple tables?

    i dont know if it applys but know that the openreport function has a embeded WHERE Clause when you call it small ex: dim stlinkcriteria as string stlinkcriteria "noProduit = " + me.mybox.text openreport form1,stlinkcriteria,stNormal (this code may have errors !!)
  4. thewizz

    Checklist Report

    hi got a big question... i what to do a checklist to see is pc A has part C (type of hardware ex.CPU,MTB,Ram...) but A only has the number of B witch is the the C type A points to B who is pointing to C when form opens in need to see a series of checks (& nochecks)for each required C type of...
  5. thewizz

    Where dateA > dateB and dateA < dateC in SQL ???

    PROBLEM SOLVED! Opss caps.. thanks it has worked ! thewizz
  6. thewizz

    Where dateA > dateB and dateA < dateC in SQL ???

    Ho do i COmpare dates in access SQL ? My DateA is a field in a Table DateB & DateC are dates in a Form (Im doing a FInd form that opens aother form on a button press & i pass the WHERE statement in the stLinkcriteria of OpenForm function) thewizz
  7. thewizz

    unbound control -> keeping data-> Howto?

    hi I would like to thank the ppl that awnwer questions ... :P I also have a question of corse :) here it is i have a unbound control/column [Type] in a continuous form of items [items]& i whant to keep its data for each record but i dont whant to dupicate that specific data wich is hold in...
  8. thewizz

    Executing a query in a module & passing the result to a textbox

    works!!! sorry roy it didnt work but thanks As For mr. Paul Briker Great thanks !! IT WORKS !!! it settles the tread i think :) thank you for your time thewizz
  9. thewizz

    Executing a query in a module & passing the result to a textbox

    hi I would like to know if it is possible to execute a query in a module(AfterUpdate Event) & passing the result in a textbox as a default value. if any body can help it'would be very welcommed :) thewizz
  10. thewizz

    Keeping data in datasheet or form view

    tanks for replying the field Type is unbound indeed to shortly explain the thing a have 3 table one for the list Types[table_type] of harware one for items[table_items] (for each individual parts) & one for given products info [table_products] (witch uses the type table for a field)...
  11. thewizz

    Keeping data in datasheet or form view

    Hi i would like to know if anybody know if i can keep some data in a field in datasheet view & or Form view ? i whant teh user to select a cathegorie but i dont whant to keep the data in the same table so i setup a "Type" table plus a parts table & a Item table in PArt i have the Type...
  12. thewizz

    Help with video card

    I have PCI GeForce 4 MX 440 on Windows XP HomeE and I have a problem with running applications (Especially VB!) I get an error message everytime I run a specific app when i run the "trace bug" it sais that Nview.dll makes an exception on 0xC0000005:Access Violation i don't have a clue...

Part and Inventory Search

Back
Top