Search results for query: *

If I don't escape the tags, IIS will think they are ASP tags...

I'm trying to modify an ASP classic file search engine (http://www.webwizguide.info/), since it now finds VB code inside the files. I'm trying to change the regular expression pattern used to avoid searching inside HTML tags to also include <% VBScript tags %>. Original code 'objRegExp.Pattern...

I did a bit of research trying to understand what you did, and I found that the syntax for RIGHT used a semicolon. Then everything worked, thanks a million! Strangely, it seems my installation (Office 2002) requires semicolons to delimit statements in many commands, even though the helpfile...

You do mean in the sheet "ReportPerProjectAndWeek", I presume? It works great there, but your next post also has a formula to put into the same cell, so I'm a bit confused. Didn't quite work, it only filled row 1 of the sheet "Time" with ones. If you wanted me to fill the week row (row 1) of...

Thanks for the quick reply, I'll give it a try right away! Trying to be a broadcast animator while hacking Excel at the same time... :-)

Trying to replace MS Project with a simpler Excel project management planning and reporting tool, but I'm stumbling when trying to calculate how many hours that was calculated and is reported for each project per week. I've set up three namned lists ("Projects", "People" and "TimeType") in a...

Hmm, found out this error seems to pop up for some expressions if a reference is missing. Really cryptic, but here's a thread that pointed me in the right direction: [link]thread181-27567[/url]

Hmm, thanks for your reply, haven't had time to test this until now. However it seems that I can't use "Left" in the control source, I get an error saying "The function you entered can't be used in this expression" I get an error whenever using the Left function, for example: =Left("Howdy", 2)

I'm using a report field with an expression as the "Control Source" so that I can write out the values of several boolean table fields as comma separated text values in one report field. The code looks like this: =IIf([Media_Files]="-1";IIf([MF_Music_Files_Bol]="-1";"Music, ";"") &...

How can I programatically set the sort order in the Sorting and Grouping dialog? I'd like to let the user change the sort order of the report based on a drop-down. Setting the "Order By" and "Order By On" properties for the report doesn't do anything. The only thing that works is setting the...

Ahh, found a way: =IIf([Category_Games]="-1";"Games ";"") & IIf([Category_Movies]="-1";"Movies ";"") & IIf([Category_Others]="-1";"Others ";"") /Jonas

Can't seem to find out how to summarize several table fields into a single report field. I have several Yes/No fields: Category_Games Category_Movies Category_Other ...that I'd like to summarize into one report field that displays something like: [COLOR=blue]Games, Other [/color...

Dalain! You've saved my day, a thousand thanks!!! It works great, and I just realized that the key violation was caused by using the BeforeUpdate event; the record I tried to insert contained a Person key that hadn't yet been created! Using AfterUpdate, everything works. Now I just have a...

Dalain, Despite your example; I can't quite get it to work. Problem 1: I have added a hidden field containing the ID_Case, and called it edtCaseID. The combo box I have called cmbExistingPersons and the row source is SELECT DISTINCTROW [ID_Personal_Info_Def], [First_Name] & [Last_Name] AS...

Thanks for all the help, I'll get started coding as soon as my wife wakes up, until then I'm confined to the couch watch morning cartoons with the kids. :-) Concerning the image, just add a link

The family hasn't woken up yet, so I'll continue... :-) Dalain: tbl_Case_Type_Def was the wrong SQL, sorry for the mix up. Thanks for your hand-on code, I'll try it out in the morning when I'm able to type a bit more freely. :-) Yes, the combo box does display all DISTINCT persons, but I...

Thanks for your replies, I'll try to type quietly so that the family doesn't wake up (it's 2 AM here). :-) Eupher: 1. I was suprised how difficult it was to use a subform with lookup tables. A SQL-knowing friend helped me out with this one, and it works, but I just realized I had copied the...

None of my brand new Access 2003 books have any examples of the simple task I'd like to perform, so I'll put my faith in you guys... Here's a screenshot with relations and all: I have a subform displaying people connected to a case. These people are all linked via a lookup table. When...