How To Make A Text Box To Retain Its Previous Value

Aug 10, 2014

I have a text box in a form. When the value in the text box is changed, a message box appears asking if the user wants to change the value in the text box. If they select "Yes", all is good and it goes on well, but when they select "No" is it possible for the text box to retain its previous value?

For example.

The value in the text box is "1". The user changes this value to "2". A message box pops up asking if the user wants to change the value, the user select "No" and so the value in the text box goes back to "1", the number it started with before it changed.

View Replies


ADVERTISEMENT

General :: Text Box On Form - How To Make Textbox Date Default To Previous Record

Nov 13, 2013

I'm having trouble with a Form and getting a text box entry box (Date entry) default to the date entered on the last record, which is linked to a table.

The only way I can get it to work is to type the date into the Text Box's Default property, for example, #11/13/13".

How to get the correct syntax or code into the Default property of the Text Box to make this work? I only want the entry to change versus the previous record/entry if the User changes / enters a new date.

View 9 Replies View Related

Forms :: How To Make Combo Box Remember Previous Value

Jun 30, 2014

Only thing left is a combobox (dropdown) with predefined values. What i want is, as soon you have picked a value from the combobox, save the record and go to the new blank record, the last picked value of that combobox auto appears in the combobox for the new record.

View 1 Replies View Related

General :: How To Make Previous Rows Disabled In Subform

May 26, 2013

I want to disable the previous row in the subform the moment I do a new row to prevent the user from editing information other users put before. Is it possible.

View 4 Replies View Related

Reports :: Subtracting From Previous Line In Report To Make Running Total

Jun 16, 2014

I have a database and one of the functions is to track the purchase of fuel. Part of purchasing fuel is registering what the current odometer reads. My query gets the Vehicle ID, Date of Transaction and Odometer reading. I want to show a report that shows how many miles the vehicle is has traveled for a certain amount of time. If it's for 2013 then I'll put the criteria for 2014 in the date. This will give me a list of all vehicles and their odometer readings. I then sort the date by ascending.

In the report I group on vehicle ID and then I want to show all their transactions and add up how many miles were driven.

Vehicle 1

1/2/201
1/5/2013
1/15/2013
ETC...
Total Miles Driven in 2014: XXXXXX

View 1 Replies View Related

Records Don't Retain Their Data

Mar 3, 2006

My database was working fine until I had to make some minor changes in a few of the fields (which I did in the table and the data entry form). Now, all of the combo boxes in all of the records show the same selection. If I change the selection in one of the fields in a record, it changes the selection in that field in all of the records to that selection. :eek:

View 7 Replies View Related

Can You Make Just One Part Of The Text In A Text Box Bold Or A Different Font Size?

Aug 20, 2004

Is there a way to make just part of the text in a text box bold, or to use different font sizes in the same text box?

Something like this:

---------------------------------
Heading in bold: description in regular (not bold)
(a smaller height line used as a line space)
Another "normal" line
a larger height line
a normal line....all in one text box!
---------------------------------

One thing I'd like to be able to do is to specify the line height of a blank line in a text box. I'm using carriage returns created with: Chr(13) & Chr(10). I could see defining the font size of a hidden character, but I'd need to know how to assign a font size to a piece of the text in a font box.

View 2 Replies View Related

Reports :: Text Box Make Bold Uppercase Text

Sep 18, 2014

is it possible with transform, only uppercase text contained in a report textbox, to bold? How? Through VBA?....

View 1 Replies View Related

Need To Retain History And Update Records Based On Condtion

Nov 26, 2007

I have this scenerio that I am trying to work through and find a proper solution:

Main table stores a part # and an index (Primary Key) along with a bunch of other data. I want to store with the part # the current active version of firmware (aka software) associated with that particular part# / index. Part # may be a duplicate, so for this reason the PK is the index, so that each index / part # will have which firmware has been used with it.

I would like the ability to retain a history of firmware versions used for a particular part # / index so that if we need to go back to a previous version of software we will know which ones have been used.

