Search results

Yeah, I agree. Just that this isn't code I wrote but rather code I inherited from someone else. I don't even know what reference "DOMDocument" requires.

I have some code from an database that I did not build that is giving me trouble when trying to compile. It starts with these three declarations. Dim oDoc As DOMDocument ... Dim wrt As MXXMLWriter40 Dim atrs As New SAXAttributes30 I have 'Microsoft XML, v6.0' checked in my VBA references...

Thanks for all the replies! I probably did that but I think it's somewhere on an old hard drive. The title of the article is 'How to Use ADOX to Create and Refresh Linked Jet Tables'. Doing a search on that support search website does give me results, but none of the links work! :banghead...

What happened to Microsoft's KB articles? I can't seem to find any of the ones I used to with old links I had. :confused: http://support.microsoft.com/default.aspx?kbid=275249 I'll admit it has been several years since I've looked for them, so I've been out of the loop for awhile.

Congrats, Paul! :)

That seems to be the general consensus. Will definitely be staying clear of the riots as best as we can! LOL, I was just about to say that as I was going through the newer posts. To be honest, my wife did most of the planning so the choices of Nafplio, Santorini Island, and Athens are what...

My thanks to those who have replied so far! Yeah, I'm a little worried about being in Athens and our flight. But this is the only chance this year for us to get away. But I've read that away from Athens things are pretty normal so I hope that's the case.

Well, the wife and I are going to Greece in June. 2 nights in Nafplio, 2 on Santorini island and 3 in Athens. Any tips on what to see and where to eat? Or any advice in general?

I really liked it. Took about 6 hours or so to get through the whole thing, but I still haven't finished the advanced rooms and challenges you get for finishing the game. It was very entertaining and intellectually stimulating. Yeah, and I was really looking forward to having cake too!!! :D...

Get the game, Portal, for FREE until the 24th!! (PC or MAC) - http://store.steampowered.com/freeportal/ :)

Ron_dK, Thanks so much for your translation help! Much appreciated! :)

Maybe "Vous aller trop bien ensemble" means "You two make a good couple" :confused:

Would anyone be willing and able to help me translate these French phrases into English? Much thanks for reading this! :) 1) Vous aller trop bien ensemble siisii From Google Translate "You go too well together siisii" Guess it means something like "You two look good together" or "You are a...

'Conditional Formatting' of controls in a continuous form Hope that helps! :)

Here's one way to do it in a query, but it can be very VERY SLOW for a lot of records. DConcat function - Concatenating field values for records matching a query's GROUP / SORT BY or WHERE clause. (Old link) I suppose you could use it to create a make-table query.

I fully agree with Pat Hartman's post about using a report rather than a query to do running totals. For more, see this thread - Really Urgent DSUM Problem But if you are curious as to how to do it in a query: Running Sum / Total / Count / Average in a query using a correlated subquery

'Conditional Formatting' of controls in a continuous form Hope that helps! :)

Maybe this will help you get started. Form - Editing Records (Form Buttons - Add, Delete, Save, and Undo changes) For the close button (button named cmdClose) Private Sub cmdClose_Click() On Error GoTo ErrMsg DoCmd.Close ExitHere: Exit Sub ErrMsg: MsgBox Err.Description...

You probably want to use the AfterUpdate event. The AfterUpdate Event is where you want to place code to be run after changes are made to a record (or data in a control). The Current Event is for when you move to a new record. This might be useful: Form - Editing Records (Form Buttons -...

How about this? SELECT Force_No AS FN, Subs_Dt, Subs_Amt, (SELECT Sum(a.[Subs_Amt]) FROM GIS_Subs AS a WHERE a.[Force_No] = GIS_Subs.[Force_No] AND a.[Subs_Dt] <= GIS_Subs.[Subs_Dt]) AS dblRunningTotal FROM GIS_Subs ORDER BY Force_No, Subs_Dt; You will have to be...