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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Gigaz

  1. Gigaz

    Multiple events

    Tks, Its working now. Gigaz
  2. Gigaz

    Multiple events :Casting from Button to CheckBox

    Tks, Post is there now. Gigaz
  3. Gigaz

    Multiple events

    Hi, Can anybody help me with following problem. I'm trying to use multievent. I created chkMultiUse and I'm trying to use it in sub myClickHandler, nut I'm getting error: Unable to cast object type Buttons to type CheckBox. I know should change in some way chkMultiUse. Please any help will be...
  4. Gigaz

    Multiple events :Casting from Button to CheckBox

    Please where is forum796, Thanks
  5. Gigaz

    Multiple events :Casting from Button to CheckBox

    Hi, Can anybody help me with following problem. I'm trying to use multievent. I created chkMultiUse and I'm trying to use it in sub myClickHandler, nut I'm getting error: Unable to cast object type Buttons to type CheckBox. I know should change in some way chkMultiUse. Please any help will be...
  6. Gigaz

    Importing data from one form to other

    Hi, I made sample database: table Inv with fields InvoiceId - autonumber InvoiceDate - date table Quo with fields InvoiceId - autonumber InvoiceDate - date table Pro ProductId - autonumber ProductName - text table InvPro InvoiceId - number ProductId - number table QuoPro InvoiceId -...
  7. Gigaz

    Importing data from one form to other

    Hi, I have tried all possible combinations with append query and sql statements and it is not working. When I want to append form Quotation that have subform Products to form Invoice that have subform Products. I have created query InvoiceProduct that have fields InvoiceId ProductId...
  8. Gigaz

    Importing data from one form to other

    Hi, I did try creating select query with criteria in tblQuotes but it was still appending all data from product list. I will try WHERE now, and let you know how did I go. Tks, Gigaz
  9. Gigaz

    Importing data from one form to other

    Hi, I did try append query as I said before I'm appending whole table products. All items are copied to Invoice form in stead only items in Quotation (exampl 233) Sql was INSERT INTO tblInvoice ( Item, Qty ) SELECT tblQuotes.Item, tblQuotes.Qty FROM tblQuotes;
  10. Gigaz

    Importing data from one form to other

    Hi Remou, Tks for reply, I have tried append query, but than I'm appending all product items from product table. What I want is to append only selected items (ones that I have quoted in my quotation (exmpl quotation nr 223). Like this if I have 200 items in my product table all 200 are append to...
  11. Gigaz

    Importing data from one form to other

    Hi everybody, I have following problem : I want to import data from one form to other in same access program. Example: I have form 1 Quotation (in relation to Customer and Product items tables) and form 2 Invoices (in relation to the same tables) I have created Quotation (nr 125,126,127) all...
See more

Part and Inventory Search

Back
Top