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 Chriss Miller 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 teachmecr

  1. teachmecr

    create a query

    Every first closed invoice gets applied towards the first open invoice thus temporarily becoming an open invoice itself and so on. so at the end you get all the open invoices in sequence 30 days apart from each other...i hope this makes it clear. thanks InvoiceNum delinquency Amount...
  2. teachmecr

    create a query

    No this is not what i'm looking for...my question is complicated than just counting the difference between two dates..thanks
  3. teachmecr

    create a query

    I have a table called Invoice. It has fields such as Invoicenum duedate Amount and status. The status could be open or close meaning whether the invoice has been paid or not. What i basically want to achieve is to find which invoice is delinquent by (1-30days,31-60,61-90,91-120 and >120). What...
  4. teachmecr

    create a form from a view in SQL server

    Hi All- I have a small task to achieve. I want to create a form in Access which (Access) would have possibly an ODBC connection to my SQL server database that has a view as my source for data for the form. What i want to be able to do is have the data from the SQL view to display in a form in...
  5. teachmecr

    Display a pop up when subform isn't filtered

    thanks..it worked.
  6. teachmecr

    Display a pop up when subform isn't filtered

    Hi there I have the following code on command button on the main form that displays customers names on the subform on finding a match from the text box. txtCustname.SetFocus strCustName = txtCustname.Text If strCustName <> "" Me.Subform.Visible = True Me.Subform.Form.Filter =...
  7. teachmecr

    Make a command button invisible on a form based on one of its text box

    i have a form frmDataForm that has its record source property set to a view linked to SQL server(ODBC). The form has about 6 fields(textboxes). I have a command button on this form that opens up another form frmComments capturing some of Dataform values. What i want is to make this button...
  8. teachmecr

    Populate form based on a text box

    k thanks...works now..just one thing though..is it possible for the subform to initially load blank or null..and shows the result only when a search is made. thanks
  9. teachmecr

    Populate form based on a text box

    main form is frmSearchOptionsTest and subform is TestSubform(its record source in its properties is "SELECT EquipCompanyNum, EquipLease, EquipSerialNum, EquipSeqNum, EquipDescription, CustName, CustDBA, OrigComment, TitleStatus, TitleType, TitleRecdDt, TitleReqDt, NewComment FROM...
  10. teachmecr

    Populate form based on a text box

    I tried your answer but it doesn't work...first it was giving syntax error when i fixed that..then it just doesn't give anything in the subform..
  11. teachmecr

    VBA Right function

    thanks a lot man...it worked..i really appreciate ur help..i have to try both search criterias at the same time ...so lets see...
  12. teachmecr

    VBA Right function

    what i'm trying to say is this: i have a textbox "txtVinSearch". when i type in a full vin number in it it takes me to the particular record for that vin in the form...but i wana be able to just search on the last 5 numbers of the vin..and when i type in the last 5 numbers of the vin..it doesn't...
  13. teachmecr

    VBA Right function

    strsearchvin takes the value from a textbox that the user is going to enter which gets compared with actual vinnum(strvinnum) and strvinnum holds the actual values from one of the textboxes of the form...they are coming from a view thur odbc (sql)..
  14. teachmecr

    VBA Right function

    Hi can plz someone tell me why the following code doesn't give me the expected results. if i do the exact search for strSearchVin = strVinNum...it gives me the correct results but somehow doesn't work with RIGHT function. I wana look up my results from the text box (by exact number or last 5...
  15. teachmecr

    Populate form based on a text box

    Hi All- I have a form with in access which is pulling data from Ms Sql thru ODBC connection (a View). What i want is to have a text box as a search field where the user types in a number or part of a number and it will only display the relevant results in the form. I have done this before with...
See more

Part and Inventory Search

Back
Top