Search results for query: *

Doh! Isn't it always the simple things that catch you out (sadly not!). I was obviously too focussed on other potential issues. You are dead right now I've set allow zero length to 'yes' it's all hunky dory. Many thanks - there's a lesson there.

I have a utility that has been converted from '97 to 2003 and now, exporting a table to a new spreadsheet in an existing workbook corrupts both the content & format of the original (1) spreadsheet in the workbook and itself (the new one). DoCmd.TransferSpreadsheet acExport, 8, "tbl" & strLCN &...

I have a simple Append query, previously working in '97 that now I've converted to 2003, won't work. If any record now has a field that contains a blank ("") (they're text fields), and they all do, the record won't be appended. The 'help' implies that this should only be the case if the field...

Thanks Pampers. I had thought of that but was trying to keep away from an additional table as I have an import facility to bring in old dB tables and its just another complication. Thought it should be simple to achieve but looks like i was wrong!

I want to allow a user to change the background picture of form in an mde file. I've added a button that opens acommon dialogue box to select a picture file which is successfully returned and put in the form's .picture property (embedded): Forms![main switchboard].picture = strFilename or -...

I would like to customise my Slide Master Layout to include a subtitle. I know I can add a text box, but this will need to have text in it that must be changed each time. Is it possible to add a "subtitle Area for Autolayouts" placeholder that then behaves in the same way as the existing title...

PHV - Many thanks for your help. Have checked in the debug window that recordset is set to nothing. Have tried DROP TABLE but this is met with the same error. Have tried (manually) deleting the attached query while code stopped at error. This doesn't affect the error. Don't want to just...

Hi Grateful for any help please. I am coding vba in an access 97 database. I have created a temp table from which I have always extracted data at a stage in my application and then deleted it. As a change to the functionality of my application I now use a query based on this table as a data...