Search results

I have been using this export function for the longest time and today it is giving me an error: Export code: On Error GoTo Err_cmdTest_Click 'Must 1st set a Reference to the Microsoft Office XX.X Object Library Dim dlgOpen As FileDialog Dim strExportPath As String Const conOBJECT_TO_EXPORT As...

I have a crosstab queries which uses the date query parameters. However, when I go to my Export command (code is below), it ask me to enter the date parameters (start date and end date) twice. What do I have to do so that the system will ask me to enter once only? On Error GoTo...

How can you export cross tab queries by using date parameters (for example: Jan 1, 2014 to December 31, 2014) Any suggestions? Thank you all in advance.

Hi, I have a continuous form with a number of unbound fields and bound fields. However, I would like to sum an unbound fields (Text28). Text28 is an unbound calculated field based on another calculated unbound field (Text22). I would like to sum Text28 in the footer or somewhere in the form...

I would like queries to do some calculations for me based on a field. The field in the form is a combo field and the user can choose either 1, 2 or 3. Based on the selection, I would like queries to generate some numbers for me. This is what I have in mind but its not working. Please help...

I have a form with a field that has formula for calculation. However, I am unable to link the field to the table since the control source is my formula. How can I that field to a table? Any help and suggestions will be appreciated. Thanks in advance

I have a main form and a sub form. Subform has a number of fields which is linked to TABLE1 Subform footer has a hidden text field called TXTSUM which sums up the total amount entered in the subform. This is the outbound field where the formula is =sum([Approved]) Now in the main form...