Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. S

    Problem declaring arrays

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

    Querynot working when opening into a recordset

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

    Access SQL Subqueries

    Hello, I am having a problem getting the expected results from a SQL subquery. The point of the query is to return all users and user titles that have not been entered into the database for the current month (not in tblHours). Some users have 2 titles and some just one title. Each month we...
Back
Top Bottom