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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: Lynne41
  • Content: Threads
  • Order by date
  1. Lynne41

    Working day difference between two dates

    Hi I am trying to calculate the working days difference between 2 dates. I have set up a calendar form to do this which will enter the dates and date difference in a table by inputting into unbound combo boxes which bring the calendar up when clicked. Whatever dates and date difference is in...
  2. Lynne41

    Importing Objects from CD (D: Drive)

    Hi I have imported forms in from a CD and now the VBA code doesn't work on any of the command buttons. When I change the form it also won't let me save - it just doesn't do anything (no warning msg) How can I resolve this and why does this happen? Thanks Lynne
  3. Lynne41

    Appending data from one worksheet to another

    Hi I have a spreadsheet with 3 worksheets. I am trying to get data over from one sheet to another if it meets a certain criteria (ie a grading of 2 or 3). How can I get the data over so it appends below the previous one and therefore eliminates blank lines? The data is as follows: Grade...
  4. Lynne41

    Colour coding - Access 2000

    Hi there Can anyone help me with Conditional formatting based on a criteria? I have set up a conditional format for a report.The difference between two number fields returns a number depending on what the answer is. I have 4 conditional formats to set but MS Access 2000 only lets me set 3...
  5. Lynne41

    Crosstab Query

    Sorry - me again! I have a table comprising of results as follows: ID Provider1 Provider2 Provider3 (up to Provider42) 1 5 4 (being rating between 1 and 6) There are 236 ID's and 42 Providers. My question is: How can I get the data into a "Results" table so...
  6. Lynne41

    Form doesn't exist but shows in Object Library

    Hi there I created a test form in my Access dbase but deleted it. I now can't open any form from a command button as I get an error message "Module not found". Having looked at the Object Library my deleted form is showing there but on clicking it it says "Form_Form1 not...

Part and Inventory Search

Back
Top