Recent content by CCIDBMNG

SOS - Yes the Use Access Special Keys is checked. HiTechCoach - It's 2007 SP2 I was actually able to stop this by creating a variable that is loaded on Form Load that loads False and then loads True when the click the Exit button. I'm then checking if the variable = False on my form_current...

Yes, I have a button on the form which closes everything. The issue is that I have code in the form_current which requeries a couple listboxes based on what's on the form. When you exit the database from the form, it runs through the code but the form is closed so it's prompting for the...

Actually it only happens when closing the entire database, it doesn't occur when just closing the form. Is there anyway to prevent this?

I have code in the Form_Current that is apparently running when I close the database. Is there anyway to stop this code from running if that database is closing? Thanks in advance for any help.

I have a subreport which is linked to a query. In the detail section of the subreport I have the straight value from the query. I added the subreport to my main report and set the source of my text box on the main report to the text box on the subreport. It works great on my computer and on...

Try this =[Meat Standards Sub].Report!BatchTotal+[Ing Standards Sub].Report!BatchTotal

That works fine when viewing the query but i need it to display at the end in the dynamic form I am creating. I will have to use code like Pat suggested.

No matter where I place the total column it always places it before the crosstab columns.

I created a crosstab query that I'm using to dynamically create a form. I know how to create a total in a crosstab query but it creates it before it creates the columns. I need the total column to show at the end of the columns. Does anyone know how to do this?

DateSerial(Year(Date()),Month(Date())+1,1) Just substitute Date() with the 90 day anniversary.

Thanks for the reply but unfortunely that didn't work.

I am having problems with reports that have subreports. If there is lots of data on my reports and the subreport ends up being at the end of the page the text sometimes gets cut in half. I have the text box set to Can Grow Yes and Can Shrink Yes. I also have the grouping in the subreport set...

I have two subreports on one report. One subreport shows hours worked on-site for a month period broken down by week. The other subreport shows hours worked in-house for a month period broken down by week. On the main report I want to show total hours worked broken down by week. I tried...

I was wondering if you ever found a solution to this problem?

I found a work around this morning, instead of having Text2 set to Text1 I set Text2 to be the sum of what Text1 was referencing.