Forms :: Event To Check Field Content?

May 11, 2014

I have a form with a number of fields and sections which change visibility based on the data entered in other fields,

The fields have an "on update" event to check the content of the field and make the appropriate changes,

I've changed this form to be able to edit records instead of "Data Entry" so now I need the checks to occur when the record changes as well as when data is entered,

How best can I achieve this without simply duplicating the code (which seems like a bad idea) into the "On Current" event?

View Replies


ADVERTISEMENT

Forms :: How To Limit A Field Content Based On The Content Of Another Field

Nov 25, 2013

As I began thinking about the data that I need to include in one of my reports I relized that I need to gather some extra data.Each design change has a lifecycle with 7 basic states from not started through to closed. States 4, 5, and 6 have two posible sub-states that I need to capture and report. It is almost like having options.

My data entry form already records the 7 basic states. What I would like to do is have another field that records the sub-states if the design change is in one of those three states.

Will a ComboBox do this?

Do I need a test routine for the After Update event in the first text box? Something that will check for states 1 - 3 and 7 move on to the next field and if states 4 -6 require users to enter the sub-state.

Would a nested if-then-else routine do the job?

View 1 Replies View Related

Create Field Content Based On The Content Of Others?

Apr 16, 2007

Can I create contents of one field based on the contents of others?

I have a database of pc systems which we've tested and was wanting to generate a single text line to identify the individual pc

The single filed would contain data from the following fields
Job Number
CPU Type
CPU Speed
RAM
HDD size

eg
So the new field would contain "Job345-P3-1000-256-20"

Can this be done?

View 3 Replies View Related

Forms :: Coloring Form Field Based On Another Field Content

Jun 4, 2013

I am making a very simple 'registration' database for a children's event in a couple of weeks.I the table/form there is a checkbox field called 'consent' which, if checked, indicates that a child can leave the event without parental consent.

There is a report printed on each child (a registration page which the leaders get a copy of). I would like on this report a 'red box' to appear if the child cannot leave without permission (i.e. the consent box is not checked). I would also like this 'red box' to appear on the form. I had thought of doing it this way - but I'm not sure if it's the best, or if it's possible:

Have a field in my table called 'consentindicator'. When the 'consent' box is checked, there is a period ('.') placed into the 'consentindicator' field. It is set to turn red when a period is present. That way, when the consent box is checked, a get a red 'box'.

View 12 Replies View Related

Forms :: Copying Content Of Previous Field

Jan 26, 2014

I would like the text from the previous field Invoice_Contact copied into the field Invoice_Contact of each new record created. I think I can use CTRL ' - but would like it done automatically if possible.

Field location:
Form = PatientUpdate - Subform = F_Invoice - Field = Invoice_Contact

The form and subform are linked through: Pat_ID

The subform is based on the table called Invoice with Invoice_ID as the primary key.I tried several variations of this DLookup from examples I found on the web but the field comes out with "error" in it and its flashing!

View 14 Replies View Related

Forms :: Making Data In A Field On A Form Appear If Content Is Not Null

Dec 31, 2014

I have a subform with continuous records. One of the fields in the recordset of the subform is a field named "Remarks". This field does not need to be visible on the continuous subform as it is rare that this field will have any entries.

I plan to apply conditional formatting on another field (IDcardNo) in the record line of the continuous subform so that when field "Remarks" contains any data it will show as a different format on the field IDcardNo.

I would like to make a small form appear when one points to the IDcardNo field with the different format, so that the data in the field "Remarks" pops up when one points to the field IDcardNo with altered format, showing that there is data in the field "Remarks".

View 3 Replies View Related

Send A Content Of Unbound Field In A Form To A Field In The Table

Feb 26, 2006

in my form I created an unbound field with a requested combination, now how can I put those in a table field.
in other words, how can I send the content of a form's unbound field to a field in the table?

your help is very appreciated.

Regards,
CS.

View 3 Replies View Related

Modules & VBA :: Matching Content To Other Content?

Feb 4, 2015

how many elements matching to my primary elements from any records of my query and count match, if some element doesn't match then I need to add it to my primary elements, then at the end (rst.eof) count how many primary elements I have.

E.G

id colours
1 blue;red
2 purple;blue;green
3 red;violet;purple;blue

dim matching_elements as long
dim primary_elements as string
dim TheNumberOfPrimaryElements as long

First of all, if I open recordset primary_elements is empty so I need to assign a value form first record.

primary_elements = rst!colours (so primary_elements = blue;red)

Now I can start comparing my primary_elements with second record:

