Search results

Cheers! That's Useful to know how it can control the display of Null values. I think I can safely remove the symbols from the rest of the fields.

Thanks! Just looked it up. However, I'm unsure why this would be added, when the DataType is already set as e.g. Short Text in the Data Type field (when in Design mode). Any idea?

Hi all, I've inherited a database and many of the fields have an "@" in Field Properties > Format box. In one case, the @ symbol was causing the Long Text to be truncated, but I haven't found any other issues with the @ symbol being present. Does anyone know if the @ serves any particular...

Yep, I think if I were to do it again, I would try something similar to your method to test it out, and to reduce the potential for errors. If I end up tweaking it, I'll post! Thanks all the same :)

Hi @sxschech, Thanks for the reply! I need to set both the rows and columns dynamically so tried your second line (needed to add another bracket after the ...lastcol) , but got an error message from that line of code: Compile error: Invalid or unqualified reference I did however manage to...

You put me on the right track and I've now got the code to add the hyperlinks working (tidied too), albeit with .Activate used: Public Function export_spreadsheet() On Error GoTo ErrorHandler Dim xlApp As Object Dim xlBook As Object Dim xlSheet As Object Dim db As...

I used this as it worked in the Excel vba to limit the range to only the used cells - the number of columns/rows may change in the export so I wanted it to be dynamic. Please can you suggest what I should be setting this to?

Hi @theDBguy, I thought that originally, but the issues is that only a small fraction of the rows in the table/query need the hyperlinks (blame bad database management which I can't change). In Access, I couldn't find a way to only format certain cells/rows in a field as hyperlinks. My...

Hi All, EDIT: I've now got a functional piece of code that exports a subset of my Access table to an Excel spreadsheet. Within the exported spreadsheet, the code also finds the cells which contain a certain value and replaces this value with a hyperlink. (I was previously having issues with...

Hi all, I'm relatively new to Access and have been using it intensively for a month or so. I've found this site useful for tips and advice so thought I'd join! Outside of Access I like climbing and cooking, though I haven't been doing too much of the former lately. Thanks for all the...