Search results

Adrianna I think the Display When property is only applicable on a form. If you wish to print a form, you can choose to display command buttons: Always, Print Only or Screen Only I don't think you can do this in a report. HTH Graham

Philip You could run a new database query from Excel to return filtered information dependant on criteria required. If you go toData >> Get External Data >> Create New Query (Excel 97) or New Database Query (Excel 2000). You will then choose the Data Source (Access Database) >> Select the...

Be Prepared.... For the bloat in documentation size that this may create. It appears that if you create a document containing a large amount of graphics such as this, and as you may save many times along the way, then your documentation may drastically increase in size!! HTH

To be able to print screen shots from Excel/Access etc. to insert into your Word document follow the procedure below: 1. To be able to print the full screen including toolbars, worksheets/datasheets etc. press the print screen button on your keyboard, then in Word click the paste button. This...

You could also try this... Dave On Candace Tripps website there is an example database containing many coloured command buttons Coloured Command Button Example Go to the MS Access Downloads Link HTH Graham

Sara The simplest way would be to create the form, using combo boxes for these fields. The value visable in the combo would be the actual text, however the value bound and stored in the table would be the actual ID number for the particular field. Returning the textual values via a query if...

Sara The design looks to be fine. The ClassCodeID, LocID and CostCtrID will be stored in your tblPosition table as Foreign Keys and related via a one-to-many relationship. If you need to return actual textual values for these then you would create a query to do this. HTH Graham

Knight This topic has been discussed many, many times on these forums. Try searching (using the search facility) for Making Access into a stand alone application or similar. The simple anwer you will find is that you can not make your Access database into an .exe file Happy searching Graham

Brent Try this topic: Winamp & Access HTH

Try the On Load event or On Activate event, these may do the trick. Graham

Andy You may also need to install MyODBC along with MySQL to allow straight connection from Access to MySQL HTH Graham

Vegard I have posted an example on the following thread that may help. This performs the search using option groups and combo boxes, take a look it may be along the lines of what you are after: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=32254 HTH Graham

Stuart You would attach the code to the button on a form that you will run the queries from (supposing this is the way that you are doing it). For example: Private Sub cmdRunHolidayQueries_Click() '------------------------------------------------ 'Attached to command button...

Dani Just amend the height of the subform to enable you to view more records without the need to scroll. Change the height to suit. HTH Graham

DAL You can do this in either macros or in code: Look up Set Warnings in the Help files. HTH Graham

You can still open the database in Access 2000.

You could also try this... On Candace Tripps website there is an example database containing many coloured command buttons Coloured Command Button Example Go to the MS Access Downloads Link HTH Graham

Private Sub cmdExitDatabase_Click() Dim msg As String 'Ask user if they want to run the macro. msg = msg & "Are You Sure You Want To Run This Macro?" If MsgBox(msg, vbYesNo, "User Information!") = vbYes Then MsgBox "TITLE", , "YOUR_MESSAGE" 'Run the macro...

Scott You could use something along these lines: Private Sub cmdExitDatabase_Click() Dim msg As String 'Ask user if they want to exit database. msg = msg & "Are You Sure You Want To Exit The Database?" If MsgBox(msg, vbYesNo, "User Information!") = vbYes Then...

Try This..... Use Win32 API to give your forms irregular shapes: http://www.mvps.org/access/forms/frm0053.htm Never tried it myself though..... HTH Graham