Recent content by nickthompson

Hi Judy As others have suggested, this is a bit of vaguely posed question, but maybe you're looking for is a vague answer. For a good UK based Access specialist capable of developing such a solution you're probably looking at a day rate of £300 to £600. It's less if you hire a developer who's...

Has anyone else noticed significant lagging with their Access forms in the last couple of days? We've noticed it across multiple PCs that have had Windows updates (all running Acc2007, Win10 64 bit, and all with linked tables to a local SQL Express db). All were running fine before the latest...

Hi Rand This looks interesting, but I get an error when trying to write to the PDF - ActiveX component can't create object, on this line Set AcroApp = CreateObject("AcroExch.App") Is it required to have Acrobat installed to use the sample (as opposed to just Adobe Reader?) Thanks

To add to Paul's valid response, I'd also suggest another way of doing this. You could set up a linked table to the query/table in question, and set the row source of the combo box to a SQL string that selects the data from that query/table. I think you'll need to requery it before you'll see...

Is PartyTimeCombo bound to a field? If so, what field type is it? If it's a date/time then the data that's stored contains a date that you're just not displaying in the combo box, but you'd need to include it in your IF statement to make a valid comparison. To see what value PartyTimeCombo...

I think I understand the issue better now. Are all the checkboxes bound? Or just the NoCase one? The trouble is that in Access you cannot refer to an instance of a control within a specific record. Every instance of that control in every record has the same name. If the other two checkboxes...

Yep, that was the first thing I did! So for example, I can put the following in a Form Load event: DoCmd.SetWarnings True TriggerError'TriggerError' is not defined, so should force an error box to pop up. I don't have any On Error line in the function. Yet I don't get an error box...

If you set the Text Format property of the textbox to 'Rich Text' it will accept HTML. You can then dynamically insert a bold tag based on the capitalisation in the field, e.g. set control source to: =IIf(Asc(Left([firstname],1))<91 And Asc(Right([firstname],1))<91,"<b>" & [firstname] &...

I couldn't quite understand your post as you start by talking about Excel, but assume you are importing into Access and the issue is with an Access report. If so, the issue should be resolved by moving the control that produces your signature into the Report footer, rather than the Page footer...

I presume the checkboxes are unbound? If they were bound to a field they wouldn't do this. You may not be binding them because you don't want to store the values in them - they're just for a temporary need like selecting records to view. If that's the case, perhaps add a field to your table and...

Thanks JHB. The 'safe mode' trick has brought back my Properties window. I thinkit was indeed related to the Properties window being considered part of the CommandBars collection. I'd been using 'DoCmd.RunCommand acCmdWindowHide' to hide the navigation pane. Regarding my other problem, I still...

I don't think the SQL string you've constructed uses the correct syntax. You have two occurences of 'SET', where I think the second one should just be a comma. Try this Dim ContractSQl As String ContractSQl = "UPDATE tblContracts " & _ "SET Order='" & Me.conOrder.Value &...

Hi folks I've been coding with Access for years, but recently think I must have changed a setting somewhere and can't figure out what I've done. Whenever my code experiences an error it just stops processing code - no error messages or anything. I used to get a standard dialog box pop up with...

I just logged on here after going through some old code David wrote for me in 2010 and saw the news that he's no longer with us. Sad news, and looking at his obituary I see he also had great heartache in his life after losing a son who was just 18. RIP David - you live on through your code and...

Hi all I have a report that is triggered from a form. Due to a very strange issue where Access doesn't right-align text properly when printing using my print driver (but right-aligns just fine on another printer), I've come up with a hack which moves a control so it does line up. The code is...