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?
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 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 RelatedI 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?
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.
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?
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
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.
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 RelatedI have a website that is asp (not .net) based with an Access DB and I am in the process of replacing an old windows 2000 server with a much faster windows 2003 server. Here lies the problem I have a script as part of the admin that exports data to a csv file. The query joins 4 tables together to get the data needed for the export. On the windows 2000 server it takes 1-5 seconds to execute and have the csv file ready for download. On the window 2003 server it times out. I striped it down to use 2 joins and it worked although it took more like 10-20 seconds to export. This exports a specific range of ID's and the range is normally only 40-50 rows. If I put time stamps in the code the problem is in the query of the database, so I know its not in the file write etc.
I am going to rewrite it to use multible querys instead of one large query, but I have many other sites that I am moving to this server that would work better if I can figure out why it is so slow.
The windows 2000 is a 900 mhz server the windows 2003 is a 2.8GHZ server both have 1 GIG of ram. The database file is on the local drive on both servers. I am guessing it is a difference in the Jet version, I just haven't been able to find a solution to the problem. This uses a DSN connection, configured the same on both servers. I have also tried it as a DSN-less connection with the same result.
I have installed access on the server and to execute the command in access it is <2 sec.
I am not an access expert I normally program in .net and php and use MySQL and MsSQL for databases, we just have these legacy sites that use Access DB's
Hi All,
This is my problem -
My customer has Access programs that work on their Windows 98 OS PC's, but when they try to use them on Windows 2000 OS PC's they will not work.
The programs I believe were originally written in Access 97 and now they have Access 2000 on the PC's.
By not working I mean the following -
The Access program allows them to enter a document name and then the file opens in Word - BUT - when they use it in Windows 2000 it does not open the document at all. It says file not found in Windows 2000 and the file does exist.
** The reason they have Access opening files is that Access keeps track of them for auditing purposes.
Now here is something that I want to mention. On PC's that were upgraded from Windows 98 to Windows 2000 the programs work.
Can anyone here tell me what is missing from 98 to 2000 that would do this.
Thank you very much for your time.
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 All,
Is there a way that I can view window explorer within a Form. Is it also possible to have Drag & Drop facility in that form.
Thanks in advance,
Jatz
Hi All,
Is there a way that I can view window explorer within a Form. Is it also possible to have Drag & Drop facility in that form.
Thanks in advance,
Jatinder Kalsi
Hi,
I have a database that contains a navigation menu. It links to several other forms throughout the database, providing users with easy access to the databases features. At the moment, when each link is clicked, it opens another seperate window with that form as the contents. As you can imagine, after a session, the user has around 20 different forms all along the taskbar, just from navigating through the database. Is there a macro or command that I can put in place to 'replace the existing window' when a link is clicked, so only one window is open at the end of a session? (The simpler the better in terms of explinations, macros aren't my best area). :)
Hi there everyone,
Must be a really simple one, this one but can't seem to find the solution! :o
Can someone put me out of my missery and tell me how to make each form open in the same window instead of ending up with millions of open windows??!!
Thanks, Matt
Can we add windows gadgets like clock and calender to access form?
View 6 Replies View RelatedI currently have a button on a form which, when clicked, I would like to do several things:
1) Check if the folder, "folder name (1)" exists
2) If no, make it; if yes, check if the folder, "folder name (2)" exists
3) If no, make it; if yes, check if the folder, "folder name (3)" exists
4) repeat this process until a new folder is made
The code I currently have seems to not work, and makes an infinite loop
Code:
Private Sub Export_Click()
Dim checker As Integer
Dim projPath As String
checker = 1
[Code] ....
Does anyone know if there is some type of theme to make windows xp windows 3d like vista's windows. example below.
http://www.winvistabeta.com/files%2Fscreens%2F5365%2Fexplorer%2Fwindows-vista-3d-switch-screen.jpg
I am currently creating a database to link together a maintenance system and a conditional reporting system and I’ve run into a little problem.
I am trying to create a form for assigning skills to a given contractor (contractor selected via a combo box (cboContractor)) by transferring selected items from a list box on the left (lstAvailable) to a list box on the right (lstselected). (much like any windows wizard would) This is done through the 4 buttons cmdSelect, cmdSelectAll, cmdDeselect, cmdDeselectAll.
Now it has been a long time since I have had to work with VB and I am struggling a little to create the required coding to pass data from one listbox to the other.
For reference:
CboContractor takes information from tblContractor. The data is ContID and ContName and the bound column is 1.
LstAvailable takes information from tblSkills. The data is SkillID, SkillComm and SkillNotes. Bound column is 1
LstSelected will place data into tblcontskills.
Tblcontskills has the fields, tcsID, ContID, SkillID
Can anyone help or does anyone know where I can find some good examples on the net as I have browsed through the search pages here and not really found a great deal that is valid
Thankyou in advance for your help everyone
how to hide the the 'Details' section in my form when viewing it in Split Form. I tried to use
Code:
Private Sub Form_Load()
Me.Detail.Visible = False
End Sub
but that just makes the Details section look blank, as oppose to not having it there at all.
have only the Form Header and Datasheet visible in the Form View of my form. Similar to the 'Contact List' form in the Contacts Template that comes with Access.
I have one main form with 3 tabulated sub forms.
My main form consists of two fields.
When the user clicks tab 2 (subform 2) or tab 3 (subform 3) the main fields should hide
I tried to achieve this by using the on click event at the tabbed forms. I referenced the two main fields and used the visible property followed by a form requery. It didn't work.
thanks in advance
Hi.
I was just wondering if you can hide a form in the windows status bar?
Hi, I have a form with a cmd butto that unhides a text box, this text box is quite big on the form and I want it to display extra informations, the problem I have is when I unhide the textbox this will appear under fixed fields on the form, I need this text box to appear over everything over the form, Hox can I achieve it?
Thanks
Marco