Recent content by DataFanatic

Thank you for the direction. As always, you folks are quick to help.

I am attempting to share a back-end Access database to allow multiple users. There seems to quite a slowdown when the second user opens a form to view any data. I have searched for the proper way to configure connections and am coming up a little short. I have all forms using queries not...

Thank for your reply. The link was quite informative. Using that information I am able to string together the existing header and a value that I store in a cell. I have been trying to use help to display all of the possible variations of Activesheet.??.?? to see just what is available. Are...

I am attempting to create a report in Excel with the ability to include a variable name in the custom header area. It seems that if the ability to include current date and time, that a variable could be available. I want to refer to cell A1 for example to include that cell value in the report...

As always you guys are superior. Glenn, your question tied right in with Blues query of the range size. There was one additional cell in the CNUM range from the LTD range. That change fixed it. Thanks again for your knowledge and willingness to help us mortals.

I have used SUMPRODUCT in the following way: =SUMPRODUCT((CNUM=A6)*(LTD <=$F$1)) where CNUM is a named range of customer numbers and LTD is a named range of numeric values. $F$1 currently has the value of 10. I have created a new sheet with updated data and #N/A is being returned as opposed to...

I built this routine from information gleaned from this site about three years ago. There was a FAQ that I unfortunately no longer have a link to. Regardless, this routine allows a user to select from none to over 127 different machines for downtime analysis. PHV was very helpful during my...

What happens with LEFT(A2,6) and TRIM(RIGHT(A2,6)) Assuming that the MAX value is 999.99

Thanks for jumping in to offer assistance. You guys are great.

Borislav, You're right. Here is great. Also the BOL was something I was unaware of. I was searching through the help file and finding nothing. (I now know it was help only for the MMC). What a great journey this will be. I have implemented things today that are very clear thanks to your...

Borislav Thanks very much for the response That works! I am very new to this stuff and have been getting little bits and pieces from this forum to get to where I am. If I can impose once again, what would be the best resource to track down these type of questions in syntax etc. Thanks...

I am trying to use a field in a table to provide the variable for this query. I get an error: "The column prefix 'tblvdte' does not match with a table name or alias name used in the query." I have searched the error and found little to aid me. Here is the query: declare @rundte as int set...

Zameer, Thank you for the link. It was very good reading. I actualy posted this in the wrong forum. Regardless, I always appreciate your help in these forums. Thanks again.

Pete, I did some more checking (without the blinders) and sure enough, there they were. I sure appreciate to helping with this and I forgot to give you a star for the effort.

Pete Thanks very much. That certainly does the trick. I have searched for this type of information with no success. Do you have a suggestion on where to get this info. It appears that Button is a reserved word and acLeftbutton etc are returned values?? (Y/N) Anyway, thanks again for direction on...