Search results

Fantastic!! Many thanks.

In Access 2016 on the debug toolbar, I can't see the buttons for "Comment Block" and "UnComment Block" and I can't see any option to bring them onto the toolbar. Can anyone advise on how to bring these two buttons to life?

Yes. Thank you. I am clicking on that and all I see is an empty white box. If I select Date/Time, then I get a range of options in the box below. But if I choose Number, there are no options beneath Long Integer. It's very strange!

Thank you for your reply. I am creating a brand new database in Access 2016 and the Number datatype offers only Long Integer. I am working somewhere else today and will try there too, and will update this thread.

In Access 2016, on more than one computer, the Number datatype in table design offers only Long Integer. There is no option for Byte, Integer, Single, Double etc. At the moment, the only way round seems to be to create the table in another version and then lift it across. Does anyone know if...

Many thanks for all of your help. The link you enclosed is very useful reading too.

I tried the initial idea of preparing the Report text boxes with the properties I prefer. Then I went to the Design tab and clicked on Text. As soon as I did that, the details in the Properties dialog jumped back to the Solid Border with Calibri font. I've tried the global method and set the...

That idea sounds ideal because then I could set the font I like as well. I've tried it but I must be doing something wrong as it's not working. I tried changing the "Partially Enclosed" radio button to "Fully Enclosed", but it didn't have any effect. I'm also trying to remember how to set it...

Many thanks for your message, especially the warning about it being only for that report. Very much appreciated. Thank you.

In Access 2016, text boxes in reports seem to be defaulted to border style: 'Solid'. Does anyone know how to change that default to 'Transparent'? Similarly, the shading in section headers seems to be Alternating colours. I am hoping to set that default such that they are all the same. Any...

Fantastic! That works a treat. Many thanks. Andrew

Simon - Many thanks. I'll definitely try that.

I am wanting to insert a Barcode ActiveX control, but it is not listed. In an instruction video, after clicking on ActiveX Controls, the one named "ABarcodeActiveX" is at the top of the list. Can anyone advise me how I can obtain this. Thanks.

Many thanks, CJ. I'll give that a try.

Paul. I have put in a criteria at the end of the expression to see if the value = the one I'm looking for - and it works!! Many thanks for your suggestion. What a great forum! Thank you. Andrew

David Many thanks. I had been wondering if I should "start from the other end". I'll try your idea. Thank you. Andrew

Paul. Many thanks for your reply. At the moment, I am using: If (StartDate Or FinishDate) = DLookup("StartDate", "qryStaffConfliction") Then DisplayMessage ("Please check for Staff confliction"). So at the moment, I am not using a criteria in the final section of my LookUp. In...

I enter workshifts for staff and need to check to make sure that a person is not already working somewhere else on that date. I am using the DLookUp function to see if the proposed date matches any existing bookings. This works fine as long as there is only one date standing in the LookUp...

Many thanks. I'll give that a try. Much appreciate your advice. Regards, Andrew

Many thanks. Much appreciate your help. I'll give it a try. Andrew