Using Win 7 32 bit Access 2010 32 bit, I can't get the property pane to open. Right-clicking the form or any of the controls and selecting Properties or Form Properties doesn't do a thing. How can I get the property pane to open.
View RepliesWhat property settings do I set to eliminate the navigation pane ? It is displayed on my splash/menu screen and I would like to remove it.
View 3 Replies View RelatedI use DoCmd.ShowToolbar "Ribbon" acToolbarNo (or acToolbarYes) depending on a value in a table which I have shown certain "trusted" users how to change.
But is it possible to do something similar with the Navigation Pane?
I'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.
i have a form with 4 subforms on it informing the amount of calls etc taken and im trying to get it to autorefresh avaery 30 secs but it refuses to do it . I have folloed advice in other threads but just can get it to work.....Question do i have to set up refreshes on the subforms or just on the containing form ? im running a split DB across network
View 11 Replies View RelatedHi,
I've got a database with a linked table to a CSV file which is automatically extracted from some logging software. The Database is used to search for text strings (e.g. "example") within several fields wichin the automated extract and then show the results with any duplicated instances taken out (via an append to table query which is indexed with no duplicates).
So:
Text is entered
FieldA is looked through for a match, if a match is found the whole record gets appended to the Append table.
FieldB is looked through and if a match is found the whole record (including field A) is appended, however if the match has already been found in A, then the record is not copied.
It does this for several fields and then you get a table which is every record containing the searched for text with no duplicates.
This table is then displayed as a subform on another form in it's "table" view.
The form I'm trying to close is the form which contains the above subform.
I've tried:
A macro with close -> form -> formname which doesn't work.
Code:
Private Sub Toggle2_Click()
On Error GoTo Err_Toggle2_Click
DoCmd.Close
Exit_Toggle2_Click:
Exit Sub
Err_Toggle2_Click:
MsgBox Err.Description
Resume Exit_Toggle2_Click
End Sub
Which also doesnt work!
HOWEVER, just to make things interesting, if I click to view the form design, then run the form again, it will close fine using either method. It just seems not to work on the initial run of the text search which then opens the form displaying the subform.
Any ideas?? I can't understand why it won't work.
Cheers - Hope I explained it ok :)
I 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.
How to hide navigation pane permanently?
I mean it should not open even when someone check display navigation bar from Microsoft access button.
I have a 2010 Access Database with a Navigation Pane. When I click a Navigation Button to view another form I lose the position and record I was on in the first form. It's almost like the first form refreshed when I click the navigation button to view the second form. Is there a way to setup the Navigation form so when I click on various navigation buttons it won't reset the previous form I was on?
View 1 Replies View RelatedIn the default property of a subform control I want to use a control of the main form without using names of forms, but using me and parent.
I used in default property of cboVATDetail: =Me.Parent!cboVAT, but it is not accepted. My aim is to use cboVAT of parent as default in cboVATDetail of child.
I have a form that launches a query. The results are displayed in a continuous form called ParentForm. On the ParentForm is a combobox which selects a singleform called a ChildForm that displays the details of the selected record. I placed a command button on the ChildForm. This button simulates a circular triple state toggle switch. By clicking this switch the form goes from ReadOnly to Edit to Add modes. The form properties AllowEdits , Allow Additions and DataEntry are adjusted accordingly. These properties when they are changed seem to initiate requery of the underlying data source. Here is the code. I am looking for a way to avoid requery of the data when the mod is changed.
Code:
Private Sub ModeBt_Click()
'-------------------------------------------------------------------------------
' Circular toggle button to change display mode of the form
' ReadOnly - Edit - Add
'-------------------------------------------------------------------------------
Select Case Me.Mode
Case "Edit Mode"
Me.AllowEdits = False
[code]....
I have seen someone's database that had tiny circles containing a "?" which, when clicked, opened up a sentence or two. A search for "Tag" on this site strikes out, also.I am hoping to place these little links near fields that may need more explanation. In the ones I have seen before, the little explanation field that popped up disappeared as soon as the focus went elsewhere without the user having to close it. I have succeeded in using the tag property to open a true popup form, but this is clunkier than I want--would just like to learn how to do the other.
View 4 Replies View RelatedI have a combo box that takes it's data from a table called tblFruitBasket. What code do I put in the Default Value property such that the default value is the fifth element (or say fifth row) of field [Fruit] of table tblFruitBasket?
View 2 Replies View RelatedI've saved a form to an text file to investigate a corrupted form issue. The output text file has below extracted text. I am wondering where I can find the TOP, RIGHT BOTTOM property of the form in design time? I could see some properties such as GridX, GridY, but not sure where are TOP property.
Version =20
VersionRequired =20
Checksum =-1566200859
Begin Form
RecordSelectors = NotDefault
[Code] ....
I have set the decimal place property of a text box to 2. Then when i run a query that puts data in that box, the deci places are still well over 2..It lokks to be over riding it, how do I stop this?
View 4 Replies View RelatedThis doesn't happen on all my other Frm/subfrms that I have. Only this one and I can't figure out why.
I have a main form with a datasheet subform and a detail subform on it. The detail subform works fine until I filter on the datasheet.
Both forms use the same view.
But, when I filter on the datasheet form, the filter on the bottom of the 2nd subform turns on and I can't unfilter it. I can't figure out what it's trying to filter. If I can figure out how this is happening, I can prevent it and then the subform will just reflect the record selected from the datasheet. This doesn't happen with any other datasheet/detail form that I have.
Is it possible to use WHERE in the Control Source property of a button on a form?
Something like this
= [Station Status]![Done] WHERE [station Status]![ID] = "28"
I want to avoid the properties list to pop out when a form is viewed in dsview. I remember there was a property to set that but I cannot find it.
View 3 Replies View Relatedwhen the Form Property "selectionchange" kicks in?I am trying to use this to run an event procedure. I have a sub form datasheet which contains a date, and when the selection is changed from one record to another in the sub form, I would like to run an event procedure that updates certain fields on the main form, according to the date.I have put msgbox in the event procedure, but it doesn't trigger when the selection is changed? or am I misunderstanding the property?I have also tried got focus, lostfocus, beforeupdate, but they only trigger when the record is changed, not just when the selection is changed.
View 4 Replies View RelatedHow to set all controls in the form I would like to get complete information about all property options.
View 6 Replies View RelatedI'm using access 2010.
How to set a single form's property to act as it's own "overlapping window" in a database that is set to use tabbed documents. I want most windows to have the tabbed layout but there are a few that I would like to have pop out and be their own windows.
I noticed that the Northwind database did this somehow. if you click on one of the products from the home screen a form pops up in its own window. I tried reverse engineering it, but no luck so far.
Code:
The expression On Click you entered as the event property setting produced the following error: Procedure declaration does not match description of event or procedure having the same name
Now this is the error message that I am constantly getting from any command button I hit on a certain form. Here is the code of the form.
Option Compare Database
Option Explicit
Public inputCSV As String, ORG As String
Private Sub CopyToTableBt_Click()
Debug.Print "Sub Execute calling ImportCSVForConfederation inputCSV="; inputCSV; " ORG="; ORG
ImportCSVForConfederation Me.CSVs, ORG
[Code] ....
I changed the names of the buttons, reconstructed the code under those names, went to the modules and changed names, made sure that a sub o function name is not duplicated in the project... But helas the error is still there. It used to work and suddenly does not work.
Is it possible to use a formula in the Caption property of a page in a tab control (i.e. to make it dynamic)
I have a number of tabs each with their own subform (with each subform driven by its own unique query)
I'd like the tab name to include the number of records returned by that query (so as records are added, the tab name is automatically updated with the new number)
So something along the lines of :
Page 1 (" & DCount("[ID]","[qryQuery1]") & ")"
Such that the page name appears as :
Page 1 (7)
I know I can code this programmatically but then that code has to be triggered by some event and I need the counts to be as real-time as feasibly possible rather than requiring the user to click on a control to trigger it. I was hoping by using a formula directly in the Caption property of the page, it would be dynamically updated every time a new record was added without the need to trigger an event first.
I've set the column widths properly on the subform, but the down arrow on the list box is still outside of the selection area. It may have something to do with lookups or concatenations, but I'm not finding that so in what I can think of to trace down.
I exaggerated the width of the list box to show where the down arrow actually shows itself.
See the form "frm_Class_Skills_Update" in the attached database. I need it to be visible when the list box is about 1.25" more narrow.
I have the following code:
Dim FrmGraphObj As Object
Set FrmGraphObj = Forms![frmE Weekly Efficiency]![gph_WeeklyEfficiency].Object.Application.Chart
FrmGraphObj.Axes(xlValue).TickLabels.NumberFormat = "0%"
I continually receive a runtime error 1004 " unable to get tick labels property of the axis class"
if I remove this code, then I error on the following code:
Dim FrmGraphObj As Object
Set FrmGraphObj = Forms![frmE Weekly Efficiency]![gph_WeeklyEfficiency].Object.Application.Chart
If FrmGraphObj.SeriesCollection(2).HasDataLabels Then
also a runtime 1004: "unable to get the seriescollection property of the chart class" on the last line above
searched this forum and found:
If your chart is in a form (or report), you have to:
1) refer to the form (or report) name (Form_Charts)
2) refer to the name of the object frame holding your chart (.Graph1)
3) refer to the object within the frame (.Object)
4) refer to the application that created the object (.Application)
5) refer to the actual chart itself (.Chart)
6) refer to the axes collection and select the axis you want to reference - in this case the category, or X-axis (.Axes(xlCategory))
I made the assumption, that I would just replace xlCategory with xlValue for the Y-axis. So I'm back to:
Set FrmGraphObj = Forms![frmE Weekly Efficiency]![gph_WeeklyEfficiency].Object.Application.Graph
With FrmGraphObj.Axes(xlValue)
.TickLabels.NumberFormat = "0%"
End With
Same error....
Looked in the Microsoft Graph Visual Basic Reference and it indicated:
"Tick-mark label text for the value axis is calculated based on the MajorUnit, MinimumScale, and MaximumScale properties of the value axis. To change the tick-mark label text for the value axis, you must change the values of these properties."
I reset my code to call these 2 functions prior to changing the number format.....
Public Sub txtMaxPercent_AfterUpdate()
Dim FrmGraphObj As Object
Set FrmGraphObj = Forms![frmE Weekly Efficiency]![gph_WeeklyEfficiency].Object.Application.Chart
FrmGraphObj.Axes(xlValue).MaximumScale = txtMaxPercent
End Sub
Public Sub txtMinPercent_AfterUpdate()
Dim FrmGraphObj As Object
Set FrmGraphObj = Forms![frmE Weekly Efficiency]![gph_WeeklyEfficiency].Object.Application.Chart
FrmGraphObj.Axes(xlValue).MinimumScale = txtMinPercent
End Sub
now I am receiving error 1004 again, this time it states "Unable to set the minimumscale property of the axis class" erroring on this line....
FrmGraphObj.Axes(xlValue).MinimumScale = txtMinPercent
debug.Print me.txtMinPercent
0.51
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: