Search results

No details are ever entered on to my db unless they have placed an order. If they havent placed an order they are not entered as they are not a customer.

Hi, i have that in mind, when they place an order they will sign an order form, that comes to me and i enter the info on to the db. They will have placed an order and i will have all contact info, order details etc.

If the customer has never placed an order then no details will be on the db for them. Once a customer has placed an order there details will be entered onto the db so they will then need an account number.

Hi All, On my contacts page within my db i have a field called postcode, the object of this exercise is i am trying to get access to create an account number for me. I want the first 2 letters of the account number to be the first two letters of the customer postcode, i then want access to...

No i didnt give the main form name. Main apologies. I now have it working, thank you so much for your help and patience.

I have done as suggested however it says the name is "security"

Yes the tab does contain rulers and a scroll bar. From your picture you have =[textforename] etc that is where i have my ="Company: " & [CompanyName] Underneath you then have your tabs, that it where mine are with one as company (yours personal data) then security (yours work date) from there i...

Hi sorry, it is on one of my tabs in the main form, but i created a new form for security and dragged the form onto the tab.

My form is called "security" and the field is called "accountnumber" it isnt a subform or a label. As the control source i have entered =Forms!Security!AccountNumber all i receive is #name?

CBrighton Apologies, it is set to =Forms the_net_2.0 I have tried ="Account: " & [AccountNumber] all i receive is #name?

Hi all, Im sure this is easily done but i keep getting an error. I have a database with many tabs, the first tab is contacts, second is security. In the security tab i have a field called account number, on the contacts page in the header i have the name of the customer displayed in big...

Hi everyone, Is there away that i can find out when a field was last edited? Is there anything in the properties, i am just looking for a date or time? Many thanks

SELECT Contacts.ContactID, Contacts.CompanyName, Network2.ContractEndDate FROM Contacts INNER JOIN Network2 ON Contacts.ContactID = Network2.ContactID; I have posted the SQL statement, i cannot post my db as it has been split. Thanks for your help.

Hi, sorry. 1. Yes there is data in the tables and yes i can view it. 2. No criteria has been set, just the names of the fields i want to view. 3. Access 2003.

Hi all, This will probably have an easy fix but i cant for the life of me work it out. I have a split database. I am trying to create a query, i go through all the normal steps and the name of the field gets displayed however none of the records are, it is just the name of the two fields i...

Why dont you just put all the fields you require on the form, then highlight them all, then right click, go to align and align them all either left, right, bottom or top? You can then make sure the width and height all match aswell. :-)

Hi Everyone, I have been looking into the conditional formatting... I have placed in the footer of my form a total field with a control source of =SUM([Percentage]) this all works fine and adds up the value of all data inputed in to the percentage fields. I have a field in the header of my...

Sorry me again, i am now moving on to another project where i will need to use an OnCurrent event, is it possible to have more that one OnCurrent event?

Thank you so much Dave, it is working perfectly. Really, really thank you.

Well i took out the code in the OnCurrent event and typed Call.UpdateCommissionDue and it comes up compile error expected end of statement, is that all i should be placing in the Call function?