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 Wanet Telecoms Ltd 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. vinanti

    Problem with database records

    Hi there, I have two dbase.in 1 of the dbases I have about 4592 records and in the other 3433 records.The fields in the first dbase are: id ,name,urls and in the 2nd dbase the fields are urls,name. i want to put the same name as in the 1st table for all the records in the 2nd table's...
  2. vinanti

    cartoon animation-problem

    Hi there, I am working on cartoon animation.I have drawn the cartoon using pen tool ,that is with the help of anchors.but i am facing a problem that is when i try to curve the anchors ,it does not allow me to do so.nor doeas it allow me to add any anchor to a bounded figure drawn in this...
  3. vinanti

    Opening Forms with LINKED CRITERIA

    hi gazer, The solution to yur problem is here: "thread702-545795" Try it,if still dont get the soln tell me i have got one more way.... bye always there to help....provided i know vinanti
  4. vinanti

    anybody from theadmin ihave got an urgent query

    hi, I have made an application i want to upload it so that others who have experience,can try it and shoot with their advices, the size of the application in mdb format is around 660 kb only. Could you please let me know how to go about it. bye, vinanti
  5. vinanti

    hi there, today the site is very

    hi there, today the site is very slow,isn't it? i had a lot of problems going through the kwyword search pages also, anyways, does anyone there have a solution to my problem: my code is: i want to open the form based on 2 criteria i tried using and in place of & in the lnkcriteria but it...
  6. vinanti

    Opening Forms with LINKED CRITERIA

    hi gazer, how did u solve it, stuck up in something similar... my code is: even i get the error type mismatch i even tried with and in place of & in the lnkcriteria. please have a look; suppnm = Forms!mod_frm!supp_nm compnm = Forms!mod_frm!comp_nm lnkcriteria = ("[supplier name] = '&quot...
  7. vinanti

    search records from databse failed

    hey, it worked wonders too good thnks a lot vinanti
  8. vinanti

    search records from databse failed

    Hi ken, thnks for the help but i m new to this concept of recordset and dao or ado and hence unable to understand it..still i m giving it a try, thnks a lot ;if not solved i shall get back bye, vinanti
  9. vinanti

    breaking a loop from middle

    hi bill, i have posted another thread for the same plz. see if u can help... bye vinatni
  10. vinanti

    search records from databse failed

    hi there, I am working in access 2002. my code is:- for i=1 to tempcnt chksav=Dlookup("[invoice no]","mast","[supplier name]'"=tempsupp"'" msgbox "chksav" if(chksav=Me.invoice_no)then Exit For endif next i=i+1 end in the above code i want to...
  11. vinanti

    breaking a loop from middle

    hi bill, thnks a lot i'll try it right away, i have another query as you can see above,i have used dlookup to fin records based a criteria;now i see that the row returned is the same record again and again it does not move to the next record in the database where the condition is fulfilled;plz...
  12. vinanti

    breaking a loop from middle

    hi everybody, I am working on a looping construct,and i want to break it the moment a condition is satisfied.i dont know how to do this,i have tried using break,end.i want the correct syntax for this,plz. my code is: for i=1 to tempcnt chksav=Dlookup("[invoice...
  13. vinanti

    Opening Forms with LINKED CRITERIA

    hi, I dont know whether this would solve your problem for sure...but just givin it try; Listen, u can do 1 thing, try passing an argument with the openform action and then in the form load event check for the appropriate argument. if argument satisfied then in the loaded form itself it would...
  14. vinanti

    Openform Statement???

    hi guys, Thnks for the help i have always been provided on time. I am again stuck up badly. I have to open a form from another form. I want to pass an argument --- compulsory and at the same time show records only of the supplier name provided by the user. I am using the foll statemnet...
  15. vinanti

    single form to perform add,mod,view--not working????

    hi, I am working on a form which gives the user various options like:add,modify,view etc.. Now when the user clicks on the modify button another form opens which takes a value from the user for supplier name and i want to open the previous form(that is the master form) for further modification...
  16. vinanti

    query related to runsql not working in 2002

    hey, thnks it worked...what i had to do is place the code in the form upadate event rather than at the previous place because it was deleting it before adding and saving it at the time of update... anyways very happy that it has got solved... but daniel i have one more query:i want to know...
  17. vinanti

    query related to runsql not working in 2002

    hi daniel, i tried this but the problem is that the record is still not deleted it says "0 records deleted ...." and ultimately when i check the base table i find the record available i dont understand why it is happening so,in ms-access 97 it was absolutely fine! plz suggest some...
  18. vinanti

    coloured combo box like in msaccess2002

    hi there, i want to create a combo box with a coloured drop down arrow as in ms access-2002 ,the sky-blue colour that come every time there is a mouse over event on the help combo box of access2002 i hope you'll get me... plz suggest ... thnks in advance, vinanti
  19. vinanti

    query related to runsql not working in 2002

    hi, i have a form with a cancel button on it;when clicked on this button i want the record from the base table to be deleted which has been half entered by the user on this form. this functionality was working very fine when i was working in ms access-97 but since i have now upgraded to...
  20. vinanti

    query related to display in tab control

    hi there, thnks to all who suggested,i found a solution by r & d thnks again vinanti

Part and Inventory Search

Back
Top