Search results

Hi all, I'm trying to make an updatable query for a partsorder form, but im having trouble. I think its due to having to many inner joins, but is there a way to make this work: SELECT DISTINCTROW WoJobTbl.JobItemNo, PartsOrder.OrderPriority FROM ((EstimateTbl INNER JOIN WoJobTbl ON...

Hi, This is probably a simple one, but I just cant seem to get it right... I want to filter my subform data, to only show records where field A is a higher value than field B. Me.MySubform.Form.Filter = "A > B" Me.MySubform.Form.FilterOn = True This way it doesn't find field B...

Hi all, I am trying to pull the currency exhange rates from a website for use in an estimate calculation form for my company. The following will display the content of the xml file in the debugger, but how can I add criteria, so I can reference a single currency? Sub GetExchRate() Dim...

Hi all, I am struggling with access 2007 estimate program for my company. I use a continuous form, to select tasks to add to an estimate, which works great. Now I want to be able to add parts to these tasks, so I have created a PartsTbl linked to the TaskId. My question is: Is it possible...

Hi everyone! I am working on a new worktime logging module for our company database. I would like the layout to show 1 week at the time, with the ability to enter the elapsed worktime from each weekday to the same line / record. I have attached a simplified copy of the db, which shows what I'm...