Recent content by stringman

  1. S

    PowerPoint Automation

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

    PowerPoint Automation

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

    Using My Own Function in the Expression Builder

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

    Using My Own Function in the Expression Builder

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

    Using My Own Function in the Expression Builder

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

    Using My Own Function in the Expression Builder

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

    Using My Own Function in the Expression Builder

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

    UPDATE query not working with date a value

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

    UPDATE query not working with date value

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

    UPDATE query not working with date value

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

    UPDATE query not working with date a value

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

    Access query field limited to 255 characters

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

    Access query field limited to 255 characters

    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: " &...
  14. S

    Access query field limited to 255 characters

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

    Access query field limited to 255 characters

    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...
Back
Top Bottom