Search results

Hi, I have some data in a table with gives a value of "Y", "C" or blank for ~20 different columns. How do i get the query to count how many times "Y" appears in each column separately. I can get it to do it for one column by adding the field to the query twice and adding a Sum Total with...

Hi, I have a subform to display some data on a report. The fields are all set to "can Grow". The screen shot below shows the section of the report in print preview (only showing 1 item). if theres a second item it just displays them like a table. The Description field is a large text field and...

Hi, I have a query that sets up my table for using at various points, want I want to do is have an Item number field created by the query. Essentially I just want it to number the records from 1 through N, like an AutoNumber field in a table but i want it to always start at 1 for whatever is...

Hi, I have a form which carries out a filter / search on a table and displays it in a subform using via query. The search essentially uses criteria selected on the form to filter down the data. What I want to do is in the subform showing the filtered results, double click the record selector...

Hi All, I have a VBA code which creates some excel sheets, saves them and then emails them to the required email address. This works perfectly well, however it requires the user to click on a command button. What I want it to do is to automatically run the code and send the email every day...

Hi, I have a registration form and a field on it for the user to add a number, could be any amount, probably usually between 1-50 but could be as high as a few hundred. The table has an auto number field which is used as the sample number for the record. What I want to do is to add a number in...

Hi All, I have a command button which runs some code to export a query into excel and then open a few bits (not important for this). If this is run again the code errors as the excel file is already open so the new one cant be opened with the new data. Is there a simple way to close the open...

Hi, I have a query which holds a set of information for a particular asset. One record for each year say showing only 6 records. I want to transpose this data so that the rows are columns and the columns are rows so i can use it in a report. Does anyone have any code to transpose data in...

Hi I have formulated a UNION query to give me a result set which is filtered using a the Asset field on a form called Reserve. I need to put the dates into "dd/mm/yyyy" format as some are Date & Time hence the format parts. I am not great at converting query SQl to VBA code......can anyone let...

Hi all HELP WANTED!!!! I have the code below which is to populate a calender fromat on a form called reserve. When the PopulateCalendar sub is called i get a Type Mismatch.....can anyone find the issue / location of the Mismatch for me...... Private Sub PopulateCalendar() On Error GoTo...

Hi, I am building a database to check out and check in equipment as a log (like a lending library). One aspect is to reserve equipment days, weeks, months in advance. I have the system set up to do this. My issues is when the user wants to reserve some equipment they fill out a from with Job...