Search results

I have a form which creates new 'estimates', when someone completes the form there is a field 'e-mail address'. Is it possible to lookup the Outlook Address Book and retrieve the email addresses in a Combo box ??

I have the following piece of code which runs when a user exits a particular record. On checking the Database i find that this hasnt occurred on some occasions and my data therefore is incorrect, can someone tell me how I would run this code against ALL records in my database, as a macro...

What is wrong with the following expression :- [Customer]=10 And [PO_Number]IsNull I'm trying to highlight a field were this condition is true ??

I am using the following code which I found on this site to generate e-mails from within my application. It works fine except a creates another session of Outlook everytime I call the routine even if I already have Outlook running. I'm using Access 2007 and Oitlook 2007. Public Function...

I have a piece of code that generates an Outlook email message together with an attachment (PDF file). I also add my Outlook signature which contains text and company logos. The text displays fine but I get the following error message instead of the logos ' The image part with relationship ID...

I have 2 Tables - Property and Service I want to add a new Service Record attached to my Property Record. Key for Property Table is PropertyID Key for Service Table is ServiceID The records in Service Table also contain a field PropertyID which is the link/relationship between the tables...

I’m trying to attach a PDF (EstimatePrint) as an attachment to my Outlook Message. Everytime I run it, it just hangs Outlook with NO errors. I assume I’m not referring to the PDF correctly ??? If I take out the Add.Attachment it works fine !! The code is below, any help would be appreciated...

I have a field 'Customer Name' on my form 'EstimatesNew' and I retrieve records from my Customer Table to autofill my form. If I wish to create a NEW customer it pops up with a new Customer Details Form. However it doesnt inherit the Data I've inserted in the original field on my main form. What...

I have a Form which contains a sub-form. I wish to limit the number of records entered/viewed on the sub-form to say 10. This is because I have pre-printed stationery which will only allow a limited number of sub-form records. Any ideas ???

I am using Access 2007 and Outlook 2007 and I am using the SendObj command to send a PDF document as an attachment to an individual e-mail. I have 5 computers within the office and the command works fine on 2 machines but not on the other 3 machines. They are all running Access/Outlook 2007. I...

I'm using SendObject to send an e-mail containing a PDF, how can I add an autosignature. i'm using Access 2007

I need to print info on the bottom of the first page of a report but no the subsequent pages. Can I hide page footer if its NOT page no 1 ???

I have a form with 2 sub-forms side-by-side. The sub-forms are too big to fit on a normal size screen, so I have scroll bars both vertically and horizontally. However, on each of the sub-forms I have a number of BLANK columns at the end of the data, thereby making the width of the sub-form...

I have the following piece of VBA code which is called AfterUpdate Me.Text62 = DLookup("[Job Desc]", "Projects Extended", "[ProjectID]=" & Nz(Me![Project], 0)) This retrieves Job Desc and puts it in field Text62 on my sub-form. However, when I enter another record with a different ProjectID...

Why does my sub-form only show one record after I've hit enter. It seems to save the individual records OK but it only shows the new record ???

How can I open a form as a tab rather than a new window ?? I just cant find the appropriate parameter !! I dont wish the form to be a tab of the form already open Thanks

I wish to create a simple data entry form as follows :- Main Form(Header) will contain a JobNo, Date, Supplier then a sub-form(Detail) will contain x number of detail records containing unique ID no, description, amount etc. It should output to ONE record to a file containing both the Header...

I have designed a form using a normal screen size and when I try and display the form on a wider screen I lose the formats for certain fields. Not sure why this is occurring.

I have a Main-Form with 2 sub-forms and I am using the sub-forms for data entry. The problem I have is that when the user completes an entry on the sub-form the cursor moves back to the Main-Form and I want it to move to a new record on the appropriate sub-form. How do I achieve this ??

When I open my form it displays as another window. I want it to appear as another TAB from my previous window. How do I do it ??