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:
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 RelatedI'm building a web application that mimics the keyboard navigation of Microsoft Access.
What is the keyboard shortcut that will move the focus from the navigation pane on the left to the content area on the right? I can't figure out how to do this in MS Access without using the mouse.
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
Query Design View is only showing Tables pane (top). Fields pane (bottom) is missing from previously saved queries. New queries show both panes as usual. Does any have any idea why? I cannot find any settings to show the bottom pane (or to hide it). Please help
View 3 Replies View RelatedHi 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 RelatedThere 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.
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
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!
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
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.
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?
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 RelatedJust 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] ....
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 RelatedI am trying to create a Task table that is associated with project. How do I do that
View 3 Replies View RelatedHow can I prevent the Pinning of the MS Access shortcut to the Taskbar?
View 8 Replies View RelatedI 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.
Hi,
I know how to remove the Navigation Pain (or Pane) so that it doesn't show on start up, but if you then want it (F11) how do you then get rid of it!! :eek:
It's driving me mad!!!
All you seem to be able to do is open and close the "shutter bar" and not remove it completely.
Any suggestions? :confused:
I have three access 2010 tables, each standing alone with their own navigation pane, etc. Is there a way that I can put all 3 tables into one navigation pane? What I need is to build a Switchboard where each of the 3 tables are my choices .
View 2 Replies View RelatedI have inherited forms, some of which somehow lock the Navigation Pane. For those that do I cannot find how the Nav Pane is locked. Is it a form property? If so which? "acCmdWindowHide" is not used in the program.
This issue prevents me from viewing form properties or Form VBA when such an open form is switched to the Design View.
I tried to modified access 2010 database. But I open it the Navigation Pane is grey out (disable) and I cannot to see any database object. How to make the Navigation Pane active?
View 1 Replies View RelatedIn Office 365 and Access 2013, when I right click on the top of the Navigation Pane and choose the Navigation Options I get a screen with NO Categories and NO Groups. I see the "Add" buttons on the bottom but they are grayed out.
View 14 Replies View RelatedIs it possible to access database objects without using the nav pane? I'd like to keep the nav pane turned off on a shared database so that the regular users don't get confused, but I have need to edit various objects. I could just turn it on and off as needed but I was hoping there was another way to access the objects.
View 3 Replies View RelatedUsing A2010, for some reason, whenever I created a new Access Object and save it, the Navigation Pane doesn't automatically update to list the new object. Same thing for if I delete an object. This only started happening about halfway into the process of creating this database. For now, I've been compacting and repairing the database to "refresh" the file and then the Navigation pane updates.
View 4 Replies View RelatedHow do I get back to this? Somehow I changed it, now my objects are "shortcuts", and my original grouping disappeared. I tried to manually put it back to the way it was with the same names but now it thinks its "custom". Can I somehow just switch it back to its original view?
View 1 Replies View Related