Search results

Thanks for the code snippet, Kodo. I'll give it a try and see what happens.

Fair enough, Kodo. But I'm still not clear on how one would go about isolating a specific aspx page (i.e. LogOut.aspx) from being verified using Forms Authentication. Is that something I can set in the web.config file? If so, please advise how I would go about doing that. Much appreciated!

No. You misunderstand. I have a menubar on top of my main web page and there are links that take you to different pages. My last menu item is a LogOut link that allows you to exit the system completely. However, if there has been inactivity for a predetermined amount of time beyond the...

I'm using Forms Authentication for my ASP.NET web application. When the session times out and the user tries to navigate to a different page, he/she will be redirected to the login page (based on the loginUrl) where he/she will be prompted to re-enter his/her credentials. HOWEVER, I don't want...

I would like to be able to PROGRAMATICALLY import an Excel worksheet into a database and append it to a table. Simple, right? Just one caveat. I would like to ensure that during the import process the values of the Excel worksheet are consistent with the design of the table structure that...

Age of a person given birthdate DateDiff("yyyy", [Bdate], Now()) + Int( Format(now(), "mmdd") < Format( [Bdate], "mmdd"))

Is it me or is there a glitch with Access 2000 where no matter how you close out (correctly or incorrectly), it will raise the "SUSPECT STATE" flag advising that your database may be corrupted? This also occurs when you use DAO and programatically close a database recordset. Any ideas why this is?

Parameter default values Although I tried Ian's and his solution is more streamlined. Touche Fornatian!

Default value for parameter query raskew, You are a life-saver!!!!

Is there a way you can place a default value in the box of a parameter query (i.e., current date for a date parameter)? Similar to what you can do with an InputBox.

I imported a spreadsheet in Excel to an Access table but unfortunately brought those nasty control code characters (i.e., carriage return, line feed) in some of the column fields that look like hieroglyphics. Is there anyway to write an update query to remove those leading and trailing...

Don't everybody all reply at once... I don't think the servers that operate this forum can handle the load.... But seriously, let me know if I've stumped you great minds or if I should file this post under unsolvable

RHomsey, Go to the design grid of your queryand add the table or query that has the field values you want to convert to a percentage. Then add a field called Answer (or whatever you want to call it) that will hold the final result. Check the jpg I've attached as an example...

I'm designing a macro to perform a multitude of processing tasks. The first step involves importing a table from one MS Access database (which is password-protected at the database level) to another. When I reach the point where the macro is attempting to import the table, I get a password...

Much appreciated, Tim.

Use this syntax in a query expression Format([FieldName],"Percent"). This will convert your final results (make sure the values are in 1/100th by using the Double number type)into a percentage.

Above is a delete function I created on a Form using the command button wizard in MS Access 97. The only additional line of code you will find is an action append query designed to add a record from one table (tblActive) to another table (tblArchive) just before the record is deleted from the...

Try using the domain aggregate function DSum(expr, domain[, criteria])) on the unbound control and complete place the date range under the applicable criteria parameter

Try This: SELECT * FROM [Table1] WHERE trans_date>=DateAdd("m",-12,Date());

You can use the DISTINCT command in a query to elimate duplicate instances of the same value thus producing a unique set of records. You can also use the "Find Duplicate Values" query wizard that Access (97 has it but I'm not sure if version 2K does) provides to isolate those values that have...