Temporary Disabling A Field In A Form

Sep 24, 2006

Hopefully someone can point me in the right direction.

I have a small spare parts db which also has pictures of some of the parts.
manufacturer
partnumber
wholesale
retail
picture

The form carries data on wholesale price which I would need to hide if the customer would like to see a picture of the required spare part.
Is it possible to have a button to temporary make the wholesale field non-visible? Or would it be better to click on a button to open a new page with just the picture of the selected part and the retail price, if so what is the best way to achieve this.

Thank you in advance for any assistance.
Kim

View Replies


ADVERTISEMENT

Forms :: Graying Out / Disabling Field Based On Other Fields On Form / Subform

Jun 27, 2013

I am wanting to grey out/disable a field on a form based on entries in two other fields being the same. One of these fields that contains the data to be referenced in on a sub-form.The form is called 'Payment_Information-Form', the field to be greyed out/disabled is called 'SUF A Paid?'

The fields that are being referenced are: 'Set up fee in s (SUF) Recrt Restriction A <=' which is on the main form, and 'SUF_Letter' which is on a sub-form (within the main form). The sub-form is called 'Costings_11_Previously_Paid_SUF subform'.If 'Set up fee in s (SUF) Recrt Restriction A <=' equals 'SUF_Letter' then grey out.I tried the following formula in both the On Current and After Update sections but it hasn't work.

=IIf([Forms]![Payment_Information-Form]![Costings_11_Previously_Paid_SUF subform].[Form]![SUF_Letter]=[Set up fee in s (SUF) Recrt Restriction A <=],[SUF A Paid?].[Visible]=True,[SUF A Paid?].[Visible]=False)

View 4 Replies View Related

Forms :: Setting Temporary Default Value For Date / Time Field

Jul 3, 2013

My setup:

frmUsedOilContract (contains a header and a subform)
subfrmUsedOilContract (contains a few controls) [datasheet view]

- Removed Date
- Voucher Number
- Building Number

I implemented some code so that a temporary default value could be set for the date and the Voucher Number. I also have the default value for 'txtRemovalDate' set at 'Date()'.

PHP Code:

Private Sub txtVoucherNumber_AfterUpdate()  'Set current value to default value.  
txtVoucherNumber.DefaultValue = txtVoucherNumber.ValueEnd Sub 

PHP Code:

Private Sub txtRemovalDate_AfterUpdate()  'Set current value to default value.  
txtRemovalDate.DefaultValue = txtRemovalDate.ValueEnd Sub 

Also have code so the default value is null when the form is opened.

PHP Code:

Private Sub Form_Open(Cancel As Integer)  'Set Default Value properties to nothing.  
txtVoucherNumber.DefaultValue = vbNullString  txtRemovalDate.DefaultValue = vbNullStringEnd Sub 

This all works great until I try to change the date. If I use the default date (today's date), the new record will stay with today's date. If I change it to a different date, the new record displays a time instead.

View 2 Replies View Related

Wiping A Temporary Table (Through Form)

Apr 12, 2006

Hey again.
Asked a question last time that might've been a little too complicated but I've made a lot of progress since then. :)

I've a form which I enter weekly data into which I have transferring into a temporary table. At the bottom of this form I've got a button which runs an update query which takes the entries from the temporary table and adds them to the main table.

