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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.