Dynamic Field Update Help?

Dec 8, 2005

I have the following Tables in my database:

Categories | Sub Categories | Products

Categories has the following fields:

Floors | Exterior | Interior

Subcategories has the following fields:

Carpet | Vinyl | Wood | LapSiding | Shingles | Insulation

I have a form called Order Details and when entering the products through my form I have two "Lookup" fields, the first which is CatID which will return a dynamic listbox in the "Categories" field containing "Floors, Exterior, Interior" pulling from the Categories table.

The second is SubCatID which will return a dynamic listbox in the "Sub Categories" field containing "Carpet, Vinyl, Wood, LapSiding, Shingles, Insulation" pulling from the Sub Categories table.

I am however having problems with my third which is "ProdID". I am wanting it to also be created dynamically through a "Lookup" on the Products table. I want when I choose for instance, "Floors" and "Carpet" from the Order Details that only the choices that match those two ID's populate the "ProdID" field and only the products for carpet not for Shingles or other sub categories.

I hope this makes sense...

TIA for any help that you can offer.

Donm

View Replies


ADVERTISEMENT

Dynamic Update Query

Aug 24, 2006

Not sure if this is possible but I figured I'd ask.

I currently have a form/update query that allows me to change a persons last name in a record depending on the value I enter in an unbound text box on the form.

Is it possible to make this query dynamic so I change field names on the fly instead of it programmed for lastname. Example, I want to change firstname instead of lastname.

Would I need another query for firstnames?

View 3 Replies View Related

Dynamic Update - Table

May 18, 2005

Good day,

I think I have the title right on my post. I have attached my db so my I am explaining maybe easier to understand. If you open the db and click Find and enter "Simpson", next click Select. For the "Schedule / Attendance" section I have created a table that will capture the 8 textboxes plus the SO ID of person, in this example Homer. But my problem is, say on May 18th he completes the Core 1 section, but don't complete the Core 2 until May 20th. I only want one record in the tblsch_att for Homer, but I don't know how I can search the table and find the entry from the 18th and Added the 20th to the corresponding record in the table. Furthermore, the only want I can get a record added to the tblsch_att table, is that I have to fill in all textboxes, but I intended to only to have Core1 done one day, Core2 the next day and so on.
Make sense!

Any help on what function can complete this would be great.

View 1 Replies View Related

Making A Dynamic Report From My Dynamic Form

Jun 30, 2006

I have a form that shows a list of all of my records in my database. I want to be able to click a button called "Report" and have that print a report that has all the records I have filtered on my form. I have a report in the format that i want it in, however, currently it prints every record and not just what is shown on my form. (The form is dynamic and I want the Report to be dynamically based on the form) HELP PLEASE!

View 6 Replies View Related

Dynamic Field Contents

Sep 1, 2006

Is there a way to make the value of one field change dynamically based on the values in other fields on the form?

Here's the general idea. I have two tables.

RecordTable
--------------
SiteID, etc.

SiteTable
-------------
SiteID, SiteBlurb

I want have a form, where you can change the SiteID value in RecordTable, and have the SiteBlurb change (i.e. the form pulls the information from SiteTable) dynamically once you have entered the new value.

View 1 Replies View Related

Reports :: Dynamic Field On A Report?

Jul 3, 2014

I'm currently creating an invoicing report for a company, and for record purposes they need a dynamic field on the report for the specific Invoice Number of each client they invoice. I have the field set up currently as a text box =[Invoice#] so they have to enter an invoice number when they generate the report. However, when I generate the report and put in a number, I'm getting some whacky outputs.

For example, I've tested it with a test client, and when I give the client an invoice number of 1, the report somehow changes it to 49.

View 1 Replies View Related

Dynamic Multiple Criteria In A Single Field

Apr 5, 2007

I have a query that displays all records. I need it to limit based on multiple criteria in a single field. I.E... instead of all employees from every section, I just want it to display employees from section A, C, D, F one time and next time maybe go with section B, C, D. For some reason the solution eludes my little brain.

View 3 Replies View Related

General :: Dynamic Decimal Places Within Same Field

Oct 25, 2013

