Search results

  1. G

    Image Quality

    I am inserting an image into Access 2007 (it is a company logo) using the commands on the Forms Design Tab. The image should have a white/transparent background and if I choose Insert Picture in Word, it appears perfectly, but using either the Logo or Image command from the Design Tab, my...
  2. G

    disable outlook security dialogue box

    I have successfully managed (with help from forums) to write some code to send a report to Outlook, but the security dialog box in Outlook keeps appearing requiring user intervention. I have found various bits of code on the system, but they all seem to be packages that you have to pay for. I am...
  3. G

    email a report automatically

    I have set up a task scheduler to automatically run a macro to call a VBA script to email a report. I have set up the task scheduler as follows Action - Start a program Program/Script - "C:\Users\User\Desktop\CIS Database.mdb" Argurments -/x ReviewDate This appears to be working correctly as...
  4. G

    automatically transfer a field when form opens in add mode

    I have a supplier form (frmsuppliers) where I add the information for new suppliers, I want users to be able to click on a button to open the contacts form frmcontacts in add mode with the name of the supplier that was shown automatically shown on the screen. The following code opens the form...
  5. G

    Argument Not Optional when emailing an order

    I have an order form and I want users to be able to email selected information from this form to the supplier when they have completed the order entry, I have found some code which I have adapted, but when I click on the command button to run this code I get Argument Not Optional with the name...
  6. G

    overcoming blank date fields when used in calculated field in a query

    I have three fields, coursestartdate, courseplannedenddate and a calculated field which uses both date fields. Doc6Overdue: IIf(DateAdd("d",(([courseplannedenddate]-[coursestartdate])/5),[coursestartdate])<=Date(),"overdue","notoverdue"). This query works well and correctly gives overdue...
  7. G

    trapping errors - is there access equivalent of iserror in excel

    I have the field shown below in a query which is now working properly and correctly putting either Overdue or Not Overdue in a new field. I am then searching on this field to obtain any overdue records. This is all fine. Reviewdate1...
  8. G

    default value in combo box in form

    I have a form which has four tabs on it. Each tab is referencing fields in a table, but most of the fields are set as combo boxes. The combo boxes link to a lookup table (tblstatus)which give the choices of Yes,No or N/A. (was advised that this was better than lookupwizard). This appears to be...
  9. G

    refreshing a field on a tab on a form

    I have a form (frminputupdatecourseinfo) that has four tabs on it. On the first tab (Enrolment Info) I have a combo box that is referencing a lookup table (tblSubject). I have set this field (subjectiD) so that if the subject does not exist in the drop down list the user can double click to...
  10. G

    calculated field in a query which needs a filter

    I am created a calculated field which is working and correctly indicating either overdue or notoverdue when I run the query, but when I try and then put "overdue" in the criteria line of the query I get the message Data mismatch in Criteria Expression. Reviewdate1...
Back
Top Bottom