Recent content by teachmecr

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

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

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

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

thanks..it worked.

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

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

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

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

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

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

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

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

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

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