I have been able to create the relationship to show all previous versions of the firmware used for a particular part # / index, but cannot figure out how to only have one 'current' and update the others as 'archived'. I would like to either use a boolean or selectable lookup (ie Current vs. Archived). What I want is that when I select one firmware to be ‘current’ all others related to the particular part # / index are updated to ‘archived’ leaving the other records not related to that part # / index alone. Also note that I am trying to make the update of the firmware status in the table view without having to go through a form.

Main Table
ID (PK)
Part No
Product

Firmware History
FirmwareVerIndex (PK)
PartNo
Firmware
ChangeDate
ChangeName
FirmwareStatus

Firmware Table (lookup table)
FirmwareIndex (PK)
Firmware
FirmwareFileName

FirmwareStatus (lookup table)
ID (PK)
FirmwareStatus

View 1 Replies View Related

Shuffle Two Fields Of A Db Differently! But Retain Ability To Relink Them

Feb 4, 2007

in a Dbthere are 2 fields which contain 'matching' data. (there are other columns too)
A Genesis
B Exodus
C leviticus
D Numbers
E Deutronomy

I want to shuffle both columns so they are both randomly mixed up
B Numbers
A Exodus
C Detronomy
E Leviticus
D Genesis

How do I do it?
I have explored the random function but that randomises the records but keeps each record intact.

I then want to print these two columns to a report which numbers each line - easy enough once I have the query BUT I want to print an 'answer page ' at the end of the report which will look like this:-

1 B Numbers (5)
2 A Exodus (1)
3 C Detronomy (4)
4 E Leviticus (3)
5 D Genesis (2)

I thought of appending a unique ID string to each pair and only displaying the first part of the string e.g
A@1 Genesis@1
etc and I can do this but maybe there is a simpler way.
Lastly supposing I would want to keep the order of column one and only shuffle column two?
Thanks for any advice!

View 1 Replies View Related

Queries :: Delete Duplicates Retain Unique Records

Aug 13, 2013

I have a table that has multiple records (count >1). I used the find duplicate records and then made it a delete query, however, this resulted in deleting all the records that had count >1. I need to retain distinct record, and delete the extra records. Using select distinct.. I do not want to use VBA to achieve this, but at the same time be able to incorporate the steps in a module that would execute the queries in a sequential order and achieve the same results.

View 6 Replies View Related

General :: Export Pivot Table To Excel But Retain Values

Jan 25, 2015

I am trying to export my Access pivot table to excel because every time I do, the values (which are text and numbers; i.e. some numbers and some <0.05 format) are changed into a sum, product..... I need to rearrange this data not calculate anything.

View 14 Replies View Related

Text Box Data Contingent Upon Previous Combo Box

Mar 28, 2006

I have a combo box where I select a Hardware store. I want the address for the store to come up if a hardware store is selected. If one is not selected I want to be able to enter an address.

I have a vendor (hardware store) table, which contains the Hardware store and it's address. I can get the combo box to show the store selections but I can't get the address to come up after I select the store.

Is there a way to link text boxs to a combo box??

Thanks, Joe

View 2 Replies View Related

Modules & VBA :: Update Text Box From Entered Value Of Previous Form

Sep 17, 2013

I have a log in screen called frmLogIn and on there i have Unbound Combo Box cboUser and Unbound Text Box txtPWord. I also have cmdOK.

IF the user sucesfully enters his password it takes him to frmMainMenu.

On that form i have a lable called lblYouAreCurrentlyLoggedInAs and a unbound text box called txtUserName.

How do i update that txtUserName to whatever was entered in the previous form's cboUser.

View 1 Replies View Related

How To Make Text Box Appear?

Aug 30, 2005

I haven't used Access in a looooong time and building a document tracking database for work. I am setting up my data entry form and would like to have a text box appear depending on the selection from a combo box. So, if the user selects "In Review" a text box will appear for entry of the reviewer's name, likewise if the user selects, "In Work." In the other cases (options in the combo box) the document is not being revised, so no name needs to be entered--so no need for the additional text box. Make sense? Any guidance/advice as to how to go about this? Thank you!

View 3 Replies View Related

Make All Text Caps

Aug 30, 2005

