Search results

Well, I tried the Chr(13)&Chr(10) before the replacement [ and it didn't work? I searched some more and it turns out you have to have the text box set to plain text and not rich text. So, my original code now works as: [ 27/06/2013 15:20:43 ] Hello [ 27/06/2013 15:33:37 ] Hello [ 27/06/2013...

Hi Dale, OK so I've just Googled this and it appears to be VBA code and there is one similar called vbNewLine?? If you would be so kind, my question is that I am typing the above in an unbound text box on a form in design view. I thought I had to open the (scary) VBA screen to put in VBA code...

Also, if a ColumnHistory expert happens to be looking, how do I get the 'histories' to show with newest at the top of the text box? I know it's possible as I've seen someone else mention it in passing (Lateefx) but they didn't give detail.

Hi All, So I have an unbound textbox with the following: =Replace(ColumnHistory("TblJob","Comments","[JobID]='" & Nz([JobID],"") & "'"),"[Version: ","[",1,-1) Which is working perfectly except one thing... The 'histories' are displaying all together instead of a new history being on a new...

Hi All, I've removed my little form and will just use the access standard one.

So... I thought of a workaround so that I wouldn't have to use code. I followed the instructions on Microsoft online help... I created a query and a little form for the user to enter the employee number. In my query I used the builder to reference the text box on my little form so I didn't make...

Hi Bob, I've made a copy of the DB, removed all confidential records, added 4 test records, compacted and repaired and then zipped the file and it is still 7.9mb, exceeding the 2mb allowance for uploading. Is there any way I can make it smaller or shall I delete forms / reports which are not...

OK, I pressed Compile and nothing happened and now the option is greyed out. I've closed the DB and opened it again the and the option is still grey.

It looks exactly like that with [Event Procedure] in the box. When I click the drop down I can see my macros and when I click the 3dots (build?) I can see the code in a new screen. The code seems to be saving. I edit it and then close the DB and open it and it's still there when I click build...

Oh dear, silly me... I didn't have the Employee Number showing on the form. I've now added it and when I look at text box, other and name it is "EmpNo" without the quotes, so I've changed it to: Private Sub cmdPrint_Click() DoCmd.OpenReport "Sub_DetForm_Rpt", acViewPreview...

Hi Bob, I've done the following: Private Sub cmdPrint_Click() DoCmd.OpenReport "Sub_DetForm_Rpt", acViewPreview, WhereCondition:="[Employee Number]=" & Me.ControlOnSub_Det_Frm End Sub ...and am getting exactly the same error? Do I have to amend the properties for the button? The form is from a...

Hi Bob, Where do I type the DoCmd... Is it still in the button, on click, event procedure, then build, then delete the other stuff and insert this in between "Private Sub cmdPrint_Click()" and "End Sub"?

Good Afternoon All, I'm hoping you can help. I have a DB in Access 2007 which I'm having trouble with. I have a form, "Sub_Det_Frm", on which I would like to place a button to print the current record, (Primary Key is an autonumber "Employee Number") to a report "Sub_DetForm_Rpt". OK...