Search results

Oops - I should have definitely noticed that after your last post. Thanks a lot Bob, you're a lifesaver. Chin chin.

I've not used any reserved words as far as I know, but thanks for the suggestion. Here it is. It is only intended to be a demonstration of the proposed UI so there is no data. The first form to open is 'Learners', then if you click on one of the enrolments it will load the 'QuickViewAim'...

No, made from scratch in 2007. Here's an example (it's happening on more than one form): Forms!Learners.List18 = Null Just done it now - thanks for the idea. The references are the same default four as the previous version that works fine. Not sure how to do that, but I've only just...

Thanks for the info. So why do you think I am getting the error? I have checked the spellings a hundred times over and they are fine so I am totally stumped.

Hi, I'm a beginner using 2007 and I've just got to the bottom of this weird problem. However, it will be a big inconvenience if I can't get the database working like the old one was so would appreciate suggestions. On the old version of this database I was able to make references in the VBA...

Think I got it - changed the current database options to 'overlapping windows'. Don't remember doing that on the other database - very bizarre. Chin chin.

Hi, I'm a beginner using 2007 and I'm trying to get a form the way I have it on another database but can't get it the same for the life of me - any help would be appreciated. The way I would like it is fitted to the screen height (within the access ribbon etc), centered horizontally, with...

Love it. thanks again david. Chin chin.

It's the front end. Would the AllowBypassKey prevent them from changing the extension from accdr back to accde or only prevent them holding shift?

Ok, thanks hiding them works great and is definitely a big improvement. However, a user can still unhide them.

Ok I'll try hiding them. Yes I have a startup form which is all the user can see in runtime, but if they open the accde they can see the objects on the left. Can I hide all of them then? I'll have a play.

Thanks David, but I have already done that and can still open the linked tables from the fe. Edit - actually I deleted and remade the links after doing the be password - would that make a difference?

Hi, I'm a beginner using 2007. I'm making a split fe/be multiuser database, and all users will have Access 2007 so I don't want to make a runtime-packaged exe really, but I am concerned that data in the backend could be damaged accidently by users if I provide an accde. I know I can change...

Thanks, will try that

Gemma The Huskey, it turns out you were right about the pictures. Two small pictures that were about 300kb at full size added 20mb to the db then a further 20 after it was run (temp files or something like that I guess?). Must have forgotten when I'd put them in and thought the bloating had...

Thanks Bob, will do that next time but too late on this occasion. Have you come across the file size changing before btw? One more question, a little off topic - I had a look at your website and I'm very interested in the fe updaters (I counted three - 2 versions of yours and one on another...

Thanks for the suggestions - I already tried compact/repair though with no luck. There is a couple of images but only on forms and they were there before the file got massive. It was my intention to keep it split but it turned out that the lag on the (rather slow) network was irritating so I...

Hi, I'm a beginner using Access 2007 and have had some strange problems today. I've been trying out splitting my database and making an accde file, but then decided to recombine the database by importing the modules/forms etc into the b/e. Everything seems to be working ok but for some...

Got it - thanks a lot to both. Chin chin.

Hi, I'm a beginner using Access 2007 and I'm currently trying to get a subform looking the way I want it. It's a datasheet view subform that I'm using purely as a (short) list for the user to see - new records / edits etc will be done elsewhere. Therefore I'd like to remove the bar at the...