Search results

Hello, I am not sure if this is possible, but what i am looking for is a control on each line item on a report to align differently based on a rule. What i am trying to accomplish is separating notes out based on the user. So any notes from myself i want to align on the left side of the...

Fantastic thanks, both scenarios worked for me as well!

I have tried Null, "" and vbNullString all as a filter and it keeps saving the previous queryDef thanks for the peek Code: If Me.chkExcel = True Then ' --------First check if the query is open and close if it is If CurrentData.AllQueries("accqInvoices").IsLoaded Then...

Hi, One issue I cant seem to work through is how to set the filter of the query back to null. If i multi select from my form lbx the filter two values it updates my txtstrWhere to "DivisionID In(1,2)" like it should. Then i run the query, all works well still and filters the query as it...

Brilliant, worked perfectly! THANK YOU!

Hello all, I have a form that has multiselect listboxes that on the click event will update a strWhere text field that is used when opening a report to pass in the where clause. that part works fine. (example of strWhereVanID In(1,4,5)) However, i want to use part of that same field the...

No they are two different hidden fields. the txtDecimal is the TimeValue for each individual day for each driver. the tstDecimalSum is the Sum of all the txtDecimal fields. not elegant but i am still learning and a moderate Access user so i tend to break things apart to work through what is...

While not elegant piecing multiple post together this worked: CStr(Int(Sum(CDbl([txtDecimal])*24))) & ":" & Format(Right([txtSumDecimal],2)*0.6,"00") Thanks everyone

Ok thanks Minty, I am getting 10:01 now but i expected the 10.03 decimal to go to 10:02, i am sure this is a rounding issue, but since i want to stay consistent with the payroll software, is there a way to address that rounding issue?

Hello, I have a SQL table that stores time as Time(0). I have a report that list all the employees hours for each day during the week as HH:MM. i need to find a way to total that time for the week so that for example 8:00+8:00+9:15 = 25:15. I have tried to add a field in the report and take...

Thanks Paul, i did a accmdSaveRecord after update on the first field and that did the trick.

Hello, I have a form that should generate and autonumber when a record is started. As soon as i start typing in the first field, the auto number field goes from (New) to blank. Even if i add an me.ID.requery or an me.ID.SetFocus on the AfterUpdate event it does not bring in the number. In...

Thanks Minty, very nice!

Thanks, but making the change still produces a blank lbx Me.lbxZone.RowSource = strSQL Me.lbxZone.RowSource = Me.lbxZone.RowSource & strSortOrder

Hello, I have been looking for a solution and haven't found quite what i need. I have a multi select lbx that filters another multi select lbx. the SQL that i wrote work great up the the point when i am trying to sort by one of the columns in the lbx. Once i add the ORDER BY statement the lbx...

Thanks for both suggestions, i didn't even consider conditional formatting.

Hello, I have a form that has a lot of textboxes on it. I have two Public Subs (cOn and cOff) that when the control in On Enter it highlights the control and bolds the label and On Exit turns that control back to normal. My question is rather than going through each control on the form and...

Thanks arnelgp, works great!

Thanks for the idea but gave it gave the same negative results

Hello, I am trying to set the control source of a textbox to a line of code in a table. I have a cbx that has "dates" like yesterday, tomorrow, last quarter etc. on the after update i want two hidden text boxes to update with the correct formula that i stored in the table. I have the control...