Recent content by kalesb

ACCDE is working correctly. I needed to compile VBA code before saving app as a ACCDE file.:)

I believe the problem is due to duplicate labels in the VBA procedures. I have a procedure that I copied multiple time that stores variables for a date range process. The varibles are used in the SQL to generate a report based on selected date range. I got the report to run without the date...

I am using Access 2010 with Windows 7. I wanted to deploy my app to user and I thought "Make ACCDE" would do that. But after I executed the compiled executable file, I can not get my reports to run or display. I did check the queries and they are working. Does anyone have any suggestions...

Success!!!! Should be checking optDates instead of option3 Private Sub Command8_Click() Dim tempDate As Variant Dim SDate As Variant Dim EDate As Variant On Error GoTo X_Err Select Case Me.optDates Case 1 DoCmd.OpenReport...

Option3 is a Option Button (Radio Button) MsgBox does not like msgBox Option3 and My Case can not figure it out either or want I wanted to do.... with Option3 set: I want to use [EDate] and [SDate] from Form for SQL where clause (see Word attachment from 1st post of the day) with Option5...

Made following change with no errors but program will not display rpt. I do get display inputbox ahead of Select Case statement. [code] Private Sub Command8_Click() Dim tempDate As Variant tempDate = InputBox("Display InputBox") output: On Error GoTo no_data Select Case Option3 Case 1...

Update: Select Case Option3.On_Focus (errored) Compiler Error: method or data member not found

I am going to change Select Case to: Select Case Me.Option3 and then insert some more inputboxes at each Case to determine if working... Select Case Me.Option3

Hello vbaInet Can you look at my last Post? I need your technical assistance.

I hit a brick wall due to my knowledge of VBA/Form but I am learning..... I took some of your suggestions and then tried a simpler approach. I could not get the module to work with Form attached due to different approach. See Form in attachment When I click OK, I run the following...

This is nice. I believe I can convert to my program if you can provide some additional information. This would help me understand your code and reduce my research time in understanding your code. Any assistance would be greatly appreciated. 1. Is CurrentProject and Allforms reserved words...

:pJust got in. I'm looking at your dbase now..... Thanks I'll provide an update shortly to see if I can take the same approach in my app...:rolleyes::rolleyes:

SQL statement works but I now have created another opportunity.:) code provided with changes in form name only: [code] WHERE (((ECP_T.F_ECP_DTE) Between (IIf([Forms]![Frm_ECP_Date_Range_Search_Parameters]![SDate],[Forms]![Frm_ECP_Date_Range_Search_Parameters]![SDate],[Enter Start Date:]))...

Success!!!! I should have caught the spelling also but apparently I can't spell. I have several reports requiring this function and with your help instead of 10 reports to build and maintain, I now only have 5!!!!! Thanks again. Good Job!!!!!:):):):)

When I try saving the SQL, I get Syntax error (missing operator) in query expression. Also can you tell me in IIF statement: Does = 1 mean TRUE?