Search results

mrxdotcom If you could send a copy of the database mentioned, it would be greatly apprieciated. You will find my e-mail address in my profile. TIA Graham

Thanks Colin, however unfortunately not exactly what's required. The tblTempUsers table already contains the UserID number that I need to append to the tblUsers table. It's just the correct syntax to do this that I am struggling with. Graham

I would like to append a UserID to a table that contains 3 fields tblUsers: UserID UserFirstName UserLastName From a table that contains only 2 fields tblTempUsers: UserID UserName So, this should append the UserID WHERE [tblUsers].[UserFirstName]&" "&[tblUsers].[UserFirstName] =...

How to Print Parameters onto your report: If you've based a report on a parameter query, you can print the parameters as part of your report. For instance, if your parameter is a date, you can print that date in the header of your report. Simply add a text box to your report's header and...

Anna Taken from the MS Knowledge Base: PivotChart and PivotTable Views Microsoft Access 2002 introduces PivotTable and PivotChart views to tables, queries, views, stored procedures, functions, and forms. You can now perform data analysis and build rich PivotTable and PivotChart view...

Wh00t You can also choose to display the Print Dialog Box HTH Graham

JTO Hopefully you should have recieved the example that I e-mailed you by know. You should also check out the Solutions sample database that comes with the Office disks, as this also offers an example. HTH Graham

Jordan76 Try a search of the forums for: Disable mouse wheel , this should return at least 20+ posts covering this topic. HTH Graham

Mermogoat Tools >> Database Utilities >> Convert Database HTH Graham

Cosmos75 I've completed all of the MOUS (or MOS as Microsoft have decided to rename it) in Access 97, 2000 and XP. Apart from the Access 97 exam being Expert level, the other 2 were only released at Core level. They only really test your knowledge of "using" Access and not developing Access...

Rick What may be causing you problems is the design of your tables, although you have not exactly indicated how these are structured. It is just when you mention that you have several of these software fields... My thoughts would be that you have a Many-to-Many relationship present. One PC...

If you wish to open specific documents, and have their details stored in a table containing document name and filepath, then you can use the following from a command button on your form: The details below show how to Open the Word application and view the document specified in the associated...

Groundrush There is also the option to set warnings on or off in the macro actions if you are unsure about using VBA. HTH Graham

Access 2002 System Requirements Access 2000 Systme Requirements Access 97 System Requirements As a student you should also learn how to use search engines and the internet to find valuable resources! HTH Graham

Michael This might help Show Print Dialog box Graham

Try the On Open event. It should fire from there. Graham

Casey You could show the print dialog box - Make Print Dialog Box appear when printing a Report Add the following to the "On Activate" event of the report. This will cause the Print Dialog Box to open so you can choose a printer, and also choose the number of copies .... ect. After you...

marathonlady This may help: Format Tab Controls Graham

Steve This might point you in the right direction: Change Colour of Control HTH Graham

From Access Help Attribute >> Maximum Number of characters in a label >> 2,048 Number of characters in a text box >> 65,535 Form or report width >> 22 in. (55.87 cm) Section height >> 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) >> 200 in. (508 cm)...