Changing Property Settings By Code

Dec 2, 2006

This is getting into some stratospheric territory for me.

I am trying to change the visibility property of a label and corresponding text box, based on the contents of a different combo box. cboHow is a combo box that uses a value list as its row source, since the content of the list won't change. There are three fields that I need when the content of cboHow = "FIS". Otherwise I don't need them and I don't want to see them. My code is below:

Private Sub txtFISDepartmentNumber_BeforeUpdate(Cancel As Integer)
If cboHow <> "FIS" Then
lblFISDepartmentNumber.Visible = False
txtFISDepartmentNumber.Visible = False
Else: lblFISDepartmentNumber.Visible = True
txtFISDepartmentNumber.Visible = True
End Sub

At the moment there is no error code, but the label and text field don't respond by becoming visible/invisible when the contents of cboHow changes. Do I put this code with the txtFISDepartmentNumber or in cboHow? and do I use BeforeUpdate or AfterUpdate? Should I have a separate If..Then..Else for the label and the text box?

I have been playing around with this for several hours now and seem to be going in circles.

I am using A2K

View Replies


ADVERTISEMENT

Property Settings To Eliminate Navigation Pane?

Oct 25, 2011

What 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 Related

Forms :: How To Make Column Width On A Subform Match Property Settings

Mar 19, 2015

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.

View 2 Replies View Related

Modules & VBA :: Report Names - Changing Settings For Array

Nov 6, 2014

I have the following script which I use to modify all report settings, with an array so that I can easily list reports that I want to change the settings for, there could be 50+ reports.

I can use a string but I have to put str1 as string, str2 as string etc... whereas an array would be easier (if I knew how to do it).

Code:
Public Sub ModifyAllReportsProperties()
Dim obj As AccessObject, dbs As Object
Set dbs = Application.CurrentProject
Dim ReportName As String

[Code] ....

View 9 Replies View Related

I Need To Change The Enabled Property After Changing Records

Nov 23, 2005

Hi Guys,

i have a problem i hope some one can help me with.

i have a form with a sub form on it, and i want to disable everything until the user clicks a 'edit' button to allow the information to be changed.

i am just testing it at the moment, so i set one text box's enabled property to false. then i added a button with an on click event with the following code:

Me!userid.Enabled = True

when i start the form, the userid box is disabled and when i click on the edit button, it enables it fine.

however, when i change to the next record, the userid box remains enabled. i cant find where to put the code to set it back to false everytime i change the record.

i should also let you know i am a beginner, so please be gentle!

View 2 Replies View Related

Modules & VBA :: Changing Table Property - After Update Check For Invalid Charters

Feb 1, 2014

I cant change the table property to number only so is there an afterupdate code I could run on a field and check for alphanumartic charters ?

View 1 Replies View Related

Reports :: Changing Visible Property Of Blank Image Fields In A Report

Dec 8, 2014

My student is doing a project on question paper generation in which he selects questions from each lesson needed and also some of these questions have images associated with them. So, if these questions are selected, the image control in the report displays it.

If there is no image, the space for the control is left in tact. I tried changing the visible property for the image control in the Detail_Format event procedure. But this code is not reached at all and the space is still left. I am not storing the image directly in the field but its path in a text field.

I want that the space occupied by the image control removed. I tried the suppression thing but obviously it did not work.

View 6 Replies View Related

Using Variable In Filter Property (in Code)

Mar 28, 2006

Hi.

Me.Filter = "Country = 'USA'"
Me.FilterOn = True

can i use a variable instead of the text 'USA'

give me an example if any pls.

thanks for help.

View 2 Replies View Related

On Load Property VB Code To Limit Records In Main File.

May 3, 2005

I have an Access application for which I would like to provide potential customers with a fully functional application but with a limit to the number of records that can be stored in the main file.

I would like to have a message displayed to say "The maximum number of records have been reached for this application."

Could you help with the VB code required to do this? The module will become active at the "On Open" property when the main Form is opened.

Thank you.

Regards,

Clive Shakespeare

View 2 Replies View Related

Modules & VBA :: Changing Image Path - Set Picture Property Of Image

Dec 4, 2014

I have a form that I would like to update a picture on using VBA. The source of the picture path is in part a query that is not bound to the form. So far I have the following code that is pretty much working, but with a couple flaws.

Code:
Private Sub Form_Current()
LoadDefaultPicture
End Sub
Sub LoadDefaultPicture()
Dim db As DAO.Database

[Code] ....

This is working. However, when I change the record the picture flashes the current picture once and then loads the new picture. It is like it reloads the current picture then loads the new one. I'm hoping there is a way to get rid of the flash.

Also, the code fails here:
strDefaultPictureName = rs.Fields("AttachmentName")

When the query does not return a record. I can definitely fix this by adding an if statement to check for a record, but I'm kind of perplexed at why it is failing at that line. I would expect it to assign an empty string to that variable name and then fail on the next command where I try and set the ".Picture" property of the image.

View 8 Replies View Related

Changing Code Via Text Box

Nov 25, 2005

Hello,
in my Access database there is quite a bit of VBA code.
I have set my LAN and file path in some of this code but will need to change it when this database will get to other users using a different LAN and path.

Is there a way I can avoid them to open the code and manually change this information?
I was thinking of some sort of text box where they will write their path (ex. \S01000sharedoffice*.*) and use a cmdbutton to overwrite the existing path?

Thanks.

View 2 Replies View Related

Help Changing Default Sort Code

Mar 1, 2005

I am trying to set the default sort code to something other than the primary key. Example- Book Code is Primary Key but I want the table to be sorted by Title. I have went into properties and used the Order By property and typed 'Book.Title' however when I view the datasheet, Book Code is still the 1st column??? Is it still being sorted by Title??

