Recent content by BrazilTechie

Great! That did it. Thanks for your time. BrazilTechie

Hi all. I am trying to create a report which will include two columns that will have a count of occurences of ACTIVATED and DEACTIVATED lines. Each record of my table has a ACTIVATED and might have an DEACTIVATED date. What I am trying to do is the display the following on eadh detail line...

I think I have pinpointed the problem: I am not being able to get the real count of duplicate records with this sql that I copied from the queries screen (which works OK if submitted there). But it needs to be part of this code. When the report is requested, the user needs to enter paid_date...

Hi all: I need to print a report and stop processing if there are duplicate in my table. From the code I call a function which will open such report and if there is no data set flag to go on. When there is data to be displayed (meaning there are duplicates) all is going fine. The problem is...

I am trying to find duplicates in a table and if found I want a report to be printed. (It should only be even viewed if there are duplicates). What have I done so far? I have created a query using the wizard, but I have not been able to check the count (if any dups) inside of my code. I would...

Hey guys: I am creating a report of dealers sales. On the Dealer Table has a field with a total for each month. I am grouping my report by dealer and all is fine on the Dealer header where I simply use the following code to get the total for each dealer for the months of January and February...

Hello everyone: I know it's been a while I had to deal with MS-Access programming... 1) How do I capture a date from a form into my code the same way I would with a inputbox? 2) How do I automatically fill a control_1 based on a control_2 in the same form (based on table1). Thanks in...

Hi everyone. Did you ever get this type of error message when trying to create an MDE file before turning your database to a client? Please tell what I am doing wrong. Thanks. BrazilTechie

Thanks everyone for your response. I figured out why it was not working. I was not checking for a NULL in the field. =(IIf(IsNull([COMMISSION]),0,([COMMISSION]+(IIf(IsNull([OTHER]),0,[OTHER]))))))) The above code took care of my problem. Thanks again guys. BrazilTechie

Yes I am. The two fields I mentioned previously.

Hi all: I wonder if I could include a calculated field in a detail area. Such as =Sum([COMMISSION]+[OTHER]) included in a unbound field. I am trying and I am not being successful. Could it be because I am grouping records by salesperson? Any help will be appreciated.

Thanks for your quick reply. You were able to help me a lot with the little info I gave you. Thanks again. BrazilTechie

Is there a way I could prompt the user with a blank dataentry form and still give him a change to go to the previous (last) and already existing record? I am using the following... DoCmd.OpenForm stDocName, , , stLinkCriteria But that only gives the chance to enter new data in one record and...

Is there a way I could prompt the user with a blank dataentry form and still give him a change to go to the previous (last) and already existing record? I have been using: DoCmd.OpenForm stDocName,,,,acFormAdd Thanks in advance.

I will follow those steps and let you know what happened. Thanks to all of you. BrazilTechie