Search results

Thanks Bob, The reason I didn't include the rest of the code was that it worked fine when I just had a section in here saying put "This Text" in A1. I then tried to expand to put results from the query into the excel cells and this is where is went wrong. I have found that if I remove the...

Just to update this, the code comes up with the error when it runs the strWorkbookname line of code. It uses this earlier in the code and has no problems with it. The spreadsheet exists in the correct folder so I am not sure what to do next. Any help would be gratefully received. CC

Thanks MStef, This exports the whole of the query into excel. The problem I have is the data needs to go into specific cells within an pre-formatted spreadsheet, which is why I have been trying to find a code to send individual fields into specific cells. I think I am close, but still keep...

Thanks for the replies. I have changed the section of code you suggested and it still comes up with the same error. Hadn't thought about the looping, thanks for pointing that out. Fairly sure I can fix that no problem, once I can get the query into excel!!

Exporting query results to Excel Hi, I am writing some code to export results from a query to Excel. I have managed to get the correct Excel file open and can write test to it no problem. The issue comes when I want to use data from a query rather than set text that is hard coded. I have...

Thanks for your help guys. The fields aren't really called time and date, I just used that to indicated the information they held.

I have a database that holds a reading every ten minutes. I have been asked to sum them to give hourly and daily values. I have easliy created a query to get the daily totals but can't seem to get the hourly ones. The table has 3 fields, date, time and reading. I am missing something...

Thanks Brianwarnock, that has worked.

Thanks dapfeifer, I have changed the Top Values in the properties and can see what it is doing but doesn’t quite do what I am after. I may have not explained things very well. The Table looks a bit like this but contains data for an entire year. Date, Time, Wind Speed, Wind Direction...

Thanks for the reply dapfeifer, but I am not sure what you mean. The data in the tabel looks something like this: Date, Time, Wind Speed, Wind Direction My query groups by day and returns the maximum wind speed. However, I don't know how to return the corresponding wind direction for the...

I have been asked by a colleague to help with a database that I have not been involved in designing. It has data weather data for a number of times for every day. They wanted to get out the max wind speed for every day. This was easily achieved by using the Group By Day and Max wind speed in...

I am having some problems exporting data to word from a form. I have used the search feature but can't find anything that helps me out. The form contains a large number of fields and also 3 subforms. All the data needs to be printed and as there are table requiring landscape orientation I...

Thanks Matt, that has worked a treat!

I have tried to search for an answer to this but no no avail! Please could someone help? I have a start-up form, which has a combo box search feature which opens up a new form with the user defined record. As well as providing all present numbers users can type in their own number. The number...

Can someone please help me out? I have a login form which asks for the users name and password and that all works fine. However, I then want to open a form giving them different editing rights depending on the access level I have assigned them. I have copied the code below. The intAccessLevel...

I am still a little unsure how this will open up a prompt for the user to enter the name of the table being generated. Yes you are right, it could create a number of tables. The user has their own front end so it would be their copy that would have the extra tables, not all users. This is...

I have a make-table query, which works fine. Is it possible for the user to be prompted for the name the table should be saved as? In the query the users is prompted for an input by [enter parameter here] but this doesn’t seem to work in the properties section in the query under “Destination...

Pat, Many thanks for that. It has worked a treat.

The format is in the format section within the property of the filed. It looks like I mentioned earlier "ABC"000

The autonumber generates the basic number. I have then added within the field property that the format should be "ABC"000 or "XYZ"000. This then returns ABC001 or XYZ001 in the field for the individual forms. This works fine. It is when I want to do a date check on both forms and merge them...