Scheduling Software Needed
I am looking for some scheduling software to meet the following requirements:
The ideal requirements for a new scheduling tool would be:
•More robust than LaunchPad, but less complicated that Maestro
•ability to initiate specific Access macros (not using an autoexec macro) REQUIRED
•must provide detailed audit logs to show success or failure of each job REQUIRED
•ability to monitor shares for files or file changes
•Networked version for shared access?
•Must be controlled from within the team
Does anybody have any suggestions?
Thank you.
View Complete Forum Thread with Replies
Related Forum Messages:
Scheduling Database
Hi all, I'm just starting on a new project to create a scheduling database for a small company (about 20 people). What i aim to do is to edit calander entries (Month view) and view calander entries hopefully using a control that looks as much like Outlook as possible again this would hopefully show what these 20 people are doing over the month. My question is: Can you use outlook to do this, or would you have to use a control and does anyone know what/how to use this control. Any help will be greatly appreciated! Matt
View Replies !
WorkForce Scheduling......
HI All.... I have a question which I believe I may already know the answer to but Here it goes. I am trying to create a db that can track and employee shift schedules. I have 28 employees and we work 24X7 so we have 3 shifts, days, evenings and night. I cant seem to get my head around how I would create it. I have tried like 10 different ways but I keep running into Form limits. They want to be able to schedule for the whole year out by month. I have attached a sample of what they want it to look like. If anyone knows of anything out there or could assist me in at least a correct starting point, I would be forever in debt to you. Thank you for taking the time to read this post and I look forward to hearing from you.
View Replies !
Room Scheduling
Can anyone point me in the direction of a room scheduling example or a tutor site. I originally wanted to use Outlook but my boss, after seeing another Acces Project I did, asked for it in the Access. I can build a basic data base on a daily basis showing rooms against hours, but my problem is forward scheduling eg "every Thursday meeting room 1 will be for Group A" etc. Can anyone please get me started - I'm tearing my hair out on this one! Thanks in advance. Peter
View Replies !
Calendar: Scheduling Meetings DB
;) Hello Guys: I need help creating a small Access Database to be able to make Schedules for Conference table Meetings. I am hoping to find an example, or if someone could please direct me to the right place where it’s been done before in Access 2000!? I was asked to use this Calendar: (“Calendar Control 9.0”) because all my co-workers have this Active X Control, which has Dates but not Time in and Out. I need to add Time or think of some other general Control, to add to this Database along with the Date Calendar. What my co-workers would like to do is to go inside the Database > choose their Name > pick a Date in a Calendar > pick a Time to RESERVE the meeting > place/ location, etc. The only thing right now I have is a Table for the Users, and I also need to figure out how to place it in the DB for other people to select their name and precede with other options. I need to make the DB recurring (like Outlook), notifying (e-mailing) of weekly Staff Meetings, for EX: every Wednesday for next months. So that next time, when somebody goes into the Database, they can see what Time slots are taken or Available on the Calendar. We tried this with Outlook, but it didn’t work due to the Conference table not being customized and not listed in the Company address List. Don’t mean to make it confusing - basically Outlook seems to be out of the question for my Group, therefore I was asked to look into Access :) . I don’t even know where to start. Can someone please help me modify this or I would be glad if you provide an Example for me to visualize where to start? In this Calendar, people want to be able to choose Hours. In addition, I need help with aesthetics for the Database tables, queries, forms/ Switchboard. Please let me know if you have any questions. Thanks a bunch in advance, Beginner:confused:
View Replies !
Employee Scheduling Database
Dear Access Expert. I would like to create a Scheduling database for employees. The database would include: - list all of the employees -tabs to look at schedule for this week, 1 week from now, 2weeks from now, 3 weeks from now, long term (1-2 months), etc -small comment section within each day for the guys to enter some comments...e.g. dentist at 10, holidays, etc There has to be something like this already out there that I can modify and work with. Is there anything like this already in the NorthWind Database that comes with Access? What about some free examples Access developers made? What about Outlook? Can I modify Outlook and use VBA somehow to accomplish this? Outlook is basically on an account basis so I don't know if I could tailor it to my 30+ employee database. Thank you very much for your input.
View Replies !
Calander Control W/ Scheduling HELP!
I have never used the calander control in access I am Very new to Access code as well. But I am Learning. This is what I am trying to do I have a Customers tbl and a Salesmen tbl I would like to have a calander that I can use to set appointments for multiple salesmen in a form. I have looked at the calanders posted here and now of them do anything like what I am trying to do. Is this possiable to do? Thanks in Advance for helping a newbie :confused:
View Replies !
Solution For User Scheduling
Hello All I am in need of a lot of help. The situation is as follows I have a table with users that have certain classes that they have to take and in another table I have the dates that these classes are offered. My problem is I want to find a way to map all the students to their required class by scheudling them into the required classes taking into account date conflicts and classes required before taking a certain other classes. I guess my question is if there is any possible to do this in access without me phyically having to schedule each users required classes to the correct time making sure there are no date conflicts. Any help would be highly appreciated because we are talking about 3000 users that need to have schedules and that is extremly time consuming if I have to sit here and do the schedule for each user. Thank you in advance for your time
View Replies !
Scheduling Access To Open And Run A Routine
Hi, I was wondering is it possible to schedule in windows somewhere to open up my syncfrontend.mdb and then run a routine that i have written inside of that mdb. The routine is a huge database syncronisation task that needs running every hour, it's all there ready to be run but just need a way to get to it and run it automatically on the hour every hour. Any ideas or help would be greatly appreciated! Thanks in advance
View Replies !
Creating Appointment Scheduling Form
HI all, Im fairly new at Access, nut ive been given the task of creating an appointment scheduling form, so that we can schedule a client for an appointment via this form. The idea i had in mind was to use a calendar to query the appointments table so that we can view all appointments for any particular day. any suggestions?
View Replies !
Scheduling Form With Calendar And DESPERATE
Here is my problem. I am hoping that someone here can be my hero on this one. I am trying to figure out what would be the best possible way to track my hospital's staffing. I need a form that I can click on the Active X calendar and have it populate the staffing table. I have built the code and it works great. The problem is that the way the code works now, I have to have a field in my table for every single date scheduled. For example, right now, I have the staffing table like this: Name Date Scheduled Date Scheduled1 Date Scheduled2 Date Scheduled3 Of course, after a month, an employee will have worked more than four shifts. I really don't want to add a field for every shift they could have worked because then, after a month, I'll have thirty date fields, and after a year, I'll have 365. So, do you have any ideas about how I can do this without having 365 date fields?? Thank you! If you can help me figure this out, you are my hero. KellyJo
View Replies !
What Programs/Software Should I Use?
I am hoping someone can give me guidance on a fairly major project I am working on. I am responsible for producing lots of figures, charts etc. each month and the current process takes a very long time! I have been charged with improving this process, which currently includes the following:- Slightly changing some CSV files each month Importing the CSV files to an Access database containing lots of other data and information Running some queries off an SQL database and importing the results to the access database Running a few queries in Access Exporting the query results to Excel Manual manipulation of the Excle files Producing graphs and tables in excel I am fairly experienced in Access and know a little Access VBA I know a bit of SQL to run queries from SQL query analyzer I have dabbled with VBA in excel But I wouldn't really call myself a programmer I need to automate the process as much as possible, but I am not sure which way to go. I would need a database to combine the data from CSV files and other information as current, but also need to build up a historical store of data. I would then want some kind of front end to select the months and year to look at, plus different categories etc. then produce a table and chart to excel or easily exported to excel for distribution to other people. Would a combination of Access and Excel using VBA be sufficient for this? A colleague has mentioned using SQL, in particular MySQL, which is downloadable for free. They have also said that you can develop a front end in visual basic and there are programs freely available where you can build a visual basic front end by drag and drop methods. They also mentioned that you could build a front end using Java. I have also read bits on this site about ASP and PHP and how they can be used as a front end with Access as a back end database. In short, I am getting confused about which combination of tools would be best suited for this job! Any assistant/opinions/thoughts would be greatly appreciated! The output tables/charts etc. would have to be distrubuted to a large range of people in the company. The database or front end would just be viewed by a couple of people. Many thanks! Sasha
View Replies !
Remove Software
Hi Need a little help with the following, running windows ME on a Compaq Presario Desktop, connected to Blueyonder Broadband, Blueyonder have provided a new anti virus and firewall package free of charge to broadband users, you need to remove your existing Virus and firewall package(McAfee) to load the new, which I have done, it appears that I still have remnants of a previous Norton Firewall, the only reference to it is when you access through the control panel and the add/remove programme, I have tried many times to remove it but the text is still there. I have searched for it but nothing comes up as found. Many thanks Derek
View Replies !
Asp Code Software
I realize this forum is mainly developers and code writers. I am far from either and I need help in developing a portion of our comapnies intranet. That said my question is : Are there any good software applications out there that do a good job at developing the web pages for putting a database online for a company intranet. I have come across several (asprunner, data asp ...). What is recommended for the person with no code ability? I am looking for users to be able to search, add and edit the database. One feature I would like is to be able to edit multiple fields. For example a table with fields: Name. Class, Date, Registered and Attended. I would like to be able to edit mulitple records at once for the Attended field instead of going into each record one at a time and marking if they attended or not. Thanks in advance for your help.
View Replies !
Fix Corrupt Files Software
Can anybody suggest which software is better for fixing corrupt MS Access files? In internet, there are many, but I don't know which one is best and guarantee. Please anybody suggest it for me, thanks.
View Replies !
Voice To Text Software
Hello everyone I am thinking of getting voice to text - software has anyone used this , and if so any recommendation - the use i had in mind was for word/outlook gbp
View Replies !
Software Licensing DB Development Help.
Hi I'm building a Software Licensing Database & I have come across this particular problem and i am not 100% sure which way would be the best way for me to solve it. So far I have created the database so that a user/software/license can be added to the system. The main form display's users information and below in a tabbed subform it displays the installed software on the machine. On the second tab it displays the license's attached to that machine. On each of these subforms its provides the user to add/delete software/license's however my problem is with error handling within the system. I have managed to make it so that a user can only selelct license's that are specific Each License can cover anywhere from 1 to <x-amount> of pc's. What I want to be able to do is the user can select a license if their is 1 available and a small text box which denote's how many license's are available. So i know im going to need a license count which is easy enough using a SUM within a query. It is the error handling that im stuck on. I need to create a statement using the 'equal to or greater than' operator if possible saying If NumberofLicenses >= then add license Else If vbOKonly message - "Insufficient License's to cover this piece of software please purchase & add the new license to the system then try again" Something along those lines.. I just dont know where this would go or how to write it! If anyone has a better way of achieving this.. fire away im open to ideas! cheers Ally
View Replies !
|
TRACKER
