Search results

  1. G

    Hide subform 2 based on value on subform 1

    The error is? It is likely associated with incorrectly referencing the combobox properties, although this looks like it may be the first error encounterd in the code you posted: What is the rowsource for the cbo eName? If it is multicolumn note the order of columns, even those that are hidden...
  2. G

    Hide subform 2 based on value on subform 1

    Try this reference: Forms: Refer to Form and Subform properties and controls (mvps.org) The two subforms appear side - by - side? Or is subform 2 a subform in subform 1? If the latter then possibly: If ename.text = "Tour De Lis" then ' the value for the combo is assumed to be an ID and not...
  3. G

    Delete a record after inform user

    Normally an item selected for sale will be selected from a catalog, in which a price is set. A quantity is then used to determine the price to be charged. A discount can then be applied to that amount - it may be that the item is discounted 100% and so the amount charged is 0. Do you need to...
  4. G

    Illegals instructed to vote for Biden - cheating plan for 2024

    Misinformation is a problem isn't it? FAQ - Voter Identification (ct.gov) check out the other pages to expand on the requirements / processes.
  5. G

    Another mass shooting

    That will be determined in a court, I expect, if it ultimately gets to court. However clearly he was seeking to get the result changed and suggested means which did not involve a recount. You give everything Trump says and does the most generous interpretation. Yeah I think he is stupid, and...
  6. G

    Another mass shooting

    Cmon Pat: "All I want to do is this: I just want to find 11,780 votes, which is one more than we have," Trump says, according to audio of the call. "There's nothing wrong with saying, you know, that you've recalculated." Who does not listen?
  7. G

    basic ticketing system design - suggestions welcome

    A schematic to adapt: Database schema for the Ticket selling example. | Download Scientific Diagram (researchgate.net)
  8. G

    Subtract integer from time duration

    Are you using the dateadd function? DateAdd function (Visual Basic for Applications) | Microsoft Learn Use "h" for interval and -number of hours). If you need to deal with minutes then you need to convert and manipulate in minutes. The time column is assumed to be a date/time data type...
  9. G

    Solved VBA Code/Formula to find left most value(s) and paste them descending

    Unsure as to where the text comes from. Are you expecting Dude 2 row in Drivers to have the value "3(W.S.F)" in cell D3, and Dude 6 row in Drivers to show the value "2(F,W) online" in corresponding cell (column D) where Dude 6 is listed, etc? It would be helpful to attach a copy of your...
  10. G

    Solved subform remains blank after new record saved

    You might try comment out the me.dataentry property The default value for this property is "False" which means that Access opens the form and shows the existing records. However, if set to True, the Data Entry property of the form specifies that the form will only show a blank record. Suggests...
  11. G

    Syncronize data from site to office

    In simple terms - you have two separate databases. They may be structurally the same (table and relationships), I assume. You add/edit/delete data in each. Then you want some kind of merge function where changes made in each (or in one - the laptop) are applied to the other. Then if successful...
  12. G

    A Proof

    Reading ability, comprehension, mental capacity ....
  13. G

    Solved Load records of a bound form after selection of SiteID.

    Do you mean not to display any records on a form until after the user selects an option on the combobox which filters the records in the forms record source? Your form on load could have this set Me.Filter = "(False)" Me.FilterOn = True then when you use the cbo ... after update .. you...
  14. G

    Solved Txt box on Form to add data

    A control which presents a calculated value, will carry out the calculation as specified. It cannot be reset to 0 without overwriting the method of calculation. Why do you need to reset to 0 if the calculation is based on a calculation /algorithm which is accurate? To change the value - alter...
  15. G

    Guitar practice log

    If you are able to construct the simple queries, then combining them - finding which phraseIDs are common across the queries of interest combined together should be straight forward. Configurable queries - where you supply a filter value from the form are also viable - you need to think about...
  16. G

    Solved Txt box on Form to add data

    Emma - your form has a recordsource, to which you may be applying a filter to display the required records. The CLEAR button, as proposed would perform an update query against the records in the form, so that the Weight in each of those records is set to 0. Be sure - each of those records in the...
  17. G

    Solved Txt box on Form to add data

    The total weight as Sum(Weight]) is a calculated value summing the weights entered for the records in question. The Clear button would need to delete (set to 0) the weight entered for the records that you are summing. This could be done a an update SQL statement of the on click event of the Cear...
  18. G

    The Deep State

    State. Stare too long and.. who blinks first.. Underground/underhand and/or Misinformation/enlightenment :cool:
  19. G

    The Deep State

    We are very close to a precipice, wearing not a blindfold, but virtual reality goggles. Enjoy your chocolate, watch the show. Hope it does not end up in a shambles when the goggles are taken off.
  20. G

    The Deep State

    Duh!.. do you think Trump is stupid and did not understand how the mob would interpret "If you don't fight like hell, you're not going to have a country anymore." Irresponsible at least. You hold him in such high regard. YOU decided to take the view he is dumb then? You seem to be obsessed about...
Top Bottom