An Even Harder Task

Nov 10, 2005

How would I combine all these instances under one After Update Click:


Private Sub lstAgreementType_AfterUpdate()

If Me.lstAgreementType.Value = "BN" Or Me.lstAgreementType.Value = "BA" Or Me.lstAgreementType.Value = "BT" Then
Me.txtSenateAandCDate.Enabled = False
Else
Me.txtSenateAandCDate.Enabled = True
End If

Private Sub lstAgreementType_AfterUpdate()

If Me.lstAgreementType.Value = "BN" Or Me.lstAgreementType.Value = "BA" Or Me.lstAgreementType.Value = "BT" Then
Me.txtSentateTreatyDoc.Enabled = False
Else
Me.txtSentateTreatyDoc.Enabled = True
End If

Private Sub lstAgreementType_AfterUpdate()

If Me.lstAgreementType.Value = "BN" Or Me.lstAgreementType.Value = "MN" Then
Me.txtRatsExchanged Date.Enabled = False
Else
Me. txtRatsExchanged Date.Enabled = True
End If

Private Sub lstAgreementType_AfterUpdate()

If Me.lstAgreementType.Value = "BN" Or Me.lstAgreementType.Value = "BA" Or Me.lstAgreementType.Value = "BT" Or Me.lstAgreementType.Value = "MN" Then
Me.lstDepositary.Enabled = False
Else
Me.lstDepositary.Enabled = True
End If

View Replies


ADVERTISEMENT

Queries :: Automate A Harder Date Field

Mar 12, 2014

I run a report based on dates I enter (see below)

>=[Date you wish to view DD/MM/YY] And <=[Enter the Date after DD/MM/YY]

I would like to automate this if possible, the dates are enter are always a set pattern

If its Monday I enter the previous Thursday and Sunday
If Its Tuesday I enter the previous Sunday and Monday
If Its Wednesday I enter the previous Monday and Tuesday
If Its Thursday I enter the previous Tuesday and Wednesday
If Its Friday I enter the previous Wednesday and Thursday
I dont run rthe report on weekends

View 7 Replies View Related

Help Task Pane???

Jul 6, 2005

Hi, im creating a new database system and want to give them a help facility in the form of a help task pane. Where they can access help from the table of contents, click on the item they want and the relevant help will appear.

Does anyone know how i can build this from scratch? :confused:

View 4 Replies View Related

Schedule A Task In Access

Oct 25, 2006

Hi i would like to know if it is possible to schedule a a task in access, at the moment i refresh all my excel report by using a button on a form in access and would like ot know if i can do this automatically

View 7 Replies View Related

Task Manager Problems

May 2, 2007

There are a few procedures that run when my Access database closes (backing up data, etc.). Since this can take a minute or two to finish (running over a network), one of the users here has started to use Task Manager to shut down the application.

This is not ideal, as the same user has also deleted the backend on more than one occasion. Should both happen on one day, we'd lose that day's updates.

Asking them not to do it doesn't work. Explaining why doesn't work. Telling them not to do it doesn't work. If I ask their supervisor to tell them not to do it, they just deny it. It's starting to look like the backup scripts aren't running, when they work fine for everyone else.

