Search results

Solved thanks to your input. I now have only one inputform which stores different steps of the quote/order/invoice process. Fields like shipping address and shipmethod are greyed out during the quote phase, become available during orderphase and DateDelivered becomes available during invoicephase.

Thanks JDraw. Awesome to have the correct lingo for this particular type. I'll read up about the subject and have a go at consolidating the database and generalize it.

Hi Jdraw thanks for this. If i understand correctly the basic method is using the statement table as my masterform and statement lines as a subform. I presume the statement type will tell if its an order, quote or invoice. Items will be products and all their details. Why are there 2 primary...

Thanks for your input plog. 2. The tables with only one field i've created to grind through a backlog of orders from 2013 till today. At first i used a dropdown box inside the table but after studying up and learning how access works this was a very bad idea. So i deleted all the relationships...

Goodafternoon, I have attached a part of my data model. Lets consider for a moment that one designs a project and sends out a quote. More often than not there will be changes to be done together with new quotes. However there will be some point where you'll get the order based on a certain...

That did the trick!!! I had the controlsource as that expression. Forgot to change it when putting the code in VBA. Works like a charm now. Much better than using ctrl+" everytime. Many thanks Sneuberg I should've joined this forum alot sooner instead of trying to find out everything on my...

The immediate window shows: Conversion Rate = 0,857 Conversion Rate = 0,857 and yes it shows it twice. The code runs the moment i select a product to order from a combobox. (afterupdate) then all parameters get filled in using Dlookup. The currencytype and conversionrate are pulled in using...

Hey gents, I'm struggling with a simple formula. I can search values on the fly in excel but access seems to have a way of its own. I have a Orderform (parent) which displays the conversionrate for the entire order. In a subform i use a reference to this conversion and currency using ...

Since theres only three people that will be using this database its rather straightforward. I'm using XE.com to get the rates. They provide an app for both windows and desktop so we can always see the rates immediatly. I've no clue how i would be able to link access to those rates dynamically...

Absolutely brilliant guys. Thanks for confirming this. That was the push i was looking for. So i'll keep my currency table just as a lookup table to select the appropriate currency symbol. I'm glad i can avoid keeping track of all those currencyrates. It would indeed complicate adding orders and...

Hi. Please find a screenshot of the inputform attached. that was my idea exactly sneuberg. But i thought i was sinning against the normalisation rules. I'm currently writing a totals query where i multiply the prices based on the conversion rates using nested Iif functions. So you think the...

So you mean putting an extra datefield on which will add a new record each time new rates have been entered? To what purpose? Maybe using a dlookup on the orderdate to match the conversiondate and bring in the correct value? Would be good to have some level of tracking in the table when i need...

hmm, i've read through the suggested links. What if i would use another form that pops up on the time i enter an order. This form could be based on my currencytable but with the following fields added: .CurrencyID (autonumber) .Currency (£,€,$, ...) .CurrencyName (USD,GBP,EUR,...)...

Hi Jdraw, Thanks for your reply. I skimmed down some of the obsolete relationships so the view gets clearer. Your suggestions are most welcome.

Thanks for your reply. The conversion rates i get from XE.com. I have them running on my desktop so i only need to glance at them on time of the order input. So the value is saved at order input level. When i deal with payments tracking the conversionrate will be stored again to know the actual...

Evening chaps, I've been learning about databases the pas few months and i've come a long way since the start. However i hit a wall as how to tackle the following problem. I read a lot on this forum but theres no clearsolution to my situation. We have a company in the UK that produces stuff so...

Greetings to all Hello all, I decided to join since i found a lot of useful information on this site and find that people here are really helpful. I've been an excel addict for more than 18years. However i hit a wall :banghead: with excel when i setup my own company. Listing customers...