background preloader

Code stuff

Facebook Twitter Assign default values from the last record. Microsoft Access Tips for Serious Users Provided by Allen Browne,

Assign default values from the last record

Created May 2006. Updated Nov 2013. (An older, less powerful version of this tip is archived here.) Sometimes you need to design a form where many fields will have similar values to the last record entered, so you can expedite data entry if all controls carry data over. Set the Default Value of each control so they offer the same value as soon as you move into the new record. The first is best suited to setting a particular field. This article takes the second approach, which has these advantages: Since the new record is blank until the first keystroke, the user is not confused about whether this is a new or existing record.

Note: The code works with Access 2007 and later if the form does not contain controls bound to multi-valued fields (including Attachment.) The steps To implement this tip in your form: Open a new module. The code Here is the code for the generic module (Step 2 above.) How it works. ASP Free Forums - View Single Post - Please please help me...LDAP query works on localhost but not other web server. Stupid htaccess Tricks. Welcome to Perishable Press!

Stupid htaccess Tricks

This article, Stupid htaccess Tricks, covers just about every htaccess “trick” in the book, and is easily the site’s most popular offering. In addition to this htaccess article, you may also want to explore the rapidly expanding htaccess tag archive. Along with all things htaccess, Perishable Press also focuses on (X)HTML, CSS, PHP, JavaScript, security, and just about every other aspect of web design, blogging, and online success.

If these topics are of interest to you, I encourage you to subscribe to Perishable Press for a periodic dose of online enlightenment ;) General Information [ ^ ] .htaccess Definition 1 ^ Apache server software provides distributed (i.e., directory-level) configuration via Hypertext Access files. Commenting .htaccess Code ^ Comments are essential to maintaining control over any involved portion of code. Important Notes for .htaccess Noobs ^ As a configuration file, .htaccess is very powerful. Performance Issues ^ [S=x] [E=variable:value] Server.MapPath Method. Path This method has no return values. Asterisk (*)Question mark (?) Angle brackets (< or >)Comma (,)Colon or semi-colon (: or ;)Single-quote or double-quote (' or ")Right square bracket (])Double slashes (// or \\) The following example uses the server variable PATH_INFO to map the physical path of the current file.

Because the path parameters in the following examples do not start with a slash character, they are mapped relative to the directory that contains the example file. The following example will retrieve the path to the current directory. The following example will retrieve the path to the parent directory. Client: Requires Windows XP Professional, Windows 2000 Professional, or Windows NT Workstation 4.0. Server: Requires Windows Server 2003, Windows 2000 Server, or Windows NT Server 4.0. Dreamweaver CS3 crashes after Daylight Savings Time ends. To view/add comments, you must enable JavaScript in your browser. Issue Adobe Dreamweaver CS3 crashes when working with certain PHP or ASP files in Code view or Design view after the clock goes back one hour, when Daylight Savings Time ends. The crashes only occur when selecting certain lines in Code view, or selecting certain objects in Design view.

The crashes only occur in files that have PHP or ASP code, intermingled with HTML code. The crashes do not occur in Dreamweaver 8 or earlier (Ref. 229536). Reason The Dreamweaver CS3 WinFileCache-AD76BB20.dat file has been corrupted by the time change. Solution. AJAX Database.