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?
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?
I have the following code to maximise and hide the menu bar:
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Predefinita' "
Me.FilterOn = True
DoCmd.Maximize
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i
End Sub
When closing any form that has been open from the control panel the control panel will not return to a maximise but will be hopen smaller, how can I always have my control panel on maximise when I close any forms or reports!!!
Thanks
Marco
Or maybe even undock it? I know I can show it or not but sometimes it's in the way or not big enough. If I open it to show the full length of the names it makes the working window too small. Seems like there should be a way to move it to the bottom for example. Then you could see the full length of the table/queries/forms/etc. names while still seeing the full window of detail for the working window.
View 2 Replies View RelatedWhen running two append queries from a button how can i suppress the confirmations msgs to make just one custom msg "Are you sure Yes/No" Then "Import Complete".
Private Sub Import_Click()
Docmd.OpenQuery "Append1"
DoCmd.OpenQuery "Append2"
End Sub
I have a list of customers in a table (tblCUSTOMERS) and a list of hundreds of items in another table (tblITEMS). The relations ship between customers and items are many to many.The form i'm using needs to have a coverage panel showing what parts are associated to the customer when updating their information. Ultimately, the data will be queried by what customers associate to specific parts.
I have an array of check boxes with the different part numbers displayed, but i don't know if or how this can be queried against.how I can go about achieving this many to many relationship.
Hi All,
I have a table called tblcheck which holds the following values:
IT, Yes/No
0001, Yes
0002, No
0003, Yes
I need to set up a query which outputs certain values depending on which of the IT values have been set to Yes. I need to take into account that a user might have all of the values set to Yes. So if I am outputting certain values in the query, I need to have them all set up in case they are used, but would like to suppress the output of any field which is related to a No value.
In the above example I would expect that nothing from 0002 would be output because it is set to No. How can I supress this output based on the Yes/No value. Would I have to do it using VB code?
Thanks,
Evan
Have a column titled Total Funded that lists numeric dollar amounts. I want to suppress the records in that column whose value is 0. I did this:
IsNull ("0") and ended up getting exactly what I don't want -- that is a query that returned only the 0 funded records. Those are the records that I want to suppress.
Any suggestions would be most appreciated.
I have this database with the purpose to storage all the tasks that are done in my team. I have a table named Tasks with all their fields. Now, I would like to set a more user friendly way for clients to update this table. I have created another table with a list of most common tasks, so when a client wants to add their tasks list they can choose one of this tasks and add it to the list. I had created a form with multiple items that contains the common tasks and next to each task a button that adds the information they choose into the table "Tasks". This works just fine. However, I would like to add a single button at the top to add all the tasks instead of having to choose one after one.
The "Add All tasks" button has this code:
Private Sub Command79_Click()
Dim valSelect As Variant, MyDB As DAO.Database, MyRS As DAO.Recordset
Set MyDB = CurrentDb()
Set MyRS = MyDB.OpenRecordset("Tasks", dbOpenDynaset)
[Code] ....
Hi:
I have a number of queries that run prior to exporting my DB into and XML file. I run the query in a section of VB code as follows:
Dim stDocName As String
stDocName = "flow_e_e_tbl_connection_name_id_update"
DoCmd.OpenQuery stDocName, acNormal, acEdit
The query executes as expected, and gives the usual warnings: You are about to run an update query that will modify your table...proceed Y/N/H....
and the status window:
You are about to update N row(s)...Update? Y/N
Is there a way to run the query in silent mode? e.g. without the popups? If not, is there another way to runthe query in a silent way?
Thanks
J
i know macros' have an option to supress alerts but how do i do it in VBA?
GOT IT
DoCmd.SetWarnings False
Hi,
I am releasing a Runtime Access 2003 application.
Am using the standard files ACCESSRT.MSI and ACCESSRT.CAB to install Runtime.
Does anybody know a QUICK way of supressing the annoying security messages which pop up, when the application starts under this configuration?
I don't want to write any fancy install wizards or scripts, just need a basic runtime install like the above method, but with "Low" Macro security set.
Thanks in anticipation.
--
Richard
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:
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
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 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
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 RelatedAs 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.
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 Related