Hi,
I have created a sub form and wanted to make it's background transparent and also be able to enter new data and change it on the form. I sat Data entry = Yes, but I still can't enter any data. And I can't find the Back Style property at all.
Any help how to do that will be very much appreciated.
B
Hi, I would like to change the properties of either the column heads in a combo-box or the column names for tables. I don't think there's any way to adjust the column head properties, and I'm doubtful there's a way to change the column caption properties.
Some of my column titles are long, and I'd like to be able to word wrap them essentially. Anyone know if this is possible? Thanks.
I created and new field and made the source "Unbound" so that it is not connected to the field I copied it from. How do I now make that the information I enter in the new field does not duplicate in all of the similar fields in other entries.
Specifically, my database is a database of employees and the field Title is "Active". If I enter "Yes" by one employee entry, all employee entries will then state "Yes" by the Active field.
How can I change the properties so that by some employees I can write "Yes" and by others I can enter "No".
I am not so familiar with Access so if you can be specific I would greatly appreciate it.
I have a form that is intended to be used for both data entry and to edit/delete records.
The form properties are set to:
AllowFilters = YES
AllowEdits = YES
AllowAdditions = YES
AllowDeletions = NO
DataEntry = YES
When a user opens the form from a menu they are given the choice for NEW, EDIT or DELETE.
If the user chooses NEW, the properties remain as above
If the user chooses EDIT or DELETE the form should open to a specific record as chosen on an interim form.
I have been using the following code to open the form for EDIT:
stLinkCriteria = "[fldID] = " & Forms!frmsearchresults.fldID
DoCmd.OpenForm "frmJobInfo", acNormal, , stLinkCriteria, , acFormEdit
However, the form continues to open in Data Entry mode.
I have a public variable that is set to NEW, EDIT or DELETE that can be used to trigger code...
Where should the form properties be set to make sure that the form opens correctly?
Any help would be appreciated.
Thanks!
I have a standard form but i would like it so that when a user clicks on the button from the main menu to open the form it changes the default view which i have set to data entry and change it to not data entry. Also another button to change its record source to a different query. Rather than make lots of different forms that have the same thing but for just different purposes.
I hope that makes sense?
Thanks
So I have two forms: Af and Bf
In Af, when a button, Abtn, clicked, it'll run
Code:
Me.Visible = False
DoCmd.OpenForm "Bf", , , , acFormEdit
Forms![Bf].Form!Blabel.Caption = Me.Atxtbox
Forms![Bf].Form!Bcombox = Me.Atxtbox
Then Af lost from view and Bf appears in form view, with Blabel and Bcombox show the value of Atxtbox.
BUT if I try something like this in Bf when an event happens
Code:
Me.Bcombox2.RowSource = "SELECT xx FROM tablexx WHERE yy = '" & Nz(Me.Bcombox) & "'"
Nothing will be shown in Bcombox2, because Me.Bcombox return Null. I know this from doing
Code:
MsgBox Me.Bcombox
and the message box will shows nothing. The same thing also happen with the Blabel's caption. In form view, it shows Atxtbox value, but when I accessed its caption's value, it returns Null.
What I wanna do is:
1) Open Af, insert value to Atxtbox
2) clicked Abtn, pass the value of Atxtbox to Bcombox
3) Af is closed, and Bf is opened
Why the null...?
Is there a way to allow edits to the properties of objects/controls only in Design view and not in the Form View?
View 2 Replies View RelatedA member of the Access User Group that I am associated with has asked a question that I can't answer.
In older versions of Access, when you went from Form Design View to Form View, if the Properties Sheet had been visible, it would be hidden in Form View. Since probably Access 2000, the Properties Sheet remains visible in Form View (if it was opened in Design View). Not a big problem, you say? Well, it is to this person, who is concerned about her users seeing the Properties Sheet and making changes in it.
Anyone know a way to defeat this behavior and hide the Properties Sheet in Form View?
Thanks.
I have a form called Orders.I need to lock this form once an invoice has been printed .
I have a check box on this form ,that if ticked should lock that specif order .
This is my Code:
Private Sub Form_Open(Cancel As Integer)
If Me.lockorder = True Then
Me.AllowEdits = False
End If
End Sub
The problem is it does nothing . I am using the open event of the form .The checkbox is called LockOrder.
Hi
I know this is probably a silly question but I had a number of checkboxes in a table and had set their default value to be 0 however I did not do this in the table properties of these fields.
I can understand some things like formatting dates in a form but storing it differently in the table but why did access not automatically input 0s in all the fields where I did not check the box?
I am working in the design view of a form, the controls properties sheet disappeared-gone and even clicking the properties sheet button it does not come back.
View 1 Replies View RelatedOn my form ECOs
When my text box RELNUM is > 0 I want form properties AllowEdits set to FALSE.
When RELNUM is null I want form properties AllowEdits set to TRUE.
This must be possible, but not entirely sure where to start.
Since I can scroll through records in this form I'm thinking I have to put an event in ON LOAD, bbut beyond that I'm at a lost.
I have a single form which becomes either readonly or editable or addnew using a circular toggle switch. The toggle switch is activated by a command button and the caption of the command button is used as the display of the mode.
The SetAddModeBt is a separate command button that initiates the add mode. The problem is that various form or field properties when defined on the fly are not stored and they get lost when you open the form again. Look at the code below:
Code:
Sub tglEditBt_Click()
'-------------------------------------------------------------------------------
' Circular toggle button to change display mode of the form
' ReadOnly - Edit - Add
'-------------------------------------------------------------------------------
' On Error GoTo NotFound
Dim ForName As String
Dim strSQL As String
Dim FMode As String
[Code] ....
Here the first two cases fail when executing the last statement saying it is not supported.
Why the ability to view the properties of an object within a form is not available when you double click on it in design view?
I was happily working away double clicking on a command button to edit some code when for some reason the next time I tried to edit it did not open up for me.
I was unable to access it even by right clicking on the object & selecting properties as that also appears to be disabled, not greyed out or anything but just does nothing when selected.
Have I inadvertently changed a setting somewhere that prevents the properties from being displayed?
In a nutshell...I want to have a form open with the "form" properties set to "NO" on "AllowEdits","Allowdelete" and "AllowAdditions" and then those same properties set to "Yes" depending on who you are when you open the form.
I think I got a handle on the "who you are" part, I am just not sure about the form properties stuff.
Thank you
I was doing my assignment with the table in access, and my sister came up to me and ask me “why it is important to check the properties of each field in a table before developing a form based on that table.” Can anyone help me and answer this, because I don’t know how to answer her question.:confused: :confused::confused:
View 1 Replies View RelatedAm sure this is an easy question but I'm missing something:
How in the heck are you supposed to get to the subform properties box. The only way I know is to click on the very thin border area surrounding the form and then try and right click your way to properties. There has to be an easier way. Usually I have to fight my way to the properties box as the area loses focus by the time I right click and I have to reselect and try and right click again...ARGH!
hi all,
i m referencing a control like me!<controlname> in my code.
but in 1 screen its not giving me option after me!<ctrlname>.(only value property).
but in other screen i m able to access the properties.
So what could be the reason for this.I particularly want to access the enabled property to set it dynamically.
Thanks
How could I implement a feature which determines if something is at least 7 days before a booking at a theatre, but no more than 2 months. For example, something like... If =Now() - 7 Then... Elseif =Now() Then...
I don't really know how to go about it.
Hirer Date is when the booking is to be held (e.g., 12/01/2006) and Booking ID is when it was booked over the phone. (121205/M = 12/12/05 in the Morning) If someone could help me I'd appreciate it greatly. :D
Hi everybody!
Is it possible to set the properties for an access database not to confirm the changes when running an update query. I have done it under tools/properties etc. but then I make it in access in general. I want it to apply on one singel access database.
Anyone?
eroness
ciao people
i've been looking around for days, hope u can solve my problem!
my form is made up of several combo boxes
i wanna write a code which after a selection in any combo box sets the properties of the latter as follow: enabled NO and locked YES (just the opposite of the default value)
can u please help me?
ciao people
i've been looking around for days, hope u can solve my problem!
my form is made up of several combo boxes
i wanna write a code which after a selection in any combo box sets the properties of the latter as follow: enabled NO and locked YES (just the opposite of the default value)
can u please help me?
Ok, Let's say I go into File->Database Properties from the "main" Access screen. This brings up a window with the title "<database name> Properties" where <database name> is the same as currentproject.name.
This window has several tabs including "Summary" and "Custom." It looks like this should be stuff that I can set and then reference from within my code.
My thought is that I can use the "Title" from the "Summary" screen as a variable for all of my msgbox titles. The other interesting one is "Project" on the "Custom" tab. It looks like this may be the same sort of thing.
I've found that the Access Help is absolutely useless - I'm about ready to take a shotgun to "Clippy." But as they say, a display is a terrible thing to waste <grin>. I've also found that it's getting harder and harder to find what I'm looking for in the MSDN library. There's so much stuff and they don't always file it in logical places.
Well, thanks for reading.. sorry for the rant. As usual, any help is appreciated!
Cheers!
Can anyone tell me a sample code on how to write/develope the Advance file properties like....
File version
Description
Internal Name
Product name
I have seen different types of files properties some has additional features while some has none - its just click once on any file and then click the right hand side mouse button and select the properties that will display all the information about the files click on second tab version (if there) will tell you the additional info about the file.
I have a line chart built in Access. Is there anyway I can change the line colors like I can in Excel? The default fuschia, bright yellow, and bright blue are horrendous.
View 3 Replies View RelatedI have an Access database split into FE/BE. For the front end, each user has his own directory on the lan. The directory is named with the UserName.
I've created an installation program in Access. It basically installs the icon on the user's desktop using Environ("UserName"). It also installs an Excel file the program needs on the hard drive.
Here's the problem...Right now, the installation program grabs the shortcut off the lan and installs it, but that shortcut has one user's UserName hard coded as the target. That one piece of information needs to change for each person. Is there a way for the program to modify the target based on the username of the person running the installation program? Without this piece, I need to visit every user after he runs the installation program and modify the properties of the new icon to point to his specific directory.
Thanks for any help you can provide!!