Hi All
I have a table with the fields Month and Year.
I need a query to count the number of occurences before and after the current month. I then intend to place the counts into a form as visits. The count before the current month would be in red and after in green.
Any assistance would be much appreciated.
ChrisD
chrisd49
Last Activity: Dec 21 '06, 06:00 PM
Joined: Nov 21 '06
Location:
-
Opening a form from a form using a text box
Hi All
I have a form which is based on a query to dis[play some basic details such as Site name, City, Post Code. I have a second form which gives a complete record set based on clicking the site name in the first form. I cant get it to load the second form showing the correct detail it always shows the detail of the first record.
Any help would be much appreciated.
ChrisD -
Hi Mary
Many thanks for your help with this. I am embaressed to admit I forgot to do the obvious first by cutting and pasting the data range I wanted. This threw up the problem in that the third column was based on merged cells in the spreadsheet so would not import. I changed the range by one row and now it works perfectly.
Thanks very much once again
ChrisD... -
Hi
Thanks for this. I tried it and get an error message which reads
error 3709 the search key was not found in any record.
I have checked the spreadsheet to ensure that all the header fields have an entry and the format is set to general for all of them.
I have pasted my code below just incase I've done something stupid and now can't see the wood for the trees.
Private Sub bImport_Click()
On Error...Leave a comment:
-
Hi
Thanks for the reply. I would have attached a couple of the spreadsheets in question to help clarify what I am trying to do (except I cant see how to do it). I know one end of the range will always be A7 and the other end will always be BB7, its the number of rows which changes. I have some code which allows me to import to a table using the excel file name to create a new table its just that it imports everything and I am lost in trying...Leave a comment:
-
Importing from Excel with a chaning range
Hi Everyone
Is it possible to import an Excel spreadsheet by range when the range is different for each sheet. There is only one sheet in the workbook. It comprises of a different number of jobs in the first column, it has weeks 1 to 52 across in thje sixth row. Also is it possible to use a fixed cell in the table to name the table it will export into. I can import the whole table easily enough but am struggling to accomodate moving...
No activity results to display
Leave a comment: