Recent content by thewizz

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...

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...

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 !!)

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...

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

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

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...

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

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

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)...

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...

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...