Search results

  1. arfox

    VBA sql updates too many records in query

    Hello all- I have what I thought was a simple programming problem... but I think I am going about it the wrong way as the solution has turned into a disaster. Basically I have a form called "frmworkCallSub" that users can use to enter scheduling information for employees. There is an...
  2. arfox

    SQL Update and date format

    Hello all- I'm having a syntax, possibly datatype problem with some VBA code and its driving me UP THE WALL!! I'm trying to create a runnning sum totalH for a field in a query. I am taking the values from "TotalTime" and putting the running sum in HourTotal . The gist (minus selection loops...
  3. arfox

    Employee Availability and Scheduling... Excel and Access

    I actually already have tables forms and queries for the employee contact info I need... pretty comfortable with database design basics. I'm just getting hung up on how to represent the -=availability=- data in a table. In the spreadsheet I'm cross-referencing the rows(times) with...
  4. arfox

    Employee Availability and Scheduling... Excel and Access

    Thanks for the advice... that sounds very helpful! My biggest source of confusion is how to store the data in the underlying tables... I'm hung up on the idea of the spreadsheet and am not sure how to represent the same data in a simple table. Do I store a list of availabilities, or have a...
  5. arfox

    Employee Availability and Scheduling... Excel and Access

    Hello there! I am a computer science major new to database development. I have volunteered to develop a database for my employer to store employee availability and allow supervisors to view employee availability and schedule them accordingly. Right now, they are using an excel workbook...
Back
Top Bottom