Search results

We get data from a vendor where one field has multiple spaces scattered throughout the value. We want to replace all occurences of multiple spaces with just a single space. Running the Replace function once does not get rid of all occurences. We tried using a function to repeatedly replace...

I wasn't able to make the code work for multiple reports. The code was just too complex for me to rework. Someone else came up with the idea of using an Access table that has a field defined as an OLE object. Report snapshots can then be used to fill that field. The timer feature in Access...

Problem with multiple reports I tried using the proc in the sample.zip. It successfully creates a PowerPoint file from an Access report. But when I try to create a PPT file from multiple reports, the file only has slides from the last report. The code seems to create a new PPT file everytime...

We have a daily task that generates a dozen graphs. Each day, we want to display the graphs on a large screen monitor for public viewing, preferably as a slideshow. Currently the graphs come from Access 2003. How can we automate getting the graphs in a format that will work with PowerPoint or...

I have a data entry form for Table-A. After I enter an account on the form, I use the account to get a value from a different table and put that value in another combobox. I tried using a SetValue to fill the combobox. I put the SELECT statement from a query in the Expression parameter. But...

When designing macros, I used to be able to hit F1 and get info on arguments for various actions. But now I only get a screen saying "The page cannot be displayed". When I go thru the Help menu adn find the topic, I get a white screen. I have all the latest Office 2003 updates. I'm running...

I could, but there are 2 reasons I don't want to use that approach. First, the domain aggragate function use more overhead than a compiled function and I have 3 more collections of queries that I need to replace. Second, I want to learn how to use VBA to manipulate recordsets, queries, etc.

I have 10 queries. Each uses the same table (tblAmt) and gets a sum from the same field (Amount). The only difference between the queries is that the Amount field is restricted to a different range in each query. I then use another query to collect all 10 sums for use in a report. I want to...

A solution is to use 2 queries. The 1st query is a totals query that groups by Account and Entered-Date. It has the Average and Count values. The 2nd query is a crosstab query which uses the 1st query as source. The Value column is a concatenation of the Average and Count fields.

I have a working crosstab query with Account for Row Heading and Entered-Date for Column Heading. The Value column is the average of a currency field. This query is the source for a report. Now my boss, in his endless quest for "one more thing", wants to knows how many items went into each...

Date generation method One solution: Make a form based on the table that needs the dates. Records can be written to the table by opening this form, doing a SetValue from a macro that updates the textbox bound to the date field, then closing the form. Multiple records can be written by doing...

Generate dates Customers can have activity on some dates in the range but not on others. Different customers will have activity on different dates. When they do have activity, I need several kinds of totals for the particular customer-date combo. So I created an empty table with fields for...

I have a table that has a single record with 2 fields: Start-Date and End-Date. I want to generate all the dates that fall within that date range and put them in another table that just has a single date field. How do I make those dates? I'm using Access 2003 and Windows XP.

Can you show me some sample VBA code that indicates how to parse a delimited textfile with VBA? Upto now, I've only used string functions in Access to parse single fields. Also, it looks like I'll have to convert the textfile to fixed-width before importing into Access. So how can I use VBA...

I have a textfile that I want to import into Access 2003. It is comma-delimited with double quotes as the text identifier. The first row has field names. Unfortunately, the number of fields is higher than the maximum Access can handle (255). What can I do to this file so I can get it into...

The source of the problem was that, during the creation of the link, not enough fields were selected as the primary key of the table. Since the key was not unique, odd results were produced by the queries. Finding the right combo of fields seems to have solved the problem. Thanks for...

I have several ODBC tables linked to an Access 2003 database. The tables are all from the same SQL Server 2000 database. Queries work fine with all the tables except one. With that table, if I specify a fixed value for a field, the query results show many values for that field. If I run a...

Reply: The previous import spec that worked was for a fixed-width text file. I think it worked because I could specify more than 255 fields by entering the start position and width. But you can't fool Access into accepting extra fields in a comma-delimited text file. I did find, however, that...

I'm trying to import data from a comma-delimited textfile. The first record has fieldnames, all fields are text, and the text qualifier is double quotes. Since there slightly over 255 fields, I've defined 2 import specs. One spec skips the last bunch of fields and the other spec skips the...

I have a Word Mail Merge that creates form letters we send to client companies (1 letter per company). I want to include in each letter the output of an Access query. One query has been made for each company. I tried putting a hyperlink column into the data source for the merge, but all I get...