Search results

oh... it would seem my manager has no idea what he's doing then... i just confirmed what you said with our sales team tho.. well theres a couple hours of pointless work done.. Thanks mate.

hey, i have a customer form which includes a "Country" combo box.. the reason i did this is because i have a separate table with a list of countries and their VAT (Value Added Tax, you americans call it sales tax i think :)) rates. i want this country saved in the customers table.. i need...

n1 cheers mate

thanks alot mate, think i gave the wrong impression when i created this thread. Was only after the theory of how it worked wasnt askin for anyone to fix my problems ;) Cheers alc

Hi, Ive set up a command button on a Client List form which is supposed to email a client a specific invoice. I have a few questions tho regarding this service.. i would try it myself but i have a dataless database atm :) If i want to send a client a particular invoice by email and i click...

ok thanks guys, ill take your advice ;)

Hi, i am currently making a database for my company which will take care of the invoicing ordering and any other aspects.. i was making good progress until my manager mentioned to me that theres a special ordering number system that they want to keep and want me to incorporate into my...

lol ok im trying to follow what you guys are saying but err im kinda stuck now :> i created the new table... but i dont understand how to implement the code where to put it and what to link it to etc :s if some1 could explain it simply id be very grateful lol

ha sweet sounds like i have alot of fun and frustration ahead of me! lol

man... how long will it take for me to learn everything you guys know... ive been working with access since december and i even went on a couple courses... i still feel like a complete utter novice lol Thanks for the help mate

ok, but i guess in order for that to work the user will have to enter the joblocation at the start?

k i've got that bit working now.. To get the joblocation and Orderid to merge into one would i use VBA on that specific form? im not really sure where to begin, but once i know where i need to do it im pretty confident i can do the rest

lol ok ill try out what you recommended

how come? i mean theres no data in my table so why can it not be done?

ok erm.. i think you can guess my next question.. what could be stopping my OrderID from changing from an autonumber to a regular number.. when i try it says i need to remove the relationships but ive done that i removed every single relationship and it still comes up with the same error.

thanks for the help guys its working now :)

ok but when i run that code i get an error saying: Compile error wrong number of arguements or invalid property assignment with the AfterUpdate highlighted: If AfterUpdate(Me!Combo96) = "Gatwick" Then which line depends on which option i select :s

atm im storing the information in my Orders Table under "jobLocation" but that will only save the GWO-### after that i need to write some more code to combine them together i guess.. the problem is my current OrderID number is an autonumber and it wont let me change it to a number even if i...

hi, In my Orders form i have a combo box which determines where the order will take place. There are only 2 selections atm as we only have two sites.. What i need this combo box to do is instead of saving "Gatwick" when it is selected i need it to replace it with GWO- as this will be combined...

yeah thats right, but i want the original price to stay the same in the record source