Search results

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

Would that need to be a many to many relationship. Thanks Pintglass

PaulO I have setup my tables as the attached file. What is the relationship between the estimate details table and the materials table? Do the others look ok. Thanks Pintglass

Hello PaulO I have been referring to your original post, so ignore my post above. Could you elaborate on the relationships for the tables you are suggesting. Thanks Pintglass

I was hoping to add to the database as i go, could you tell me how i could add items from the search list to a list box to create a report on. Thanks Pintglass

Thanks for the reply PaulO I was hoping to make it a bit simpler than what your suggesting. Basically I run a small building firm so all I want to do is have a database of all the materials that I use which I would create a table for. From this table I would be able to search for a product...