matching_elements= 1
primary_elements = blue;red;purple;green

comparing my primary_elements with third record:

matching_elements= 3
primary_elements = blue;red;purple;green;violet

It's my last record so I need to count primary_elements

TheNumberOfPrimaryElements = 5

I need "matching_elements" to count other function in my application.

View 7 Replies View Related

Split Content Of The Field

Apr 15, 2008

I have a field in access database called result (coming from webform) and the content is something like: 'not much; 2' or 'frequently; 5'. How can I split numeric and text value into two separate columns in query?
I will greatly appreciate any help.

Debbie

View 14 Replies View Related

Collate Field Content From Multiple Records

Jul 15, 2007

I have a database with company records in one table and calls made to companies in another table; the two tables properly related on a CompanyID field. A query joining the tables returns a dataset with multiple instances of CompanyID's because each company may have received 0 - n calls.

I would like to collate the content of the 0 - n[/I] callnotes records for each company into a single 'CollectedNotes' entity. I have two questions please.

Can anyone think of a way to do this without using code?

If not, can anyone give me a helping hand with the code?

In pseudo-code terms, I anticipate something like accessing the recordset for CompanyID's related to CallID's looping through to write the content of each instance of a CallNote (identified by unique CallID) to a new 'CollectedNotes' object. Help gratefully received. Thanks. MITW

View 3 Replies View Related

Deleting Records Based On A Field Content?

Nov 16, 2004

Hi all!

I'm rapidly beginning to get a little confused... I'm trying to mass-delete records based on the content of a field.

I want to run either a query or a button on a form (or anything, for that matter) that will delete any records when there is an X in the N_Disp field.

Any ideas?

Thanks,

Barry

View 3 Replies View Related

Counting Records With Specific Field Content

Nov 23, 2005

hi there

I'm building a forum from the scrath. It is already working, but I want to have in each topic the number of replies it has.
there are 2 tables, one for the topics and other to the replies. in the replies table there is a field called id_post that has the id of the post witch it belongs.

I solve the problem by inserting a query inside the loop of the posts:

<%
While Not rs.EOF
%>
<%
Set rs2 = Server.CreateObject("ADODB.Recordset")
sql = "SELECT COUNT(*) as cont FROM replies where id_post= " & rs("id") & " "
rs2.Open sql,Conn,1,2
%>

post: <%=rs("post")%> replies:<%=rs2("cont")%>

<%
rs.MoveNext
wend
rs.close%>

but someone told that this would make the page slower, so I want to know if I can do the same thing without having the query inside the loop.

I don't know if I made myself clear, sorry for that.

tks for the help.

View 1 Replies View Related

How To Show Field Content In A Label - ID Of Dataset

May 24, 2012

I want to display the ID of a dataset in a form but I don't want the user to be able to edit it. Therefore I want to display the id in a label and not a textbox or combo etc.

I can't see a way of how to do this though. Is this possible, or am I going about it the wrong way?

View 3 Replies View Related

Enable/Disable Event Proceedure With Check Box

Mar 28, 2006

Hi, bit of a noob here. I've searched for a while but I can't find anything related.

I have a data entry form that auto recalls the last entry that was made in it. I did this in an effort to speed up data entry. Anyways, here is the code I use.

Private Sub Investigator_AfterUpdate()
Investigator.DefaultValue = "'" & Investigator.Value & "'"
End Sub

Now the problem is that I want to be able to enable and disable this event proceedure with a check box. Is there a way to do this?

Thanks in advance for all your help.

View 2 Replies View Related

Check To See If A Table Is Already Open On A Click Event

Feb 4, 2005

Some of the things that bring me screeching halt really surprise me. I swear, this sounds like it should be so easy....

What I need to do is check, when the user clicks on a button, whether a specific table that is going to be modified/deleted later in the click code is already open. If it is open, I will msgbox the user to close the table first and exit the sub.

Any ideas?

All help, as always, is much appreciated!

John

View 4 Replies View Related

General :: 4 Check Boxes Trigger Another Event

Jan 23, 2013

Basically, I have progress table with learners and each learner must undertake 4 tests. Once they have completed each test, in the original learner table, I want it to show that they have completed the task if all 4 boxes are checked by it triggering one final check box.

View 2 Replies View Related

Dynamically Generate Content On Forms

Apr 10, 2006

Hi,
Does anyone know of a way to dynamically fill the content of a form at runtime. I want, for example, when a user clicks a button, a textbox is dynamically added (but I would prefer not to use hidden objects). I've tried the "CreateControl" option but I can't seem to get this to work. Any coding examples would be much appreciated.
Thanks,
Mark.

