Recent content by stringman

Any thoughts on this? Maybe what I'm asking is not clear? Any help would be greatly appreciated. Ken

Hello. I am trying to automate a PP presentation. The slides are populated by images that exist in a directory. I have been struggling to format one of the images all day and have hit the proverbial brick wall. I am using Access 2003 to generate this code. The problem is w/ the following...

RuralGuy, Thanks for your help. Everything is working now. For some reason, setting arrSplit to variant instead of string was causing the "Type Mismatch" problem. Just some formatting issues for me to work out on the output. FYI, here is final working function: Public Function...

I used variant because the input is double and the output is a string. I think you fixed that problem by making the function and variable different types: Function Dec_to_DMS(dblCoord as double) as String

I found the reason I was getting the "Undefined Function" error message. I had 2 copies of the same function inside the same module. Different editing stages. Pretty stupid. I have also found other errors where the variable names were not consistent. The new function is below w/ changes in...

I made the changes you suggested and now the function has no value w/in the parenthesis. I used to get "Dec_to_DMS(dblCoord)" after selecting the function. Now I get "Dec_to_DMS()". Anyway, the module is named modDec_to_DMS and the function is named Dec_to_DMS. I am still getting the same...

Hello, I am trying to use a function I wrote to convert latitude and longitude from decimal to degrees/minutes/seconds (DMS). The function shows up in the Expression Builder under the "Built-in Functions" folder. The data is stored as type double in a table called Scenarios. I want to pass...

Thanks. Problem fixed by placing brackets around the field name in the UPDATE statement. No fileds named Date for me. Ken

EMP, I placed brackets around the Date field in the SQL statement and it worked like a charm. I knew it had to be something simple. No more fields named after Access function for me! Thanks. Ken

Hello, I am having a problem w/ my UPDATE statement when the date value is included in the statement. I have tried surrounding the date variable (strDate) in "#" and w/ and w/out single quotes to no avail. I doesn't matter if I dimension strDate as a string or a date. I know there must be a...

Hello, I am having a problem w/ my UPDATE statement when the date value is included in the statement. I have tried surrounding the date variable (strDate) in "#" and w/ and w/out single quotes to no avail. I doesn't matter if I dimension strDate as a string or a date. I know there must be a...

neileg, you are correct. I don't do reports often and when I looked at the reports text box properties, there were no "Events" associated w/ the text box. Therefore, I assumed I had to build the expression elsewhere. However, after neileg said to build the expression in the report I noticed...

Not a single IF. The query field contains the following: Text: "(" & [qryWeekInReview]![Classification] & ") Task: " & [qryWeekInReview]![Task] & "; Impact: " & [qryWeekInReview]![Impact] & "; Org: " & [qryWeekInReview]![Org] & "; Personnel: " & [qryWeekInReview]![Personnel] & "; POC: " &...

I'll give it a try but I'll still have to open a recordset and manualy create the query. Still less messy than creating a table and then creating the query. I guess I could stuff a concatenated variable into the report text box during the report onload event. When I get results, I'll post...

Hello, I have created a query using the query builder by concatenationg several fields using the expression builder. Once concatenated, the total number of characters is greater than 255, and is therefore truncated. Since this is a query field and not a table field, there must be a way around...