Search results

  1. O

    Should be simple query - giving me heartache

    I have which I thought would be an ultra-simple matter that is turning into nothing but trouble - I'm under a time constraint and am getting to the point where I have to look for assistance - so thought there was no better place than this forum. Basically I pulled some data into an access...
  2. O

    Build/Export File - Loop through table records

    A coworker has a set of test files (txt format) which they use consistently - sometimes the test region they are using changes so they have to open up each file and change a small portion of it to point to the new test region. (There will be other changes done as well sometimes, or...
  3. O

    Advice On Table Fields

    I am looking to improve a current report model that consists of spreadsheets all over the place for each and every month, quarter, year, etc. One of the things that I am going to attempt to integrate is some web reporting to my companies biggest client. What we currently report to them is...
  4. O

    Enter Parameter Value -> But Parameter is present

    Hello all! I'm having an issue with a DB that I'm working on which I can't figure why it is happening. So here is what is going on: I have a form: frm_WeeklyInformationEntry and on this form are two fields titled: Weekly_Start_Date & Weekly_End_Date. I have a table: tblDocSent that has...
  5. O

    Quarterly Addition Field in Report

    This is probably simple, but I have not been using Access/VB for several years now and my skills are quite rusty. So my situation is this: My area has web reports that are put together monthly and it has always been done using Excel. This task has been handed back to me while a co-worker is...
  6. O

    Help with automated email

    OK - we have a person leaving our department in a couple weeks and one of the tasks she does is coming to me. Basically what this task is is: she has a list of about 30 people that she emails quarterly to remind them to review their content on the website. Each person's email has links to...
  7. O

    Conditional formatting - highlight entire row based on keywords in different columns

    I apologize if this has been answered - this site is loading like junk right now and I'm having a hard time navigating it (my company is stuck on IE 8 and I have problems with a lot of sites. Don't know if it is the browser or what the deal it, just know it sucks) Anyhow, this is what I have...
  8. O

    Mail Merge Help

    I'll do my best to explain what I am wanting to do here with a mail merge (Word 2007). I have data in an excel file which looks like: Group A Group B Name Y/N 12345 1234A John Smith N 12345 1234B John Smith Y 98765...
  9. O

    Shortcut vs Dedicated Front End to DB

    I'm getting ready to push out a new DB for approximately 20 people to use - it is used to document names/addresses & then generate new files with updated addresses. A prior version of this had usage that generated approximately 40,000 records per year. At any given time there would be about 10...
  10. O

    DB for tracking Testing

    First let me say I browsed but did not find anything matching this but if I missed it please feel free to point me in the right direction. Also, thanks in advance for any input. OK - so currently when keeping track of my test cases I have a spreadsheet and just go down the list on them making...
  11. O

    Require field only if specific combo selection made

    Thanks in advance for any assistance with this - and I browsed through the forms sections but did not see an answer to this. My form has a combo box (Reason) and several text fields on it. What I would like to happen is if Reason 1 is selected, then Text_Field1 becomes required. If any...
  12. O

    Find Duplicate Values

    Hello, I have an Excel file which has 4 different worksheets on it. The first worksheet (profiles) has a listing of User Names and Group #'s. The other 3 tabs have a listing of all the available group #'s split by their their different categories (small, large, individual). The task I...
  13. O

    email attachment - lotus notes

    I have a feeling this must be covered somewhere, but I didn't find anything - if it's out there I'm sorry for asking, and feel free to point me in the correct direction. Right now I have a macro that will open lotus notes & attach my report into it and all I have to do is hit the send button...
  14. O

    Simple Sales DB

    I know this is very easy, but I have not looked at access for about 7 years and am finding it very difficult. All I am trying to create is a super simple sales database. I intended to have 3 tables: customer, product, orders and basically have a simple form where I would: A. Select the...
Top Bottom