Recent content by rustersen

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

Excellent!! Nice clean solution.. thanks a bunch!! :D

You're right, B is a calculated field, so that must be the problem. Thanks!

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

Also, I'm not converting from a currency to DKK, but vice versa. I have a bound [Rate] field in my estimate form, controlled by a combobox: Private Sub Currency_AfterUpdate() Dim objXML As MSXML2.DOMDocument Dim EUR_Rate As Variant Dim USD_Rate As Variant 'Create the DomDocument Object...

I'm afraid I never really found any good tutorial, I used snippets of code from misc. webpages. I did read a bit on htt p://ww w.w3schools.com/dom/dom_httprequest.asp to get a better understanding, but my final code was made up of different sites. For a very long time I believed...

Again, thank you for your help! Like you mentioned, I had to activate MSXML 6.0 in the VBA editor. The currency xml i am using does include some danish letters, but I managed to pull the currency rates I need ( USD & EUR ) using this code: Dim objXML As MSXML2.DOMDocument Dim EUR_Rate As...

Thank you for your reply! I have tried your code, but I get a 'Compile error: User-defined type not defined' error on DOMDocument. Do you know why? I am using Access 2007...

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

...never mind, figured it out. Appearently I had to remove the Me! in front of TaskId. =DCount("*"; "PartTbl"; "AircraftModelID =" & [Forms]![Estimate]![AircraftModelID] & " And [TaskId] =" & [TaskId])

Thanks John, The strange thing is, if I add: MsgBox DCount("*", "PartTbl", "AircraftModelID =" & [Forms]![Estimate]![AircraftModelID] & " And [TaskId] =" & Me!TaskId) ..to a onlick event on one of the fields in the forms, clicking that field returns the correct number of subrecords for...

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