Maintenance Scheduler
Feb 13, 2006
Morning guys and gals
I am trying to create a sceduling calendar for my department which displays given events day by day.
I have created this using subforms for each day and a combo box to select the month.
For display purposes it works fine but I am having a little difficulty with the functionality.
I want to be able to click into any of the subforms, and depending on whether there is data within, open a specific document.
1)If there is an item in the schedule the I want to open a report filtered for that date.
2)If the day is blank then I want to open a form to input an item. (This works but I cannot get the date to pre-fill)
I have created a seperate piece of code to do this but it doesn't want to work. It may be because my knowledge of VB isn't what it was or it may be that I am completely barking up the wrong tree.
Hopefully someone can have a look and let me know where I am going wrong.
Code
Private Sub OpenCalRep(date1 As Date)
If date1 = Null Then
DoCmd.OpenForm "frmmaintenance", , , , acFormAdd
Forms!frmmaintenance.txtDate = Forms!frmcalsite.txtDate
Else
DoCmd.OpenReport "rptmaintenance", acViewPreview, , "Tables!tblmaintenance.txtdate" = "forms!frmcalmain.sf1.form!txtdate"
End If
End Sub
I realise that there is no counter to increment the subform name yet (SF1, SF2, etc) but I want to get the code to work for just the first box initially so I know that I'm heading in the right direction.
This code is the prefilled from the subform by using:
Private Sub SF1_Enter()
OpenCalRep (Forms!frmcalmain.SF1.Form!txtDate)
End Sub
I realise that there is no counter to increment the subform name yet (SF1, SF2, etc) but I want to get the code to work for just the first box initially so I know that I'm heading in the right direction.
Regards
Jason
View Replies
ADVERTISEMENT
Aug 17, 2007
Hi folks,
I have searched on this, but did not find any article that is comprehensive enough. I wonder if anyone can advise on database maintenance routines particularly for Microsoft Access.
I know:
Regular Back ups
Compact and repair database
Please fell free to add on to this list.
Thanks,
B
View 4 Replies
View Related
Jun 7, 2007
My database consists of several forms linked by open form buttons that function as "previous" and "next" navigators through this series of forms. Each time I switch from one form to the other, the record jumps back to the first record.
Question:
When entering a new record, how can I make it so that when I switch from the first form to subsequent forms, the record on the subsequent forms will match the record on the form prior to it without having to use the record navigation buttons at the bottom of the form.
View 5 Replies
View Related
Apr 4, 2007
Got a little system going whereby when a job is created it will display the date that the job is next due by.
I'm trying to work out how to create a qry that will display all due dates & not just the next one.
Here is how it should work.
If a job is created on the 1st of April 2007 & the type of job is MONTHLY then I want it to list the rest of the monthly orders that are planned for the year.
Here are the different PPM types that I'm using to calculate with
8784= Yearly
43848= 5 Yearly
2208= 3 Monthly
744= Monthly
168= Weekly
Has anyone done anything similar cause I can't see how it can be done?
This is what I'm using to create the next date due
NextDue: DateAdd("h",DLookUp("[PPMNextDue]","[tblPPMType]","[tblPPMType]![PPMID]=" & [PPMID]),[DateReported])
Here is my qry that the above code is in.
SELECT tblPPMType.PPMID, tblBuildings.PropertyName, tblPPMType.PPMType, tblTasks.DateReported, tblPPMType.PPMNextDue, DateAdd("h",DLookUp("[PPMNextDue]","[tblPPMType]","[tblPPMType]![PPMID]=" & [PPMID]),[DateReported]) AS NextDue, tblContracts.ConDescription
FROM tblContracts INNER JOIN (tblBuildings INNER JOIN (tblPPMType INNER JOIN tblTasks ON tblPPMType.PPMType = tblTasks.JobDetails) ON tblBuildings.ProID = tblTasks.BuildingID) ON tblContracts.ContID = tblTasks.ContractNo
ORDER BY tblPPMType.PPMType;
This is the result.
DateReported---------PPMNextDue--------NextDue
14/03/2007 14:35:34----8784----14/03/2008 14:35:34
15/03/2007 15:08:00----8784----15/03/2008 15:08:00
15/03/2007 10:07:11----8784----15/03/2008 10:07:11
14/03/2007 14:52:56----2208----14/06/2007 14:52:56
15/03/2007 15:10:21----2208----15/06/2007 15:10:21
15/03/2007 10:19:35----43848----15/03/2012 10:19:35
14/03/2007 14:54:13----43848----14/03/2012 14:54:13
14/03/2007 14:55:15----4416----14/09/2007 14:55:15
15/03/2007 22:36:27----744----15/04/2007 22:36:27
14/03/2007 14:56:30----744----14/04/2007 14:56:30
15/03/2007 20:34:27----744----15/04/2007 20:34:27
18/03/2007 22:38:41----744----18/04/2007 22:38:41
15/03/2007 13:39:02----744----15/04/2007 13:39:02
15/03/2007 10:58:55----168----22/03/2007 10:58:55
14/03/2007 14:59:21----168----21/03/2007 14:59:21
Any suggestions will be welcomed
thanks :)
View 2 Replies
View Related
Sep 24, 2005
Hi,
I can't seem to get this right...any help much appreciated:
I have a two tables LESSON<PAYMENT (One to Many)
LESSON
Lesson_ID (PK autonumber)
Lesson_Date (Date)
PAYMENT
Payment_ID (PK autonumber)
Lesson_ID (FK)
Payment_Date (Date)
I am maintaining LESSON using a simple form. On creating each new LESSON record, I also wish to insert a row into PAYMENT, using values from the LESSON table - Payment_ID(autonumber), Lesson_ID = LESSON.Lesson_ID, Payment_Date = LESSON.Lesson_Date
What is the best way to do this?
I have tried to add an Event Procedure to 'Before Insert' but I can't seem to get the syntax correct. Also, for this to work, do I need to paint all fields on LESSON form including (hidden) PK?
I have simplified the tables above but they are relevant to what I am trying to do. Any help would be much appreciated- am new to Access...rather frustrating.
Many thanks,
Simon.
PS I have searched through existing messages but can't see one that answers this, I apologise if this has been answered before- just point me to the orig post.
View 2 Replies
View Related
Jul 15, 2015
I have a table called schedule maintenance.
In that table I have a "date" field
Is it possible that if " todays" date = a date in the field date a e-mail can be sent to me to remind me there is a scheduled maintenance to be done.
View 6 Replies
View Related
Jun 1, 2007
About 2 years agao I created a FABTASTIC database in Access that was scheduled to run each day. Since then I have move companies and now can't remember for the life of me how to create this in Microsoft Scheduler. I can get it to open Access, but not a specific .mdb and not a specific Macro
Please Help
Thanks
View 2 Replies
View Related
Aug 30, 2005
Hi,
I just returned from quite a long trip browsing and searching the forums, but I am unable to find anything that could help me. Some things were more or less related, but most weren't close enough.
I have a classroom and this classroom is full of computers. People can make reservations on those computers and generally do so ;-) I want to be able to get rid of the silly excel-spreadsheet I am using now to schedule these computers and people. People can come whenever they like and stay for a fixed number of hours (generally anyway ;-) ).
What I want is:
- to be able to store the people's personalia (no problem)
- to be able to assign the people to computers on certain dates and certain times (no problem)
- to check whether the people can actually use a computer (whether one is available). This is more difficult, I guess, but I think I can do this
- to be able to see 'at a glance' who is scheduled to come for today (or this week and at what time. (Let's say I want the computers in columns and the time in the rows, per half an hour). I'll try and draw a picture below this post). I have no idea whether this is humanly possible. I don't mind spending some time with it. First I would like to hear your thoughts about before I pursue this project...
So, any input about this is welcome. I am sure I must have missed some relevants posts on this forum here, so please feel free to submit any links or search queries to help me...
Also, your thoughts about this are much appreciated, especially about the overview table.
Thanks in advance!
+------+------+------+------+------+
| |comp 1|comp 2|comp 3|comp 4|
|10:00 |John | | | |
|10:30 |John |Maria| | |
|11:00 | |Maria| | |
|11:30 | etc |Maria| | |
|etc | etc | etc | | |
+------+------+-----+------+------+
View 4 Replies
View Related
Aug 14, 2006
Hi
I'm creating a medical journal for privat home use.
Is there anyone that know about a free appointment scheduler preferable in Access 2003 format?
Or how should I solve this?
Mikael
View 1 Replies
View Related
Dec 4, 2007
There are some ideas floating around these forums on "booking" databases and whatnot, but I have a bit of a different twist with what I am trying to accomplish.
I am trying to develop at database that will allow users to log in and schedule their vacations. I have 2 tables at the moment tblEmployees and tblVacations. In the tblEmployees table you have:
EmployeeID (autonumber)
EmployeeName (text)
HireDate (date)
weekseligible (text)
the weekseligible field will be entered manually and be between 3 to 6 weeks of total possible vacation weeks.
The tblVacations has the following fields:
ID (autonumber)
weekofyear (date field with week starting sunday for all 52 weeks)
vacation1
vacation2
vacation3
vacation4
Only 4 people can take vacation any one week of the year. The vacation fields will be combo boxes where an employee can select their name from a query based on the employees table.
What i need to happen is to prevent someone from scheduling more weeks than their weeks eligible - I have no idea how to do this. My guess is there should be someway to do this using queries and somesort of a count function, but I am having a hard time getting started.
any help is greatly appreciated.
Thank You!
View 1 Replies
View Related
Nov 15, 2005
I want to build a room scheduler. Before I get too far in to my first attempts, does anyone know if there any examples out there I can use to give me ideas?
If not I wonder can anyone advise me as to a difficulty I currently can see with what my attempts so far. I have built a very basic database with fields for each room and time slots through each day. This works ok. The problem I see is finding a way of setting a room booked for say "every Thursday between 14.00 and 15:00". I have considered using a query to do it but cannot see how to formulate it.
Thanks in advance for any help you may offer.
Peter
View 2 Replies
View Related
Aug 17, 2013
I've built and implemented an Access 2010 application for a corporate client. It's entirely menu driven, with no user access to the navigation pane. It's split with multiple BEs on a share drive and the FEs on individual PCs (distributed via Auto FE Updater). Two hundred users have been defined to the application but so far there are only up to 10 max concurrent users at a time.
The clients want to add more users to the system but after that will go into maintenance and support mode. The question is how much I should charge for the maintenance and support service on a monthly basis.
I'm not looking for a $ amount as much as strategies/guidelines for pricing. The clients anticipate using the application for about four years, at which point a new, corporate-wide application should be rolled out and my app will get replaced by it. They will probably need to convert the data from my app into the new app, and will want/need occasional enhancements to the system over the next four years as well.
View 1 Replies
View Related
Aug 7, 2006
Does anybody know how to schedule in access like sql. Like a "job" in sql server?
View 14 Replies
View Related
Mar 19, 2014
Just got a new Windows 7 computer and installed Office 2013. I have a report that saves itself as a pdf in a temp folder and then attaches the pdf to an email and sends it out. I use a macro to run the report and everything works fine from there. I have a VBS file that runs the macro and clicking the vbs file makes everything work fine. the code is below.
When I tried to run it though the task scheduler it show as completing fine, but it doesn't. So I added a reference the vbs in a batch file (below) and output the logs to a temp file. After I ran the batch and opened the log I seen the message
Wed 03/19/2014 14:11:17.74 Username
C:Users*****DesktopAuto Reportsaragingrecent.vbs(1, 1) Microsoft VBScript runtime error: Permission denied: 'CreateObject'
Wed 03/19/2014 14:11:17.77
I turned UAC all the way down. turn off the virus scanner, and have local and domain admin access. I'm at bit a lose here. I had this working before but can't seem to remember how I did it. This is just one example I have several other reports that were schedule to run overnight, but they basically all use the same code and processes.
Code:
'launch macro
set accessApp = CreateObject("Access.Application")
accessApp.OpenCurrentDatabase "C:Users******DesktopAuto ReportsAgedTrialBalance.mdb"
accessApp.DoCmd.RunMacro "MCRecent"
[Code] ....
View 2 Replies
View Related
Sep 17, 2013
I am trying to get windows server 2012 task scheduler to open my access database. When the task runs all that I see happen is the locking file will appear on my desktop and I have to go to the task manager and kill it to make it stop. I tried a .bat file to open it as well and im still getting the same thing. If I just click on the database and open it manually it runs just fine.
View 3 Replies
View Related
Sep 16, 2013
Without putting a /CMD parameter value in the command line, is there any way to detect in VBA that the current state of the application is that it is executing from a scheduled task ?
What's happening is that my Outlook email is failing because a Namespace Logon method cannot be invoked when there is no user logged in. I must jump over that statement when running from a scheduler.
View 2 Replies
View Related
May 1, 2013
I have an Access database that sends an email to users when there is an exception in the query. It works fine when I run it from Windows 7, but when I use task scheduler I get an error message;
Runtime error 429 activex component can't create object
and the error stops a;
Set olapp = New Outlook.Application
It only happens when i run it from Task Scheduler.
View 14 Replies
View Related
Jan 25, 2008
Hi,
WHen I used Windows task scheduler to start my application, and then close the application normally, the application closes but Access is left running, still visible in the task bar. The only way I can get it to close is by using task manager to kill it. I found an old KB article ( # 246953) that hints that this (or something like it) is a known bug in Access 2000 but supposedly was resolved by an Office 2000 service pack 2. But I am already running Windows XP, SP2. Anyone else having this problem? Any workarounds?
View 1 Replies
View Related