Search results for query: *

ALthough this is not a school project, I believe a small tool that checks everything should be of great interest to anyone who develops small databases/interfaces in MSAccess and wants to optimize their code. SPEED Ferret seems to be the best option, although I am still not going to pay for it...

I am trying to search all code in a MSAccess database to find out if a query(or all of my queries) are actually used. An implementation that lists where they are used and located would be great, but I just need to list the ones that aren't used in record sources, combo boxes, listboxes, reports...

Is there a way to copy a pivotchart and paste it in word,excel,or powerpoint? The regular chart has the capabilities, but the pivotchart does not. Maybe there is a way to convert a pivotchart to a chart programmatically?

I need to make the pivotchart able to be copied and pasted into Powerpoint. I think I might have to go through Excel to do this. Is there a way to open up the pivotchart within access as an excel graph? Is there a simple embedded excel open command? -I need to do this in access, not from the...

I was quering a query. I think that was causing problems for those fields not to show up. I'll fix that

How can I include the date columns as well? It is blanking them out. The cumulative sum works great though! Thanks.

I am trying to make a cumulative query to use in a pivotChart. I have a query with this data already: Date1 Date2 Est Actual | I want: 1/2/05 1/3/05 3 4 | 3 4 1/3/04 1/4/04 4 6 | 7 10 1/1/03 1/1/03 2 2 | 9 12 Date1, and...

I figured it out. You reminded me to do the code in the sql view. I was trying to add the group by clause to my query in the design view. Thanks anyways.

Neither worked. I tried putting both variations in the design view 'criteria' field under the column I am working with. I kept getting syntax errors with no help. I also tried setting the Form.GroupBy property in the code. That didn't work either. Is there a way to put the 'group by clause' in...

I am trying to implement the same thing into one of my queries. I tried adding the 2 variations into the criteria lines, but had no luck. Is there a way to put this into a query?

Sorry for asking a dumb question. I was looking for the delete event in a table field. I didn't think the delete event would be on the form. The on_delete_confirmation event worked great! Thanks guys.

Is there any type of function or way to mirror a delete event? The afterupdate() works great for adding records, but I haven't found anything for deleting. THANKS!

I have another question along the same lines. After I have created the unique combination, One of my fields is a date where I use the Now() function. I would like to limit the now to just a short date(10/17/2005). Formatting the date to a short date only shows the date as short, but actually...

I have "TableB" that contains "idTableB"(Primary key), "descriptionB", "myDate". The rule I would like to implement is: No two records with the same "descriptionB" and "myDate" should exist. I don't want these to serve as the primary key though. >>I know this may not be "normalized", but it is...

My error is somewhere in the DSum syntax. I am trying to sum the columns on a subform, and put that sum value into the parent form field.I am getting an error that says it can't find the field "|" referred to in my expression. I tried using the regular Sum(..) , but I was getting some kinda of...

OpenArgs works great for the main forms, however I am now trying to access a subform. I am using this code below after I have used the OpenArgs to tel which form I am at. I would like to access a subform in FormA. This works for a main form Forms![FormA]!dtDate = Me![Calendar0].Value however I...

RoyVidar- you said exactly what my problem is. (I don't have a subform, just another form) Is there a way to reference the main form from the pop-up form? They are not linked at all. I have this: (Calendar0 is on a separate form that pops up) Forms![Form A]!theDate = Me![Calendar0].Value I...

I get an error "invalid reference to parent property" when using that. It wont let me access the name property. Any idea?

I am opening a subform by use of a button. Within this form I would like to be able to check if the parent form is a certain particular form. This matters because I would like the subform to do different things based upon which form it is called from. Something like If (Me.Form.Parent = [My...

Thanks. That solved it. I am relatively new to Access, and haven't used any references to the parent form. This will definately make some things easier for me!