Discussions - comp.databases.ms-access

	How to handle the property setting Single Form in a Sub Form
	Dear reader, I now confronted with the following effect. There are three forms: Form-1 mainform, Form-2 sub and Form-3 sub in Form-2. Form-1 Default View Single Form Allow Form View Yes Allow Datasheet View No Form-2 Default View Single Form... more » By Simon - Nov 21 - 2 new of 2 messages

	Help!! Try to create grid type switchboard for meeting rooms reservations
	All, I'd like to create a switchboard that allows us to see room status. By steve1040 - Nov 21 - 3 new of 3 messages

	Query not returning recordset when code running
	I have a very strange problem which is confusing me. For several months I have provided a reporting facility via my system which uses a query (which is called in a report's Open event) to provide the details of a number of pupils. This query uses two parameters to filter the record source and the value of the parameters... more » By Riverboat Gambler - Nov 21 - 14 new of 14 messages

	How to convert Relationships into the new Access 2010 format
	I have historically used a lot of relations with enforced referential integrity and cascading deletes. Can someone tell me how to convert these into the format required for Access 2010 to be Sharepoint 2010 compatible? bob By Bob Alston - Nov 20 - 1 new of 1 message

	A2007 Security
	My current security process (with A2000) involves: BackEnd: - Autoexec macro with DoCmd.Quit - All tables hidden (prevents unauthorized linking) FrontEnd: - Has Startup form Both Ends: - AllowSpecialKeys = False (prevents F11) - AllowByPassKey = False (prevents holding Shift during startup) - StartUpShowDBWindow = False... more » By zuckermanf@gmail.com - Nov 20 - 1 new of 1 message

	Printing selected rows from subform
	I have a form with 2 subforms – one displaying invoice headers, the other showing the relevant invoice item lines for the selected invoice header. In the form header, I have a combo box with a list of customers. When I select a customer, subform1 shows the invoices for that customer and subform2, the invoice lines.... more » By gorsoft@hotmail.com - Nov 20 - 4 new of 4 messages

	Access 2010 beta - Publish to Sharepoint
	Ok I got the Access 2010 beta. found I must have the database in Access 2007 format in order to be able to see the share to Sharepoint option and thereby get to the validation routine to see if it is compatible with Sharepoint. It wasn't. Three types of errors: Fields with characters not allowed (: ? $ ........)... more » By Bob Alston - Nov 19 - 18 new of 18 messages

Security in Access 2007

I'm writing a training manual for the database I designed. I'd like to include a print screen including the message bar which allows you to click on Options to enable macro content. I had previously declared the database to be in a trusted location, so no message bar ever appeared. Now I can't get it to appear even when I try to bring... more »

By Tomahawk Lady - Nov 19 - 2 new of 2 messages

	Microsoft Ofice 2010 Public Beta Download
	[link] By Bob Alston - Nov 18 - 1 new of 1 message

	Disk error
	Hey, Windows Server 2008 standard Remote desktop on a access 2003 database having linked tabels sometimes (!) triggers diskerror opening a linked table or controls based on this linked tabels. I have no idea how to solve this problem ! I'm only the developper of the databases but can it be caused by the... more » By Filips Benoit - Nov 18 - 1 new of 1 message