Is it possible for a report's displayed decimal places to be conditional.

I have field that has a lab test's name a field that displays the result of the test.

For some tests I only want 2 decimal places, for others I want 4. Is this possible within the same field?

View 2 Replies View Related

Modules & VBA :: Dynamic Query Change Field Selections

Jun 25, 2014

I am trying to build a function that will create a dynamic query for a chart on a Subreport.I am not exactly sure I am going about this the right way, but I need the user to be able to change selected fields for use in the query. I have a form with 3 combobox controls for selecting options to change the SQL statement. So far my code only deals with one of these comboboxes for simplicity. There is a button to call my function. Currently, the function is setting hidden text box values based on the combo controls, but I'm not sure if this is redundant.

I am using this as my guide for building the sql, but I am having trouble picking up the values in my text boxes for use in the SQL. [URL] .....

Code:
Option Compare Database
Option Explicit

[code]...

how do I get a value from an unbound textbox on an unbound form into a string to use as sql? The value in the textbox is a number.

View 3 Replies View Related

Modules & VBA :: Dynamic Button Function And Single Field Report

Jun 25, 2013

I'm still learning Access 2010 and having issues getting my buttons to work. I'm working on a simple address database.edit/save button. On form load, my fields are locked and my button will read "edit". After clicking, my fields are unlocked, my search features are locked, and my button reads "save" just how I need it to. The issue happens when I try and save the field edits, lock fields, return search features, and get button to read "edit" again. I know I need to add some code into what I already have, but I'm running into a wall as I have tried many options to get it to work. Here is the code for this button:

Code:
Private Function Lockdown() 'locks controls at load
Dim tb As Control
Dim cb As Control
Dim subf As Control

[code]...

Second issue is with my report button. I have not been able to get this to work once. I have done many searches on single record reports, and have found the same code every time. I added that code into my database, but can't seem to get it to work. In my database there are two address (shipping and work location) which I would like to print out together. I have the work location on the main form and the shipping on a subform. There are and upwards of 150 locations I will have in my database, Here is the code I'm working with:

Code:
Private Sub cmdrptadd_Click()
Dim strReportName As String
Dim strCriteria As String

[code]...

View 3 Replies View Related

Dynamic "Month" Field Controlled By Date Entry...

Nov 7, 2005

Hello.
I've been reading these forums for a few months now while developing a database for logging bugs during website QA, but never posted.

I need a way to change the "Month" combo dynamically based on what a user enters into the "StartDate" and "EndDate" Fields. (I'm using Access '97)

e.g.
I have Validation set up on both start and end date fields so they are required before a record can be saved. I would like the "Month" combo box to update with the proper month after a user has entered the StartDate and EndDate.
(Basically a timesaver for users who are entering 20-25 criteria into a single form.)

There's one hangup:
the date ranges aren't typical, as in, "November 1-30 = November"... It's more like "10/23 through 11/30 = November"
here's what that chunk of the form looks like:
http://www.ewiessner.com/misc/images/sded_month.gif
So if I were to enter 9/27 start, and 10/27 end, "October" would populate in the "Month" combo box, and I could continue to other fields.

Any input would be appreciated, and I apologize if this is a repeat post, I couldn't find any similar topics.

Thanks,
-E

p.s. - If it helps, I have a 'Month' table with 1-12 = Jan - Dec, the 'StartDate' and 'EndDate' fields are text entry boxes bound to the master 'Details' table where all the data is stored.

View 3 Replies View Related

General :: Update Main Form Field Value After Updating Field Value In SubForm?

Feb 12, 2015

I have a main form and a subform.

Both forms have the field called JobID in common.

Both forms have a field called JobStatus.

Any easiest solution so that After I Update the field called JobStatus in the subform, it changes the field called JobStatus in the main form to the value which was selected from the subform?.

View 3 Replies View Related

Field Update Using DSUM: Field Joins Are Not Working Correctly

Sep 11, 2007

I know there are numerous threads regarding dsum() on the forum, but I wasn't able to find the exact answer to my problem.

