Search:

Hans

Thank You.

Took me a while to work out the sections bit, but now I've got it the form works perfectly http://windowssecrets.com/forums/images/smilies/biggrin.gif

Hello All

I've created a form to be used for reporting incidents, as such it takes the user through the process in a step by step manner and, where necessary, restricts the answers to Yes/No.
...

Thanks Hans, works a treat http://windowssecrets.com/forums/images/smilies/biggrin.gif

Hello again

How can I find out who the users are in an Access Database? I seem to rememer an old post containing instruction on how to see who currently has an access database open, but search...

Hans

As ever I owe you my sanity. I guess I'm just not familiar enough with VBA to see the simplicity of it all.

In 10 minutes you've shown me how to do something I've been failing to do, on...

OK, Sorry, been beaten with this for so long I assume everyone knows what kanban is...

The attachment is what I'm trying to produce, the columns under the green header are the ones I get from the...

Dear All

I'm trying to persuade Access to build me an audit sheet for a kanban system.

Currenlty I've got a query provides the data I require and some code that copies the query into Excel,...

Hello again.

I'm trying to get a spreadsheet to return a single value, from column Z, where Column A matches Column X and Column B matches column Y.

I've used vlookup extensively in the past,...

The CSV values are all 2 digit alpha numeric values, for exampe the string starts (400 values in some, so only a few here) 00,01, 02, 03, 04 etc

I'd want to replace the complete, but then only...

OK, answers /forums/images/smilies/biggrin.gif

All cells in specific range, basically I've got a column in the spreadsheet with these CSV strings in.

There's only worksheet in each of the...

Dear All

We are using some spreadsheets to prep data for loading onto a server, during the preparation work I've managed to persuade folks to load less data, this has resulted in me now needing to...

Another voice from the masses, thanks for the hard graft, my computer is a much friendlier, better behaved, tool now you're back /forums/images/smilies/biggrin.gif

Hans

Thanks, the DAO stuff worked, I'd tried to convert it myself yesterday, but didn't get past the error message, just got many other varieties of error message, all with the same sort of...

Right, been doing some digging on the MS site and found this knowledge base article, http://support.microsoft.com/kb/248144 which says the error message is by design. So, what do I need to do to get...

Hans

Thanks, I can follow most of this, although the ADODB is a bit odd to a DAO luddite like me...

I've got the error message 3251, Object or Provider is not capable of performing requested...

(Edited by HansV to make provide link to post - see <!help=19>Help 19<!/help>)

Hello Again.

I'm trying to get Access to copy around 220 file names from a specific network folder (I can move...

Thank You Hans

Dear All

I am trying to use the iif in a query to convert the first two characters from a field into a predefined text value, I can actually make this work <img src=/S/shocked.gif border=0...

Thanks Hans

Had to do a little bit of modifying (I'd not mentioned the columns after M......) but it's just completed in ten minutes wht I'd spent most of Friday afternoon starting off.

Thanks...

OK, I have a number of work sheets that have alpha characters in one cell in the row. What I would like to be able to do is to create a new row, that same as the original, but with only one of the...

<img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30> <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

So, that's why it doesn't work from a command button or while...

Hans

Thanks for that, but I'm getting error messages, not concatenated strings....

The errors are: -

expected line number or lable or statement or end of statement if I use...

Hello All

I have a need to concatenate a whole load of cells (300 plus) into one string, the contents of each cell must be separated by a comma followed by a space. Is there any way I can do this...

Apologies Hans, the spreadsheet is the template. The cell D32 has the validation criteria in it, this criteria is applied to two cells (I29 and I30), the problem is that where the data used to...

Dear All

I have a spreadsheet that is populated with a varying dataset. The data is related to delivery performance and one of the cells validates the average performance and the most recent...