Any help would be greatly appreciated

View 2 Replies View Related

Changing Field Attributes In Code

Jan 24, 2007

I know that I can use an Alter Table query to add table fields from code.

But what if I just want to change a field from being Required or Not Required, or perhaps change the field width of a text field?

How do I do that from VBA?

View 1 Replies View Related

Changing Access Code Page On Web Server

Oct 10, 2004

When I send a database to server it changes all of my special charters to unicod charterset, I suposed that server is on american charter set, I would like it to change to central europien windows - 1250 code page, is it posible and how? it is very importand to me.
thx

View 1 Replies View Related

Changing Vertical Scroll Bar Position Of A Form With Code

Sep 15, 2004

Is there a way to change the vertical scroll bar position to always be at the top when I move from form to form. Right now, it will start at the top, but when I move to a different form and back, the vertical scroll bar is positioned in the center. I turned off the autocenter property of the form and saved it in the desired position, but that doesn't work. My form is maximized when it opens. I would greatly appreciate some help. This has been an annoyance for quite some time now.

View 1 Replies View Related

Modules & VBA :: Changing Record Source On A Form - 2 Different Outcomes Using Same Bit Of Code?

Apr 28, 2015

I'm changing a record source on a form when the user clicks a "save" button.

I'm doing this to store a value from the current form in a table that is not part of the default form query.

This works fine.

I have a separate button on my form called "Home", when the user clicks this button it requerys the current form which triggers the before update event to run, this in turn brings up a message box which asks the user if they want to save or not. If they click yes then it runs the SaveButton click() code.

For some reason when the user presses the save button and then exits, everything works but if a user presses the “home” button which triggers the save button then it brings up the “2107 The Value you entered doesn’t meet the validation rule defined for the field or control.” Runtime error and stops on the change recordsource command.

Why triggering the same code directly from a button or indirectly from a before update event has two different outcomes.

View 4 Replies View Related

What Have I Done To My Settings?

Jan 2, 2007

Installed Access 2003 recently and could swear that on a form in design view, sizing a control button for example, by holding down shift key, worked as I expected; it sized up or down by 1/4th of a grid line.

Today, I hold down shift and size a control, and it sizes up or down by one full grid line. Can't find anything in Options that I might have changed, nor in the Format menu.

Does anyone know what may have caused this?

View 2 Replies View Related

Security Settings

Jul 19, 2006

I am new to the Access database building. I am trying to create a Student database for contact information, etc. I have a main table which stores all the users' data. When the student opens the database, I would like to identify the user. They should be able to view everyone's information, but only edit their own. How can i make this happen?

Also, if that is easy enough, I would like to identify when a staff member logs on. This way they can have special permissions to access a schedule searching feature, to look at all the students schedules.

Thanks for the help.

Mike

View 5 Replies View Related

ODBC Settings

Mar 16, 2007

Good Morning,

Im trying to set an ODBC connection to automate the connection process.

The current code I have is:

Set wrkODBC = CreateWorkspace("NewODBCWorkspace", "admin", "", dbUseODBC)
MsgBox "Opening Connection...."

Set MainConn = wrkODBC.OpenConnection("Connection1", dbDriverPrompt, True, "ODBC;DATABASE=live; DSN=live;")

which works fine in bringing up a dialog box to choose the connection.

But what do i write in the database and dsn fields to enable the automation process.

See attached picture for the log in settings. All I have to do is press 'Connect' to start talking to the ODBC.

any help would be greatly appreciated.

Justin

View 6 Replies View Related

Can Anyone Help With Laptop Settings?

Jun 6, 2007

How to swith sleep mode off? Does anyone know? thanks

.................................................. ............
<offending URL removed>

View 3 Replies View Related

Access & Startup Settings

Apr 12, 2007

I have been looking all over for this function in MS Access 2007. Anyone have an knowlege on how to access the Startup section?


Thanks a bunch, :D

~Kilch~

View 2 Replies View Related

Regional Settings And Access

Mar 10, 2008

I'm new to my job and ms access and not very savvy in the latter. There are fixes for my problem on the internet, but I really don't understand them.

I'm used to dd-mm-yyyy format and it's tough for me to think in mm-dd-yyyy in, for example, MS outlook. If I change my regional settings, of course, outlook and access follow suit. The access database is shared and we print out records as cover sheets for our files. Thus, it's not an option to have me on dd-mm and others on mm-dd. Is there a way for me to enter mm-dd in when using the database but have dd-mm standard for every other aspect?

If you can help, which I would appreciate immensely, please pretend that I don't know what I'm doing.

Thanks

View 7 Replies View Related

Can't Save Printer Settings

Sep 10, 2005

I designed a query, opened it and printed it. But the margins were too wide and I needed it to print in landscape also. So I changed the settings and it worked fine, but I can't get it to save the settings. Is it possible to save the printer settings for printing a query, both the margin and the landscape settings. If so, please tell me how. Thanks.

View 4 Replies View Related

Access: Remember Print Settings

Nov 10, 2005

HI

If i set the print settings (page orientation, size etc) when i have a query open, Access has forgotten it next time i open the query.

How the smeg do i get it to remember the print settings?

Please help me im running out of hair!

Thanks

View 3 Replies View Related

New Server - How To Change Settings (Ac 2007)?

Jan 24, 2008

Hi.
I have had a server change and db was moved and I need to change the IP etc. Is there a easy way to do this? I have searched through this forum in vain. :(
Kind Regards
Marie

View 3 Replies View Related

Find And Replace Default Settings

Dec 22, 2005

Is there any way to change the default settings on the Find and Replace dialog from 'Whole field' to 'Any part of field'?

Thanks very much in advance.

Rob

PS Happy Christmas!!

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved