Search results

As far as I can tell a crosstab query wont do the job. I literally want to take the query results and turn them on their side. So say the query results are as below (i have 6 records but included 3 for example purposes): Header : Sample ID........Sample Date.....Sample...

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

haha brilliant!!! Works well. If you clicked in the box it changes the background to light blue (on the get focus). The LostFocus then changes it back to a colour so it was loosing your formatting after being clicked in. I changed the LostFocus from its statement to PopulateCalender so it re...

Yes like that. For the purpose of this the days with info in can all be the same colour. For my next project different colours for different people etc may come in useful but I will worry about that one once I've finished this project. Your calendar really does look top notch! Puts mine to...

thanks to you static for finishing off the code too!!!!

works brilliantly!!!! thank you so much for all your help Colin massive thanks to you. It may not have been the best way to go about things but so glad I (you) lol got there in the end!!! One last question / thing.... Is there a way to fill in the calendar field in say red IF there is data in...

Thanks guys will see if that works. Whats this bit for: Private Sub Asset_Click() cboMonth_AfterUpdate End Sub

i Colin. DB attached. So in here i have moved the records to the transactions table so it removes the need for a Union query. The sql code for the recordset works and the calendar is populated fine. All i need it to do now is only add / show the records that are from the chosen asset. So...

hi colin, you have been a massive help so far and i really appreciate your efforts in giving me a hand !!

:banghead::banghead::banghead::banghead: i cant get the union code to work and i cant see anything missing. The below code works if it is all in the Transactions table so im thinking its easier to do it that way. strSql = "Select Transactions.[Job Number], Transactions.Initials...

it maybe due to the rest of the where statements being missing. If you look at the below i also need the [FCheckOut] Between " & lngFirstOfMonth & " And " & lngLastOfMonth or [FInDate] Between " & lngFirstOfMonth & " And " & lngLastOfMonth or ([FCheckOut] < " & lngFirstOfMonth & " and [FInDate]...

tried copying the code into the database and tried both versions you provided. They both throw up an error "Too few parameters. Expected 1."

hi ridders, thank you....i will try your code shortly!!! Your calendar looks awesome and looks like it would be really useful....I would never be able to build one of those!

i created a new database a copied the form, tables etc across and it changed the size from 37,000 to 780 KB You will see in the VBA code there are a lot of strSQL's i have commented them out as i have been trying new things. I have added a comment before each one to try and keep track of it...

few....sorted it.....file attached

i removed everything so only the form is there and the 3 tables. I have removed all the additional records so there isnt much in each table. The file siz is 37,000 KB and then zipped its 34,000 KB i cant see how i can get it smaller than that to upload it.

i tried as a .accdb and .rar file but both did the same thing. The files size is 37,000KB so should have been ok

failed to upload again.....missing security token or something!

tried uploading the database but it failed due to a security key or something...i will try again

Hi Colin.....lol ive been working on it for days and days lol hence me looking at other options. My concern is the Union bit is only the first bit and then i would need to add in all the And / Or statements lol which i just dont have the capability to do lol