Is there any way of either
(a) Preventing them from doing this (unlikely, I'd have thought)
or
(b) Recording the fact that this has happened.

It doesn't necessarily have to be recorded in Access itself - although that would be ideal - if there's some other file I can access to get the info?

Any suggestions are gratefully received.

View 9 Replies View Related

How To Approach This Task Any Ideas More Than Welcome Thanks

Jul 30, 2007

Hi, ive been asked to provide a solution, for an electronic spreadsheet be sent out via email then returned by customers, once filled in for all the data to be collected onto one sheet that looks like the attached sheet. the easiset way i can see is to not use a spreadsheet but to use a datbase instead and just put it in the desired format, how easy is it to import mutliple spreasheets into correct fields on a dbtable thanks for any input or ideas

Al

View 3 Replies View Related

How To Always Keep Task Pane Open

Sep 26, 2005

Is there a way to always keep the task pane open? Right now when I open a file from the list on the task pane displayed under OPEN, the task pane disappears when the file opens. Then when I open the task pane again by clicking on the little white sheet of paper icon at upper left for "new", the task pane opens but the recent list of files used has collapsed and I have to click on the little house at top right to display the list of recently used files again so I can open one of them. Is there a way to keep both the task pane and the list of recently used files open at all times? Thanks.

View 5 Replies View Related

Calendar Based On Task

Dec 14, 2005

As a continuation from this thread (http://www.access-programmers.co.uk/forums/showthread.php?t=98369)...

Currently, I have a list of programs, each program could be considered the "task". When the task is completed, I want the user to click the date on the calendar and have it grayed out. As I mentioned before I have this working correctly, but I have the calendar pulling up based on a query that relys on the program ID. No problem, that way each program has it's own calendar. Now I need to be able to have it pull up the current month if one exists, and if it does not exist create it. For instance it works fine now, but once we hit 1/1/06, it will still be the same calendar... I want it to create a new record, so I could theoretically look at the old calendar if need be.

I tried to tie my query to a month field as well, but to no avail.

Thanks for your help!

View 14 Replies View Related

Help Accessing Task Manager

Aug 18, 2004

this has been "bugging" me for a while. everytime i access task
manager it opens for couple of seconds and then disappears. i heard
that this was some type of virus and/or spyware related. norton, spyware,
and adaware haven't seemed to solve this problem. please help

View 2 Replies View Related

Program Windows Scheduled Task

Aug 23, 2007

Hi All,

Does anyone one if it is possible to program a schedule for "Windows Scheduled Task" via VBA?

Reason:- A multi user application is set to give a 5 Min warning at the same time every day. After the 5min the users are politely kicked off.

At that time the Windows Scheduled task opens up the BE (only on 1 PC the fastest). The BE start form has a time event that backs up the BE and compacts and repairs itself then closes the application.

Not pretty I know but it works really well.

This shutdown time can be set/changed on the FE however, when it is the windows Scheduled Task has to also be changed which I would like to do automatically via VBA

Any help would be appreciated.

View 1 Replies View Related

Can We Supress Forms From The Task Panel?

Nov 7, 2006

Hi guys,

I have moved all my small databases into 1 larger database to save up on Taskbar space, but the problem is that when I use an opening form to open other forms (switchboard style) the additional forms show in the Start menu Task bar.

Is there some sort of macro that I can use to tell each form to suppress itself from the Task bar?

View 1 Replies View Related

Modules & VBA :: How To Force Windows Task Bar To Always Be On Top

Apr 14, 2014

I write Access 2010 apps in VBA that require no knowledge of Microsoft Access on the part of the user. My forms contain all the necessary controls to use the program without relying on any of the Microsoft Access toolbars. I call this "de-Microsofting" the app. When I prepare the .accdb program to create a .accde app, I uncheck every checkbox (Options/Current Database) except "Compact on Close". This works well, but it also hides the Windows taskbar at the bottom of the screen. Some of my users need to be able to jump from my app to others (e.g., Excel) and back without having to exit my app. How can I force the Windows taxkbar to always be on top using VBA or, possibly, some setting?

View 4 Replies View Related

General :: Task Scheduler To Run Macro?

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

General :: How To Execute A Task In Background

Feb 2, 2014

Is there a way to run a query, macro, and/or report in the "background". By this I mean in a way that frees up the current operator to do other things in the database while the query, macro, report keep on running?

View 1 Replies View Related

Create A Task Table That Is Associated With Project?

Feb 13, 2015

I am trying to create a Task table that is associated with project. How do I do that

View 3 Replies View Related

Prevent Pinning Of Access To Task Bar

Jul 7, 2015

How can I prevent the Pinning of the MS Access shortcut to the Taskbar?

View 8 Replies View Related

Record Time Spent Task?

Jul 9, 2014

I am using the Issues Template Database and would like to add a function to it.

I would like to record each time spent task/ action when working on an issue.

For example:
Tasks
- Email
- Phone Call
- Report

So, say I wanted to add one Report- time taken 30mins and record that then on an another day, Email- 10mins So record each task and time taken.

View 1 Replies View Related

Hide Access Window Task Bar And Reports

Nov 15, 2005

All,

I've been using Dev Avish's excellent code shown within the sample database section to hide access windows. I've taken his call fsetAccessWindow function and set it to 1 or normal in two separate databases. Both databases seem to work slightly differently. The idea is that opening the database produces one Visible instance of access on the taskbar which is the purple standard graphic (Access 2000 / Windows 2000). With the first database I have set up reports through the active x control as required when using dev's code and even when I hit the report button the user is only aware of one visible instance of access as the purple colour graphic.

I am trying to implement the same code in a second database and have copied the code from the previous database into this database. It works great for the forms however there is a slight glitch when report forms are accessed. Rather than remaining with the purple access part on the task bar the task bar section is split into two between the form and the report. In the previous database users would not notice that the report had been opened at all. (although technically it was still running in the backrground)

I have checked most of the properties between the two database forms and they would appear to be the same..

Has anyone got any ideas why the taskbar is behaving differently between these two databases there must be some difference between my set up but as yet cannot find it??

Thanks Mark

View 3 Replies View Related

How To Show The Database Objects In The Windows Task Bar

Sep 11, 2007

I have a problem. This problem is that I cant see the Database objects (Forms,Report,...) in the Windows task bar. I want the user to be able to see any opened form, or report directly in the task bar as any file opened by the Windows user.

I have tried to check on the (Show Windows in TaskBar) option available in the Tools -> options of the MS Access, but it doesn work with me.

What is happening now that I am forced to show the Menu Bar and use the Window menu to switch between the objects, however, This will not be OK for me because my system hides all the command bars the MS Acccess use.

Is the any way to solve this hard problem?

View 1 Replies View Related

How To Handle A Large Data Cleaning Task?

Jan 11, 2006

I need to create a program that will regularly import a text file of over one million records into an Access table. I've been give a list of about fifty different updates to perform on the data to clean it.

I can't imagine performing all these updates in one query. However, creating fifty individual queries seems horribly inefficient from a processing perspective.

I'm accustomed to stepping sequentially through a table in FoxPro, which seems ideal to me for this type of situation. What is the best way to handle this in Access?

View 4 Replies View Related

How To Hide Form From Windows Task Panel?

Nov 7, 2006

Hi guys,

I have moved all my small databases into 1 larger database to save up on Taskbar space, but the problem is that when I use an opening form to open other forms (switchboard style) the additional forms show in the Task bar.

Is there some sort of macro that I can use to tell each form to suppress itself from the Task bar?

View 1 Replies View Related

Modules & VBA :: Scheduled Task On Windows Server

Apr 20, 2015

I have a vbs-script that opens my access database db.mdb and runs the module "Export":

dim accessApp
set accessApp = createObject("Access.Application")
accessApp.OpenCurrentDataBase("D:Datadb.mdb")
accessApp.Run "Export"

accessApp.Quit
set accessApp = nothing

This works fine as a scheduled task on a Windows 7 computer.

Is there a way to make this work on a Windows Server 2008 R2 ? When I double click the vbs-file, the file opens instead of runs. And when I create a scheduled task, nothings happens.

View 2 Replies View Related

Queries :: Task List Max Tasks And Max Hours

Jun 14, 2014

I would like to make an action list based on tasks. I try to make a query that does the following things:

-Taken.Priority=1
-show maxium 5 tasks sorted on make date(taken.ingevoerd)
-OR with a total duration of maxium 480 minutes (Taken.[Geschatte duur (min))

The last one is to hard for me to make. For example if the duration of 4 tasks is 420 minutes, the fifth task (100 min) should not be shown, because the criteria of maximum amout of minutes is reached.This is what I have made so far:

SELECT DISTINCT TOP 5 Taken.ID, Taken.Omschrijving, Taken.Ingevoerd, Taken.Deadline, Taken.Priority, Taken.[Geschatte duur (min)]
FROM Taken
GROUP BY Taken.ID, Taken.Omschrijving, Taken.Ingevoerd, Taken.Deadline, Taken.Priority, Taken.[Geschatte duur (min)]
HAVING (((Taken.Priority)=1))
ORDER BY Taken.Ingevoerd DESC;

View 2 Replies View Related

General :: Open Database With Task Scheduler

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

Tables :: Task Tracking For Making Item

Aug 24, 2013

Im trying to create a database to track who worked on what item and on what date, with four tasks required to complete the item.To give an example:I have a factory that builds Lego models, for each model there are four steps:

1)Unbox Parts
2)Sort Parts
3)Build
4)Check build

Any employee can work on any task, and multiple tasks can be done by the same employee.Having a completed item table with a field for each task, and a date for each task, with one to many relationships from employee id to each task type. This failed as I needed many to many, so I made a junction table to link them, and this is where I get a little muddled.

Do I need a table of task types, then a table tracking each task to feed into the item table, or is there a simple solution I'm overlooking?

View 4 Replies View Related

Access Database Fails When Using Task Scheduler

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







Copyrights 2005-15 www.BigResource.com, All rights reserved