Search results

Thanks for coming back to me Freshman, that was my initial idea to bound the field to the same source but to be honest i havent worked on my DB in such along time i have forgotten how i do it :-(

Well i used to enter the data twice manually so placed the data in seperate tables which corresponded with the form. Now i want to just have it take the data and place in another but i am unsure how to do this.

Here goes, i have a tabbed form, my main form which is called contacts has a field called telephone number, on another tab within that i have a form called purchase info. Both forms have the field telephone number and when i enter the telephone number on the contacts form i want it to take that...

I am trying to build a report which grabs data from many different tables. The issue i am having is i select the fields i want in the report and from which tables but it only displays the field names on the report and not the data itself. Does anyone have any idea why this is?

Hi Everyone, I am trying to add a table to a report to display data taken from a table itself. The table will need to have 3 Columns, i can draw this quite easily with rectangles and lines but on generating this report for each customer some will display more data than other customers so i...

A little while ago John Big Booty helped me out with some code in order for a pop up box to display a reminder if a documents received box hasn't been completed after 3 days. I now need a pop up box for a field called ContractEndDate - this will be filled out with a date and i am hoping someone...

Yay thats exactly what i want, well i have an hour and a half to crack this then maybe i can go to the beach instead of working on this over the weekend. :-)

Thank you for all your responses. I am going to try and tackle this over the weekend. The main problem i think i will have is getting the letter to pop up on a status change so any advise you can give me in order to create this would be much appreciated. I am very new to access unfortunately so...

High and Wild, that is not very nice,,,,,sitting on the beach indeed. I am in an office trying to get my head round access db's :-( Order accepted would be no more than one per day. Only one letter would go out to one customer at a time. I would prefer to send via letter than email. I will...

Thank you for coming back to me. Firstly High and Wild - Hi, hope your enjoying the sunshine,,, i dont need to save a copy of the letter once it has gone out but maybe would need to record it somewhere perhaps just the date it went out that would be fine. What i am hoping to do which i think...

Thank you for all the responses. I like the idea of using a report but how do i add my context and also company logo etc? Many thanks

Hello, i have standard welcome letters that go out to all customers, it is always the same except the date, contact and address. Is there a way i can build my template letter in to my db and maybe a command button that is entered on that contact and it will add the date, contact and address and...

Yay worked brilliantly thank you. Under Enter Key Behaviour.

I am hoping this will be really easy...... On my db i have an address box which is set to a Memo Type however i want to display the address like so: 123 Made Up Drive Blah Blah Blah N23 4TR However when i press the enter button it will take me to the next field not move me down a row so my...

I now have it working perfectly. Thank you to all those who replied and helped me. :-)

Yay i have got it working, i would like it so that when the records that have not been updated pop up it also displays the company name. I have added the contactId and company name to the pop up form and the contactID is displayed however the company name is not????

I am just having a look at that which will hopefully tell me how i need to do it, thanks for all your help.

That is exactly what i want unfortunately am not sure where to add the code you gave me in order for it to work??

indeed it is im in the UK to lol, thank you for all your help and i will give this a go in the morning....

ok i will give that a go, in section 4 you have said to put >3 if you want to display records where the document was received more than 3 days ago. but i want it to be a reminder if the field hasnt had a date put in 3 days after creating the record. from above it seems it would be...