View 4 Replies View Related

Forms :: Verifying Content Against A Table

Oct 8, 2014

I have a simple database that a user records the work they have done for the day. They are required to fill out the form with the item number, date, qty etc... the problem is some people are fat fingering things and i am not getting the right item numbers... I have a table called dbo_item with all the possible item numbers in it, is it possible that after they hit enter or click off the item number box it will tell them they put in an invalid item if it doesn't match one of the items from that table?

View 3 Replies View Related

General :: Check Box Event - Lock Textboxes Depending On Each Record

Aug 30, 2013

I have a checkbox which when checked then turns textboxes to locked as below. However when I navigate to the next record which may not be checked the text boxes remain locked. I obviously want to lock the boxes depending on each record. I am navigating via the windows next/back record buttons. How do i do it?

Private Sub Check44_Click()
If Check44.Value = -1 Then
serial.Locked = True
gain.Locked = True
swst.Locked = True
Else
serial.Locked = True
gain.Locked = True
swst.Locked = True
End If
End Sub

View 6 Replies View Related

Forms :: Using OnClick Event To Open Query Text Displayed In Form Field?

Oct 10, 2013

I have a table that holds the SQL texts for ca. 1000 Select queries (mostly minor variants that are used to programmatically swap out RowSource strings for combo boxes). I'd like to have a quick and easy way to open/review/modify these queries.

One strategy would be to display the SQL strings in a field on a Datasheet form, then use an onClick event on a text box linked to the SQL-holding field (or perhaps an onClick event tied to an unbound text box on the form) to open the associated query. That would allow me to view the SQL of the query that I want to open, allow me to quickly scroll through the list of stored SQL texts, and give me options for sorting or limiting the SQL-texts displayed in the datasheet form.

But, I can't seem to get the onClick event to work. The problem seems to be that I can't figure out how to pass the SQL string contained in the field to a function that will use that string to open the query .

View 10 Replies View Related

Forms :: Check For Duplicate Serial Field

May 12, 2014

I have a simple database that I put my execptions in for the day for scanning. Is there a way that my serial field on my forum can check to see if someone already scanned that serial for that day using the "On Lost Focus" event.

View 7 Replies View Related

Forms :: Check Box Checked - Field Cannot Be Updated

Sep 27, 2013

I have created a user form that contains check boxes for various fields, and on this form, when the box is checked, I get a prompt that the field cannot be updated. I have several other forms that use these same yes/no fields, and I am not having the same problem on these forms. I checked the property sheet row source for the form and I don't see anything wrong with the select statement (that I know of).

View 1 Replies View Related

Forms :: Check Box Drop Down Multi Value Field

Jan 3, 2015

Trying to use some code to 'Select All' from a 'Check Box Drop Down' Multi Value Field . The table field size is long integer.

When trying to "Select All" the code returns a RTE 3163 "This field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data".

Private Sub cmdSelectAll_Click()
Dim SelVals, i
ReDim SelVals(0 To lkupAssignedTo.ListCount - 1)
For i = 0 To lkupAssignedTo.ListCount - 1
SelVals(i) = lkupAssignedTo.Column(1, i)
Next i
lkupAssignedTo.Value = SelVals
End Sub

Not my code, but just something I have found and trying to adapt. Tried changing the field sizes but no luck. Maybe something to do with declaring variables perhaps??

View 3 Replies View Related

Forms :: Check Box Within A Form Ticked Or Not Dependent On Another Value Within A Field?

May 10, 2013

I there a way to determine whether or not my checkbox within a form is ticked or not dependent on another value within a field?

I have a field called 'DaysRemaining' and another check box field called 'Expired'. I want the expired checkbox to be ticked if the value within 'DaysRemaining' is '<0' and unticked if '>=0'. Is there a way i can do this within the control source of my check box?

View 1 Replies View Related

General :: Access Runtime 2010 Don't Show Some Forms Content

Jul 27, 2012

I have a question that i have implemented database with access runtime 2010

I have a navigation form opens up which provides buttons to open different forms & reports .

But I cannot open some of the forms in runtime although title heading apears but other content just goes blank , it has subforms in it . . some forms opens and some reports as well but some form just doesn't.

And on the notification bar it asks for a save as ??? why is that ...

View 5 Replies View Related

Forms :: Make Image Appear In Form When There Is Check In Check Box From Table?

Jun 26, 2014

how can i make a image appear in my form when there is a check in the check box from the table?

View 14 Replies View Related







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