(I'm doing a fantasy football league. An example is that if I enter that a player has recieved one yellow card in the weekly data, when I update the main table it will add one yellow card onto the total, etc.)

The problem I need help with is that I find that I need to get the temporary table to wipe itself as soon as I press the button to update the main table. Is there a way I can work it into the update query, or will it need to be done seperately?

Thanks.

(I have searched for this kind of thing, and found a topic that was dealing with VBA. From what was posted it didn't seem to relate to my problem, so I decided a new topic would be my best bet to get some help.)

View 4 Replies View Related

Modules & VBA :: Create A Login Form That Allows User To Change Temporary Password

Feb 25, 2014

I have been trying to create a login form that allows the user to change his/her temporary password logging it to the proper table along with timestamp and who done it info.But, after spending the morning trying to find the proper syntax I am flummoxed.

I can get everything to work accept the update of the fields. I can get the command to work (writes to the location) but it does the pop-up what is the parameter thing when it works. I have all the information just need to get it in so the command recognizes it.

DoCmd.SetWarnings False
DoCmd.RunSQL "UPDATE lut_TeamList SET Pass = txt_Password.value WHERE TeamListID = Me.cbo_UserName.Value"
DoCmd.RunSQL "UPDATE lut_TeamList SET UpdatedBy = Me.cbo_UserName.Value WHERE TeamListID = Me.cbo_UserName.Value"
DoCmd.RunSQL "UPDATE lut_TeamList SET UpdatedWhen = Now() WHERE TeamListID = Me.cbo_UserName.Value
DoCmd.SetWarnings True

View 5 Replies View Related

Forms :: Label Font Change On Disabling A Field?

Jan 23, 2015

I am creating a form and I have some fields I don't want people being able to change so I selected to disable them in the datasheet but now the labels have a strange double text, it looks different than all the other labels and is driving me nuts. when I enable it the font on the label goes back to what the others are but once I change it to disabled it goes funky again. how do I fix this?

View 4 Replies View Related

Complete Newbie.please Help With Enabling/disabling Field Based On Combobox Selection

Oct 24, 2006

Hi everyone,


Firstly apologies for posting what is likely to a really simple problem and probably has been explored before. I have been looking through other treads but nothing that I could identify really fits the bill.

Essentially based on choices made against a combo-box, I wish to lock or hide combinations of fields/combo box within the form. Realistically I want to lock rather than hide.

All the fields/combo boxes in the form I want to effect are bound.

I can effectively do this as long as the fields/combo-boxes are unbound, but it seem to fail when they are bound.

Any assistance would be really helpful so thanks in advance.

View 3 Replies View Related

Disabling A 2 Fields On A Form

Jul 26, 2005

I would like to be able to disable 2 other fields on a form if a user selects a certain item from a drop down list on that same form....????

ANY HELP

View 3 Replies View Related

Forms :: Disabling Fields In Access Based On Data Entered In A Previous Field

Sep 9, 2013

How to disable fields in Access based on data entered in a previous field? For example if "yes" is chosen from a drop down show "Date field" if "no" is chose hide "Date Field".

View 2 Replies View Related

Disabling ALL Controls On A Form Via A Combo Box

Aug 10, 2005

My database has a form with a combo box where the user can select whether the record displayed is "Current", "Sold", or "Withdrawn". I would like to set up the form so that when the user selects "Sold" or "Withdrawn" from the combo box, all other controls on the form are locked and disabled (ie. can't be changed).

What's the best way to do this?

View 4 Replies View Related

Disabling The Close Button On A Form

Dec 21, 2006

I have a form which I want to disable the close button. On the properties of the form I set Close Button option to 'NO'. When I open the form the form close button is disable, but as soon as I maximse this screen, the close button becomes enabled again. Any Ideas as to why this is happening and how I can disable this button comlpetely on this form?

View 2 Replies View Related

Forms :: Disabling Additions In A Form

Mar 22, 2013

I have a form which acts as a search function for users looking to amend existing records. This is based on a query, where users enter a parameter (PolicyNumber) and this returns only the records which match the PolicyNumber in a form view. I have also added basic navigation buttons to move between all records with the same policy number. I have a problem in that I can't disable the option to add a new record in this form once people navigate to the end of the records.

The user clicks a 'search' button, manually inputs the policy number, and the records are returned in form view. The code for the button is as follows:

Code : DoCmd.OpenForm "frmAdjustmentsEdit", acNormal, "qryPolicyNumberSearchWriteOff", "", acEdit, acNormal

How I can disable the addition of records in this? Also as a sidenote if no records are found I would like it to display a MsgBox, but despite trawling the internet have been unable to find a solution I could get to work.

View 7 Replies View Related

Forms :: Disabling Fields From A Different Form / Table

Feb 14, 2014

I am trying to disable a field in a form based on a value in a field on a different table/form. I have been able, through simple VBA code, to disable fields based on a value in the same form. Are queries/sub forms the only way to go?

View 7 Replies View Related

Modules & VBA :: Enabling And Disabling One Control On Continuous Form

Mar 4, 2014

Basically I have a continuous form with each record having a textbox and a checkbox. There can only be one checkbox ticked per record but what I want to do is to stop the other checkboxes from being ticked if one is already ticked.

View 2 Replies View Related

Modules & VBA :: Disabling Auto-formatting Of Controls In A Form?

Jul 14, 2014

I have a problem with formating controls in a form. As a example, I inserted a tree view control and adobe reader control. After I've resized them manually in a design form, I switch into form view and they both resize automatically to their own size (don't know where it gets from).

In the result, I can't obtain the required width and height. How can I make them resizable to my own preference?

View 14 Replies View Related

Forms :: Disabling Subform Depending On Main Form Value

Jan 9, 2014

I have a mainform called frm_Main containing the field AgeCalc

I then have a a subform which has some tabs, one of those tabs contains a subform called frm_Bans.

If the AgeCalc field is <17 I want to disable the subform frm_Bans.

View 4 Replies View Related

Temporary Tables

Apr 24, 2008

Can somebody point me in the direction of a good website to find out about how temporary tables are used?

We have one that picks up all fields in table except one and I have no idea how the information is gathered or where it comes from.

Thanks.

View 7 Replies View Related

Temporary Variable

Feb 12, 2007

Hi There,

Is it poss to create a temp variable in a query. I want its value to be some text then a field:

"some text " + [name]

How do I create this in the query?

Thanks,

View 3 Replies View Related

Temporary Table???

Feb 20, 2007

I would like to create a "global" temp table that can be viewed by all users. The syntax is:
Create [TEMPORARY] TABLE tablename (field type)

QUESTION1:
When I put the optional [TEMPORARY] in, I get a syntax error...
Create [TEMPORARY] TABLE t (ID int)
I've tried...
Create TABLE [t] (ID int)
Is that the same as doing this???
Create TABLE t (ID int)

Can someone clear up my syntax?

QUESTION2:
If i can create a temp table when does the table go away? When I close access? Do I have to delete it?

Can someone clear this up? Thanks.

View 4 Replies View Related

Temporary Display

Mar 27, 2005

Hello eveyone.. I have a slight problem which goes way over my knowledge of the subject!

I have to make a form saying "ISLAND HORSE RACING CLUB" appear for 5 seconds before loading up the main form to add records but I cannot for the life of me figure out how to do it!!

anyone got any pointers? had a look at "timed events" on this forum but dont know how to implement it to help me

Any help would be appreciated

Regards

AaRrGgHh

View 7 Replies View Related

Build A Temporary Table

Apr 22, 2006

hi

hi

i have sql query in a string

strQuery="...."

how to create temporary table with the result of this query?

thanks

View 1 Replies View Related

Temporary Table Names

Aug 1, 2006

Hi there

I'm new to this so please be patient!

I have developed an Access database which produces financial reports based on a date range which the user specifys, taking the data from a SQL server. He chooses his dates and then runs a macro which creates the new tables, overwriting previous tables. Numerous financial reports run on these tables so I need to keep the table names the same.

The problem is that only one user can access the DB at anytime because the new user can't delete the other users table becuase it may be based on a different date range.

I'm open to suggestions but maybe what I need to so is create tables which are based on the user id when he logs in to the Access database so that he doesn't delete someone elses table. How can I do this please!!!???

Thanks in advance

Davebhoy

View 4 Replies View Related

Data In Temporary Table

May 17, 2007

For my inventory DB, when creating a purchase order, I need to store all transaction in a temporary folder and give a temporary number to PO and after finalisation only all data should be appended to main po table with new po number that will be last+1. And all data from temporary tables should be deleted. Like an air ticket is generated, first checks all details, give seat location also and if "Committed" gives the final ticket with no

Any idea about structural configuration and type of queries to be used

View 3 Replies View Related

General :: Temporary Record Or Backup

Sep 19, 2012

I am using different values of a record (selected from a combobox) in my form/table which a user can edit and afterwards use for calculations and reports. the problem I encounter is that the fields are bound so if changed there is no undo if not mistaken.Is there a way to have for instance load a record in a temporary place (without making a large amount of temporary variables) and only update if the "save" button is pressed?

View 1 Replies View Related

Modules & VBA :: Creating Temporary Relationships Between Tables

May 3, 2015

I'm thinking about creating temporary (while db open) relationships between tables, since transfering tables is possible only if no linked relationships are present. However it's important to preserve in some cases referential integrity.Looking online, I found this code:

Code:
Public Function CreateRelation(primaryTableName As String, _
primaryFieldName As String, foreignTableName As String, _
foreignFieldName As String) As Boolean

[code]...

Even with the comments I don't really understand what exactly this code does or doesn't do.I tried the code. It seems (?) to create a relationship. Since the relationship doesn't show up in the relationships table, I'm not really sure if it's there.

- why it's not visible among other relashionships (or is it me?? maybe, it wasn't the code that was working but the query...)
- how to implement referential integrity
- what's the behaviour of this supposed relationship. Is it permanent or not? If not when is it deleted?

View 12 Replies View Related

Modules & VBA :: Putting Values Into Temporary Table?

Jun 28, 2013

I'm trying to put values into a temporary table for the user to view the work behind a returned calculated value.

Here is my code:

Code:

Sub SearchPartNumber_Entered()
Dim txtPartNumber As Variant
Dim rst As Recordset
Dim rstt As Recordset
Dim u As Variant

[code].....

How do I put all values under all 'u' 's into one table?

View 13 Replies View Related







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