Recent content by grovelli

Hi, have you already read http://office.microsoft.com/en-us/access-help/programming-pivottable-pivotchart-views-in-access-HA001034579.aspx ? If you've been using Pivot Charts, could you please take a look at http://www.access-programmers.co.uk/forums/showthread.php?p=1008046 ? Thank you.

On the startup form of either attached mdb, select "Portata Povo" then, on the calendar, select 1 September 2009, click on the button that says, "set start date", on the calendar select 30 September 2009 and click on the button that says, "set end date" and click the Chart button. In one mdb...

I've found the attached mdb but don't know whether it could be of any help in properly importing those xml invoice files.

I'm not an expert in XML by all means. "when you navigate by a node, you can examine the basevalue for odn num, or maybe more generally look for an = sign" Do you that using VBA? And what's a leaf node inside the XML file? The only place I've ever heard about leaf nodes is here. Thanks for your...

Hi, I have a problem very similar to yours. I have downloaded invoices in XML form from a web trader portal. I attach an example XML file and the associated dtd file (XMLInvoices.zip). I can import the xml file into Access but the following, very important, bit of info, gets left out: <odn...

In the attached mdb, is there a way to avoid the RecordSource of the subform being incremented by one day every time you open the main Dezzo form? Try opening and closing the Dezzo form a few times; you'll see records being added to the g1dez and g2dez tables. I'm using the following code in the...

Excellent!! Thank you very much:)

The attached mdb opens two forms on startup. Is there a way to reproduce clicking the Command0 button on the Form3 form via VBA code? I'm asking this because I intend to hide the Form3 form on startup and I'm also forced to use this procedure because the Ricarica subroutine in Module1 works...

Thank you Pat, that was very good advice. I carried out putting the two subforms onto the main form but I kept the text/combo boxes in FrmMeteo unbound because if I bound them, you'd have multiple text/combo boxes referring to the same field.

If, on the startup form of the attached mdb, you type anything in any of the text boxes of the FPersonale subform(which, in form view, is labeled "Shift schedule") you get a message titled "Write Conflict" saying that during the current session the record had been modified by another user...

Yes, thank you Modest. I've found out ADO recognises regional settings as differently from DAO, SQL and VBA so I don't need to format rst.Find ("Giorno=#" & Format(Forms!Prev!CGior, "mm/dd/yyyy") & "# ") I can just use rst.Find ("Giorno=#" & Me!CGior & "# ")

If I put a breakpoint before the code line rst.Find ("Giorno=#" & Format(Forms!Prev!CGior, "mm/dd/yyyy") & "# ") in the Private Sub Comando255_Click() of the attached mdb, select March 8, 2006 on the calendar and then click the Agenda button on the startup form, I can see that the conditional...

Thank you, That's what I was looking for.:)

Hi, I cannot resume the code at the next instruction because I need the line If rst.State = adStateOpen Then rst.Close to work so as to close the recordset.

In the Click event for the Comando50 button on the startup form of the attached mdb, I'm trying to use the line If rst.State = adStateOpen Then rst.Close but I get the Ado runtime error 3219: The operation requested by the application is not allowed in this context. when the...