Search results

  1. C

    Question HELP! All but forms and queries are gone?

    Hi I got a message from someone in another office to say that she could not generate a report, so she restarted the database and got the following error: The form name "Index" is misspelled or refers to a form that doesn't exist I can still use the database fine but when I opened a second...
  2. C

    Filtered lookup combo box?

    On my form, I have two combo boxes which are populated by a table of employees. One is for project director and the other for project manager. These are stored as ID numbers but displayed as full names in a dropdown list. I'm wondering, as we only have 4 directors, can I filter the list so that...
  3. C

    Using IF to dismiss negative numbers

    Hi I have the following expression I use to round down when breaking down Fee Proposals: Int([PriceQuoted]/[HourlyRate]*2-0.5)/2 This works perfectly, except if I do not enter a price I get a figure of -0.5, obv. Could I use the If function to have it give me zero if I leave the price blank?
  4. C

    Upgrading MS Office

    Hi I'm hoping someone with some experience in this may know more than I. I'm looking to upgrade MS Office at work. But there's FAR too many options and I just wanna :banghead::banghead::banghead: Basically, I have 20 users so understand that I need 20 individual copies. I've been quoted £180...
  5. C

    Making a database for ISO monitoring

    Does anybody use Microsoft Access to monitor ISO standards? Considering it for the 2015 QMS and EMS and wondered if anybody had any experience with doing so?
  6. C

    Question Absolute beginner in need of certification - version help

    Hi :) I'm hoping somebody in here can assist. Until I started my admin job 3 months ago, I had never heard of Access. My company has a very old database (10+ years) which runs on Access 2007. After getting to know my way around (as a user rather than maintainer), I believe this can be made far...
Top Bottom