Search results

Yes I completely agree... thats where I keep getting confused and running in circles. But looking at those diagrams, I think I sussed it, by adding an interlinking table "tblOrders" This will hold a CustomerID, the invoiceID and the ContactID, the contactID will still be linked to CustomerID...

I tried and tested it but it doesnt seem to work... A contact can have many Invoices, otherwise I'll be repeating contacts for every new invoice with the same contact...

ah - so it is a three way relationship! The contacts belong to the Company - not the invoices! Of course!! Therefore one invoice has only one contact! This makes so much more sense now! Breakthrough!!

I see, those are both very useful diagrams. I was getting mixed up because I am amending a database which previously only had [ Customer ]----< [ Invoice ] In which the Invoice table has an attributes for ContactTitle, ContactName, ContactSurname... After a few invoices I found I was...

Three entities: Customers, Invoices and Contacts. Basically a customer (e.g. a company) would have a main contact for marketing purposes, but individual invoices for that company could have many contacts. I have gone around in loops, believing this is a three way relationship... which I...

I need to create a way to display things as buttons along a task bar, like most applications do. Not necessarily like the new 2007 suit does with the categories - although that would be a bonus. Anyone got any tips or know somewhere to go? - I literally don't know where to begin!?

Thanks for that... I found the conditional format window... very limited and not very useful... I didn't see any point about updating to 2010 seeing as not much had changed... however I will investigate further into using scripts to format it... Ill keep you posted.

Oh and there is a Yes/No field if the person is a customer, and another yes / no field for bad debt customers, relayed from a complex query...

I have a list of names in a form from a query, I would like to colour code the names, for example, Green for current customers, Brown for potential customers and Red for Bad debt customers... I am sure it is possible, I have seen it done before, but I can't seem to find the guide anywhere any...

I have found what I need to do - but its a VBA tutorial... the code looks very similar to what I've been working with in Access, but I was just wandering, what is the actual difference between raw VBA and the VBA access uses?

This is a great starting point! Thanks! (and yes it does need to go through Outlook as some computers have 3 email accounts to send and receive from)

It is nothing against Outlook, just at the moment in time Outlook is a separate entity to the database, so we need to copy and paste emails to email them once we found the email, or to add them to the database... its also confusing to find previous emails from the same contact in an instant and...

I was just wandering how easy and if its possible to use Access as an email system, using outlook in the background, but access as the GUI... the idea is emails from already known users on a given table could be linked, and hence record the emails in the database... making it much easier to...

worked a treat - together with an "Is Null" statement it filtered out all the ones that were there and left me with a list of number... Just what I needed Thanks!

thats all I need... a quick reference of which numbers are missing. Thanks for the tool tip ^.^

I have a list of manually in-putted invoice numbers and need to figure out a way to create a list from this to tell me which numbers are missing... there are excess of 1000 entries so far (considering there are over 1300 invoices and counting, some have obviously been forgotten) Hope you can help/

perfect, the macro setting was switched to "disable all marcos with notification"... yet it did not notify me... after trying all other settings, the only one that would work is the Enable all Macros, which it tells me is highly dangerous... doesn't sound healthy? Is there a way around it somehow?

I have a search tool, which I have developped through previous threads on here, and it worked perfectly until I decided to upgrade my computer to windows 7. Now nothing happens... I was wandering if there is a patch or add on or some setup I may have missed to avoid this problem. I only know...

dtan = DLookup("[dtan_lib_no]", "[TblVideo]", "[video_id]=""" & vididmax & """") this line looks iffy? "[video_id]=" & vididmax ) too many quote marks? is vididmax a variable? or a control?

Switch(IsNull([CompanyName]),UCase(Left([LastName],3)),Not IsNull([CompanyName]),UCase(Left([CompanyName],3))) I'm using a switch statement to decipher the left 3 characters of the Company name or Last Name, then upper casing them... this is all very well, but every so often I'll have a...