I need some ideas here.
I export my tables to workbook sheets in excel using transferspreadsheet.The different sheets in my workbook are later imported to the corresponding access tables using transferspreadsheet.
1)I want to know how to totally hide my sheets in the workbook so that the users don't tamper with them after export using transferspreadsheet.
I need Access to open an Excel file prior to pulling information from it, because the Excel file itself only updates when it is opened. I was able to achieve this with the code below:
Quote:
'Opens a hidden Excel window.
Dim app As New Excel.Application
app.Visible = False
Dim book As Excel.Workbook
Set book = app.Workbooks.Open("S:OperationsAssistantDataba sesBUSES.xlsx")
[code]....
This works fine if NO Excel window is already open, but if the user happens to have some file open in Excel already, my code doesn't seem to work right. The file does not open in a hidden window. Instead, it opens in the window already open, and additionally, the file is not closed afterward, which leaves the user wondering where the hell this random file came from, and they have to close it. I need this Excel file to open, but I want it to be completely hidden from the user.
Hi guys
firstly, i have been searching the forum for previous posts on this issue - I was hoping someone else has asked this question before... no luck tho
if someone can point me the right direction that would be great(im guessing it will have to be done through VB) - I wanted to know if it is possible to have a "hidden" field in my primary form, which would be set to autonumber, so that when the user fills in and submits this first form, the hidden autonumber can be passed to subsequent forms.
anyone have any ideas?
Thanks in advance
Akash
Hi there..
By mistake i cjeck the hidden property of a form. Now this form is no more visible.
How can i get tht form back to visible state.
Thanks
Danny
how can a hidden table ,obvious table ??
:p :p :p :p :p
Hello friends,
i have a database with some hidden queries and I want to know how to view these hidden queries.can someone tell me how it works?
There are queries in my database that are not displayed in the query window of Access.
They are listed in the MSysObjects tables but I need to update the query and I cannot get to it.
I have show hidden objects checked in the options (MSys... tables are displayed but not these queries).
Why is this happening and how can I change it?
Thanks in advance
Is there any way to keep a combo box hidden until the combo box above it has been selected.
Basically I have the user choose a week number from combo box 1 and want to keep combo box 2 with a different list hidden until combo box 1 has been selected.
Sorry if this sounds mixed up but its the best way i can describe the problem
Thanks in advance
i accidentally change a property of a query to hidden, i don't know how to make the query displayed again.
what should do?
Hi, all. I am sorry if i do something wrong but it is my first time here.
Situation:
I have an application with a login form. Once you press the login button the login form is hidden (visible=False) to be able to pass the userid to another form. In order to close the application the user needs to press a button in the swithcboard but that is not possible because the hidden form.
Question: How can i close the hidden form to be able to close the application?
Thx in advance.
Hi,
Was wondering whether its possible to control the appearance of pages...
I have a main form on which I have about 7 pages. When the main form is in the FORM-view, the headings of the pages are 'hidden'. One has to scroll up in order to see them.
As certain users of the database will be using Access viewer and thus only see this main form, it would be convenient if I could make sure that when the MAIN form is on, the headings are not hidden. So, it's a layout problem.
Any tips on this?
Thanx Stacey
hello all ! here is a new challenge.
I have an application in access 2k, where i am hidden access environment using code. Because i am hidding access environment the popup and mode properties are in YES.
Situation:
i have a form with a combo list, where i can select a report, 1 button to view the report , another button to print the report and another button to close the form.
Once the user has selected the report and pressed the view button the following code runs:
DoCmd.OpenReport "reportname", acViewPreview, acWindowNormal
if the user pressed print the following code runs:
DoCmd.OpenReport "reportname", acNormal
Problem:
When a user wants to view a report nothing happens. the report is not open.
do any of you have an idea?
i am attaching 2 db. One where you can see the problem with hidding environment (wine_NOcode). The second db without hidding it (wine_code).
the pwd is 1.
thx very much, Max.
I have searched the forums but all I can find is code to hide the windows taskbar, when actually I want the opposite.
I have a form which I have set the following properties:
Pop-up = Yes
Modal = No
Control Box = Yes (Only while designing, will change)
Max/Min = None
I have also placed code in the On Load event namely "DoCmd.Maximize"
When the form loads, it maximises as I would like but it also covers the windows taskbar, which is something I don't think my users would like at all!!! Any idea how to get it to still maximise ( as this hides the db windows) but not hide the taskbar?
When trying to open an Access database on the server, an error message appears - "Compile of hidden files error", followed then by a run-time error. There is no problem accessing the the server and opening the database from another PC? Does anyone have any ideas what could be causing this. Backups to CD have started failing at the same time.
View 3 Replies View RelatedHello,
I have hidden most of the menu bars for my database (from the tools.. startup.. menu) and I dont have a backup of my latest database (yes, I know, stupid.) The only menus I have are File, Edit, Insert, Records, Window and Help. The database window is also not displayed.
How do I get them back..? My database is set to load a form on startup, all data is accessed via a set of forms linked from the first. I cant access the tables, design view, anything. I feel like such a muppet...
Help!!
Hi
I have created a monster I think and I am not sure how or why.
I needed a query to tie together data from a range of tables and so it has about 20 constituent queries, each of which involves some calculation.
The query isn't so horrendous
SELECT tblApplications.lngApp, qryExpWkHomeHelp.WkHomeHelp, qryExpWkPrescrip.WkPrescrip, qryExpWkHosp.WkHosp, qryExpWkRent.WkRent, qryExpWkSup.WkSup, qryExpWkInt.WkInt, qryExpWkLife.WkLife, qryExpWkCouncil.WkCouncil, qryExpWkCar.WkCar, qryExpWkCar1.WkCar1, qryExpWkHp.WkHp, qryExpWkDep.WkDep, qryExpWkCont.WkCont, qryExpWkProp.WkProp, qryExpWkOther.WkOther, qryExpWkTel.WkTel, qryExpWkTv.WkTv, qryExpWkWater.WkWater, tblApplications.lngAppCon, tblApplications.bAppEleg, tblApplications.dtmAppGcSub
FROM qryExpWkWater RIGHT JOIN (qryExpWkTv RIGHT JOIN (qryExpWkTel RIGHT JOIN (qryExpWkOther RIGHT JOIN (qryExpWkProp RIGHT JOIN (qryExpWkInt RIGHT JOIN (qryExpWkLife RIGHT JOIN (qryExpWkCouncil RIGHT JOIN (qryExpWkHp RIGHT JOIN (qryExpWkDep RIGHT JOIN (qryExpWkCont RIGHT JOIN (qryExpWkCar1 RIGHT JOIN (qryExpWkCar RIGHT JOIN (qryExpWkSup RIGHT JOIN (qryExpWkRent RIGHT JOIN (qryExpWkPrescrip RIGHT JOIN (qryExpWkHosp RIGHT JOIN (qryExpWkHomeHelp RIGHT JOIN tblApplications ON qryExpWkHomeHelp.lngExpApp = tblApplications.lngApp) ON qryExpWkHosp.lngExpApp = tblApplications.lngApp) ON qryExpWkPrescrip.lngExpApp = tblApplications.lngApp) ON qryExpWkRent.lngExpApp = tblApplications.lngApp) ON qryExpWkSup.lngExpApp = tblApplications.lngApp) ON qryExpWkCar.lngExpApp = tblApplications.lngApp) ON qryExpWkCar1.lngExpApp = tblApplications.lngApp) ON qryExpWkCont.lngExpApp = tblApplications.lngApp) ON qryExpWkDep.lngExpApp = tblApplications.lngApp) ON qryExpWkHp.lngExpApp = tblApplications.lngApp) ON qryExpWkCouncil.lngExpApp = tblApplications.lngApp) ON qryExpWkLife.lngExpApp = tblApplications.lngApp) ON qryExpWkInt.lngExpApp = tblApplications.lngApp) ON qryExpWkProp.lngExpApp = tblApplications.lngApp) ON qryExpWkOther.lngExpApp = tblApplications.lngApp) ON qryExpWkTel.lngExpApp = tblApplications.lngApp) ON qryExpWkTv.lngExpApp = tblApplications.lngApp) ON qryExpWkWater.lngExpApp = tblApplications.lngApp
WHERE (((tblApplications.bAppEleg)=Yes) AND ((tblApplications.dtmAppGcSub) Is Null));
Well maybe it is pretty horrific!
However it is taking nearly two minutes to load on a fast PC (3.4GHz Pentium 4 with 1Gb RAM) so put it on a basic desktop and it will die.
I did wonder about fragmenting it into four queries and then putting one query at the top of the nest but reckon that's another layer and all the calculations need to be done.
Basically the sub queries are calculating a weekly value based upon input and periodicity of payments - i.e. if quarterly then it divides the payment by 13.
Any thoughts on how I could speed it up?
Thanks in anticipation
Whilst trying to tidy up my database in the Start-Up menu, I checked the boxes that hid all toolbars and menus, so now when I open the database, all I get is the opening Main form I created.
Does anyone know how to correct this please, I need to continue working on the database and it is driving me nuts............
I have a report based on a query.
I have this grouped by a jobid.
For each field on the report I have hide duplicates set to yes. for each job id most of the line should be hidden except for a couple of fields (part used and description).
This works in 99% of cases but I occasionally I get the whole line repeated
I've treble checked that the fields are duplicates (they are) and am at a loss what to look for.
I have a question that involves windows permissions as well as access links. I have a contacts database split into a front end and a back end. For security reasons I want to place the back end in a folder that is hidden from the users. In other words the users can access the front end as normal and run queries and reports but they are not able to navigate in Windows to the folder containing the back end or view its contents.
Is it necessary to use VBA to do this? If so what is the script? If not, how is it done.
I have an extremely complex database that requires 12 forms to remain open simultaneously. A command macro successfully opens all 12 forms, but 3 of the 12 are hidden from view because the window does not have enough room to display all 12. Even when I use the left / right arrows, these 3 forms are still partially hidden. How can I ensure that none of the tab controls are partially hidden behind other tabs ?
View 3 Replies View RelatedI have 30 fields on a form that houses codes that are 1 to 2 digits in length. Some of those codes are used way more often than others so I decided to build a VBA script to apply the most common codes to the fields based on entry in 3 other fields and applied to a button. The code works great but one of the fields (the 6th one) is behaving oddly. I have tried multiple criteria for code and it is ONLY the 6th field being the pain. The code is applied to the field but it is invisible until that field gains focus by either clicking on it or tabbing to it. I checked the fields format to others of the 30 and all of the settings are exactly the same. There is not anything set in any of the events and there is not any other code pointing at those fields.
View 3 Replies View RelatedIs it possible to hide the locations of linked tables that we see when using linked table manager? I want to have a desktop Access FE database link to a BE database which is on an intranet server. I know this works because I have done it, but for security reasons can the link address be hidden? That is really a just-in-case scenario, because I can establish the links when opening the main form, and delete them when closing it. It's also easy enough to keep users out of the ribbon and the navigation pane.
If that can't be done, is it possible using VBA to map the database location to a network drive letter, as you can do with Computer - Map Network Drive (Win 7), without knowing what drive letter is the next one available?
Any way to export data from a report if it is hidden.
View 13 Replies View RelatedThis one has me stumped:When a particular database opens, its window is partially under (hidden by) the menu and tool bar. I can't click on the window's top in order to move it. I've tried several things (i.e. resizing the screen resolution, moving the menu and tool bars, resizing the window, etc.) with no resolution. Any suggestions.Am using Access 2003, Thanks, Joel
View 1 Replies View RelatedHello,
I have hidden most of the menu bars for my database (from the tools.. startup.. menu) and I dont have a backup of my latest database (yes, I know, stupid.) The only menus I have are File, Edit, Insert, Records, Window and Help. The database window is also not displayed.
How do I get them back..? My database is set to load a form on startup, all data is accessed via a set of forms linked from the first. I cant access the tables, design view, anything.
Help!!
Hi Everyone, This should be quite easy,
I have 20 text boxes in a form
Dependent on the ammount of people attending [number in Group] text box
I am trying to make the same amont of [Client#] text boxes visible
The below coding works but i cannot go any further than 1 and 2 attending, As the if and else statement cannot be continued
Im sure there is an easy way to do this -
Private Sub C_AfterUpdate()
If [Number in Group].Value = 1 Then
[Client 1].Visible = True
[Client 2].Visible = False
[Client 3].Visible = False
[Client 4].Visible = False
[Client 5].Visible = False
[Client 6].Visible = False
[Client 7].Visible = False
[Client 8].Visible = False
[Client 9].Visible = False
[Client 10].Visible = False
[Client 11].Visible = False
[Client 12].Visible = False
[Client 13].Visible = False
[Client 14].Visible = False
[Client 15].Visible = False
[Client 16].Visible = False
[Client 17].Visible = False
[Client 18].Visible = False
[Client 19].Visible = False
[Client 20].Visible = False
Else
[Number in Group].Value = 2
[Client 1].Visible = True
[Client 2].Visible = True
[Client 3].Visible = False
[Client 4].Visible = False
[Client 5].Visible = False
[Client 6].Visible = False
[Client 7].Visible = False
[Client 8].Visible = False
[Client 9].Visible = False
[Client 10].Visible = False
[Client 11].Visible = False
[Client 12].Visible = False
[Client 13].Visible = False
[Client 14].Visible = False
[Client 15].Visible = False
[Client 16].Visible = False
[Client 17].Visible = False
[Client 18].Visible = False
[Client 19].Visible = False
[Client 20].Visible = False
End If
End Sub
Thank you. AM