The root of my problem is that I'm trying to update a field on a table using dsum, which references another query to update the table. Although I have all of the correct keys from the physical table joined to the query in the dsum function, the code/ms access seems to ignore the joins. As a result, all payees are having their "vol" field set instead of a select subset.

Query (GetTxnVolAmtTR"):

SELECT p.payee_id, sum(txn_volume) AS vol, t.market, t.period_id
FROM ft_payees AS p, ft_txn_summary AS t
WHERE p.payee_id=t.payee_id And p.market=t.market
GROUP BY t.payee_id, t.period_id, t.market, p.payee_id;


Update statement (references the query above):

UPDATE tmp_ft_component AS rc
SET rc.volume = Dsum("vol","GetTxnVolAmtTR","GetTxnVolAmtTR.payee_id= " & [rc.payee_id] And "GetTxnVolAmtTR.market= " & [rc.market] And "GetTxnVolAmtTR.period_id= " & [rc.period_id] & "")
WHERE rc.component_name='Total Revenue';

as you can see, I have all of the fields I want joined, but the code seems to ignore this. I've tried looking at this site: http://www.mvps.org/access/general/gen0018.htm , but haven't found my answer. Any help would be much appreciated!

View 3 Replies View Related

Forms :: Update Field Value In FormB From Underlying Field Value FormA

Apr 17, 2015

I have two forms, both of which have a field called JobID (Form A is the primary Key and Form B is the linked field - Relationship: One to Many).

Form A = FrmJobs
Form B = FrmPurchaseOrders

I have put a command button on Form A. When I click the button I need it to open Form B and then automatically fill the field JobID in Form B with the same value in Form A from which it was opened. I have tried the following:

Private Sub Command214_Click()
Me.Refresh
On Error GoTo Err_Command214_Click
Dim stDocName As String
Dim stLinkCriteria As String

[code]...

The above code works on my old database but not on my new database. I get the following message "Object does not support this property or method".

View 6 Replies View Related

Update A Form Field By Double Clicking A Query Field

Apr 25, 2013

I have 3 peices of data that I am working with: Group number, plans and benefit elections. On my form I have fields for the group number and plan and 2 queries. When I enter a group number the first query displays a list of plan descriptions for that group. From there I can enter the plan description into the form's plan field and that runs the second query to give me a list of valid elections for that plan. This all works fine but I want to make the plan selection a little less tedious. What I would like is to be able to double click the query field housing the plan description and have it copied to the form's plan field. I could use the ID instead of the plan description but I work in a production environment and very key stroke counts so I would really like to have a simple double click process.

Is this even possible? If so how would I set that up? I tried using the double click on event macro builder but it does not seem to have this kind of option.

My form contains fields for group number and Plan. The same form houses 2 querys, one that pulls plans based on the group number and the other to pull elections based on the plan field (not the plan query). Would like to double click a plan within the plan query and have that description populated into the form's plan field.

View 6 Replies View Related

Automatic Update For A Field Depending On The Value Selected In Another Field.

Mar 28, 2007

tblAppointment will take register appointments.

tblTreatment contains Cost for different AppointmentTypes.

The above two tables are linked as 1-M relationship (1 Treatment can have Many Appointments)

Entering data in the tblAppointment - AppointmentType and AppointmentCost are the fields in tblAppointment. AppointmentType a drop down box, so that a specific AppointmentType can be selected.

Problem: Now depending on the AppointmentType selected the AppointmentCost field should automatically display the correct Cost.

Can anyone help please?

Thanks

Paz

View 2 Replies View Related

Update Field To Todays Date When Data In Other Field Changes

Apr 27, 2008

Hi

i have 2 fields in a form - 'Balance' and 'Date'. Quite simply I need the date field to change automatically to todays date each time the data in the 'Balance' field is changed. Can anyone advise me on how to accomplish this.

Many thanks

Geoff

View 2 Replies View Related

Forms :: Update A Field Based On Prior Field

Jul 13, 2013

I have a table that has been converted into a form for an input. Now suppose I have two columns. Say I enter value in first column. Now the second column is a lookup to a data from another table.

What I want is to see only those data in 2nd Column which have the value filled in Column 1. This is should be in run time mode. I fill in the value and then in the 2nd column I directly get to see only common values.

View 2 Replies View Related

Update A Field Based On Data Entered In Another Field?

Jan 9, 2015

I am wanting to update data in one field which is being pulled in from another table based on an entry in another field in a form

Attached is the database. In the sales form I want to enter a customer ID which will then pull in the customer name from the customer table and put it in the Customer Field in the sales table.

I know I am duplicating the data by having customer name in both tables which is bad database design!

View 3 Replies View Related

Update Table Field Based On Another Field.

Mar 3, 2008

Ok. I've got a table named SIPATable and some of the fields contain summed values. Let's say for instance I have a field named "GaDRaw", which represents a raw score. now...I need to update a field called "GaDPer", based upon the value in "GaDRaw". So...If "GaDRaw" <=16, then I would want "GaDPer" to be updated to = 35. Further, if "GaDRaw" = 17. then I want "GaDPer" to = 37. and so on....

I think it's an If Then Else statement, but not sure how or where to place it. Id like it to be as code under a command button, and update the table all at once.
Any help would be appreciated.
Thanks in advance,
Freud52

View 7 Replies View Related

Forms :: Update Field Value Based On Value From Another Field

Aug 24, 2014

I have a form used to track attendance of employees:

I want to update a value in Field B to a default value if a specific criteria is selected in Field A. How? I cannot seem to find a answer...

Specifically: If the combo box value "Not Present" is selected from Field A, I want to value in Field B to automatically update to "Not Available".

View 11 Replies View Related

Modules & VBA :: Update Field Value Based On Another Field

May 11, 2015

I have the following fields in an A2010 form

PaymentMethod
Total
InstalmentAmounts
OurFee

InstalmentAmounts field is populated based on the results of PaymentMethod which is a combo box

Here is the current code

Select Case Me.Payment_Method.Value
Case "Three post dated Cheques"
'If three payments by cheque
Me.InstalmentAmounts.Value = Round(Me.Total.Value / 3, 2)

In some cases there will be a few pennies that the client "overpays" because the instalment amounts will not add up to the Total. I need to add up the TotalInstalmentPayments to find out what the client actually pays and then add the difference between TotalInstalmentPayments and Total to the OurFee field

So

Total = 500.00
Payment Method = 3 instalments so
IstalmentAmounts = 166.67 (rounded) so client pays 500.01 so the 0.01 needs to add to the OurFee field.

View 4 Replies View Related

Trying To Update Field Based On Value From Another Field

Aug 25, 2006

I am trying to update a field to say "Yes" or "No" based on whether it is more than thirty days out from the value in another field. I am having trouble doing this for some reason...totally stuck!

Please help :-)

