hmm the exceptions are highlighted in the raw data before the pivot table is generated. Thus i think the pivot table has a standard format so it doesn't show the exceptions that is highlighted
hm with the autogenerated name, how do i go about doing this? as i am running the codes again now and now all of the pivot tables dont come out at all with the same error as "applicatio n-defined or object-defined error"
nicolenwn
Last Activity: May 4 '10, 08:46 AM
Joined: Nov 4 '09
Location: Singapore
-
Create pivot table using macros
Thanks for your input Kadghar! i'm still having problem with the exceptions part though, any idea on how to highlight the exceptions in the pivot table?
Also highlighted in my raw data are exceptions. For example the record that is incompleted for customer A is highlighted in red. However after my pivot table is created when i click to view the records for Customer A, non of the trades are hi...Leave a comment:
-
Thanks for your input Kadghar! i'm still having problem with the exceptions part though, any idea on how to highlight the exceptions in the pivot table?
Also highlighted in my raw data are exceptions. For example the record that is incompleted for customer A is highlighted in red. However after my pivot table is created when i click to view the records for Customer A, non of the trades are highlighted.
Also, i've tried creating...Leave a comment:
-
Create pivot table using macros
Hi everyone(:
I'm having trouble creating pivot tables using macros.
First i tried recording it then running the exact same thing. It worked fine the first time but a week later when i tried it again the pivot table failed me. As i am using raw data as the data source, hence the number of rows changes everyday and therefore the datasource for the pivot table code cannot be fixed.
How do i do this?... -
Hi ggeu,
thanks a million for your help but it still seems like it is not working and still giving the same error. I am using Microsoft Excel 2002 (SP3). That might be the problem, although it was working fine previously. I will be trying this on another desktop that holds Microsoft Excel 2003 and see how it goes.
As for the breakpoint part, i'm not sure about it. I have been using Msgbox to solve my errors only(:...Leave a comment:
-
Use DATEDIF formula in macros for unfixed cells (Eg, Cells (b, c))
I need my macro to calculate the date difference between 2 ranges in 2 different sheets.
Ive got the codes below using record macro, however my range is not fixed as i'm using unfixed cells like (Cells (b, c)).
I've triedCode:ActiveCell.FormulaR1C1 = "=DATEDIF(R[5]C,'production breakdown'!R[-5]C[1],""d"")"
...Code:Cells(b, c) = DATEDIFF("d",(Cells(b,y)),'Production -
thanks for your efforts, but i'm kinda having an error in
Sub GetCustName()
Error message: Compile error
Can't find object or library.
Cheers,
Nicole...Leave a comment:
-
Dear ggeu,
Many thanks for your research efforts, i cannot thank you enough!
Q1: Yes there will be many products from different categories (Eg, Vegetables, Poultry, Dried goods). But if a listbox is created will it be user friendly in a way that the user is able to add and remove new items to order in future?
Q2: Yes the weight must be multiplied by the price ($00.00) and then the total cost of the order...Leave a comment:
-
Sorry, for to add,
I've tried adding a customer name that does not exist in the user list, but nothing happens. I wanted to add a msgbox to inform the user but i do not know where to put it, haha so sorry.
MsgBox "Customer Not Found! Please Add In 'User' Tab"
Thanks guys!
NicoleLeave a comment:
-
Hey ggeu,
Thanks for the help again!
I have another question! As you saw in my previous excel workbook, i had a tab named 'Price List'
Because the rates of the vegetables change everyday just like foreign currency do, is there a way i can input the rates in the 'Price List' tab and then using this tab, calculate the price of the vegetables that is generated using the 'Take Order' button?
...Leave a comment:
-
Dear ggeu,
This is excellent! Oh my god a million thanks to you(: you've helped alot and i appreciate it!
Have a great day!
Nicole((:Leave a comment:
-
Collect Data On Excel Sheet Using Input Box
Hi GGeu & Kadghar,
Many many thank you for your help!! I really appreciate it
The Version of my VB is Microsoft Visual Basic 6.3. I am not really sure if this is what you mean. Sorry
Also, attached is the file that i use. This is supposed to be an interactive menu to use when taking vegetable orders. Basically i need to collate the orders based...Leave a comment:
-
Collect Data On Excel Sheet Using Input Box
I have a user form which has a number of buttons on it. Each button represents a vegetable (Eg, Cucumber, Carrot, Tomato)
The purpose of this is to take orders from customers for the vegetable they would like to order and the amount.
When each button is clicked (eg, Carrot) the macro would place the word 'Carrot' on the excel sheet. After which an input box will appear for the user to input the amount needed.
... -
Read Access & Read & Write Access
Hi, i have another question regarding MS Access database again):
Hope i could get some help and advise! It'll be greatly appreciated.
As i have a database of records. This databse is used by 2 different teams.
My team needs Read and Write Access while another team can only be granted Read Only Access.
Is there any way i can create a Read Only Access only and grant it to the other team?... -
Can I trace the last person who used the database?
Hi ADezii,
By saying" Assuming you have User-Level Security defined, you can Log each User's opening and closing of the Database by writing to a Hidden Table"
Could you elaborate more about the User-Level Security as i have no idea what that is about. And also with regards to the Hidden Table,does this mean i have to create a new table?
...Leave a comment:
-
VLOOKUP ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-3],C[-2],1,FALSE)"
Hello(:
Can any help explain this line of code (Just a sample code):
ActiveCell.Form ulaR1C1 = "=VLOOKUP(R C[-3],C[-2],1,FALSE)"
It is used in Excel VBA. What does RC means and which cell is it referring to?
Any help is appreciated! Thanks(: -
Can I trace the last person who used the database?
Hi all,
Great day(:
I have a database stored in the shared drive and currently the records are being changed mysteriously. Is there a function in MS Access that allows you to check who was the last person who used the database or who was the one who changed a record?
Many thanks for all the help received(:
Cheers,
Nicole -
nicolenwn started a topic Is it possible to create password protection for the tables in the MS Access DB?in AccessIs it possible to create password protection for the tables in the MS Access DB?
Hello all,
Do you know the best method or functions to password protect the tables in the database? As I found out that my records in the tables are being changed, and if this continues, my data will be inaccurate.
Many thanks in advance for your help(:
APPRECIATED
Cheers,
Nicole -
Thanks ADezill for your help!
Regarding your last quesiton (Question 7), i would want to keep the prior comments in a Memo Field preferably as I need it for record keeping, however the purpose of this is to separate the latest comment input by the user so as to allow the latest comment only to be exported into excel.
I have tried to export the whole textbox as a whole, however because excel has the 255 character limit,...Leave a comment:
-
Thanks Adezill,
but is there any other way to do this. As i the solution you gave allows me to open queries, whereas what i was kinda lookinf for was a button to open the function "Create New Query in Design View" that has the same interface as one on the Database main windows.Leave a comment:
No activity results to display
Leave a comment: