Search results for 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...

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

Hi All, I have a small access application developed in Access 2007. Every time I run it on a machine that has no access but just the run time files(downloaded from Microsoft site) it pops up with a security notice and if i hit ok the application opens up and works fine..I just wana be able to...

Hi All, I have a main form leaseinfo and then a subform called leaseinfosubform and i have 2 combos on the main form as comp_num and lease_num(depedent on comp_num combox). The subform has several fields including comp_num and lease_num and its placed on the main form and shows data based upon...

sorry about that..its ver 10.

My parameter list doesn't display all the values that exist in the table. Any suggestion what could be the problem. But when i type in a value that is not displayed by the parameter the report gets generated which is fine but i want all the value to appear in my parameter list so user can choose...

Thanks for ur quick response...and ur help..apprecited..