Search results for query: *

Hi, Yes I did. To be honest I think the idea suggested by GlennUK might be the way forward. I've been trying to do something with the date field which would vary each year, whereas a formula based on months would be far simpler and consistent across years. I'll give that a go. Thanks!

Hi, weeknum doesn't calculate ISO weeks and would still have this issue when trying to add in a year as it would still overlap in weeks around New Year. Chantil

Hi, I'm hoping someone might be able to help me. I have a list of records for which I'm trying to calculate year and week number for 2007-2011. I calculated the ISO week number using the following formula...

Thanks for this. Can you use multiple queries as sources of data for the graphs, or would you then have to have another query that pulls in tboth he raw data per week, and the rolling average for that week from the other query? If so, would it be possible for you to provide me with an idea of...

I wonder if someone can help me? I have data for a number of diseases which I have turned into bar charts which show the number of cases per week for the past year. This is using Access 2003. I'd like to add a rolling average to this graph which shows the average of the number of cases for the...

Thanks substitute. I've been really stupid! When I saw the 'openquery' option on the macro I automatically assumed it meant more of a select query rather than thinking it would actually 'run' a query. I think I'll go with option 1 out of the two, my coding skills are non-existant! :)

Hi, I'm trying to put together a new database at work and I want to write a macro for it. The trouble is I'm not really sure what I'm doing. The database consists of a number of seperate tables which I recieve an update for each week, and I've just followed the process outlined on the...

That is absolutely perfect! Thank you very much!

It's now bringing up: Run-time Error '3463': Data type mismatch in criteria expression. And the line that's highlighted when you go to debug is: rs.FindFirst "[id] = '" & Me![Combo96] & "'" Thanks for your continuing help on this, it's much appreciated!

Thanks, I've given it a go. Unfrotunately it's still staying put on that first record.

That's causing the same problem and now not changing record at all, just staying on the first one.

I have... Private Sub Combo96_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[surname] = '" & Me![Combo96] & "'" If Not rs.EOF Then Me.Bookmark = rs.Bookmark End Sub

Thanks, I've tried the code that you suggested but now it's not bringing up any record details, it just keeps displaying the first record.

Apologies if this has been asked somewhere before, I checked the FAQ / search and couldn't find an answer but I admit that I am not the most tecnically minded person and a solution may have gojne completely over my head... I wanted to add a search function to a form on my database which allows...

Thanks for your help, I'll give your suggestions a go and hopefully I'll come up with an answer.

Unfortunately for reasons beyond my control I have to have these fields included in my main table and so I want to make as little work as possible for our data entry clerk.

I am currently designing a form for a database that I have been renovating. There are a number of fields in the database which define different geographical areas (such as Stategic Health Authority and Primary Care Trust) and I am trying to find out if there is a way to populate these fields by...