Search results

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...

I've created a new database using the standard Switchboard function. However, when I use the Exit Application command the database closes but MS Access stays open. It's a minor problem but infuriating, especially as I've never encountered this problem before and everything I try won't fix it...

I run a multi-user system of over 200 users. The only facility I have for advising an office-wide logout is required is the email system. However, staff either don't read their email or forget so I have to run around like a headless chicken trying to get everyone to get out/stay out of the...

Thanks. I will use Me. in the future but as the system is rather large and was written by another programmer I think I'll change them as I come across them... I have changed the remaining Now to Date. My supervisors have changed their minds again and want the weekly block now removed and...

Got it working! 2nd ELSE Statement was interfering with the coding. The following works... Only problem is my manager now wants a Sunday to belong to the previous week for clearance purposes!! (ie if staff are in on a Sunday they can use Friday as a clearance date). I could scream... Anyway...