Jump to content

skcombs

Members
  • Posts

    14
  • Joined

  • Last visited

Recent Profile Visitors

138 profile views

skcombs's Achievements

  1. I am working with a legacy ACCESS application where many records are duplicated but with different primary IDs. These were created in ACCESS with Append Queries. The straightforward way is to find the record to duplicate, download to EXCEL, change the ID and upload to append to the table. But I'm trying to automate this task using auto-submit submission forms. The challenge is letting the user modify the ID and create a new record in the same table. I am not updating the original record, but keeping it. Any suggestions welcome. My first approach is to search for the record to duplicate, create an HTML block that passes all parameters by query string to a submission form. This form lets users change the ID and passes on to a submission form that auto-submits. That does work if there are only a few parameters in the query string. It fails if the query string exceeds some limit (somewhere over 1,000 characters). Is there a known limit to query string length? And, is there a better way to do this?
  2. What does this error message mean: "Pivot tables cannot have more than 200 columns." I have specified 5 columns and 9 rows with 5 calculated values. If I try to add another column and calculated value, I see this message. The columns are fields that have Yes/No values, The calculated values are convert Yes values to number 1s and sum. In the resulting Pivot Table, I see a count of all the Yes values, a count of all the No values, and the totals. How can adding another column trigger the error?
  3. If I am inserting a new payment that has a payment date and a payment amount, I cannot know whether the payment date is the most recent date of payments for that loan. It could be that someone is entering a date that is prior to other dates in the payments table. I have triggers invoked when a payment is made or deleted. When a payment is entered into the Payments table, I thought I could update the MostRecentPaymentDate in the parent Loans table by saying MostRecentPaymentDate = SELECT TOP 1 from PaymentsTable. Payment Date, Order By PaymentDates (desc) in the Payments table. I'm not getting the result I would expect if the newly inserted date is included in the sort. Is this because the insertion/deletion hasn't completed yet?
  4. Situation: Parent LOAN table includes fields: Date, Amount, SumOfPayments, MostRecentPayment, MostRecentPaymentAmount Child PAYMENTS table includes fields: PaymentDate, PaymentAmount When a PAYMENT is inserted, the SumOfPayments should increase by PaymentAmount, and if Payment is deleted, SumOfPayments should decrease by that amount. Easy enough in a trigger. The problem comes in the MostRecent fields. I can create a TASK to reorder PAYMENT table entries by PaymentDate and then reset those fields in the LOAN table, and loop thru PaymentAmounts to recalculate SumOfPayments. But triggers occur mid-transaction, so too early to set the MostRecent fields, or do I misunderstand? I would like to run the task immediately after the insert/delete/update takes place. Is there any way to do this? Also, in a tabular report that allows inline edit and where the results are ordered by PaymentDate, I do not see a reordering after editing/updating the Payment Date. If I reload the results, the order is correct, but not if I edit inline. Here is an example of the results after changing the first row's date to occur before the date in the second row.
  5. On insertdata trigger, I would like to set a text field to concatenate two #inserted text fields. Does anyone have an example or link to documentation?
  6. How kind of you for working on this, I am grateful. I will implement your suggestion. Your explanation is very clear.
  7. I have a table where the responses are stored as numbers. A lookup table has the pairing of labels to numbers, and the labels are used for the radio button responses. One reason for this is that I want to compare the rating a respondent gives to each question over time to the same question.
  8. In a survey, I am using a Likert Scale of 4 values (Strongly Disagree -> Strongly Agree) to answer several questions on a submission form. I would like to create a Pivot Table with questions on one dimension, scale names on the other, with a count of User-Ids as the values. How do I use the scale values (Strongly Agree...) from a lookup table to specify the rows (or columns) ? ALSO, I kept getting an ERROR when I submitted this question telling me to try again, so Sorry for the multiple submissions.
  9. I had the same problem in Wordpress v3.xxx. I tried this suggestion to wrap the embedded Caspio code in a div, where I set the width to a percentage. And you need to disable RESPONSIVE on the datapage. But it still failed because Wordpress stripped out the div tags in my HTML code. <div style=”width: 100px; height: 100px; overflow: auto”> <!–Embedded Deploy Code–> </div> If that is what you see too, then edit your theme's functions.php and add this function to stop WP from removing div tags, and other tags as well: // stop wp removing ALL Html tags function override_mce_options($initArray) { $opts = '*[*]'; $initArray['valid_elements'] = $opts; $initArray['extended_valid_elements'] = $opts; return $initArray; } add_filter('tiny_mce_before_init', 'override_mce_options');
  10. I had the same problem in Wordpress v3.xxx. I tried this suggestion to wrap the embedded Caspio code in a div, where I set the width to a percentage. And you need to disable RESPONSIVE on the datapage. But it still failed because Wordpress stripped out the div tags in my HTML code. <div style=”width: 100px; height: 100px; overflow: auto”> <!–Embedded Deploy Code–> </div> If that is what you see too, then edit your theme's functions.php and add this function to stop WP from removing div tags, and other tags as well: // stop wp removing ALL Html tags function override_mce_options($initArray) { $opts = '*[*]'; $initArray['valid_elements'] = $opts; $initArray['extended_valid_elements'] = $opts; return $initArray; } add_filter('tiny_mce_before_init', 'override_mce_options');
  11. In parent table, I use prefix autonumber as identifier, named ID. In child tables, the identifier is to inherit, so I use same identifier name, ID, but as datatype string. (1) Now, I want to create datapages for a submission form that will use fields from the parent form and pass the identifier to the datapage for the child table. In the child form, I hide the identifier ID but use external, with parameter InsertRecordID. After submitting the form, I am actually seeing "@InsertRecordID" as the entry for ID in the child table. (2) The child table is in a one-to-many relationship with parent table. In my submission form, I want multiple instances of the child table. For example, the form user is to list all family members and their relationship to the user. So, in filling out the form, I'd like to pass the user's ID to the child form and have a new listing for each family member, then submit. All family members would inherit users ID identifier. Is there a video I could watch that explains this?
×
×
  • Create New...