Search results

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

Problem solved, although I not sure what I did different. VBA is not complaining now when I redim the array using a variable ReDim Preserve arrData(iIndex, 3) Maybe the problem was where I was performing the Redim within the loop. Thanks Ken

Hello, I am trying to create a multidimensional dynamic array, but it does not seem possible. In short, I am using the split() function to pull data into a dynamic array, because I do not know ahead of time how many times I will have to call the split() function. Because the data being split...

openrecordset is not an available option since I am using ADO. Thanks Ken

Hello all, I have a a form which I use to populate query parameters and send the result to MS Word, where a table is created from the query. The form contains 2 controls: 1) a combo box containing the month number and 2) a text box containing a year value. The form also contains a command...

ByteMizer, Problem solved. I had the following code after the SQL statement: On Error Resume Next DoCmd.Close acQuery, "qryUsersRemaining" DoCmd.DeleteObject acQuery, qryUsersRemaining Set qdf = dbs.CreateQueryDef("qryUsersRemaining", strSQL) DoCmd.OpenQuery ("qryUsersRemaining") I did...