Search results for query: *

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...

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

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...

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...

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

By gathering info from a user-form, I create a SQL string to be passed as a query definition in ADO. Creating the SQL string works fine but when it comes to appending the query as a database view, the code takes too long. Is there a way to run/create a select query without using ADO or DAO...

Can anybody tell me why the FollowHyperLink method won't work for PDFs on my computer? It will work for Word documents but for PDFs it looks like it quickly brings up Adobe Acrobat Reader and then Reader quickly closes. It doesn't run as a process behind the scenes, it just closes before it even...

Is there a way to code simple validation when viewing a form as a datasheet? I have Field1 that is Yes/No. I don't want Field2 to allow data entry unless Field1 = Yes. If Field1 = "Yes" Then Field2.Enabled = True Else Field2.Enabled = False End if This code disables all the records for...

I found code on this site that hides the Access Window and only displays my forms if there Pop Up property is set to Yes. However, I have occasionally noticed that the forms won't always open properly. When I unhide the Access Window and go into design view of the form the form area is always...

Not sure if this is possible but I would like to share an MDE file but others may not Access version greater than 2000. Can Access 97 or 2000 open MDE files made in Access 2003? Vince

Hi folks. I can't seem to figure out what is wrong with my append query. I probably don't have the proper syntax by I don't know what that would be for Access. Here is the query: INSERT INTO dt_Field_Parameter IN 'J:\Proj\DB\MODCRCH.mdb' ([Table_Name], [sys_code], [measurement_date]...