Search results

Just another addition, i have also tried puttin an unbound text box on the report with the line forms!frmInvoice!TaskNo.Column(2), but this just brings up the first task over and over again. if i could set some criteria to this parameter that would be good?

Hello people. Could you please help me. This one is a little hard to explain so i;ll try my best. I have an invoicing system. I Open the form, select which job i want to invoice on from the left list box, then the appropriate task no's for that job appear in the right list box. i select which...

what do u mean by missing paranthesis. and embedding? this code even with the inverted commas still gives the same msg. even though the [JobNo] is now in inverted commas this is really bugging me :)

sorry guys the previous post's reply is me just appending somethin in the question any help would be appreciated

sorry btter make a change to that the code i wrote in vb is wrong here is the correct code Private Sub GenerateReport_Click() Dim strWhere As String strWhere = "[JobNo] = " & Me!JobNo strWhere = strWhere & " AND [TaskNo] In " strWhere = strWhere & Me!TaskNo DoCmd.OpenReport "qryInvoice", , ...

hello, i have a form in which i select a job no in a list box, that then showes the relevant tasks for that job in another list box in which multiple select is allowed. i then put the folliwing code behind the view report button Private Sub cmdPrint_Click() Dim strWhere As String strWhere =...

I need to run an append query and update the information on a form I have a quote table, i enter a quote number, name, description and customer. I want to then go to the jobs form, hit a button, request a new job number, and then ask what quote number i would like to turn into a job. This part...

i didnt see it thats the thing. i was told by another forum to use that event. maybe it was taken out of context

ive compacted it and zipped it but it is 1.1 meg and the limit is 1 meg on this site. i cant get it any smaller?!

i cant get it small enough. only to just under 2 meg can u get it by ur email?\

thanks for that i tried those tips bubt still didnt work dont spose u could have a look at it?

no i hadnt thanks for that :) however im now gettin a different error message. Too Few Parameters. Expected 2 ??

i was told to put this code under On Requisite, but i dont know what that is so i put it under On Open. Private Sub Form_Load() Dim db As DAO.Database Dim rs As DAO.Recordset Dim qdf As QueryDef 'Note that YourDuerySQLstring should return one record Set qdf = db.CreateQueryDef("", "SELECT...

What is the on Requisite event? is this another name for somethin else?

ok. i will try it a little later and let you know. thankyou for your time mate. much appreciated :)

sorry it is too big i cant get it below a 1 meg zip file

give me a minute again sorry. im having trouble gettin it smaller

the file is too big. let me get rid of some data

give me a sec and i'll post the database. i havnt written it in sql give it 5

i want to use the textbox called TaskNo on my form as criteria in getting the information from the Query to store it in the textbox ActualCost?