Search results for query: *

Hi, I have 28 separate queries that need to be run and each one has a need to return data between two dates so my queries use the "Between [Start date] And [End date]" criteria. However this means that with 28 queries I have to manually type in the same start date and same end date 28 times...

Desperately looking for a VBA solution to a tedious manual task. I have a requirement to count the number of emails received in a shared mailbox folder, note the date and time it was received, and then note the date and time of the reply so I can get a measure of the time taken to reply to an...

Hi, I have code that sends an email to each person in a table, the table has four columns, Firstname, Lastname, Email Address, Amount. The Amount is a total made up from one or more values. What I want to do is add to the body of the email message the results of a second table that holds the...

I need some help please. I'm using Excel 2003 to return some values from a large spreadsheet. The values need to be summed but only if matching 2 criteria. Column 1 holds a company name (there are 5 different names), column O holds the value. I need the sum of values where column 1 matches 1 of...

A spreadsheet containing VBA created in Excel 2000 references the MSOUTL9.OLB object library. When the spreadsheet needed an update done the VBA was edited on a PC running Excel 2003 and when saved it kept the references to xx11xx libraries. When the spreadsheet was then opened by users running...

Let me start by saying that my computer originally had Office 2000 Professional installed and working correctly. I have followed the MS knowledge base article number 241141 "How to install Access 97 and Access 2000 on the same computer" (unfortunately I do have that need, long story...)...

I am trying to export an Access 2000 (9.0.2720) table into a text file format. After selecting the destination and Save as type = Text Files, I select Delimited, choose ok, select Semicolon as the delimiter, leave the default "" as the text qualifier, choose finish and get an error message...

Having looked at previous posts, I have found (most of) an answer to my query, however, there is one part I could not find. I have added the following VBA script to a new module in Excel 2000 (thanks to previous post) =================================================== Function...

A colleague used to be able to input a date (UK format) using the numeric keypad i.e. 1.9.3 and the cell would display 01-Sep-2003 however, since some problems occured and IT did whatever it was they do, she can no longer enter a date this way. I've tried various formats both date and custome...

I have a table with just one field, there are 56 records in this table. I am using this table as the criteria in a query so everytime I run the query I am prompted for a value (contained in the table). If I make my query a Make Table query, is there any way I can run it so that instead of...

I'll try to keep this short with as much data as poss. I have two queries based on a budgets table. One extracts the actual spend by period based upon the unique identifier "A" for actual and the other extracts the budget based upon the unique identifier "B" for budget. I may...

I have a simple query that pulls in the data from an ODBC source. The result of the query is displayed in a simple form. The form is just an A4 ish size form with each record on a separate page. I want to put a command button on the form that allows me to e-mail each record individually, that...

My report is based on a query. One of the query fields has a Parameter value that needs to be entered when either the query or report is run. From a switchboard button I need the report to print 3 copies once the parameter value has been entered. Is this possible and if so how? Thanks in...

I have a number of fields, Supplier Name, Address etc that I want to include on a remittance advice. Some of the fields are empty for some suppliers and not on others. How do I suppress the blank lines so that for every supplier the address comes up as one block address with no blank lines?