Search results

I Always backup my databases, backend and frontend, regardless of them being backed up on the server. If the server fell over, I could easily run my db's from a single pc, which would be of no use if the data was out of date ;)

Creating your own switchboard using forms would be the easiest way, but I believe it can be done with the switchboard manager. Tools >> Database Utilities >> Switchboard Manager

Select the cells you want a checkbox in and run this.... Sub MakeCheckbox() Dim myRng As Range Set myRng = Selection For Each ctrl In myRng.Cells ActiveSheet.CheckBoxes.Add(ctrl.Left, ctrl.Top, ctrl.Width, ctrl.Height).Select Next myRng.Select End Sub

Did you try my example? I would personally group the reports/workbooks in their respective sub folders under the main folder and have the user select which folder they need to print. For example, if the main folder was "Cars", I'd have "Ford", "BMW", "Volvo" etc. as the subfolders holding all...

Example...

You could use something like this.... Option Explicit Private Sub PrintAllWorkbooks() Dim wb As Workbook Dim ws As Worksheet Dim MyFolder Dim I As Long Application.EnableEvents = False Application.DisplayAlerts = False Application.ScreenUpdating = False MyFolder = GetFolder...

Will the files always be in the same folder?

Application.DisplayAlerts = False Your Code Here Application.DisplayAlerts = True

This is a very simple example of logging every time the database is opened or closed to a text file.

=substitute(a1,"?","")

=LEFT(A1,LEN(A1)-4) With A1 being the cell with the string. :)

I'm wondering why you have a link in your sig :rolleyes: http://www.access-programmers.co.uk/forums/showthread.php?t=68868

while scratching her

The end? :rolleyes:

Unfortunately, no. :( I believe this to be the only way to hide the Access environment.

The folder where you put the db needs to have a sub folder called 'Interface' containg the image. So if you put the db in C:\Test\ the image would need to go in c:\Test\Interface\

In the sub ShowMe() 8 is the start size, 104 the finish size. For I = 8 To 104 Step 4 If I < 73 Then Me!lblSAMPLE.FontSize = I If I = 40 Then Me!lblSplash.Visible = True If I > 39 Then Me!lblSplash.FontSize = I - 32 Me.Repaint Try changing it to something...

The same with a progress bar

Not a progress bar, but I think better :)

You can use the snapshot viewer control on a form :)