Search results

Howzit That is because the ratio is only being applied against the labour charge and the 55, which will give you 135 then adding the 1 from the text box to give you 136., basically 1+ [((1 * 35) +55) * 1.5] If you want the ratio to be applied against all the text boxes and the labour charge...

Howzit Yes that is correct. Sorry If Nz(Me.Labour, 0) * 35 < 35 Then dblLabour = 35 Else dblLabour = Nz(Me.Labour, 0) * 35

Howzit The problem was that you were multiplying the labour portion tot he cost text boxes and where 0 would have resulted in 0. Try this - I note that your result for 0 values in the text boxes has moved from the original 150 down to 135, so I have changed the calculation accordingly...

Howzit If all your text boxes are 0 and the labour field is 0, your answer will indeed be 90, as (nz([Labour],0) * 40) section calculates to 0 as well. You are then left with 60 * 1.5 which is your 90. I 'm not sure what each of the text boxes are holding, but the only way you will get to...

Howzit This should do it... Private Sub CalculateButton_Click() me.textbox6 = ((nz([TextBox1],0) + nz([TextBox2],0) + nz([TextBox3],0) + nz([TextBox4],0)) * (nz([Labour],0) * 40) + 60) * 1.5 End sub

Howzit Put the formula in the control source of text box 6 and it will update after each entry. Cater for null values by using the Nz function. Something like... =((nz([TextBox1],0) + nz([TextBox2],0) + nz([TextBox3],0) + nz([TextBox4],0)) * (nz([Labour],0) * 40) + 60) * 1.5

Howzit I had a similar problem when doing a migration job for Great Plains - all the dates were coming across as dd/mm/yy hh:mm - but I only wanted dd/mm/yy and there was no time factor in the date. I got round this by changing the datatype in the specification I was using to export the data...

Howzit The problem he is facing is not what tool (shell or followhyperlink) to open the pdf with, it is building the string to make the file name. He has part of the file name in one table and the rest on his current form which is bound to a separate table. There is no guarantee that the...

Hello Jasmine Sorry I do not understand the problem you are having. Can you explain it more please

Howzit Same here. Time delays upto a minute if going into Advanced and hitting Preview button. Using Internet Explorer and this is the only site that I have these sort of problems..

Howzit Yes there are some serious time lags on forum lately. Hitting the quote button just now - I had to wait the best part of a minute before this came back. Even then the formatting icons only show as red crosses, but still work. A little frustrating. This post does seem to be getting...

Howzit Try something like... Private Sub BPO_Click() Dim r As Variant dim strRootPath as string If Dir(Listings![Property Root Folder] & Me![Valuation Link], vbDirectory) "" Then strRootPath = Dlookup("[Property Root Folder]","Listing","[ListingID]=" & me.listingid) strRootPath =...

Howzit Not exactly a scientifc answer, but this looked ok on mine strMess = "STATEMENT A : 1024 " & vbCrLf & vbCrLf strMess = strMess & Right(" DATE :", 20) & " 10/02/2012" & vbCrLf & vbCrLf strMess = strMess & Right(" SEASON :", 17) & " Winter" MsgBox...

Howzit See this post to see if it will help http://www.access-programmers.co.uk/forums/showthread.php?t=25430

Howzit No. I would test the content of the vouchernumber and voucher field before setting off the macro(s). Only when the 2 fields meet your criteria would the macro be set off.

Howzit Try if me.voucher >0 AND me.vouchernumber = 0 then msgbox "yourmessage",vbokonly,"Yourtitle" 'your rest of code else ' your oither code \ action end if

Howzit I would import the text file into one staging table, and do all the work in the staging table to allocate common keys for the header and detail lines, as well as spliting the lines (use update queries) to its individual components based on the first character of each line. Once the...

Howzit I use this in excel Dim db as dao.database dim rs as dao.recordset set db = opendatabase("\\fullpath\yourdatabase.mdb") set rs = db.openrecordset("yourtable")

Howzit Try Dim strSheet as string strSheet = Sheets("Home").Range("d17").value strsheet = strsheet & " Summary" Sheets("Home").Visible = True Sheets(strsheet).Visible = True Sheets("Action Plan Template").Visible = True

Howzit There should be no problem with updating linked tables. What error message are you getting?