Recent content by Doctor Kronenbo

I posted this so long ago and I have so many databases on the go I can't remember which one had the problem! But I must have resolved it somehow. Thanks for replying though!

Thanks for your reply! I tried the extra 'and' and got a syntax error as coding later in the form's code affected it. It's hard to explain without posting the whole code...

Hi, I'm trying to join together two tables "tblApplications and tblApplications1" in an SQL statement to combine results from the both of them. The present SQL statement used on just the one table is as follows: varSQL = "" varSQL = "SELECT tblApplications.* FROM tblApplications WHERE (...

I have a form with Continuous Records as its default view. I would like to number the amount of records displayed on screen to about 5 or 6 at a time instead of having them scrolling right off the bottom of the screen. Is there any easy way to do this? Thanks

It's actually Doctor Kronenbourg. A log in name I use in a few forums. Unfortunately I didn't notice that Access Forums had a limit on the number of letters when I set up my account. And no I'm not a doctor, it's a beer related in-joke.

Will give that a go. However the problem seems to lie in the fact that the image is tiling (it's just a small background image with a light blue rock texture). If disable the tiling there's no flashing but obviously the image hust appears whereever you align it. With try creating a larger...

Thanks. But still flashes like a Christmas tree.

yeah tried that too. Same problem. Thanks for replying anyway. All the best.

whoops sorry mistyped - it's only 3.9 KB!!! It's a JPEG.

Yeah, that's how it's setup already.

I have a minor but irritating problem with a small database I have created. When my main menu loads up it keeps flashing until all the data has been displayed (its looks up the user name and version number from tables and also displays the date). I've traced the source of the problem to the...

Many thanks for your reply! Unfortunately my employer, the esteemd British Government, has tight rules and regulations about downloading and installing software from outside sources onto our systems so the links supplied will not assist in solving the problem. However, the sites did provide a...

I have a file inherited from another designer that I wish to modify. However, I have discovered that it was made an MDE file and therefore I can't access the modules within the file. I also don't have the original file. Is there any other way to remove MDE settings and gain design access to...

Problem solved. I sorted it by creating an Exit Macro and calling it from the Switchboard. Works fine now. Thanks for your help.

I've tried integrating the DoCmd.Quit and Application.Quit commands into the switchboard code but neither has been successful. I don't have any BeforeUpdate code anywhere in the project. I do have an Exit Application button on the main form and that works fine. Could this interfere with the Exit...