Search results for query: *

Hi, hope someone can help with this and save me some time. I've done 8 pages of flowcharting and now I've reviewed it I realise it would have been much better with an id number at each step. I've found out how to add an id field but this deletes all the text I've already entered. Can anyone...

Thanks for your help so far, Dale, and you're welcome to the star :-) Unfortunately my buttons don't toggle so I think I'm doing something wrong. At the moment I've got buttons to turn on bold and italics, but this doesn't turn them back off so I've added a plain text button to my toolbar as a...

Thanks very much for your help. I've decided to leave the formulae on the protected sheet because the users need to see the impact of their changes, so I've added a toolbar with buttons to insert and delete rows, left/center/right align and bold/italic text. Another quick question - to get...

I've got a spreadsheet with some complex formulae in it that's kept on the server for my colleagues to update with their data. Unfortunately every now and then someone will overtype the formulae with a value and mess it up. I've tried protecting just the formulae, but it causes chaos because...

Got it - thanks. Alison :-)

Thanks for replying, Joe. It sounds just what I want but I can't work out how to do it - I've checked online help and I'm no wiser. I set the spec file up just by going through Get External Data ... and saving it, and I can only select from the list of date types in there. Is there a way to...

I'm trying to update tables from a CSV file when my db opens using: DoCmd.TransferText acImportDelim, "MPAN", "MPAN Details", strFile, -1 The CSV file includes a couple of date fields that I've set as date/time in the spec file but I get a type conversion failure every...

Can anyone help me (a VBA beginner, in case you can't guess)with automating my report generation? What happens is that a directory containing a couple of CSV files is created by our finance system every day and named according to the day, eg Data_File_1_030601 and Data_File_2_030601 in a...