Discussions - comp.databases.ms-access

	Email with Error 53: File Not Fond
	I have 23 users on a WAN in 3 wide-spread geopgraphical US regions- UpstateNY, DownstateNY and New England. There is code in an A2003 app to prompt user to send and email (Corporate configured Outlook 2003) of a report to a specific person in the company (Vicki O'Leary). Although every user has not had occasion to use the auto-email... more » By isobadd - 10:33pm - 1 new of 1 message

	there is a good news for every one ,have a look
	Contact with me: E-mail:onshoes2...@gmail.com Yahoo:tradertrad...@yahoo.cn MSN: nikeb...@hotmail.com Our website:[link] Footwear (paypal payment) [link] Nike Airmax 2010 New,AirMax Wan Premium,AirMax Skyline,AirMax 2009,Airmax 87,AirMax Light 88,Air Stabb 89,Airmax 90,Airmax 90... more » By tina - 7:47pm - 1 new of 1 message

Checkbox in form detail section not updating changes

Hi, I feel like such a newbie! Sorry! But I can not figure out why a checkbox in the detail section of a form reflects any change made to it but when I go into debug, it is always set to True when I am trying to update a table. I uncheck it in the form but it remains as True. The field in the table is a Yes/No field. I have tried setting the detail section to... more »

By PW - 6:30pm - 2 new of 2 messages

	Creating Snapshots - Destinations Path length Limit?
	I'm using Access 2002 to create a snapshot using: DoCmd.OutputTo acOutputReport, strReport, "SnapshotFormat(.snp)", strSnapshotFile It works fine for the following path for strSnapshotFile: \\server\dpcman\Tenant Statements\091123\301 Coronation Drive, Milton\Carbon Energy Limited\Tax Invoice and Statement.snp... more » By Bob Darlington* - 6:06am - 3 new of 3 messages

	Question on Albert's video regarding A2010
	In the vid Albert has on A2010, [link], he placed the temp of the area on the page. How is that done? He mentioned a web control. Do you drag a web control to the form and it would be similar to a hyperlink in a table that stores the link to the external site?... more » By Salad - Nov 22 - 8 new of 8 messages

	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 - 4 new of 4 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 - 15 new of 15 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 - 5 new of 5 messages

	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 - 2 new of 2 messages