Search results

Dim db As Database

It says: user-defined type not defined!

thank you...

I want to make a report that will display the 10 best customers accordingly to their purchases! In my customers table i have a total purchases field that show the amount of purchases the customer has.... Anyone can help me with this ? Thank you

please someone help because i need to give the database by friday and i need this solution to continue to do other features on my database....

issues my report is presented in the right way when opened on access 2007 but on other access the debugger shows that message!

sample this is my sample so that you can see my tables and the ivoice input form.... the code for deducting must be added on the show me how it looks button i think....

sample actually i do not take orders, i sell things and the qty sold will be deducted when pressing the create report button ... i will post a sample for you to see....

sample maybe? ok because i am a newbie in access(relatively) a sample would really really help because i do not know how to do what you said... if i am asking a lot i am sorry.... but this help will be much appreciated.... once again, thank you all

i think that what i need is something like find product by using product code(i think is something WHERE ...) product code = me.cmbpc (pc = product code) and less me.qty

I have a invoice form from which my invoice report takes the details! The form is like this: Product Code | Description | Qty | Unit Price | Amount In the product code I have a combo box. Now what i need to do is to less the quantity from the "in stock" in the record of the product(find it...

what changes did you make? i cannot find them!

security i have already disabled the navigation pane from the left so that the user cannot jump directly to the switchboard before loging in BUT if the user that logs in is "Administrator"(only one administrator) then i want the right click to be enabled, else it must be disabled(this is the...

admin no i need to have only 1 file and when a user logs in the moves must be limited(no design view), but when the administrator logs in he must be able to do whatever he wants!

hide database window i have done that but once you open the form through the switchboard you can right click and view design mode!!!! is there a way to disable the righ-click for all the users except the user "administrator"? If i do this will the administrator be able to switch to design view?

login and permissions i have to ask if u use the wizard to do this or if I only need to put the code in... also i have 10 forms thatt I want to make only avaliable in editmode(user must not have access to design view) for all my forms without opening the all the time the user logs in! Is this...

problem with access 2003 I have done what what you said and worked just fine in access 2007 but when i open it with the 2003 access, and try to preview the report it gets me to the debugger and tells me "you can't assign a value to this object!" for Me.amount1 = amount1 Is there a way to make...

sample here is attached your sample with the changes I made so that you can see what the problem is!

problems again! thank you for your quick responses... i am sure you mean column count and not width! this problem has been fixed! BUT(again) I have discovered that when I put also the price and then try to find the total in my report, I have to fill all the products in my invoice form or else...

price no, i mean on my input form i want to see the price when i select a product from the product list, not only the category...