Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JamesLynch

    Removing decimal places

    After building an expression to work out a percentage value I am left with a figure like 4.22225645. How can I cut the decimal places down to just one of two figures. Even Better can I round the value up and Down. Thanks James
  2. JamesLynch

    Summing up values

    I have two Sales teams that need to be reported on a daily basis, with each team have four people and each of these (hopefully) make more than one sale per day. As you can imagine there are a number of results that I need to produce, namely - The total Sales value per Sales person(summary, not...
  3. JamesLynch

    Filters on a form

    I have a table with 100 records with eight fields in each. A form that displays two tick boxes. - Checked (y/n) - Succesful (y/n) I need the end user to select to check through these records and tick them off, if a similar record is found from a diffenent source. So far, so good. However I...
  4. JamesLynch

    Compiler Error, Ambigious name detected.

    Having selected the "Add new record" option from the command box, I receive the following error message when I return to form view. Compiler Error, Ambigious name detected. Err_Save_Record_Click Any ideas folks?
  5. JamesLynch

    Systems Clock and date.

    Is it possible to import the system date into a particular field. Thereby everytime the end user enters their sales details, the time and date is automaticaly recorded, in turn these can then be sorted by various time frames?
  6. JamesLynch

    Using Tabs

    I wish to create a four sections type questionaire, using a tab for each section. What do I need to do to forcce the end user to complete all the fields in the first section / tab before moving onto the next. I also need to ensure that each tab is completed before a new record can be started...
  7. JamesLynch

    Importing from Outlook into Access

    I am importing a series of Outlook forms that contain the same eight fields into Access. However having successfully imported these records via the “Get External Data” option, I only seem to have imported the static email Categories / Fields, i.e. ID, Importance, Icon, Sender name, etc. While...
  8. JamesLynch

    Can I manually edit the Autonumber

    In my last query I asked.... I need to enter a set of records on a daily basis, which contain the same fields. Customer details etc. With the exception of cutting and pasting the following days records, is there any way to include the both days records together without over writing the first...
  9. JamesLynch

    Importing one set of data on top of another

    In my last query I asked.... I need to enter a set of records on a daily basis, which contain the same fields. Customer details etc. With the exception of cutting and pasting the following days records, is there any way to include the both days records together without over writing the first...
  10. JamesLynch

    Importing one set of data on top of another

    Thank you FancyPrairie for your early suggestion, it worked a treat. Now for my latest question. I need to enter a set of records on a daily basis, which contain the same fields. Customer details etc. With the exception of cutting and pasting the following days records, is there any way to...
  11. JamesLynch

    Importing Records from MS Outlook into Access

    I need to import an Outlook template containing eight fields, into MS Access. Unfortunately I don't know where to start with this process and I am presently forced to - Convert each of these emails into a .txt format (as there is no .csv format available) - Convert each of these files into...

Part and Inventory Search

Back
Top