Replies

Gee Alan, I am impressed! this works beautifully.

Thanks guys, ufortunately my scanner won’t let me use a dll – it demands an EXE so i’ll just have to use paint.

The error was “Kent had a brain meltdown” The line I am actually having a probem with is –
strTable = “demographics”
DoCmd.TransferDatabase acImport, “Microsoft Access”, Me.txtLabelPath, acTable, strTable
This one error with runtime error 2006
The object name you entered doesn’t follow , object naming rules.

it looks like I left the destination object name off the end. Now it works. Bad day, lost the plot.

Found the problem – somehow I had a query named tmpImport1. but here’s another one, and I’m ashamed to say that I used a macro for the first time in ten years, to get around it, but the macro is not flexible enough.

‘ Import the text file using the specifiction
varSessionAttendanceScan = “SessionAttendanceScan”
DoCmd.TransferText acImportDelim, varSessionAttendanceScan, “tmpImportSessionAttendance”, strFileName, False

what is wrong with this line?

The Lebans solution should do the job. They actually want to print each second pair of records upside down. I can use Mod to control which set of controls are visible. They also had a solution to change the colour of control buttons – very useful, thanks for the tip.

That is much easier to remember – thanks

That’s nailed it, thanks Hans you are a star.

Ahh! Thanks for that. I looked there but didn’t see it – its so much easier to find something when you know what you are looking for.

I checked and it would seem that maybe something is corrupted with the database so going back to a previous version has solved my problem if not my curiousity. Thanks for your help.

that’s what I wanted – Thankyou very much.

Thanks for the fast reply. I have a copy of the database before I applied a database password. In the short term I can just disable the shiftkey on startup using the Property Editor written by Jamie Czernik but somebody could still edit this property to gain access. Previously I have applied a database password that was only prompted for when I opened the VBE I thought that it was the database password. this allowed users to edit and create reports and forms but denied acces to code which is what I want.
Do you know how to set the VBE password?

Yo R D Man!!
That fixed it thanks big time.

I had already tried the second suggestion and really felt that your first suggestion would work but alas…
any other suggestions?

Thanks Guys that’s exactly what I wanted.

I found it – it was greyed out because the database was in 2000 format. All is now right with the world, thanks.