Search results

Its working! I added BETWEEN FORMS and Forms to criteria!~ Thank you everyone for your help!

Thank you so much everyone! Not sure what happened. The code seems to be working fine now.

Sorry for the late reply as I was out of town. Here's the sql code for my crosstab PARAMETERS [[Forms]!Metrics![StartDate]] DateTime, [[Forms]!Metrics![EndDate]] DateTime; TRANSFORM Count(tblA.StudyID) AS [# of all Metrics] SELECT Year([A_Date]) AS [A_Year], Month([A_Date]) AS MonthName...

Thanks again CJ_London. I tried the link and for some reason it is still not working. Saying I put invalid brackets [] Between [Forms]![FormName]![StartDate] And [Forms]![FormName]![EndDate] I also tried using Forms!formname!textboxname and it says the same error message. I tried both...

Thank pbaldy. I tried what you suggested and nothing gets exported even after it says my file has been exported to the folder. When I go to my folder, I do not see any Excel file.

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

Thanks CJ_London. That didn't really solve my problem. When I hit Export, I am still asked to enter the date parameter twice. Sorry, here's the code

In my query parameter I have: and in my query Date field/column I have: Between [Enter Start Date "dd-mm-yy"] And [Enter End Date "dd-mm-yy"] under criteria with Total field set to 'Where'

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

Actually... you are right. I had to add [Enter Start Date] and [Enter End Date] in the parameters with data type as date/time and it worked!! Thank you so muchhhhh

Thank you CJ_London. I do have the date field and I inserted your code under date field criteria and changed the Total Value to Where. It is giving me an error message: Any thoughts?

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.

Sorry :( I am not sure how to do this as I am fairly new to Access. Would you be able to help me with this?

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

hahah that was easy. I feel silly. LOL Thank you!!

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

Thank you so much for your reply as well Marlan. How do I link the field to the table field. The database was created by someone else initially and the only workaround for me is to create a unbound field - calculated field and I would like to save that calculated field to the table along with...

Sorry for the late reply and thank you so much for your reply. I tried using ME.TXT1 = ME.TXT2 for After update or On change event and it didn't work. Any advice?

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

Thanks llkhoutx. I just tried and it is giving me an error