View 5 Replies View Related

Update Field Changes To Table Field

Nov 13, 2007

Hi,

I have a parts table with a field that holds a vendor's name which is selected from a combo box on a parts form. I've just noticed that if a vendor name is changed on the vendor form the field in the table isn't updated. I now have to go through all parts to adjust any changes done to the vendor name. Is there a way I can automatically update the vendor name in the parts table if there is a change done to the Vendor name in the vendor table?

Thanks

View 5 Replies View Related

Make One Field Update Another Field

Oct 24, 2012

I am having this problem. On the same form named frm_Employees_on_Call_What_Order

I have 2 command buttons, one named Thursday and one named Wednesday. I want those buttons to update 2 fields on the same form.

I have 2 fields also on the same form named OnCallDte and CallNexttDte which are date fields.

Thursday should update OnCallDte and Wednesday should up date CallNexttDte

Each of the command buttons Thursday and Wednesday have there own code bound to them in date format.

View 2 Replies View Related

Form Event (Before And After Update) Copy Form/Field Value To Another Table/Field

Aug 17, 2006

Group,

I thank you in advance for considering this inquiry.

From within a Form.field (based on a master table query), I desire to trigger two events; one before update and one after update.

This function will serve to document specific form.field value changes to a "log" table for review prior to being committed back to the master table.

What I'm looking for are functions, which I can use in a Macro or VBA code to facilitate a field read and copy before change and a read and copy after change triggering.

I'm sure this is absurdly simple.

View 2 Replies View Related







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