Search results

  1. C

    Rounding function to always round UP in MSAccess?

    Simple one, really.... I know the Round function exists in MSAccess, but what I need is one that will always round up, and never round down! Easy enough in Excel, but I can't find one in Access?
  2. C

    Question Help with using Excel linked tables

    !! WARNING - LONG POST!! I'm having a few issues with a database I've set up.... Each week I receive downloaded data in Excel - this is supplied to us in a pre-defined format from our client(s) (the data is actually timesheet information for Contractors) When we receive the data, it...
  3. C

    Question Time input (masks / 'translation'

    I'm struggling with putting together a form to allow the input of times into a database that I'm building... the purpose of the database is to log stage times for competitors on a car rally! The users need to input a start time and end time for each car on each stage, along with any stage...
  4. C

    Turning Column Names into field values?

    Sorry if this should be posted somewhere else but I couldn't work out where to post it! Anyway: I have a spreadsheet which contains data exported from another system (which I have no control over). I'm using this spreadsheet as a linked table in my database. The problem I am having is that...
  5. C

    Help with subqueries... aaarrggh!!

    Access 2007. I have a training database which logs all our employees and which training courses they have been enrolled on (plus when they attended, etc... ) What I am trying to do is to write a query which tells me which of our current employees has NOT been enrolled on a certain course...
  6. C

    Sort Mainform based on earliest date on subform?

    I have a form which shows training events - these can take place over one or several days, and can be run by one trainer or several, so I have my basic Events Info in one table (EventID, EventType, Location, that kind of thing) and the 'Jobs' in a separate table (EventID, JobDate, TrainerID...
    • CazB
    • Thread
    • Replies: 12
    • Forum: Forms
  7. C

    Perplexed!

    I'm looking for some help here (obviously!) I have a database which tracks Sales Leads... in tblLeads (which is a download from another system, so I have no control over how it 'appears' in my database) I have LeadID (PK) ConsultantID (FK to tblConsultants) DateLeadPulled (Date ;) )...
  8. C

    Dim db As DAO.database - says user-defined type not defined?

    I have an 'old' database that was originally set up in Access 2003 and I've had to leave it that way as we still have a couple of users who are using 2003 (I'm on 2007...) Don't know if that's the problem but when I just tried putting Dim db As DAO.database into my module code in a form...
  9. C

    Using an array to speciy email recipients (Access 2007 - Lotus Notes)

    I've got a form which emails out a report when a new record is added to my database but I'm stuck when it comes to making it send it to more than one recipient. I came across this on the web... which suggests I should be using an array but I don't know anything about arrays so I'm...
  10. C

    Question about Form Events (and which one I should use!)

    I have a form where, whenever a new record is created, I want a report to be emailed out. I have some code (almost ;) ) which will email the report, but which Event should I attach the code to? The form opens in data entry mode. I know the 'easy' option would be to put a button on the form...
  11. C

    Problem sending a report from 2007 via Lotus Notes

    I have a function which generates a report as a RTF file, then sends it out to a list of users via Lotus Notes. The list of users is generated within the function using a query. The code worked fine while I was testing with just me in the recipients... but as soon as I add more people to the...
  12. C

    Help With Setting Colours.... Declaring A Constant?

    Hopefully a simple question: Access 2007: I have a continuous form which, when it opens, uses code to display alternating colours... I need to set a default 'alternate' colour, and I want to find the code to use for Light Grey - on the design of a form, the color to use on a control would...
  13. C

    Sending emails: selecting recipients from a table? Access 2007

    In an Access 2007 module, is there a way of sending an email to a list of people stored as a list in a table in the database, rather than having to put all the names into the function? I have a function I'm using to generate and send out an email to certain people, but the list is constantly...
  14. C

    Help please - trying to email a report as a RTF but it comes up as .tmp?

    Hoping someone can help me.... Using Access 2007 and Lotus Notes 8.5 I've got some code to output a report to email as an attachment: it looks like this DoCmd.SendObject acSendReport, "rep09emailnotification", acFormatRTF, "(Recipients)", , , "email subject", "email body text", 0 For...
  15. C

    Hello... from sunny Cheshire!

    Morning everyone, I'm Caz and I've been using MS Access on and off for over 15 years, and have been through a number of upgrades in that time! I currently work as an IT Trainer but I also maintain a couple of smallish databases that I developed using MS Access 2000 that have since been updated...
Top Bottom