Activity Stream

Hi Ranman256 and Orange, Thank you very much for your responses and help. Ranman256, thank you for the tip about the continuous view. Orange, thank...

Both your code and that done by orange requires the Microsoft WinHTTP Services VBA reference. Both versions worked for me. Is the reference ticked...

Here is a sample using your data. I used Debug.print but you could use MsgBox. ' ----------------------------------------------------------------...

So why are any records created with no DateTemp field. I understand that the date field is irrelevant but, from your description, it should still...

Sorry but that makes no sense A query is based on data from one or more tables - you can't UPDATE it as such. Modify the query SQL to get the...

Thax in advance Ridder. I really want to update the query, not the table. Do you think it would be fine for what I want to get, this code? ...

Not sure exactly what you are asking "search box to bring up results for any text in any fields and display the results in datasheet view." You...

the form has a property : DEFAULT VIEW , set = continuous forms. this will show all records as a list. you currently have 1 form to show a single...

"As far as I understand you, it still doesn't work correctly or you wouldn't have the same date for weeks 15 & 16. Also there is no date on either...

The new screenshot is OK but it would help if you cropped your images before uploading so you only show the relevant parts The query will give...

As far as I understand you, it still doesn't work correctly or you wouldn't have the same date for weeks 15 & 16. Also there is no date on either...

UNION queries are used to get all the results from 2 different sources which isn't what you need Not clear where the data for query 1 comes from but...

Dont look at the DateTemp column, that is not part of any code. It is just the date manually entered whenever the record was last modified. the...

Many thanks for your reply. Not sure why the attachment can't be seen though. The criteria I have used is as below, with the room no in the AND row...

Up to WeekNo 10, the date is for successive Saturdays From then on the days vary -Fri/Sun/Mon/Tue so the interval isn't every 7th day WeekNo 15/16...

Are you using CreateObject code in each case so that you open two separate instances of Excel? GetObject should be used instead where you want to...

Further to davegri's comments, you can calculate the average of the 3 game scores in a query using (++)/3 However there are a number of issues...

As you have discovered, queries like to process data vertically, not horizontally. If you want horizontal calculations, a spreadsheet is more...

can you show me an example ? You meant ? wb0 = x0.workbooks.Add wb = x.workbooks.Add

Hi All, Here is what I have started on my own with some guidance from the form that was given to me along with some reading and video watching (a...

Since it is the application that is hidden, try declaring and setting and controlling two sets of Excel object variables.

Welcome to the forum Your attachment is invalid so I couldn't look at it Try selecting unique values in the query properties

Happy to help!

That's awesome, thank you very much!!!

Hello Pbaldy, thank you for your help.. you solved my problem now I get the 32 records and I learned a good lesson.