Search results

I'd have in really small letters so people would have to get close to read it... You're standing on my n*ts!

To do this, all your forms will need to be set up as pop up = Yes, Modal = Yes and all your error handling must be correct or your database will open without being visible and you'll need to reboot to amend the errors because it will not even be visible in the Task Manager. Copy and past the...

Maybe create several car shaped forms and use DoCmd.MoveSize on a timer event to race them around the screen....We could have bets and everything :rolleyes: :D

Unzip the folder to your desktop and open the db :)

I think this is better :D

I use Real VNC... http://www.realvnc.com/

Nothing will be lost if you import everything into a new database. As it stands at the moment, it sounds like your db is corrupt, that's why it won't compile.

Right click in a blank area on any of the tabs, left click on Import and select your db

Try importing all your tables, forms, queries etc into a blank database and running it again

All sorted, I did it by renaming the reports caption dynamically before firing the SendObject :)

Does anybody know if it's possible, using the SendObject command, to change the Name of the attachment it creates? Rather than having the Name of say the report, changing it to tha date/time. Any help appreciated.

Me.YourTextBox = ""

Glad it worked :)

You could use something along the lines of.... Private Sub YourMemoField_KeyDown(KeyCode As Integer, Shift As Integer) Select Case KeyCode Case vbKeyReturn MsgBox "You Pressed Return" Me.AnotherControl.Setfocus Case...

You could try playing with this.... Function ChangeProperty(strPropName As String, varPropType As Variant, varPropValue As Variant) As Integer Dim dbs As Object, prp As Variant Const conPropNotFoundError = 3270 Set dbs = CurrentDb On Error GoTo Change_Err...

You must have mistaken me for someone else :D

Look up... DoCmd.MoveSize ;)

Where are you having problems? You could post a stripped down version of your db if you want us to take a look for you.

You could create a table with two columns. Column one ID number (not autonumber), column two all your reports, then base the listbox query on that table and order by number.

Create a listbox on a form and call it LstReports. In the Multi Select properties select 'simple'. In the Row Source place the following query... SELECT MSysObjects.Name FROM MSysObjects WHERE (((Left([Name],1))<>"~") AND ((MSysObjects.Type)=-32764)) ORDER BY MSysObjects.Name; This will list...