Search results

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

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

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

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

I have a HUGE system which presently restricts updating a "Final Action" date to today's date only. However, I want to change it so users can input dates for only the present working week. The present coding is as follows... Private Sub dteActioned_AfterUpdate() Dim strTime As String strTime =...

Hi all - new to this forum so hope you all can help! I recently took over admin duties on a multi-user (234 users and counting) Access system (CCUSYS). Whilst compacting the linked data file (CCUDAT) my PC crashed and the file subsequently required repair. I managed to fully repair the file but...