Search results for query: *

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

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

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

I have a Calendar Control (10.0 2002) that is on a pop up form. Once the user closes the pop-up form, the date on the parent form is set to what the user selected. I am getting a date of 12/30/1899 and a time around 12:00am though! I have run into a problem like this before, but I can't remember...

I'm trying to return a value from a select statement into my code to use. Something like Dim String as runSql(Select ..) ??? I couldnt' find what I was looking for. Any help or references would be appriciated. Thanks.

I am opening up a subform in a new window by the use of a button. Form A is the parent, Form B is the child. A 1-many relationship. When pressing the button on Form A, Form B pops up with the appropriate records linked by idKey. However, when I create a new record in form B, (B)idKey is not set...

I am trying to update my form based upon a combobox selection of a date. Two fields make up the Primary Key in the Table(form). idA, idB. Based upon the date Selection in the combo box, I would like to update the rest of the fields on the form. I have some code that works for a one field...

I am trying to update a form based upon a combo box. I know the rs.findFirst probably will work, but I have 2 fields that represent the primary key- so I am unsure of what the syntax should look like. Any help is much appreciated!

I have table A with multiple fields(columns) I would like to set one of the fields to a query from another table that returns 1 result. Can this be done, and how? Thanks.

Is there any way to bring up the edit hyperlink dialog box (by pressing a button). I haven't found any resources that allow me to get a hold of the dialog box- so that the user can browse for a hyperlink with just a simple click of the mouse on a form. Thanks.

I am trying to add the edit hyperlink messageBox to the form, so that the user can select the file or link they want, instead of having to type it in manually. I'd like to put the button right by the hyperlink textbox field. Thanks.

I am using a Dsum() within the textbox to calculate a value. After I change the numbers in the fields used for the calculation, the textbox does not automatically refresh with the current calculations. What function will do this? Thanks.

I am trying to calculate a percentage for each count into a field[percent] in a subform. I want to take the corresponding [count] and divide it by the sum of the [count] column within the subform. ex: count is stored in the db, percent is not(its just a txtfield) Count Percent(Generated) 6...

I have a form with a combo box on it, along with other fields. When selecting from the combo box, the rest of the corresponding fields update. But when scrolling through the other fields with the mouse scroller - the combo box does not update to match the rest of the fields. The data type in the...

I am trying to open a Plan form(by pressing a button) based upon a field from a Main record that is currently open.- Calling a query based upon a field from the current record. I have no clue what to do. How do I access the a Main field to put it into the query... and also if the query comes out...