Search results

I have a user who has a front end copy of the database on his desktop. He often gets a lock file on his desktop that does not delete on closing the database. To get rid of it he is forced to reboot his computer. Any ideas on why this is happening?

bIsMultiValue = (rs(0).Type > 1) Are you talking about this part of the code? I assumed that I should build the below fields into my query... and not into the VBA, Is that right?

Below is how my sql would look. I have Four fields that are being concatinated, but the four fields do not always have the same count. The correct counts seem to populate in the query. SELECT Material_Description.ShipperID, Count(Material_Description.Material.Value) AS...

OHHH.... No it printed the word "False"

It appears that bIsMultiValue is the result of a determination of weather or not the requested field is multi-valued. I don't know how this is determined..."Type is above 100". Does that mean that it has at least 100 characters (even if they are blank)? Set rs =...

Yes----It prints "Bug8" which is right before the line- If bIsMultValue Then

When running the following code, it never prints Bug9-12, even though it is processing multiple values. However I have no idea why... Do While Not rs.EOF Debug.Print "Bug8" If bIsMultiValue Then 'For multi-valued field, loop through the values Set...

Thanks! I was able to watch the video from my phone, and was able to gleen some good ideas from it to help me. I will watch it again when I get home, and view Paul's link also (I can't access them here).

I put in the breakpoint and Debug.Print Statements, one before and one after the Debug. There is no print statement that I see. Of course i don't really know where to look for it. I'm expecting it just to pop up somewhere, but I don't see it. Below is only part of the code....the * is...

Thanks Paul....Yes, That appears to work! I had to put a SELECT DISTINCT at the beginning to remove extra lines of data, but it seems to return what I need without the parameter boxes. As an added bonus, it returns the data a little more quickly which was another problem I was having...

Iteresting....I think it's because of the concatRelated. This combines multiple rows. I'll play with it and see if it will fix the problem.

Re: Problem Solved Problem Solved-I needed another query to pull out the expressions.

Re: SQL - Abrigded version (Unnecessary stuff removed) SELECT Current_Shipments.ShipperID, ConcatRelated("MaterialsID","[Concat Materials]","ShipperID =" & [Current_Shipments]![ShipperID]) AS MaterialsORDER, ConcatRelated("MAT","[Concat Materials]","ShipperID =" &...

Re: Parameters The parameters it's asking for are R MATID PKGID EQUID

Here is the SQL code SELECT Current_Shipments.ShipperID, Current_Shipments.[Departure Date], Current_Shipments.[Arrival Date], ConcatRelated("MaterialsID","[Concat Materials]","ShipperID =" & [Current_Shipments]![ShipperID]) AS MaterialsORDER, ConcatRelated("MAT","[Concat...

I have a querry with multiple expressions. All but one of the expressions generates a paramenter box on opening the query (which I do not want). I need to understand why it is doing this and how to get rid of it. Any ideas?

Well the end result that I need is this.... The code needs to do what it says it does and exclude null values AND zero string values so that the comma is ONLY there IF a value exists. How to get there is not apparent... But my first thought is that I need to put something in the...

Your response led me to believe that there was something really obvious that I wasn't understanding soooo.... I set the breakpoint....then I ran the query (which I hadn't done before) It tripped the debugger and highlighted the line where I set the breakpoint. After that I was able to step...

Thank you for bearing with me... I have inserted a breakpoint, removed the Debug pring statement and am now trying to press F8 to step through each step. Nothing seems to happen when I click F8. I would expect for it to highlight each line one by one, but it's not doing anything.

I've responded to this in the VBA Programmers Forum as my question seems to have morphed into a coding issue. :) You can find my response here: http://www.access-programmers.co.uk/forums/showthread.php?p=1193766#post1193766