I need to make all my text in all my fields Caps.
The users want type the text in the field and have it be caps even if they don't have the caps lock on.
Is there an easy way to do this?
Any help would be great!

View 5 Replies View Related

Using Date And A Value To Make A Text Box True

Mar 27, 2008

Hey all, i got another small problem with this bloody database!

The problem today folks is this, im making a booking system (well the booking is a small part of the overall system) so i have DateArrive, RoomID, and all the usual.

now what i want is to make a query that says
if DateArrive & RoomID (Booking Table) then make RoomOccupied(Room Table) true

if that makes sense, i tried some in sql and got the date bit working, but wasn't sure how to go further so as to make it so RoomID is involved

(ill say in another way If a room is booked on a specific day i want to make Occupied true)

thanks for anymore help u can give

View 6 Replies View Related

Make A Text Box Visible On Cmd Button

Aug 27, 2006

Hi, I have a form with a INFO button, what I need is when the info button is pressed a text box becomes visible on the form and when pressed again the text box become not visible, this will allow the final user the have additional information regading compiling the form etc!
Thanks
Marco

View 5 Replies View Related

How To Make Text Clickable In MS Access

Jul 23, 2012

How to make the text clickable (and will open a new form)

for example

StudentNo

12345<---- if i click this one 12345 information such as name, age, course, year and etc. will show in a newform
12346
12347
12348
12349
12341

View 3 Replies View Related

Is It Possible To Make Long Text Longer

Jul 4, 2014

I have a large spreadsheet with one column of information which is longer than what access accepts as long text. So when I convert the spreadsheet to access all the large boxes of information are shortened so that I am losing a lot of information.

View 1 Replies View Related

Make Table To CSV, Remove Text Qualifier

Feb 26, 2008

Thanks for looking!

I'm using a query to export a table to a text file, i.e.

SELECT * INTO [Text;HDR=No;Database=C:].[test#txt]
FROM [TestTbl]

Text fields end up surrounded by double quotes as a text qualifier. Is there a property I can use to get rid of the text qualifier within the SQL (similar to how HDR=No gets rid of the headers)?

I've tried searching and guessing, but nothing has worked yet. Thanks!

View 6 Replies View Related

Can Selecting A Combo Box Make A Text Box Visible Again

Sep 29, 2005

Hi,
Is it possible when choosing a combo box to have it make a text box visible, when in this text boxes properties you've chosen visible=NO. Can an event procedure or some code be written that will make visible=YES.

Thanks any help with be greatly appreciated

View 1 Replies View Related

How To Make A Button That Autofills Text Into A Form?

Mar 10, 2006

Hello-
I have a database form where I have a lot of like data I type.
Can I make buttons to automatically put text into the form field?
How do I do this?
-Tim

View 3 Replies View Related

Can Selecting A Combo Box Make A Text Box Visible Again?

Sep 30, 2005

Hi,
Is it possible when choosing a combo box to have it make a text box visible, when in this text boxes properties you've chosen visible=NO. Can an event procedure or some code be written that will make visible=YES.

Thanks any help with be greatly appreciated

View 1 Replies View Related

Make Text BOLD On A Report (criteria).

Feb 5, 2008

Not sure if this is possible but here goes (even if I make a fool of myself for asking).

I have a report that lists data based on criteria set in a form. The main criteria is Month (Month4Report) and Year (Year4Report).

The report lists all jobs that started that month and also any jobs that had work done during that month - even if they started in the previous month.

What I would like to do is highlight any job that has an actual start date prior to the current searched month (Month4Report). By making it bold or other way.

Is this possible?

Thanks.

Martin

View 8 Replies View Related

Forms :: How To Make Text In A Listbox To Flash Red

Mar 25, 2015

I'm working on a series of forms for a company that I'm currently employed at, and on one of them I've made a listbox which will display records which need action in the next 2 weeks.

That's all going fine. However, it it possible to make the items in the listbox flash red? Just so that our external worker REALLY has no excuses!

Just to clarify, I want the text identifying the records (E.g. Name, FinalDate) to flash, but not the headers for the columns in the listbox.

View 10 Replies View Related







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