Search results for query: *

I've discovered the answer to this! The answer lies in the syntax of the SQL statement: SQLStatement:="Select * from `Sheet1$` Where [File Record = " & Record Notice the use of [] to enclose a column heading with spaces in the name - and then the addition of a variable

Hi, without boring you with the background, I am trying to run a mail merge from the excel data source, rather than from a word document. I have a table similar to the one below (but much larger), and a number of word documents that use the same mail merge fields. the table below and the two...

I need to select items from a pivot table based on dates. The pivot is based on a list of employees who have left, and I have grouped the leaving dates by month, using the =Date() function, ie: Date Month 15/03/2008 01/03/2008 26/04/2008 01/04/2008 02/03/2008 01/03/2008 I...

I playing with some code where I want to set up a list of values, that can then be picked up in a loop. The loop works fine but what's being written to the spreadsheet is wrong. The code: Sub Macro3() ' Dim Franchise1 As String Dim Franchise2 As String Dim Franchise3 As String...

Hello, I look after a database of employees for a company that is undergoing massive restructuring and I'm going crazy trying to rework the views/permissions for different users. Background: The company divides the country into regions and each of the regions is subdivided into separate...

I look after a database for my HR department. One of the most difficult areas we have to keep up to date is the Line Manager - "Direct Report" relationship. As is (I believe) fairly standard, each employee has on their Jobs table (one to many with main table) a field for recording who their...

That's done it! Thanks for your help.

I have been trying to use and insert statement with the following PHP code: <?php session_start(); $_SESSION['SentenceText'] = $_POST['SentenceText']; $_SESSION['SentenceManner'] = $_POST['SentenceManner']; echo'...

Perhaps I'm thinking about this the wrong way. What I want to do is design a parameter query with a user friendly (ie. for the non-technically minded) drop-down box that presents a predesigned choice, ideally from an editable lookup table. The idea is that the user clicks a button (to open a...

I have created a parameter query, which I can access from a form with a combo box. (see: http://www.fontstuff.com/access/acctut08.htm) The idea is to allow users to select from a predefined list. This works great when I access (no pun intended) it via the form, but if I try to run the query...