Recent content by Pintglass

Hi gblack It would probably be easier for me to send you my db file so you can see what I'm doing wrong. Let me know if thats OK Thanks pintglass

Thanks gblack for the reply. On my main form I have 2 sub forms one for materials one for labour, on this main form I have 3 buttons to create reports with, one report containing both labour and material details and total, one report with material total and labour total and one report with...

Thanks for the reply. I have tried different joins but it doesn't seem to make any difference. The main problem I have is when I try to sum the calculated fields in the report. For example if I have 5 items in the materials query and only 1 item in the labour query the labour query sums 5 items...

Hello I have created a quotation database in this I have created two querys with calculated fields. One query for materials and one for labour I'm now trying to bring these querys together to create a report. The problem I'm having is that when I create the main query for every item that...

Bob, i know you said that it would be a lot of code to have a form like the spreadsheet, but i would like to have a go at doing this as how it is at the moment its hard to remember what data has been entered with there being so many different values. Was my idea of using dlookup to populate...

Thanks Bob for the new db i will have a look and let you know how it is. Pintglass

Bob this is my db file the textbox on the event form is only for testing i was going to create a subform when i could get it to work. Thanks Pintglass

I've got a rough main form done using combo box's what im trying to do is have a subform in the excel style showing the values entered for the particular date. I've been trying to set the control sources of text boxes using dlookup something like this...

Yeah thanks bob I've got it now. Im just trying to think of the best way to create my forms i was hoping to create something similar to the excel file that i have but im not sure i can do it like that. Thanks Pintglass

Bob, could you just elaborate a bit more on the relationships between the tables as i am not sure that i am following them correctly. Thanks again Pintglass

Sorry bob im having a hard time picturing this, what values will be held in the tblTimeFrames then. Thanks Again Pintglass

Thanks Bob for the help on this. I have just one question in the tabletimeframes would i have to have fields for each of the time frames. Thanks again Pintglass

Hello I am trying to create a database to log events on a daily basis, the log is to record events for my disabled daughter. We have a behavioral specialist who is trying to help my daughter with certain aspects of her daily routine. So the database would be to try and build up a picture of...

Me.Recalc doesn't seem to work either. For some reason the event does not seem to be firing when the form gets the focus. Thanks Pintglass

Hello I am trying to get a form to refresh using the (On Got Focus) event. I have tried Me.Refresh & Me.Requery but this does not seen to work, the form i am trying to refresh is based upon a query with a calculated field. Regards Pintglass