Search results

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...

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...

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...

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 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...

I have two forms which contain entries which have an AutoNumber field, the tables and hence the forms are not related. Both the AutoNumbers have a format associated with them so when the user sees them in the form they look like: ABC001 0r XYZ001 Both forms also have a date in them. I have...