Recent content by vpellerito

Oh that's right. I forgot that was possible. Thanks! Vince

I'm currently using the IIf function in my access queries when I need to test against values, but I was wondering if there was a switch or case function that I could use instead. I've used "Select Case" in VB but I know that won't work in an Access query. Is there such a function that works in...

Thanks for your responses. Sorry for my late response but I was away this weekend. The reason why I asked how to set an array value to the maximum value allowed for a Double data type was because this was what was done the original author of the code. I want to take some code written in Fortran...

I'm trying to set the value for my array to the maximum value allowed for a Double data type. How do I do this without explicitly setting a constant (which I can't seem to do anyway)? I've seen this as a property in some languages but not sure how it works in VB. Thanks

I'm having a similar problem. Though it seems as though it is a session / connection timeout causing the problem. See this thread http://www.tek-tips.com/viewthread.cfm?qid=1334958 I'm using Access 2003 as my front end with links to a SQL Server 2005 database. I seem to be periodically loosing...

Thanks. No answer on what happened to me but plenty of ways to prevent further problems. Decompiling the FE on opening sounds like a good habit.

Working in Office Access 2003 (Access 2000 file format). I found this Microsoft article that discusses this happening but it doesn't match my scenario. http://support.microsoft.com/kb/223199 I was working in a form and testing my code so I had the VBE window showing as I tested the form...

There are people with different versions of Access in my office (2000 to 2007). I created a database in 2002-2003 that opens alright in 2007. However after it is opened in 2007, I can't open the database in 2003 (my version). The database closes due to the error giving my the option to create a...

OK. I figured as much. I knew that it could be done by manipulating a recordset in VB because I have control over the "cursor" as it goes through a set of records and specific criteria but I didn't think it would be possible using straight SQL. The FAQs faq701-3499 and faq701-4233 pretty much...

Is it possible to write a SQL select statement that grabs values from one or many fields (of a particular grouping ) and displays as a single concatenated field? For example, Project, Station, Question, SubQuestion, Response KK-55, 10, 1, A, Boat KK-55, 10, 1, B, House KK-55, 10, 1, C...

Thanks Missinglinq. I misspoke when I said the Dirty property doesn't work. I did mean that the formatting I wanted wasn't showing through in Datasheet view like I had coded. Which was why I was looking for a an expression to add to the Conditional Formatting of the form that would take in...

The Dirty property doesn't seem to work when the form is viewed as a datasheet. I could make the form Continuous and try to mimic the functionality of Datasheet view but that option seems like it would take more time than it's worth. I was looking for a way to change the format of the...

Is there an expression I can place in the Conditional Format of my datasheet that works when the current record is being editted (Dirty)? I have used VBA code for the Form_Dirty event in the past but this only works for Form views, not Datasheet views. Thanks. Vince

Thanks Remou. That thread was very helpful. Vince

Well, I read elsewhere on this site that ADO was faster than DAO. Is that not the case? Vince