Search results

the record source is contacts and no unfortunately not on Skype. thank you for helping me with this.

ok i have created the date field, not really sure what you mean about setting up a query behind the form sorry????

Hi thank you for coming back to me, i have about 70 records in my current db that do not have the date completed....i was hoping to be able for it to work from any new records created. I am new to querys, code, macros etc so would really need help advising where to put the information in order...

please can someone help me????

Thanks John, i dont understand what needs to go in RecordCreatedDate? Can you advise where i put this code. I opened my general form and hit the code builder button and pasted the code next to the OnOpen and saved. When i went to open my form it advised that there isnt a macro saved??? any help...

Also i am not very clued up with code should i say so can you advise what parts of the code i need to amend, i take it i would need to put the name of the table where it states YourTableName, and the name of my form in YourFormName but where it states YourRecordID and RecordCreatedDate i am not...

Thank you so much, when you say to place the code in the on load event of the form, do i just copy and paste into the properties of on load event and my general form is set to open on opening the db but would i place the code on the general form or the form that contains the DocumentsReceived field?

I am a total novice when it comes to the db, i havent ever used code, querys or macros so not sure how i would go about this? As i am a novice i thought it would be simple, just set it to any new records added from now, if that field doesnt have data entered within three working days then it...

Anyone???????

I have a field on my form called DocumentsReceived. On opening the db it is set to open a form called General (DocumentsReceived) is not on this form. After three working days the DocumentsReceived field should have been completed with a date. If the field hasnt been completed within 3 working...

No sorry, there are about four people who will be viewing the db, 2 x managers, 4 x cust serv. The 4 x cust serv will be the only 4 editing the db the managers will just view the db. Once the record has been created we should receive the documents for a said order within 3 days and once we have...

I understand what you mean about one mouse click not causing to much of an issue but if i was the person in concern that would be adding a record for that week while the other is on holiday, if i then opened the form and it asked if i wanted to send the email then surely i would say no as i...

Thanks for that, is there not a way the emails could just be automatically sent? Without having to press a button once it has sorted the data?

Hi Everyone, I am a total novice when it comes to VBA but thought i would post what i am planning to do to see if you can advise: I have a DB and for one field on a form i have its called Documents Received and a date should then be entered. Once the record has been created this field should...

from form billing they have been set to link contact id but the data is still not linking to the contact id.

yes it is a subform, a tabbed form within a tab

The data saves in the table and is giving an Invoice ID (autonumber) but it also has contactID (number) so i need the data to be assigned with the contactID that has already been assigned. I.E I have a contactID of 36 for one customer so when i enter the invoicing info and i go into the table it...

Please help me! I cannot find anything on the web,

Hi everyone, I have a table called billing, which contains InvoiceID, ContactID, InvoiceNo,Amount and Paid fields. When i add data to my form the data does not save in the form so on closing and reopening anything entered has dissapeared. If i enter the table the data is there with an...

Hi everyone, I have a table called billing, which contains InvoiceID, ContactID, InvoiceNo,Amount and Paid fields. When i add data to my form the data does not save in the form so on closing and reopening anything entered has dissapeared. If i enter the table the data is there with an...